- Review of Excel Essentials for Business - Level 1
- Range Names, Custom List and Dealing with Errors
- Understanding Absolute and Relative Cell Reference
- Working with Logical Functions (IF, AND, OR & NOT)
- Working with Dynamic Arrays SORT & SORTBY FUNCTION UNIQUE FUNCTION FILTER FUNCTION SEQUENCE FUNCTION XLOOKUP FUNCTION
- Using Excel Formulas for Quick & Dynamic Analysis SUMIFS COUNTIFS AVERAGEIFS SUMPRODUCT IFERROR For Credible Reports FREQUENCY, SMALL & LARGE to Organize and Rank
- Working with Paste Special and Find & Replace
- Formatting, Custom Formatting and Protecting Worksheets and Workbooks
- Creating and Managing Tables & Slicers, Charts and Objects
- Creating Interactive reports with Excel Pivot Tables and Charts
- Solve problems with Goal Seek
- Automating tasks with macros
- Customizing Excel