- Introduction to Excel
- Introduction to Basic Arithmetic in Formulas
- Introduction to Basic Functions (SUM, PRODUCT, POWER, QUOTIENT, MAX, MIN, AVERAGE, COUNT, COUNTA, COUNTBLANK)
- Working with Text Functions (CONCAT, CONCATENATE, TEXT JOIN, UPPER, LOWER, PROPER)
- Understanding Order of Operations
- Managing Worksheets
- Working with Dates & Time. (TODAY, NOW, YEAR, MONTH, DAY, EOMONTH, EDATE, WORKDAY, NETWORKDAYS)
- Absolute and Relative Cell Reference
- Understanding The Importance of Data Validation
- Working with Statistical and Math & Trig Functions. (MEAN, MEDIAN, MODE, SUMIF, COUNTIF, AVERAGEIF,)
- Range Names, Custom List and Dealing with Errors
- Formatting, Custom Formatting and Protecting Worksheets and Workbooks
- Working with Logical Functions (IF, AND, OR & NOT)
- Working with Lookup & Reference Functions (VLOOKUP, FILTER, SORT, UNIQUE etc)
- Manipulate Data and Modifying worksheet
- Creating and Managing Tables & Slicers, Charts and Objects
- Introduction to Interactive reports with Excel Pivot Tables
- Printing Excel Files and Saving as PDF