Excel Masterclass: From Beginner to Advanced

Master Microsoft Excel with hands-on projects. Learn formulas, PivotTables, charts, and VBA basics. Start FREE with our basics plan!

Free Basics Beginner 4 enrolled 10 lessons 4h 14m

Created by John Instructor

About This Course
🆓 FREE BASICS PLAN INCLUDED!
Start learning with our free introductory lessons. Upgrade anytime to access the full course.

---

This comprehensive Excel course takes you from absolute beginner to advanced user. You will learn:\n\n- Basic navigation and data entry\n- Formulas and functions (SUM, VLOOKUP, INDEX-MATCH)\n- PivotTables and PivotCharts\n- Data visualization and dashboards\n- Introduction to VBA and macros\n\nPerfect for professionals looking to boost their productivity.
What You'll Learn
Create complex formulas and functions
Build interactive dashboards
Automate tasks with macros
Analyze data with PivotTables
Requirements
  • Basic computer skills
  • Microsoft Excel installed
Course Curriculum
  • Introduction to Excel Free Preview 9 min
  • Data Entry and Formatting Free Preview 20 min
  • Basic Formulas: SUM, AVERAGE, COUNT 25 min
  • IF Function and Conditional Logic 20 min
  • VLOOKUP and XLOOKUP 30 min
  • PivotTables Fundamentals 35 min
  • Creating Charts and Visualizations 30 min
  • Advanced Formulas: INDEX-MATCH 25 min
  • Data Validation and Protection 20 min
  • Introduction to VBA Macros 40 min
Your Instructor
John Instructor

Instructor

Experienced software developer with 10+ years of teaching experience.

Free Basics
FREE
  • 2 introductory lessons
  • Course overview
  • Community access
Start Free
Full Course
₦65,000
  • All 10 lessons
  • Quizzes & assessments
  • Project submissions
  • Certificate of completion
  • Lifetime access
Enroll Now
This course includes:
  • 10 video lessons
  • 4h 14m total
  • Lifetime access
  • Mobile friendly
  • Certificate of completion