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 and Macros
Watch Promo
Welcome to the most COMPREHENSIVE Excel course, designed to teach you every single Excel feature, whether you're a beginner or advanced Excel user (no experience with Excel required).
This course is based on my extensive experience using Excel. I have created thousands of Excel documents in my career at Accenture, on Wall Street at Goldman Sachs, and, in the venture capital industry. I've included dashboards and templates so I can help you work smarter and not harder!
There are three ways you can take this course.
If you're new to Excel, follow the Beginner track, which will help you build a strong foundation in Excel before you proceed.
Once you've mastered the basics, follow the Intermediate track to learn techniques like formatting, formulas and creating tables in Excel.
Finally, once you're feeling comfortable with Beginner and Intermediate Excel functions, tackle the Genius track to learn advanced formulas, functions, tables, dashboards and macros to analyze complex data. Of course, you can combine all lessons and take them together if you'd like to achieve true Excel mastery!
After taking this course you will know EVERYTHING about Excel and be able to take your career or business to the next level.
Here's how I'll help you go from zero to hero when it comes to all Excel features:
Excel Foundations
- Text & Number Formatting
- Cell Alignment
- Borders and Shading
- Brief Introduction to Formulas
- Introduction to Conditional Formatting
- Inserting / Editing / Ordering Images & Icons
- Copying Formulas
- Inserting "&" / "$" in Formulas
- Formatting Numbers in Formulas
- Inserting Bar & Pie Charts
- Inserting Button Hyperlinks
Simplifying Formulas With Defined Names:
- How to Use a Defined Name (to Simplify Formulas)
- How to Change Defined Names
- Advanced Defined Names
Formulas 101: SUM, NPV & More
- How Excel Helps with Basic Formula Creation
- Beginner Level Formulas
- Intermediate Formulas
- Genius Level Formulas
- Using Formulas in VBA
- Case Studies & Exercises on Using Formulas
Charts 101: Bar, Pie, Map and More
- How Excel Helps with Basic Charts Creation
- Basic Charts Creation
- Advanced Charts Creation (Case Studies & Exercises)
Pivot Tables 101: Analyze Data
- How to Create a Basic Pivot Table
- How to Create an Advanced Pivot Table
- How to Create an Even More Advanced Pivot Table
Dashboards & Reports
- How To Use Dashboards To Analyze Data
- Global GDP Dashboard Case Study & Exercise
- Billionaires Dashboard Case Study & Exercise
- More Dashboards/Reports Case Studies & Exercises
Using Visual Basic for Applications, Macros and Controls
- Creating Our First Macro
- How to Record a Macro
- How to Run a Macro
- Creating a Shortcut Key for Your Macro
- Changing the Code the Macro Created
- Adding Buttons & Other Controls
Creating Our First Function
- How to Create a Function
- How to Call a Function within our Sub (Code) Exercise
Understanding the VB Interface & Objects
- Understanding The Hierarchy Of Projects, Modules, Subs, & Functions
Data Types & Coding Structures
- Data Types & Coding Structures
Functions & Bugs/Errors
- Functions Explained (Message Box & More)
- Bugs & Handling Errors
Putting It All Together+Additional Topics
- Downloading Stock Data Case Study & Exercise
- ActiveX Form Controls Case Study & Exercise
- Additional VBA Topics Case Study & Exercise
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.
Your Instructor
Chris Haroun is the CEO and Founder of the 300+ hour online Haroun MBA Degree Program®. He has sold more than 2,000,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®” & many 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 start up business models).
He has founded several companies & served on the boards of several Bay Area companies & charities, including The LEMO Foundation & 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. Chris lives in Hillsborough, California with his wife Christine and his 3 sons Andrew, Matthew and Dylan.
Course Curriculum
-
Preview[B/A] Exercise 2.1 Introduction: Excel Foundations Part 1: Money Doubling Exercise (1:32)
-
Start[B/A] Lecture 2.1.1 Text & Number Formatting (4:21)
-
Start[B/A] Exercise 2.1.1 Text & Number Formatting (1:05)
-
Start[B/A] Answer 2.1.1 Text & Number Formatting (0:49)
-
Start[B/A] Lecture 2.1.2: Cell Alignment (2:26)
-
Start[B/A] Exercise 2.1.2: Cell Alignment (0:21)
-
Start[B/A] Answer 2.1.2: Cell Alignment (0:40)
-
Start[B/A] Lecture 2.1.3: Borders and Shading (3:17)
-
Start[B/A] Exercise 2.1.3: Borders and Shading (1:16)
-
Start[B/A] Answer 2.1.3: Borders and Shading (4:01)
-
Start[B/A] Lecture 2.1.4: Introduction to Formulas [We will cover formulas in much more detail in Section 3] (1:37)
-
Start[B/A] Exercise 2.1.4: Introduction to Formulas (0:28)
-
Start[B/A] Answer 2.1.4: Introduction to Formulas (1:10)
-
Start[B/I/A] Lecture 2.1.5: Introduction to Conditional Formatting (2:20)
-
Start[B/I/A] Exercise 2.1.5: Introduction to Conditional Formatting (0:11)
-
Start[B/I/A] Answer 2.1.5: Introduction to Conditional Formatting (0:11)