Microsoft Excel – Advanced Excel Formulas & Functions Bootcamp

This 2-day intensive bootcamp is designed for professionals, students, and data enthusiasts who want to take their Excel skills to the next level. The program focuses on advanced formulas, functions, and data analysis techniques that help you save time, improve accuracy, and make smarter business decisions. By the end of the bootcamp, you’ll confidently apply Excel’s most powerful features to real-world scenarios.

Key Learnings

By completing this bootcamp, participants will:

• Master advanced Excel formulas & functions for problem-solving.
• Learn logical, lookup, text, and date functions to automate tasks.
• Apply nested formulas and combine multiple functions for efficiency.
• Use array formulas and dynamic arrays to analyze complex data.
• Gain skills in error handling, formula auditing, and debugging.
• Build business-ready dashboards & reports using formulas.

Course Content

Day 1: Mastering Advanced Formulas

1. Quick recap: Excel basics & formula foundations
2. Logical Functions – IF, IFS, AND, OR, SWITCH
3. Lookup Functions – VLOOKUP, HLOOKUP, XLOOKUP, INDEX + MATCH
4. Text Functions – LEFT, RIGHT, MID, LEN, CONCAT, TEXTJOIN
5. Date & Time Functions – TODAY, NOW, EOMONTH, DATEDIF, NETWORKDAYS
6. Nesting & Combining Multiple Functions

Day 2: Functions for Data Analysis & Automation

1. Math & Statistical Functions – SUMIF(S), AVERAGEIF(S), COUNTIF(S)
2. Array Formulas & Dynamic Arrays – UNIQUE, SORT, FILTER, SEQUENCE
3. Error Handling Functions – IFERROR, IFNA
4. Formula Auditing & Debugging Techniques
5. Practical Business Applications – Financial Models, HR Dashboards, Sales Reports
6. Capstone Exercise – Build a mini dashboard using advanced formulas

⚡ By the end, learners will be able to work smarter, not harder in Excel — transforming data into insights with confidence.

Flexible Class Options

• Weekend Classes For Professionals  SAT | SUN
• Corporate Group Training Available
• Online Classes – Live Virtual Class (L.V.C), Online Training