[AE.18]
[AE.18]
Advanced Excel
BUSINESS4 WeeksClassroom
Overview
Almost everyone puts "Microsoft Excel" on their resume. Almost nobody actually knows Excel well. There's a massive gap between "I can make a table and use SUM" and "I can build automated dashboards, clean 100,000-row datasets, write macros, and produce reports that my manager's manager wants to see." This course lives in that gap. You already know basic Excel. We're going to take you to the level where you're the person in the office that everyone comes to when their spreadsheet breaks, and more importantly, the person who builds the spreadsheets that run the department. Pivot tables that slice data any way you want. VLOOKUP, XLOOKUP, INDEX-MATCH for pulling data across sheets. Power Query for cleaning messy data without manual work. Conditional formatting that makes patterns jump out. Basic macros and VBA to automate the repetitive stuff. And dashboards. Actual, interactive dashboards that update automatically and look professional enough for a boardroom. This is a short, focused course. No filler. You walk in knowing basic Excel, you walk out being the Excel person. That skill alone is enough to get hired in accounting, operations, analytics, HR, and a dozen other departments, immediately, without any other qualification.
Quick Facts
Duration4 Weeks
FormatClassroom
CategoryBUSINESS
Code[AE.18]
Enrolling Now
New batches forming. Enquire for pricing and details.
What You'll Achieve
Build complex formulas (VLOOKUP, XLOOKUP, INDEX-MATCH, array formulas)
Create pivot tables and pivot charts for instant data analysis
Use Power Query to clean and transform messy data automatically
Record and write basic macros (VBA) to automate repetitive tasks
Build professional, interactive dashboards with charts and slicers
Curriculum
- •VLOOKUP, HLOOKUP, XLOOKUP & INDEX-MATCH
- •IF, IFS, COUNTIFS, SUMIFS: conditional logic at scale
- •Text functions, date functions & nested formula building
- •Array formulas & dynamic arrays (FILTER, SORT, UNIQUE)
Tools & Technologies
Microsoft ExcelPower QueryVBAGoogle Sheets
Ready to start?
Get in touch to learn more about Advanced Excel, upcoming batches, and enrollment details.
Enquire Now