The Complete Microsoft Excel Course Basics to Programming
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 Excel 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: [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[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
Section 2: [B/I/A] Introduction to Section 2: Excel 101 Foundations (Basics): Create, Edit
Lecture 5 [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 6 [B/A] Exercise 2.1 Intro: Excel Foundations Part 1: Money Doubling Exercise
Lecture 7 [B/A] Lecture 2.1.1 Text & Number Formatting
Lecture 8 [B/A] Exercise 2.1.1 Text & Number Formatting
Lecture 9 [B/A] Answer 2.1.1 Text & Number Formatting
Lecture 10 [B/A] Lecture 2.1.2: Cell Alignment
Lecture 11 [B/A] Exercise 2.1.2: Cell Alignment
Lecture 12 [B/A] Answer 2.1.2: Cell Alignment
Lecture 13 [B/A] Lecture 2.1.3: Borders and Shading
Lecture 14 [B/A] Exercise 2.1.3: Borders and Shading
Lecture 15 [B/A] Answer 2.1.3: Borders and Shading
Lecture 16 [B/A] Lecture 2.1.4: Intro to Formulas [Covered in more detail in Section 3]
Lecture 17 [B/A] Exercise 2.1.4: Introduction to Formulas
Lecture 18 [B/A] Answer 2.1.4: Introduction to Formulas
Lecture 19 [B/I/A] Lecture 2.1.5: Introduction to Conditional Formatting
Lecture 20 [B/I/A] Exercise 2.1.5: Introduction to Conditional Formatting
Lecture 21 [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 22 [B/A] Exercise 2.2 Introduction: Excel Foundations Part 2: Saving Money
Lecture 23 [B/A] Lecture 2.2.1: Inserting & Editing Images
Lecture 24 [B/A] Exercise 2.2.1: Inserting & Editing Images
Lecture 25 [B/A] Answer 2.2.1: Inserting & Editing Images
Lecture 26 [B/A] Lecture 2.2.2: Inserting & Editing Icons
Lecture 27 [B/A] Exercise 2.2.2: Inserting & Editing Icons
Lecture 28 [B/A] Answer 2.2.2: Inserting & Editing Icons
Lecture 29 [B/I/A] Lecture 2.2.3: Ordering Images
Lecture 30 [B/I/A] Exercise 2.2.3: Ordering Images
Lecture 31 [B/I/A] Answer 2.2.3: Ordering Images
Lecture 32 [B/A] Lecture 2.2.4: Copying Formulas
Lecture 33 [B/A] Exercise 2.2.4: Copying Formulas
Lecture 34 [B/A] Answer 2.2.4: Copying Formulas
Lecture 35 [B/I/A] Lecture 2.2.5: Inserting “&” in Formulas
Lecture 36 [B/I/A] Exercise 2.2.5: Inserting “&” in Formulas
Lecture 37 [B/I/A] Answer 2.2.5: Inserting “&” in Formulas
Lecture 38 [B/A] Lecture 2.2.6: Inserting “$” in Formulas
Lecture 39 [B/A] Exercise 2.2.6: Inserting “$” in Formulas
Lecture 40 [B/A] Answer 2.2.6: Inserting “$” in Formulas
Lecture 41 [B/I/A] Lecture 2.2.7: Formatting Numbers in Formulas
Lecture 42 [B/I/A] Exercise 2.2.7: Formatting Numbers in Formulas
Lecture 43 [B/I/A] Answer 2.2.7: Formatting Numbers in Formulas
Lecture 44 [B/A] Lecture 2.2.8: Inserting Bar Charts
Lecture 45 [B/A] Exercise 2.2.8: Inserting Bar Charts
Lecture 46 [B/A] Answer 2.2.8: Inserting Bar Charts
Lecture 47 [B/I/A] Lecture 2.2.9: Inserting Pie Charts
Lecture 48 [B/I/A] Exercise 2.2.9: Inserting Pie Charts
Lecture 49 [B/I/A] Answer 2.2.9: Inserting Pie Charts
Lecture 50 [B/I/A] Lecture 2.2.10: Inserting Button Hyperlinks
Lecture 51 [B/I/A] Exercise 2.2.10: Inserting Button Hyperlinks
Lecture 52 [B/I/A] Answer 2.2.10: Inserting Button Hyperlinks
Lecture 53 [B/A] Lecture 2.2.11: Printing
Lecture 54 [B/A] Exercise 2.2.11: Printing
Lecture 55 [B/A] Answer 2.2.11: Printing
Section 5: [B/I/G/A] Section 3.1: Defined Names 101: Simplify Formulas
Lecture 56 [B/I/G/A] Introduction to Section 3.1: The Bigger Picture of Defined Names
Lecture 57 [B/I/A] Lecture 3.1.1 How to Use a Defined Name (to Simplify Formulas)
Lecture 58 [B/I/A] Exercise 3.1.1 How to Use a Defined Name (to Simplify Formulas)
Lecture 59 [B/I/A] Answer 3.1.1 How to Use a Defined Name (to Simplify Formulas)
Lecture 60 [B/I/A] Lecture 3.1.2 How to Change Defined Names
Lecture 61 [B/I/A] Exercise 3.1.2 How to Change Defined Names
Lecture 62 [B/I/A] Answer 3.1.2 How to Change Defined Names
Lecture 63 [I/G/A] Lecture 3.1.3 Advanced Defined Names
Lecture 64 [I/G/A] Exercise 3.1.3 Advanced Defined Names
Lecture 65 [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 66 [B/I/A] Introduction to Section 3.2: The Bigger Picture of Formula Creation
Lecture 67 [B/A] Lecture 3.2.1 How Excel Helps with Basic Formula Creation
Lecture 68 [B/A] Exercise 3.2.1 How Excel Helps with Basic Formula Creation
Lecture 69 [B/A] Answer 3.2.1 How Excel Helps with Basic Formula Creation
Lecture 70 [B/A] Lecture 3.2.2 Beginner Level Formulas
Lecture 71 [B/A] Exercise 3.2.2 Beginner Level Formulas
Lecture 72 [B/A] Answer 3.2.2 Beginner Level Formulas
Lecture 73 [I/A] Lecture 3.2.3 Intermediate Level Formulas
Lecture 74 [I/A] Exercise 3.2.3 Intermediate Level Formulas
Lecture 75 [I/A] Answer 3.2.3 Intermediate Formulas
Lecture 76 [G/A] Lecture 3.2.4 Genius Level Formulas
Lecture 77 [G/A] Exercise 3.2.4 Genius Level Formulas
Lecture 78 [G/A] Answer 3.2.4 Genius Level Formulas
Lecture 79 [G/A] Lecture 3.2.5 Using Formulas in VBA
Lecture 80 [G/A] Exercise 3.2.5 Using Formulas in VBA
Lecture 81 [G/A] Answer 3.2.5 Using Formulas in VBA
Lecture 82 [B/I/G/A] Lecture 3.2.6 Case Studies on Using Formulas
Lecture 83 [B/I/G/A] Exercise 3.2.6 Case Studies on Using Formulas
Lecture 84 [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 85 [B/I/A] Introduction to Section 4.1: The Bigger Picture of Charts
Lecture 86 [B/A] Lecture 4.1.1 How Excel Helps with Basic Charts Creation
Lecture 87 [B/A] Exercise 4.1.1 How Excel Helps with Basic Charts Creation
Lecture 88 [B/A] Answer 4.1.1 How Excel Helps with Basic Charts Creation
Lecture 89 [B/A] Lecture 4.1.2 Basic Charts Creation (Without Help from Excel)
Lecture 90 [B/A] Exercise 4.1.2 Basic Charts Creation (Without Help from Excel)
Lecture 91 [B/A] Answer 4.1.2 Basic Charts Creation (Without Help from Excel)
Lecture 92 [I/A] Lecture 4.1.3 Advanced Charts Creation (Case Studies)
Lecture 93 [I/A] Exercise 4.1.3 Advanced Charts Creation (Case Studies)
Lecture 94 [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 95 [I/G/A] Introduction to Section 4.2: The Bigger Picture of Pivot Tables
Lecture 96 [I/G/A] Lesson 4.2.1 How to Create a Basic Pivot Table
Lecture 97 [I/G/A] Exercise 4.2.1 How to Create a Basic Pivot Table
Lecture 98 [I/G/A] Answer 4.2.1 How to Create a Basic Pivot Table
Lecture 99 [I/G/A] Lesson 4.2.2 How to Create an Advanced Pivot Table
Lecture 100 [I/G/A] Exercise 4.2.2 How to Create an Advanced Pivot Table
Lecture 101 [I/G/A] Answer 4.2.2 How to Create an Advanced Pivot Table
Lecture 102 [I/G/A] Lesson 4.2.3 How to Create an Even More Advanced Pivot Table
Lecture 103 [I/G/A] Exercise 4.2.3 How to Create an Even More Advanced Pivot Table
Lecture 104 [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 105 [I/G/A] Introduction to Section 4.3: The Bigger Picture of Dashboards
Lecture 106 [I/G/A] Lecture 4.3.1 Global GDP Dashboard Case Study
Lecture 107 [I/G/A] Exercise 4.3.1 Global GDP Dashboard Case Study
Lecture 108 [I/G/A] Answer 4.3.1 Global GDP Dashboard Case Study
Lecture 109 [I/G/A] Lecture 4.3.2 Billionaires Dashboard Case Study
Lecture 110 [I/G/A] Exercise 4.3.2 Billionaires Dashboard Case Study
Lecture 111 [I/G/A] Answer 4.3.2 Billionaires Dashboard Case Study
Lecture 112 [I/G/A] Lecture 4.3.3 Many Dashboards/Reports Case Studies
Lecture 113 [I/G/A] Exercise 4.3.3 Many Dashboards/Reports Case Studies
Lecture 114 [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 115 [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 116 [G/A] Introduction to Section 5.1: Creating Our First Macro
Lecture 117 [G/A] Lecture 5.1.1 How to Record a Macro
Lecture 118 [G/A] Exercise 5.1.1 How to Record a Macro
Lecture 119 [G/A] Answer 5.1.1 How to Record a Macro
Lecture 120 [G/A] Lecture 5.1.2 How to Run a Macro
Lecture 121 [G/A] Exercise 5.1.2 How to Run a Macro
Lecture 122 [G/A] Answer 5.1.2 How to Run a Macro
Lecture 123 [G/A] Lecture 5.1.3: Creating a Shortcut Key for Your Macro
Lecture 124 [G/A] Exercise 5.1.3: Creating a Shortcut Key for Your Macro
Lecture 125 [G/A] Answer 5.1.3 Creating a Shortcut Key for Your Macro
Lecture 126 [G/A] Lecture 5.1.4: Changing the Code the Macro Created
Lecture 127 [G/A] Exercise 5.1.4: Changing the Code the Macro Created
Lecture 128 [G/A] Answer 5.1.4: Changing the Code the Macro Created
Lecture 129 [G/A] Lecture 5.1.5: Adding Buttons & Other Controls
Lecture 130 [G/A] Exercise 5.1.5: Adding Buttons & Other Controls
Lecture 131 [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 132 [G/A] Introduction to Section 5.2: Creating Our First Function
Lecture 133 [G/A] Lecture 5.2.1: How to Create a Function
Lecture 134 [G/A] Exercise 5.2.1 How to Create a Function
Lecture 135 [G/A] Answer 5.2.1: How to Create a Function
Lecture 136 [G/A] Lecture 5.2.2: How to Call a Function within our Sub (Code)
Lecture 137 [G/A] Exercise 5.2.2: How to Call a Function within our Sub (Code)
Lecture 138 [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 139 [G/A] Introduction to Section 5.3: Understanding the VB Interface & Objects
Lecture 140 [G/A] Lecture 5.3.1: Modules Contain Subs and Functions
Lecture 141 [G/A] Exercise 5.3.1: Modules Contain Subs and Functions
Lecture 142 [G/A] Answer 5.3.1: Modules Contain Subs and Functions
Lecture 143 [G/A] Lecture 5.3.2: Projects Contain Modules
Lecture 144 [G/A] Exercise 5.3.2: Projects Contain Modules
Lecture 145 [G/A] Answer 5.3.2: Projects Contain Modules
Lecture 146 [G/A] Lecture 5.3.3: Objects Go In Subs and Functions
Lecture 147 [G/A] Exercise 5.3.3: Objects Go In Subs and Functions)
Lecture 148 [G/A] Answer 5.3.3: Objects Go In Subs and Functions
Lecture 149 [G/A] Lecture 5.3.4: Objects are Containers for Smaller Objects
Lecture 150 [G/A] Exercise 5.3.4: Objects are Containers for Smaller Objects
Lecture 151 [G/A] Answer 5.3.4: Objects are Containers for Smaller Objects
Lecture 152 [G/A] Lecture 5.3.5: Objects Have Properties
Lecture 153 [G/A] Exercise 5.3.5: Objects Have Properties
Lecture 154 [G/A] Answer 5.3.5: Objects Have Properties
Lecture 155 [G/A] Lecture 5.3.6: Properties Have Values
Lecture 156 [G/A] Exercise 5.3.6: Properties Have Values
Lecture 157 [G/A] Answer 5.3.6: Properties Have Values
Lecture 158 [G/A] Lecture 5.3.7: Objects Have Methods
Lecture 159 [G/A] Exercise 5.3.7: Objects Have Methods
Lecture 160 [G/A] Answer 5.3.7: Objects Have Methods
Lecture 161 [G/A] Lecture 5.3.8: Methods Perform An Action
Lecture 162 [G/A] Exercise 5.3.8: Methods Perform An Action
Lecture 163 [G/A] Answer 5.3.8: Methods Perform An Action
Lecture 164 [G/A] Lecture 5.3.9: Objects in More Detail
Lecture 165 [G/A] Exercise 5.3.9: Objects in More Detail
Lecture 166 [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 167 [G/A] Introduction to Section 5.4: Data Types & Coding Structures Part 1 of 2
Lecture 168 [G/A] Introduction to Section 5.4: Data Types & Coding Structures Part 2 of 2
Lecture 169 [G/A] Exercise 5.4.1: Data Types Explained (#s, Text & More)
Lecture 170 [G/A] Answer 5.4.1: Data Types Explained (#s, Text & More)
Lecture 171 [G/A] Exercise 5.4.2: Coding Structures (If Then, Case Etc.)
Lecture 172 [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 173 [G/A] Introduction to Section 5.5: Functions & Bugs/Errors Part 1 of 2
Lecture 174 [G/A] Introduction to Section 5.5: Functions & Bugs/Errors Part 2 of 2
Lecture 175 [G/A] Exercise 5.5.1: Functions Explained (Message Box & More)
Lecture 176 [G/A] Answer 5.5.1: Functions Explained (Message Box & More)
Lecture 177 [G/A] Exercise 5.5.2: Bugs & Handling Errors
Lecture 178 [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 179 [G/A] Introduction to Section 5.6: Putting It All Together & Additional Topics
Lecture 180 [G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 1 of 5
Lecture 181 [G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 2 of 5
Lecture 182 [G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 3 of 5
Lecture 183 [G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 4 of 5
Lecture 184 [G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 5 of 5
Lecture 185 [G/A] Exercise 5.6.1: Case Study 1: Download Stock Data
Lecture 186 [G/A] Answer 5.6.1: Case Study 1: Download Stock Data
Lecture 187 [G/A] Lecture 5.6.2: Case Study 2: ActiveX Form Controls Part 1 of 2
Lecture 188 [G/A] Lecture 5.6.2: Case Study 2: ActiveX Form Controls Part 2 of 2
Lecture 189 [G/A] Exercise 5.6.2: Case Study 2: ActiveX Form Controls
Lecture 190 [G/A] Answer 5.6.2: Case Study 2: ActiveX Form Controls
Lecture 191 [G/A] Lecture 5.6.3: Additional VBA Topics
Lecture 192 [G/A] Quiz 5.6.3: Additional VBA Topics
Lecture 193 [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 194 [B/I/G/A] Introduction to Other Helpful Excel Topics
Section 18: Bonus Materials
Lecture 195 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. !
Course Information:
Udemy | English | 13h 39m | 13.11 GB
Created by: Chris Haroun
You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com