This course qualifies as a prerequisite course towards the MPE

Course Description:

Unlock the full power of Excel 365 in this dynamic, hands-on course designed to elevate your spreadsheet skills from intermediate to advanced—with the added advantage of AI integration.

This course begins with the core Excel skills every professional needs: mastering formulas, data cleansing, nested functions, and pivot tables. You’ll build a solid foundation in managing files, validating data, and working with tables and conditional formatting.

As the course progresses, you’ll move into advanced Excel applications powered by Artificial Intelligence. Discover how tools like ChatGPT can generate VBA code, automate repetitive tasks, and enhance data analysis through smart recommendations like AI-driven pivot tables.

Through detailed video lessons, exercises with solutions, downloadable reference materials, and real-world deliverables, you’ll gain both the technical skills and the confidence to use Excel as a powerful decision-making tool.

What You’ll Learn

Excel Intermediate Level 1

• Introduction to Excel 365 formulas and functions

• File management and data cleansing techniques

• Conditional formatting and table organization

• Nested functions for advanced logical operations

• Intro to pivot tables and macros

Excel Intermediate Level 2

• Top-used Excel 365 formulas for real-world tasks

• Named ranges and cell validation

• Link management across files

• Deeper use of pivot tables and data visualization

Advanced Excel with AI – Modules I to III

• Overview of AI, types of AI, and Generative AI in Excel

• Using ChatGPT with Excel and generating VBA code

• Scenario analysis and goal seek

• Implementing forms and slicers for data interaction

• AI-assisted pivot tables for smart analysis and reporting

• Custom prompts and automation using AI tools

Why Take This Course?

• Learn step-by-step through detailed video tutorials

• Apply knowledge with realistic exercises and solutions

• Gain modern skills relevant to accounting, business, and data roles

• Master both traditional Excel techniques and emerging AI tools

• Prepare for AI-driven workplace environments