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
Post a Comment