The Complete Microsoft Excel Course Including How to Program in Excel

Learn EVERYTHING about Excel from scratch, including how to program in Excel with Visual Basic for Applications & Macros

   Watch Promo   Enroll in Course

Welcome to the most COMPREHENSIVE Excel course, which teaches every single Excel feature from scratch and how to program, in Excel using Visual Basic for Applications & Macros. No experience in Excel or with programming is required to take this course. There is a 30 day money back guarantee, so you have nothing to lose and everything to gain. Please watch the comprehensive promotional video trailer for an outline of the course.

This comprehensive course has 4 tracks as follows: a Beginner track, an Intermediate Track, a Genius Track and an All Lectures and Exercises Track. After taking this course you will know EVERYTHING about Excel and be able to take your career or business to the next level.

This course is based on my extensive experience using Excel in business and as a programmer since the 1980s. I used to be a beta tester for Microsoft as part of the Microsoft Developer's Network. I have created thousands of Excel documents in my career at Accenture, on Wall Street at Goldman Sachs, at the top hedge funds, in the venture capital industry and with the companies I have founded. I provide many downloadable templates based on my work experience that are available to the students that take this course, so I can help you work smarter and not harder when using Excel.

Here is the course outline: [B = Beginner Track Lessons and Exercises, I = Intermediate Track Lessons and Exercises, G = Genius Track Lessons and Exercises, A = All Track Lessons and Exercises - where you can go from zero to hero when it comes to all Excel features).

[B/I/G/A] Section 1: Course Overview, Quick Reference and Resources

  • [B/I/G/A] Section 1.1: Introduction & How to Take Course + Selecting a Track: (Beginner, Genius & More)
  • [B/I/G/A] Section 1.2: Settings and Security
  • [B/I/G/A] Section 1.3: Help Videos & More
  • [B/I/G/A] Section 1.4: Downloads of Files

[B/I/A] Section 2: Foundations: Microsoft Excel 101: Create, Edit & More

  • [B/I/A] Introduction to Section 2: Excel 101 Foundations (Basics): Create, Edit and More

[B/I/A] Exercise 2.1: Excel Foundations Part 1: Money Doubling Exercise

  • [B/A] Exercise 2.1 Introduction: Excel Foundations Part 1: Money Doubling Exercise
  • [B/A] Lecture 2.1.1 Text & Number Formatting
  • [B/A] Exercise 2.1.1 Text & Number Formatting
  • [B/A] Answer 2.1.1 Text & Number Formatting
  • [B/A] Lecture 2.1.2: Cell Alignment
  • [B/A] Exercise 2.1.2: Cell Alignment
  • [B/A] Answer 2.1.2: Cell Alignment
  • [B/A] Lecture 2.1.3: Borders and Shading
  • [B/A] Exercise 2.1.3: Borders and Shading
  • [B/A] Answer 2.1.3: Borders and Shading
  • [B/A] Lecture 2.1.4: Introduction to Formulas [We will cover formulas in much more detail in Section 3]
  • [B/A] Exercise 2.1.4: Introduction to Formulas
  • [B/A] Answer 2.1.4: Introduction to Formulas
  • [B/I/A] Lecture 2.1.5: Introduction to Conditional Formatting
  • [B/I/A] Exercise 2.1.5: Introduction to Conditional Formatting
  • [B/I/A] Answer 2.1.5: Introduction to Conditional Formatting

[B/I/A] Exercise 2.2: Excel Foundations Part 2: Saving Money

  • [B/A] Exercise 2.2 Introduction: Excel Foundations Part 2: Saving Money
  • [B/A] Lecture 2.2.1: Inserting & Editing Images
  • [B/A] Exercise 2.2.1: Inserting & Editing Images
  • [B/A] Answer 2.2.1: Inserting & Editing Images
  • [B/A] Lecture 2.2.2: Inserting & Editing Icons
  • [B/A] Exercise 2.2.2: Inserting & Editing Icons
  • [B/A] Answer 2.2.2: Inserting & Editing Icons
  • [B/I/A] Lecture 2.2.3: Ordering Images
  • [B/I/A] Exercise 2.2.3: Ordering Images
  • [B/I/A] Answer 2.2.3: Ordering Images
  • [B/A] Lecture 2.2.4: Copying Formulas
  • [B/A] Exercise 2.2.4: Copying Formulas
  • [B/A] Answer 2.2.4: Copying Formulas
  • [B/I/A] Lecture 2.2.5: Inserting "&" in Formulas
  • [B/I/A] Exercise 2.2.5: Inserting "&" in Formulas
  • [B/I/A] Answer 2.2.5: Inserting "&" in Formulas
  • [B/A] Lecture 2.2.6: Inserting "$" in Formulas
  • [B/A] Exercise 2.2.6: Inserting "$" in Formulas
  • [B/A] Answer 2.2.6: Inserting "$" in Formulas
  • [B/I/A] Lecture 2.2.7: Formatting Numbers in Formulas
  • [B/I/A] Exercise 2.2.7: Formatting Numbers in Formulas
  • [B/I/A] Answer 2.2.7: Formatting Numbers in Formulas
  • [B/A] Lecture 2.2.8: Inserting Bar Charts
  • [B/A] Exercise 2.2.8: Inserting Bar Charts
  • [B/A] Answer 2.2.8: Inserting Bar Charts
  • [B/I/A] Lecture 2.2.9: Inserting Pie Charts
  • [B/I/A] Exercise 2.2.9: Inserting Pie Charts
  • [B/I/A] Answer 2.2.9: Inserting Pie Charts
  • [B/I/A] Lecture 2.2.10: Inserting Button Hyperlinks
  • [B/I/A] Exercise 2.2.10: Inserting Button Hyperlinks
  • [B/I/A] Answer 2.2.10: Inserting Button Hyperlinks
  • [B/A] Lecture 2.2.11: Printing
  • [B/A] Exercise 2.2.11: Printing
  • [B/A] Answer 2.2.11: Printing

[B/I/G/A] Section 3.1: Defined Names 101: Simplify Formulas

  • [B/I/G/A] Introduction to Section 3.1: The Bigger Picture of Defined Names
  • [B/I/A] Lecture 3.1.1 How to Use a Defined Name (to Simplify Formulas)
  • [B/I/A] Exercise 3.1.1 How to Use a Defined Name (to Simplify Formulas)
  • [B/I/A] Answer 3.1.1 How to Use a Defined Name (to Simplify Formulas)
  • [B/I/A] Lecture 3.1.2 How to Change Defined Names
  • [B/I/A] Exercise 3.1.2 How to Change Defined Names
  • [B/I/A] Answer 3.1.2 How to Change Defined Names
  • [I/G/A] Lecture 3.1.3 Advanced Defined Names
  • [I/G/A] Exercise 3.1.3 Advanced Defined Names
  • [I/G/A] Answer 3.1.3 Advanced Defined Names

[B/I/G/A] Section 3.2: Formulas 101: SUM, NPV & More

  • [B/I/A] Introduction to Section 3.2: The Bigger Picture of Formula Creation
  • [B/A] Lecture 3.2.1 How Excel Helps with Basic Formula Creation
  • [B/A] Exercise 3.2.1 How Excel Helps with Basic Formula Creation
  • [B/A] Answer 3.2.1 How Excel Helps with Basic Formula Creation
  • [B/A] Lecture 3.2.2 Beginner Level Formulas
  • [B/A] Exercise 3.2.2 Beginner Level Formulas
  • [B/A] Answer 3.2.2 Beginner Level Formulas
  • [I/A] Lecture 3.2.3 Intermediate Level Formulas
  • [I/A] Exercise 3.2.3 Intermediate Level Formulas
  • [I/A] Answer 3.2.3 Intermediate Formulas
  • [G/A] Lecture 3.2.4 Genius Level Formulas
  • [G/A] Exercise 3.2.4 Genius Level Formulas
  • [G/A] Answer 3.2.4 Genius Level Formulas
  • [G/A] Lecture 3.2.5 Using Formulas in VBA
  • [G/A] Exercise 3.2.5 Using Formulas in VBA
  • [G/A] Answer 3.2.5 Using Formulas in VBA
  • [B/I/G/A] Lecture 3.2.6 Case Studies on Using Formulas
  • [B/I/G/A] Exercise 3.2.6 Case Studies on Using Formulas
  • [B/I/G/A] Answer 3.2.6 Case Studies on Using Formulas

[B/I/A] Section 4.1: Charts 101: Bar, Pie, Map and More

  • [B/I/A] Introduction to Section 4.1: The Bigger Picture of Charts
  • [B/A] Lecture 4.1.1 How Excel Helps with Basic Charts Creation
  • [B/A] Exercise 4.1.1 How Excel Helps with Basic Charts Creation
  • [B/A] Answer 4.1.1 How Excel Helps with Basic Charts Creation
  • [B/A] Lecture 4.1.2 Basic Charts Creation (Without Help from Excel)
  • [B/A] Exercise 4.1.2 Basic Charts Creation (Without Help from Excel)
  • [B/A] Answer 4.1.2 Basic Charts Creation (Without Help from Excel)
  • [I/A] Lecture 4.1.3 Advanced Charts Creation (Case Studies)
  • [I/A] Exercise 4.1.3 Advanced Charts Creation (Case Studies)
  • [I/A] Answer 4.1.3 Advanced Charts Creation (Case Studies)

[I/G/A] Section 4.2: Pivot Tables 101: Analyze Data

  • [I/G/A] Introduction to Section 4.2: The Bigger Picture of Pivot Tables
  • [I/G/A] Lesson 4.2.1 How to Create a Basic Pivot Table
  • [I/G/A] Exercise 4.2.1 How to Create a Basic Pivot Table
  • [I/G/A] Answer 4.2.1 How to Create a Basic Pivot Table
  • [I/G/A] Lesson 4.2.2 How to Create an Advanced Pivot Table
  • [I/G/A] Exercise 4.2.2 How to Create an Advanced Pivot Table
  • [I/G/A] Answer 4.2.2 How to Create an Advanced Pivot Table
  • [I/G/A] Lesson 4.2.3 How to Create an Even More Advanced Pivot Table
  • [I/G/A] Exercise 4.2.3 How to Create an Even More Advanced Pivot Table
  • [I/G/A] Answer 4.2.3 How to Create an Even More Advanced Pivot Table

[I/G/A] Section 4.3: Dashboards 101: Includes Reports

  • [I/G/A] Introduction to Section 4.3: The Bigger Picture of Dashboards
  • [I/G/A] Lecture 4.3.1 Global GDP Dashboard Case Study
  • [I/G/A] Exercise 4.3.1 Global GDP Dashboard Case Study
  • [I/G/A] Answer 4.3.1 Global GDP Dashboard Case Study
  • [I/G/A] Lecture 4.3.2 Billionaires Dashboard Case Study
  • [I/G/A] Exercise 4.3.2 Billionaires Dashboard Case Study
  • [I/G/A] Answer 4.3.2 Billionaires Dashboard Case Study
  • [I/G/A] Lecture 4.3.3 Many Dashboards/Reports Case Studies
  • [I/G/A] Exercise 4.3.3 Many Dashboards/Reports Case Studies
  • [I/G/A] Answer 4.3.3 Many Dashboards/Reports Case Studies

[G/A] Section 5: Programming Using Visual Basic for Applications, Macros and Controls

  • [G/A] Section 5 Introduction: What, Why & How We Will Learn Programming

[G/A] Section 5.1: Programming Part 1: Creating Our First Macro

  • [G/A] Introduction to Section 5.1: Creating Our First Macro
  • [G/A] Lecture 5.1.1 How to Record a Macro
  • [G/A] Exercise 5.1.1 How to Record a Macro
  • [G/A] Answer 5.1.1 How to Record a Macro
  • [G/A] Lecture 5.1.2 How to Run a Macro
  • [G/A] Exercise 5.1.2 How to Run a Macro
  • [G/A] Answer 5.1.2 How to Run a Macro
  • [G/A] Lecture 5.1.3: Creating a Shortcut Key for Your Macro
  • [G/A] Exercise 5.1.3: Creating a Shortcut Key for Your Macro
  • [G/A] Answer 5.1.3 Creating a Shortcut Key for Your Macro
  • [G/A] Exercise 5.1.4: Changing the Code the Macro Created
  • [G/A] Answer 5.1.4: Changing the Code the Macro Created
  • [G/A] Lecture 5.1.5: Adding Buttons & Other Controls
  • [G/A] Exercise 5.1.5: Adding Buttons & Other Controls
  • [G/A] Answer 5.1.5: Adding Buttons & Other Controls

[G/A] Section 5.2: Programming Part 2: Creating Our First Function

  • [G/A] Introduction to Section 5.2: Creating Our First Function
  • [G/A] Lecture 5.2.1: How to Create a Function
  • [G/A] Exercise 5.2.1 How to Create a Function
  • [G/A] Answer 5.2.1: How to Create a Function
  • [G/A] Lecture 5.2.2: How to Call a Function within our Sub (Code)
  • [G/A] Exercise 5.2.2: How to Call a Function within our Sub (Code)
  • [G/A] Answer 5.2.2 How to Call a Function within our Sub (Code)

[G/A] Section 5.3: Programming Part 3: Understanding the VB Interface & Objects

  • [G/A] Introduction to Section 5.3: Understanding the VB Interface & Objects
  • [G/A] Lecture 5.3.1: Modules Contain Subs and Functions
  • [G/A] Exercise 5.3.1: Modules Contain Subs and Functions
  • [G/A] Answer 5.3.1: Modules Contain Subs and Functions
  • [G/A] Lecture 5.3.2: Projects Contain Modules
  • [G/A] Exercise 5.3.2: Projects Contain Modules
  • [G/A] Answer 5.3.2: Projects Contain Modules
  • [G/A] Lecture 5.3.3: Objects Go In Subs and Functions
  • [G/A] Exercise 5.3.3: Objects Go In Subs and Functions)
  • [G/A] Answer 5.3.3: Objects Go In Subs and Functions
  • [G/A] Lecture 5.3.4: Objects are Containers for Smaller Objects
  • [G/A] Exercise 5.3.4: Objects are Containers for Smaller Objects
  • [G/A] Answer 5.3.4: Objects are Containers for Smaller Objects
  • [G/A] Lecture 5.3.5: Objects Have Properties
  • [G/A] Exercise 5.3.5: Objects Have Properties
  • [G/A] Answer 5.3.5: Objects Have Properties
  • [G/A] Lecture 5.3.6: Properties Have Values
  • [G/A] Exercise 5.3.6: Properties Have Values
  • [G/A] Answer 5.3.6: Properties Have Values
  • [G/A] Lecture 5.3.7: Objects Have Methods
  • [G/A] Exercise 5.3.7: Objects Have Methods
  • [G/A] Answer 5.3.7: Objects Have Methods
  • [G/A] Lecture 5.3.8: Methods Perform An Action
  • [G/A] Exercise 5.3.8: Methods Perform An Action
  • [G/A] Answer 5.3.8: Methods Perform An Action
  • [G/A] Lecture 5.3.9: Objects in More Detail
  • [G/A] Exercise 5.3.9: Objects in More Detail
  • [G/A] Answer 5.3.9: Objects in More Detail

[G/A] Section 5.4: Programming Part 4: Data Types & Coding Structures

  • [G/A] Introduction to Section 5.4: Data Types & Coding Structures
  • [G/A] Exercise 5.4.1: Data Types Explained (#s, Text & More)
  • [G/A] Answer 5.4.1: Data Types Explained (#s, Text & More)
  • [G/A] Exercise 5.4.2: Coding Structures (If Then, Case Etc.)
  • [G/A] Answer 5.4.2: Coding Structures (If Then, Case Etc.)

[G/A] Section 5.5: Programming Part 5: Functions & Bugs/Errors

  • [G/A] Introduction to Section 5.5: Functions & Bugs/Errors
  • [G/A] Exercise 5.5.1: Functions Explained (Message Box & More)
  • [G/A] Answer 5.5.1: Functions Explained (Message Box & More)
  • [G/A] Exercise 5.5.2: Bugs & Handling Errors
  • [G/A] Answer 5.5.2: Bugs & Handling Errors

[G/A] Section 5.6: Programming Part 5: Putting It All Together+Additional Topics

  1. [G/A] Introduction to Section 5.6: Putting It All Together & Additional Topics
  2. [G/A] Lecture 5.6.1: Case Study 1: Download Stock Data
  3. [G/A] Exercise 5.6.1: Case Study 1: Download Stock Data
  4. [G/A] Answer 5.6.1: Case Study 1: Download Stock Data
  5. [G/A] Lecture 5.6.2: Case Study 2: ActiveX Form Controls
  6. [G/A] Exercise 5.6.2: Case Study 2: ActiveX Form Controls
  7. [G/A] Answer 5.6.2: Case Study 2: ActiveX Form Controls
  8. [G/A] Lecture 5.6.3: Additional VBA Topics
  9. [G/A] Quiz 5.6.3: Additional VBA Topics
  10. [G/A] Answer 5.6.3 Additional VBA Topics

[B/I/G/A] Section 6: Other Topics (Topics Not Covered in Sections 1 to 5)

  • [B/I/G/A] Introduction to Other Helpful Excel Topics

By the end of this comprehensive course, you will be armed and ready to take your career or business to the next level using Excel. No experience in Excel or with programming is required to take this course. There is a 30 day money back guarantee, so you have nothing to lose and everything to gain.

Thanks,
Chris Haroun


Your Instructor


Chris Haroun
Chris Haroun

Chris has sold more than 1,500,000 of his online business & self-improvement courses in 12 languages in 196 countries and his courses have been profiled in Business Insider, NBC, Inc, Forbes, CNN, Entrepreneur & on other business news websites.

Chris is the author of the #1 best-selling online business course called "An Entire MBA in 1 Course®” & more than 50 other courses. He’s the author of the book "101 Crucial Lessons They Don't Teach You in Business School®," which Business Insider wrote is "the most popular book of 2016." Forbes called this book "1 of 6 books that all entrepreneurs must read right now."

He is the founder & CEO of Haroun Education Ventures, an award-winning business school professor, MBA graduate from Columbia University & former Goldman Sachs employee. He has raised/managed over $1bn in his career.

He also has work experience at hedge fund giant Citadel, consulting firm Accenture & several firms that he has started, including an investment firm that had a venture capital investment in Facebook several years before the Facebook IPO.

He is a frequent guest lecturer at several Bay Area MBA schools including Berkeley & Stanford. He also has an undergraduate degree with a major in Management Information Systems & International Business from McGill University where he is a McGill University Dobson Fellow (awarded for his work mentoring students with startup business models).

He has founded several companies & served on the boards of several Bay Area companies & charities, including LEMOfoundation.org & Providing Opportunities for Women. His #1 charitable focus is currently building schools in Rwanda and other countries as well as continuing to provide many scholarships to students all over the world.

He is passionate about education as he believes that all problems can be solved via education. He lives in Hillsborough, California with his wife Christine and 3 sons.


Course Curriculum


  [B/I/A] Section 2: Foundations: Microsoft Excel 101: Create, Edit & More
Available in days
days after you enroll
  [B/I/A] Exercise 2.2: Excel Foundations Part 2: Saving Money
Available in days
days after you enroll
  [G/A] Section 5: Programming Using Visual Basic for Applications, Macros and Controls
Available in days
days after you enroll
  [G/A] Section 5.3: Programming Part 3: Understanding the VB Interface & Objects
Available in days
days after you enroll
  [B/I/G/A] Section 6: Other Topics (Topics Not Covered in Sections 1 to 5)
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!