Course Content
Advanced Formulas and Functions:
- Logical – IF, OR, AND, SUMIF, COUNTIF, AVERAGEIF
- Lookup and Reference Functions – Vlookup, Hlookup, Xlookup,
- Index, Match, Filter, Indirect, Chooseraw, Choosecol
- Text Functions
- Date and Time Formulas
What-If Analysis (Data Analysis)
- Scenario Analysis
- Goal Seek
- Data Table
- Advanced Conditional Formatting
- Power of dynamic tables
- Advanced Filters
- Working on the large size files
- Sparklines, Slicers and Timelines
Advanced Pivot Tables
- PivotTable calculations
- Using slicers in Pivot Tables
- Conditional formatting in Pivot Tables
- Creating PivotCharts
- Advanced Charting
- Importing data from different sources
- Avoi d manual data entry – User restrictions with Data Validation
ChatGPT & AI for EXCEL