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
COURSE SCHEDULE & FEES
2:00 PM - 5:00 PM
Training Session
Online
Online Session
6253
Inclusive of all taxes
DOWNLOAD COURSE CONTENTS
Please click the button below to download the course content. You'll need to provide your contact information to receive the document.
INCOMPANY/GROUP TRAINING REQUEST
Why Choose Our Incompany Program?
- 🎯 Tailored content specific to your business goals
- 👥 Train entire teams together, saving time and cost
- 📍 Delivered at your location or virtually
- 📅 Flexible scheduling to suit your timelines
- 📈 Increase retention and application of skills