Advanced Excel & AI

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