Microsoft Excel – Advanced Excel Formulas & Functions Bootcamp

2 Days Price: 8,000

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

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

Day 2: Functions for Data Analysis & Automation

Math & Statistical Functions – SUMIF(S), AVERAGEIF(S), COUNTIF(S)
Array Formulas & Dynamic Arrays – UNIQUE, SORT, FILTER, SEQUENCE
Error Handling Functions – IFERROR, IFNA
Formula Auditing & Debugging Techniques
Practical Business Applications – Financial Models, HR Dashboards, Sales Reports
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.