The Complete Microsoft Excel Course 2026 (Udemy.com)

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