Advanced Excel
Master formulas, dashboards, pivot tables, and reporting workflows.
What You'll Learn
Master VLOOKUP, INDEX/MATCH, and XLOOKUP
Build dynamic dashboards with charts and slicers
Create and manipulate PivotTables with confidence
Write nested IF, SUMIFS, and COUNTIFS formulas
Automate repetitive tasks with basic macros
Use Power Query to clean and transform data
Design professional-grade reports from raw data
Present data insights clearly to stakeholders
Curriculum Breakdown
Learning Format
Recorded Video
Step-by-step video lessons with real datasets you download and work through.
Hands-On Projects
Professional dashboards and reports you can show directly to employers.
Live Q&A Sessions
Tackle your specific spreadsheet challenges with Emma in live sessions.
Certification Details
Professional Certificate
Issued by Tech101
Complete all modules and build your three capstone projects to earn your verified Tech101 Excel certificate — recognised by employers across finance, HR, and operations.
Certificate Requirements
- Complete all 38 video lessons
- Submit all 6 hands-on projects
- Pass the final assessment (70% minimum)
- Complete within 6 months of enrollment
Completion Certificate
Awarded upon finishing all course content and submitting projects. Shows dedication and completion.
Graded Certificate
Earned by passing the final assessment with 70%+ score. Demonstrates verified skill proficiency.
Your Instructor
Emma Roberts
Data Analyst & Microsoft Certified Trainer
Emma is a data analyst and Microsoft Certified Trainer with 8+ years building Excel solutions for Fortune 500 companies. She specialises in making complex data analysis accessible to everyone.
Requirements & Prerequisites
Technical Requirements
- Basic Excel familiarity (can open files and enter data)
- Microsoft Excel 2016 or later (Microsoft 365 recommended)
- Willingness to download and work through the practice files
- Windows or Mac computer
Who This Course Is For
- Office professionals who use Excel daily but want to go deeper
- Finance, HR, and operations staff handling reports
- Analysts looking to speed up their workflows
- Anyone preparing for a data or business analyst role
Student Reviews
David L.
2 weeks ago
My PivotTable game went from zero to hero in a weekend. The dashboard project alone was worth the price.
Fatima A.
1 month ago
Emma's teaching style is incredibly clear. I've tried three other Excel courses — this one is the best by far.
Tom B.
3 weeks ago
The Power Query section alone saved me hours of manual work per week. Fantastic course.
Frequently Asked Questions
Students Also Enrolled In
Ready to Begin?
Ready to Start Your Data Journey?
Join 18,700 students who are already building real skills with Advanced Excel.
🛡️ 30-Day Money-Back Guarantee • Lifetime Access • Certificate Included