← Back to Courses
POPULARExcel Analyst Path|5 formula challenges

Advanced Excel with AI

From formulas to full automation — XLOOKUP, FILTER, Power Query, VBA and Microsoft Copilot. Taught with your real data files, not demo datasets.

COVERS:XLOOKUPFILTER & SORTDynamic ArraysPower QueryVBA MacrosLETMicrosoft Copilot
Excel Challenges0/5 done
1
XLOOKUP — Find Employee Dept
Beginner
›
2
FILTER — Sales Above Target
Beginner
3
Power Query — Clean Messy Data
Intermediate
4
VBA — Auto-Generate Monthly Report
Intermediate
5
Dynamic Dashboard — Auto-Updating KPIs
Advanced
Key Concepts›
Dynamic Arrays & Spill Ranges
XLOOKUP / FILTER / SORT / UNIQUE
Power Query M language
VBA variables, loops and subs
LET for readable formula logic
Pivot Tables & Calculated Fields
Microsoft Copilot in Excel
Challenge 1 of 5Beginner

XLOOKUP — Find Employee Dept

Your HR file has two tables: Employees (ID, Name) and Departments (ID, Dept, Manager). Use XLOOKUP to pull the Department for each employee — it should handle missing IDs gracefully with "Not Found" instead of an error.
EXCEL FORMULA EDITOR
Ctrl + Shift + Enter
// Write your Excel formula here// Use the hint above if you need guidance=
Concepts used: XLOOKUPStructured Table ReferencesError Handling
Full Curriculum

4 modules · ~13 sessions.
Each session solves a real work problem.

01
Advanced Formulas
3 sessions · 6 topics
›
→XLOOKUP and array matching
→FILTER, SORT and UNIQUE dynamic arrays
→Named ranges and structured table references
→Error handling: IFERROR, IFNA, ISERROR
→Text functions: TEXTJOIN, TRIM, CLEAN
→LET for multi-step formula logic
02
Power Query
3 sessions · 6 topics
›
03
VBA and Automation
4 sessions · 6 topics
›
04
AI Tools and Dashboards
3 sessions · 6 topics
›

Is this course right for you?

✓ Good fit if...
✓You use Excel daily and want to stop doing things manually
✓You spend 2+ hours/week on copy-paste or report formatting
✓You know basics but want formulas that actually save time
✓You want to automate your monthly reporting cycle
✓Your team needs better Excel skills quickly
✗ Not for you if...
✗You've never opened Excel before (start with basics first)
✗You want only a self-paced video course
✗You need Power BI — this is Excel only
✗You want a certificate without doing real exercises
Duration
~1 Month
Live · 3 sessions/week · New batches monthly
✓Your own Excel files used in session
✓WhatsApp support between sessions
✓Session recordings to review later
✓Certificate of completion
✓Free consultation before you enrol
Why TechnoExcel
10K+Professionals trained
4.8★Google · 729 reviews
#1Most-requested course
Wk 1When you stop doing things manually