The Complete Microsoft Excel Course (Basics To Programming)

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

What you'll learn

Learn EVERYTHING about Excel (every single feature, icon, function etc.). There are 4 tracks depending on how much experience the student has with Excel.

Go from absolute beginner to expert in this comprehensive course.

In optional lectures, you will learn programming in Excel (assumes the student has no or little programming and Excel experience).

The comprehensive course even includes Macros, Visual Basic for Applications and much more.

Requirements

No prior Excel or programming experience is required to take this course. A version of Microsoft Excel on Windows or on a Mac from 2019 or later is recommended.

Description

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:  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[G/A] Introduction to Section 5.6: Putting It All Together & Additional Topics[G/A] Lecture 5.6.1: Case Study 1: Download Stock Data[G/A] Exercise 5.6.1: Case Study 1: Download Stock Data[G/A] Answer 5.6.1: Case Study 1: Download Stock Data[G/A] Lecture 5.6.2: Case Study 2: ActiveX Form Controls[G/A] Exercise 5.6.2: Case Study 2: ActiveX Form Controls[G/A] Answer 5.6.2: Case Study 2: ActiveX Form Controls[G/A] Lecture 5.6.3: Additional VBA Topics[G/A] Quiz 5.6.3: Additional VBA Topics[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 TopicsBy 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

Overview

Section 1: Section 1: Course Overview, Quick Reference and Resources

Lecture 1 Section 1.1: Introduction & How to Take Course + Selecting a Track

Lecture 2 [B/I/G/A] Section 1.2: Settings and Security

Lecture 3 [B/I/G/A] Section 1.3: Help Videos & More

Lecture 4 [B/I/G/A] Section 1.4: Downloads of Files

Lecture 5 How to Ask me Questions Live on my Weekly Webcast (Includes Zoom)

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

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

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

Lecture 7 [B/A] Exercise 2.1 Intro: Excel Foundations Part 1: Money Doubling Exercise

Lecture 8 [B/A] Lecture 2.1.1 Text & Number Formatting

Lecture 9 [B/A] Exercise 2.1.1 Text & Number Formatting

Lecture 10 [B/A] Answer 2.1.1 Text & Number Formatting

Lecture 11 [B/A] Lecture 2.1.2: Cell Alignment

Lecture 12 [B/A] Exercise 2.1.2: Cell Alignment

Lecture 13 [B/A] Answer 2.1.2: Cell Alignment

Lecture 14 [B/A] Lecture 2.1.3: Borders and Shading

Lecture 15 [B/A] Exercise 2.1.3: Borders and Shading

Lecture 16 [B/A] Answer 2.1.3: Borders and Shading

Lecture 17 [B/A] Lecture 2.1.4: Intro to Formulas [Covered in more detail in Section 3]

Lecture 18 [B/A] Exercise 2.1.4: Introduction to Formulas

Lecture 19 [B/A] Answer 2.1.4: Introduction to Formulas

Lecture 20 [B/I/A] Lecture 2.1.5: Introduction to Conditional Formatting

Lecture 21 [B/I/A] Exercise 2.1.5: Introduction to Conditional Formatting

Lecture 22 [B/I/A] Answer 2.1.5: Introduction to Conditional Formatting

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

Lecture 23 [B/A] Exercise 2.2 Introduction: Excel Foundations Part 2: Saving Money

Lecture 24 [B/A] Lecture 2.2.1: Inserting & Editing Images

Lecture 25 [B/A] Exercise 2.2.1: Inserting & Editing Images

Lecture 26 [B/A] Answer 2.2.1: Inserting & Editing Images

Lecture 27 [B/A] Lecture 2.2.2: Inserting & Editing Icons

Lecture 28 [B/A] Exercise 2.2.2: Inserting & Editing Icons

Lecture 29 [B/A] Answer 2.2.2: Inserting & Editing Icons

Lecture 30 [B/I/A] Lecture 2.2.3: Ordering Images

Lecture 31 [B/I/A] Exercise 2.2.3: Ordering Images

Lecture 32 [B/I/A] Answer 2.2.3: Ordering Images

Lecture 33 [B/A] Lecture 2.2.4: Copying Formulas

Lecture 34 [B/A] Exercise 2.2.4: Copying Formulas

Lecture 35 [B/A] Answer 2.2.4: Copying Formulas

Lecture 36 [B/I/A] Lecture 2.2.5: Inserting "&" in Formulas

Lecture 37 [B/I/A] Exercise 2.2.5: Inserting "&" in Formulas

Lecture 38 [B/I/A] Answer 2.2.5: Inserting "&" in Formulas

Lecture 39 [B/A] Lecture 2.2.6: Inserting "$" in Formulas

Lecture 40 [B/A] Exercise 2.2.6: Inserting "$" in Formulas

Lecture 41 [B/A] Answer 2.2.6: Inserting "$" in Formulas

Lecture 42 [B/I/A] Lecture 2.2.7: Formatting Numbers in Formulas

Lecture 43 [B/I/A] Exercise 2.2.7: Formatting Numbers in Formulas

Lecture 44 [B/I/A] Answer 2.2.7: Formatting Numbers in Formulas

Lecture 45 [B/A] Lecture 2.2.8: Inserting Bar Charts

Lecture 46 [B/A] Exercise 2.2.8: Inserting Bar Charts

Lecture 47 [B/A] Answer 2.2.8: Inserting Bar Charts

Lecture 48 [B/I/A] Lecture 2.2.9: Inserting Pie Charts

Lecture 49 [B/I/A] Exercise 2.2.9: Inserting Pie Charts

Lecture 50 [B/I/A] Answer 2.2.9: Inserting Pie Charts

Lecture 51 [B/I/A] Lecture 2.2.10: Inserting Button Hyperlinks

Lecture 52 [B/I/A] Exercise 2.2.10: Inserting Button Hyperlinks

Lecture 53 [B/I/A] Answer 2.2.10: Inserting Button Hyperlinks

Lecture 54 [B/A] Lecture 2.2.11: Printing

Lecture 55 [B/A] Exercise 2.2.11: Printing

Lecture 56 [B/A] Answer 2.2.11: Printing

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

Lecture 57 [B/I/G/A] Introduction to Section 3.1: The Bigger Picture of Defined Names

Lecture 58 [B/I/A] Lecture 3.1.1 How to Use a Defined Name (to Simplify Formulas)

Lecture 59 [B/I/A] Exercise 3.1.1 How to Use a Defined Name (to Simplify Formulas)

Lecture 60 [B/I/A] Answer 3.1.1 How to Use a Defined Name (to Simplify Formulas)

Lecture 61 [B/I/A] Lecture 3.1.2 How to Change Defined Names

Lecture 62 [B/I/A] Exercise 3.1.2 How to Change Defined Names

Lecture 63 [B/I/A] Answer 3.1.2 How to Change Defined Names

Lecture 64 [I/G/A] Lecture 3.1.3 Advanced Defined Names

Lecture 65 [I/G/A] Exercise 3.1.3 Advanced Defined Names

Lecture 66 [I/G/A] Answer 3.1.3 Advanced Defined Names

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

Lecture 67 [B/I/A] Introduction to Section 3.2: The Bigger Picture of Formula Creation

Lecture 68 [B/A] Lecture 3.2.1 How Excel Helps with Basic Formula Creation

Lecture 69 [B/A] Exercise 3.2.1 How Excel Helps with Basic Formula Creation

Lecture 70 [B/A] Answer 3.2.1 How Excel Helps with Basic Formula Creation

Lecture 71 [B/A] Lecture 3.2.2 Beginner Level Formulas

Lecture 72 [B/A] Exercise 3.2.2 Beginner Level Formulas

Lecture 73 [B/A] Answer 3.2.2 Beginner Level Formulas

Lecture 74 [I/A] Lecture 3.2.3 Intermediate Level Formulas

Lecture 75 [I/A] Exercise 3.2.3 Intermediate Level Formulas

Lecture 76 [I/A] Answer 3.2.3 Intermediate Formulas

Lecture 77 [G/A] Lecture 3.2.4 Genius Level Formulas

Lecture 78 [G/A] Exercise 3.2.4 Genius Level Formulas

Lecture 79 [G/A] Answer 3.2.4 Genius Level Formulas

Lecture 80 [G/A] Lecture 3.2.5 Using Formulas in VBA

Lecture 81 [G/A] Exercise 3.2.5 Using Formulas in VBA

Lecture 82 [G/A] Answer 3.2.5 Using Formulas in VBA

Lecture 83 [B/I/G/A] Lecture 3.2.6 Case Studies on Using Formulas

Lecture 84 [B/I/G/A] Exercise 3.2.6 Case Studies on Using Formulas

Lecture 85 [B/I/G/A] Answer 3.2.6 Case Studies on Using Formulas

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

Lecture 86 [B/I/A] Introduction to Section 4.1: The Bigger Picture of Charts

Lecture 87 [B/A] Lecture 4.1.1 How Excel Helps with Basic Charts Creation

Lecture 88 [B/A] Exercise 4.1.1 How Excel Helps with Basic Charts Creation

Lecture 89 [B/A] Answer 4.1.1 How Excel Helps with Basic Charts Creation

Lecture 90 [B/A] Lecture 4.1.2 Basic Charts Creation (Without Help from Excel)

Lecture 91 [B/A] Exercise 4.1.2 Basic Charts Creation (Without Help from Excel)

Lecture 92 [B/A] Answer 4.1.2 Basic Charts Creation (Without Help from Excel)

Lecture 93 [I/A] Lecture 4.1.3 Advanced Charts Creation (Case Studies)

Lecture 94 [I/A] Exercise 4.1.3 Advanced Charts Creation (Case Studies)

Lecture 95 [I/A] Answer 4.1.3 Advanced Charts Creation (Case Studies)

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

Lecture 96 [I/G/A] Introduction to Section 4.2: The Bigger Picture of Pivot Tables

Lecture 97 [I/G/A] Lesson 4.2.1 How to Create a Basic Pivot Table

Lecture 98 [I/G/A] Exercise 4.2.1 How to Create a Basic Pivot Table

Lecture 99 [I/G/A] Answer 4.2.1 How to Create a Basic Pivot Table

Lecture 100 [I/G/A] Lesson 4.2.2 How to Create an Advanced Pivot Table

Lecture 101 [I/G/A] Exercise 4.2.2 How to Create an Advanced Pivot Table

Lecture 102 [I/G/A] Answer 4.2.2 How to Create an Advanced Pivot Table

Lecture 103 [I/G/A] Lesson 4.2.3 How to Create an Even More Advanced Pivot Table

Lecture 104 [I/G/A] Exercise 4.2.3 How to Create an Even More Advanced Pivot Table

Lecture 105 [I/G/A] Answer 4.2.3 How to Create an Even More Advanced Pivot Table

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

Lecture 106 [I/G/A] Introduction to Section 4.3: The Bigger Picture of Dashboards

Lecture 107 [I/G/A] Lecture 4.3.1 Global GDP Dashboard Case Study

Lecture 108 [I/G/A] Exercise 4.3.1 Global GDP Dashboard Case Study

Lecture 109 [I/G/A] Answer 4.3.1 Global GDP Dashboard Case Study

Lecture 110 [I/G/A] Lecture 4.3.2 Billionaires Dashboard Case Study

Lecture 111 [I/G/A] Exercise 4.3.2 Billionaires Dashboard Case Study

Lecture 112 [I/G/A] Answer 4.3.2 Billionaires Dashboard Case Study

Lecture 113 [I/G/A] Lecture 4.3.3 Many Dashboards/Reports Case Studies

Lecture 114 [I/G/A] Exercise 4.3.3 Many Dashboards/Reports Case Studies

Lecture 115 [I/G/A] Answer 4.3.3 Many Dashboards/Reports Case Studies

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

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

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

Lecture 117 [G/A] Introduction to Section 5.1: Creating Our First Macro

Lecture 118 [G/A] Lecture 5.1.1 How to Record a Macro

Lecture 119 [G/A] Exercise 5.1.1 How to Record a Macro

Lecture 120 [G/A] Answer 5.1.1 How to Record a Macro

Lecture 121 [G/A] Lecture 5.1.2 How to Run a Macro

Lecture 122 [G/A] Exercise 5.1.2 How to Run a Macro

Lecture 123 [G/A] Answer 5.1.2 How to Run a Macro

Lecture 124 [G/A] Lecture 5.1.3: Creating a Shortcut Key for Your Macro

Lecture 125 [G/A] Exercise 5.1.3: Creating a Shortcut Key for Your Macro

Lecture 126 [G/A] Answer 5.1.3 Creating a Shortcut Key for Your Macro

Lecture 127 [G/A] Lecture 5.1.4: Changing the Code the Macro Created

Lecture 128 [G/A] Exercise 5.1.4: Changing the Code the Macro Created

Lecture 129 [G/A] Answer 5.1.4: Changing the Code the Macro Created

Lecture 130 [G/A] Lecture 5.1.5: Adding Buttons & Other Controls

Lecture 131 [G/A] Exercise 5.1.5: Adding Buttons & Other Controls

Lecture 132 [G/A] Answer 5.1.5: Adding Buttons & Other Controls

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

Lecture 133 [G/A] Introduction to Section 5.2: Creating Our First Function

Lecture 134 [G/A] Lecture 5.2.1: How to Create a Function

Lecture 135 [G/A] Exercise 5.2.1 How to Create a Function

Lecture 136 [G/A] Answer 5.2.1: How to Create a Function

Lecture 137 [G/A] Lecture 5.2.2: How to Call a Function within our Sub (Code)

Lecture 138 [G/A] Exercise 5.2.2: How to Call a Function within our Sub (Code)

Lecture 139 [G/A] Answer 5.2.2 How to Call a Function within our Sub (Code)

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

Lecture 140 [G/A] Introduction to Section 5.3: Understanding the VB Interface & Objects

Lecture 141 [G/A] Lecture 5.3.1: Modules Contain Subs and Functions

Lecture 142 [G/A] Exercise 5.3.1: Modules Contain Subs and Functions

Lecture 143 [G/A] Answer 5.3.1: Modules Contain Subs and Functions

Lecture 144 [G/A] Lecture 5.3.2: Projects Contain Modules

Lecture 145 [G/A] Exercise 5.3.2: Projects Contain Modules

Lecture 146 [G/A] Answer 5.3.2: Projects Contain Modules

Lecture 147 [G/A] Lecture 5.3.3: Objects Go In Subs and Functions

Lecture 148 [G/A] Exercise 5.3.3: Objects Go In Subs and Functions)

Lecture 149 [G/A] Answer 5.3.3: Objects Go In Subs and Functions

Lecture 150 [G/A] Lecture 5.3.4: Objects are Containers for Smaller Objects

Lecture 151 [G/A] Exercise 5.3.4: Objects are Containers for Smaller Objects

Lecture 152 [G/A] Answer 5.3.4: Objects are Containers for Smaller Objects

Lecture 153 [G/A] Lecture 5.3.5: Objects Have Properties

Lecture 154 [G/A] Exercise 5.3.5: Objects Have Properties

Lecture 155 [G/A] Answer 5.3.5: Objects Have Properties

Lecture 156 [G/A] Lecture 5.3.6: Properties Have Values

Lecture 157 [G/A] Exercise 5.3.6: Properties Have Values

Lecture 158 [G/A] Answer 5.3.6: Properties Have Values

Lecture 159 [G/A] Lecture 5.3.7: Objects Have Methods

Lecture 160 [G/A] Exercise 5.3.7: Objects Have Methods

Lecture 161 [G/A] Answer 5.3.7: Objects Have Methods

Lecture 162 [G/A] Lecture 5.3.8: Methods Perform An Action

Lecture 163 [G/A] Exercise 5.3.8: Methods Perform An Action

Lecture 164 [G/A] Answer 5.3.8: Methods Perform An Action

Lecture 165 [G/A] Lecture 5.3.9: Objects in More Detail

Lecture 166 [G/A] Exercise 5.3.9: Objects in More Detail

Lecture 167 [G/A] Answer 5.3.9: Objects in More Detail

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

Lecture 168 [G/A] Introduction to Section 5.4: Data Types & Coding Structures Part 1 of 2

Lecture 169 [G/A] Introduction to Section 5.4: Data Types & Coding Structures Part 2 of 2

Lecture 170 [G/A] Exercise 5.4.1: Data Types Explained (#s, Text & More)

Lecture 171 [G/A] Answer 5.4.1: Data Types Explained (#s, Text & More)

Lecture 172 [G/A] Exercise 5.4.2: Coding Structures (If Then, Case Etc.)

Lecture 173 [G/A] Answer 5.4.2: Coding Structures (If Then, Case Etc.)

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

Lecture 174 [G/A] Introduction to Section 5.5: Functions & Bugs/Errors Part 1 of 2

Lecture 175 [G/A] Introduction to Section 5.5: Functions & Bugs/Errors Part 2 of 2

Lecture 176 [G/A] Exercise 5.5.1: Functions Explained (Message Box & More)

Lecture 177 [G/A] Answer 5.5.1: Functions Explained (Message Box & More)

Lecture 178 [G/A] Exercise 5.5.2: Bugs & Handling Errors

Lecture 179 [G/A] Answer 5.5.2: Bugs & Handling Errors

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

Lecture 180 [G/A] Introduction to Section 5.6: Putting It All Together & Additional Topics

Lecture 181 [G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 1 of 5

Lecture 182 [G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 2 of 5

Lecture 183 [G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 3 of 5

Lecture 184 [G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 4 of 5

Lecture 185 [G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 5 of 5

Lecture 186 [G/A] Exercise 5.6.1: Case Study 1: Download Stock Data

Lecture 187 [G/A] Answer 5.6.1: Case Study 1: Download Stock Data

Lecture 188 [G/A] Lecture 5.6.2: Case Study 2: ActiveX Form Controls Part 1 of 2

Lecture 189 [G/A] Lecture 5.6.2: Case Study 2: ActiveX Form Controls Part 2 of 2

Lecture 190 [G/A] Exercise 5.6.2: Case Study 2: ActiveX Form Controls

Lecture 191 [G/A] Answer 5.6.2: Case Study 2: ActiveX Form Controls

Lecture 192 [G/A] Lecture 5.6.3: Additional VBA Topics

Lecture 193 [G/A] Quiz 5.6.3: Additional VBA Topics

Lecture 194 [G/A] Answer 5.6.3 Additional VBA Topics

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

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

Section 18: Bonus Materials

Lecture 196 Bonus Items

This course is for anyone interested in learning beginner, intermediate or advanced Excel skills (and programming concepts is an optional section). This course teaches EVERY Excel feature and is intended for ANYONE that wants to learn Excel. !