Basic & Essential Excel Formulas And Functions Course 2020
Excel Master,Filter,AND,OR ,Vlookup,IF Conditions,Microsoft excel Formulas & Functions ,Excel Basic Formulas & Functions
What you’ll learn
-
How to write basics formulas and perform calculations from scratch
-
Learn the most popular Microsoft Excel functions for beginners
-
Identify formulas and functions and know the difference between the two.
-
How To Use The Popular Mathematical Function In Excel With Real Practical Excel Sheets Such As SUM, AVERAGE, MAX, MIN, ROUND, SUMIF, COUNT, COUNTA, COUNTIF Functions
-
How To Use The Essential Text Function In Excel With Real Practical Excel Sheets Which Are LEFT, RIGHT, CONCATENATE, UPPER, LOWER, MID, PROPER, TRIM, REPT, TYPE, EXACT, HYPERLINK Functions
-
How To Use The Essential & Popular Date & Time Functions In Excel With Real Practical Excel Sheets Which Are NOW, TODAY, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, TIME, EDATE
-
How To Use The Lookup Function In Excel Which Are IF, VLOOKUP, AND, OR, Functions With Real Practical Excel Sheets
-
How To Use The DATA VALIDATION, FILTER Function In Excel With Real Practical Excel Sheets
Requirements
-
A computer or laptop
-
No prior Excel knowledge is needed.
-
Microsoft Excel 2007 ,2010,2013,2016,2019 or Office 365 (Some features may not be available in earlier versions)
Who this course is for:
- Excel users both inexperienced and experienced who don’t feel confident about using Excel formulas and Functions
- Anyone who uses Excel for work or personal needs such as Sales Manager, Students, Individual, Accountants ,Auditor, Financial Analyst, Information Clerk
- Anyone who uses Excel for entering data, lists, formulas, functions
