How I Made the Section 3.2 Formulas 101 Tab

The Complete Microsoft Excel Course Including How to Program in Excel

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) (20:31)
[B/I/G/A] Section 1.2: Settings and Security (3:45)
[B/I/G/A] Section 1.3: Help Videos & More (12:08)
[B/I/G/A] Section 1.4: Downloads of Files (1:12)

[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 (3:11)

[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 (1:32)
[B/A] Lecture 2.1.1 Text & Number Formatting (4:21)
[B/A] Exercise 2.1.1 Text & Number Formatting (1:05)
[B/A] Answer 2.1.1 Text & Number Formatting (0:49)
[B/A] Lecture 2.1.2: Cell Alignment (2:26)
[B/A] Exercise 2.1.2: Cell Alignment (0:21)
[B/A] Answer 2.1.2: Cell Alignment (0:40)
[B/A] Lecture 2.1.3: Borders and Shading (3:17)
[B/A] Exercise 2.1.3: Borders and Shading (1:16)
[B/A] Answer 2.1.3: Borders and Shading (4:01)
[B/A] Lecture 2.1.4: Introduction to Formulas [We will cover formulas in much more detail in Section 3] (1:37)
[B/A] Exercise 2.1.4: Introduction to Formulas (0:28)
[B/A] Answer 2.1.4: Introduction to Formulas (1:10)
[B/I/A] Lecture 2.1.5: Introduction to Conditional Formatting (2:20)
[B/I/A] Exercise 2.1.5: Introduction to Conditional Formatting (0:11)
[B/I/A] Answer 2.1.5: Introduction to Conditional Formatting (0:11)

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

[B/A] Exercise 2.2 Introduction: Excel Foundations Part 2: Saving Money (3:47)
[B/A] Lecture 2.2.1: Inserting & Editing Images (7:18)
[B/A] Exercise 2.2.1: Inserting & Editing Images (1:30)
[B/A] Answer 2.2.1: Inserting & Editing Images (5:43)
[B/A] Lecture 2.2.2: Inserting & Editing Icons (1:59)
[B/A] Exercise 2.2.2: Inserting & Editing Icons (0:54)
[B/A] Answer 2.2.2: Inserting & Editing Icons (2:59)
[B/I/A] Lecture 2.2.3: Ordering Images (9:30)
[B/I/A] Exercise 2.2.3: Ordering Images (0:21)
[B/I/A] Answer 2.2.3: Ordering Images (0:58)
[B/A] Lecture 2.2.4: Copying Formulas (2:41)
[B/A] Exercise 2.2.4: Copying Formulas (0:33)
[B/A] Answer 2.2.4: Copying Formulas (0:19)
[B/I/A] Lecture 2.2.5: Inserting "&" in Formulas (2:58)
[B/I/A] Exercise 2.2.5: Inserting "&" in Formulas (0:58)
[B/I/A] Answer 2.2.5: Inserting "&" in Formulas (0:50)
[B/A] Lecture 2.2.6: Inserting "$" in Formulas (7:30)
[B/A] Exercise 2.2.6: Inserting "$" in Formulas (1:44)
[B/A] Answer 2.2.6: Inserting "$" in Formulas (1:06)
[B/I/A] Lecture 2.2.7: Formatting Numbers in Formulas (3:34)
[B/I/A] Exercise 2.2.7: Formatting Numbers in Formulas (1:01)
[B/I/A] Answer 2.2.7: Formatting Numbers in Formulas (2:52)
[B/A] Lecture 2.2.8: Inserting Bar Charts (2:14)
[B/A] Exercise 2.2.8: Inserting Bar Charts (0:19)
[B/A] Answer 2.2.8: Inserting Bar Charts (1:34)
[B/I/A] Lecture 2.2.9: Inserting Pie Charts (1:16)
[B/I/A] Exercise 2.2.9: Inserting Pie Charts (0:30)
[B/I/A] Answer 2.2.9: Inserting Pie Charts (1:49)
[B/I/A] Lecture 2.2.10: Inserting Button Hyperlinks (3:21)
[B/I/A] Exercise 2.2.10: Inserting Button Hyperlinks (0:50)
[B/I/A] Answer 2.2.10: Inserting Button Hyperlinks (2:57)
[B/A] Lecture 2.2.11: Printing (1:40)
[B/A] Exercise 2.2.11: Printing (1:11)
[B/A] Answer 2.2.11: Printing (2:02)

[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 (1:09)
[B/I/A] Lecture 3.1.1 How to Use a Defined Name (to Simplify Formulas) (10:23)
[B/I/A] Exercise 3.1.1 How to Use a Defined Name (to Simplify Formulas) (1:37)
[B/I/A] Answer 3.1.1 How to Use a Defined Name (to Simplify Formulas) (3:36)
[B/I/A] Lecture 3.1.2 How to Change Defined Names (6:14)
[B/I/A] Exercise 3.1.2 How to Change Defined Names (1:47)
[B/I/A] Answer 3.1.2 How to Change Defined Names (2:23)
[I/G/A] Lecture 3.1.3 Advanced Defined Names (4:56)
[I/G/A] Exercise 3.1.3 Advanced Defined Names (1:53)
[I/G/A] Answer 3.1.3 Advanced Defined Names (5:16)

[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 (0:56)
[B/A] Lecture 3.2.1 How Excel Helps with Basic Formula Creation (4:58)
[B/A] Exercise 3.2.1 How Excel Helps with Basic Formula Creation (0:43)
[B/A] Answer 3.2.1 How Excel Helps with Basic Formula Creation (1:20)
[B/A] Lecture 3.2.2 Beginner Level Formulas (11:29)
[B/A] Exercise 3.2.2 Beginner Level Formulas (0:43)
[B/A] Answer 3.2.2 Beginner Level Formulas (1:00)
[I/A] Lecture 3.2.3 Intermediate Level Formulas (11:55)
[I/A] Exercise 3.2.3 Intermediate Level Formulas (0:58)
[I/A] Answer 3.2.3 Intermediate Formulas (1:24)
[G/A] Lecture 3.2.4 Genius Level Formulas (10:44)
[G/A] Exercise 3.2.4 Genius Level Formulas (0:56)
[G/A] Answer 3.2.4 Genius Level Formulas (3:19)
[G/A] Lecture 3.2.5 Using Formulas in VBA (3:09)
[G/A] Exercise 3.2.5 Using Formulas in VBA (0:29)
[G/A] Answer 3.2.5 Using Formulas in VBA (1:04)
[B/I/G/A] Lecture 3.2.6 Case Studies on Using Formulas (9:15)
[B/I/G/A] Exercise 3.2.6 Case Studies on Using Formulas (0:43)
[B/I/G/A] Answer 3.2.6 Case Studies on Using Formulas (3:53)

[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 (0:47)
[B/A] Lecture 4.1.1 How Excel Helps with Basic Charts Creation (4:49)
[B/A] Exercise 4.1.1 How Excel Helps with Basic Charts Creation (1:11)
[B/A] Answer 4.1.1 How Excel Helps with Basic Charts Creation (1:02)
[B/A] Lecture 4.1.2 Basic Charts Creation (Without Help from Excel) (9:30)
[B/A] Exercise 4.1.2 Basic Charts Creation (Without Help from Excel) (1:30)
[B/A] Answer 4.1.2 Basic Charts Creation (Without Help from Excel) (4:45)
[I/A] Lecture 4.1.3 Advanced Charts Creation (Case Studies) (11:14)
[I/A] Exercise 4.1.3 Advanced Charts Creation (Case Studies) (1:18)
[I/A] Answer 4.1.3 Advanced Charts Creation (Case Studies) (4:40)

[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 (1:35)
[I/G/A] Lesson 4.2.1 How to Create a Basic Pivot Table (10:55)
[I/G/A] Exercise 4.2.1 How to Create a Basic Pivot Table (1:07)
[I/G/A] Answer 4.2.1 How to Create a Basic Pivot Table (4:06)
[I/G/A] Lesson 4.2.2 How to Create an Advanced Pivot Table (12:38)
[I/G/A] Exercise 4.2.2 How to Create an Advanced Pivot Table (1:46)
[I/G/A] Answer 4.2.2 How to Create an Advanced Pivot Table (5:23)
[I/G/A] Lesson 4.2.3 How to Create an Even More Advanced Pivot Table (7:22)
[I/G/A] Exercise 4.2.3 How to Create an Even More Advanced Pivot Table (1:53)
[I/G/A] Answer 4.2.3 How to Create an Even More Advanced Pivot Table (10:13)

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

[I/G/A] Introduction to Section 4.3: The Bigger Picture of Dashboards (1:49)
[I/G/A] Lecture 4.3.1 Global GDP Dashboard Case Study (8:50)
[I/G/A] Exercise 4.3.1 Global GDP Dashboard Case Study (1:01)
[I/G/A] Answer 4.3.1 Global GDP Dashboard Case Study (3:11)
[I/G/A] Lecture 4.3.2 Billionaires Dashboard Case Study (7:18)
[I/G/A] Exercise 4.3.2 Billionaires Dashboard Case Study (1:22)
[I/G/A] Answer 4.3.2 Billionaires Dashboard Case Study (6:28)
[I/G/A] Lecture 4.3.3 Many Dashboards/Reports Case Studies (17:47)
[I/G/A] Exercise 4.3.3 Many Dashboards/Reports Case Studies (0:38)
[I/G/A] Answer 4.3.3 Many Dashboards/Reports Case Studies (11:23)

[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 (9:06)

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

[G/A] Introduction to Section 5.1: Creating Our First Macro (2:26)
[G/A] Lecture 5.1.1 How to Record a Macro (6:28)
[G/A] Exercise 5.1.1 How to Record a Macro (1:10)
[G/A] Answer 5.1.1 How to Record a Macro (1:05)
[G/A] Lecture 5.1.2 How to Run a Macro (0:36)
[G/A] Exercise 5.1.2 How to Run a Macro (0:25)
[G/A] Answer 5.1.2 How to Run a Macro (0:18)
[G/A] Lecture 5.1.3: Creating a Shortcut Key for Your Macro (1:02)
[G/A] Exercise 5.1.3: Creating a Shortcut Key for Your Macro (0:25)
[G/A] Answer 5.1.3 Creating a Shortcut Key for Your Macro (0:28)
[G/A] Lecture 5.1.4: Changing the Code the Macro Created (9:54)
[G/A] Exercise 5.1.4: Changing the Code the Macro Created (1:19)
[G/A] Answer 5.1.4: Changing the Code the Macro Created (1:34)
[G/A] Lecture 5.1.5: Adding Buttons & Other Controls (10:18)
[G/A] Exercise 5.1.5: Adding Buttons & Other Controls (2:00)
[G/A] Answer 5.1.5: Adding Buttons & Other Controls (3:48)

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

[G/A] Introduction to Section 5.2: Creating Our First Function (2:03)
[G/A] Lecture 5.2.1: How to Create a Function (3:32)
[G/A] Exercise 5.2.1 How to Create a Function (0:57)
[G/A] Answer 5.2.1: How to Create a Function (1:18)
[G/A] Lecture 5.2.2: How to Call a Function within our Sub (Code) (3:40)
[G/A] Exercise 5.2.2: How to Call a Function within our Sub (Code) (1:16)
[G/A] Answer 5.2.2 How to Call a Function within our Sub (Code) (1:21)

[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 (2:36)
[G/A] Lecture 5.3.1: Modules Contain Subs and Functions (12:09)
[G/A] Exercise 5.3.1: Modules Contain Subs and Functions (1:32)
[G/A] Answer 5.3.1: Modules Contain Subs and Functions (3:03)
[G/A] Lecture 5.3.2: Projects Contain Modules (7:08)
[G/A] Exercise 5.3.2: Projects Contain Modules (0:36)
[G/A] Answer 5.3.2: Projects Contain Modules (5:28)
[G/A] Lecture 5.3.3: Objects Go In Subs and Functions (14:22)
[G/A] Exercise 5.3.3: Objects Go In Subs and Functions) (1:53)
[G/A] Answer 5.3.3: Objects Go In Subs and Functions (2:33)
[G/A] Lecture 5.3.4: Objects are Containers for Smaller Objects (5:58)
[G/A] Exercise 5.3.4: Objects are Containers for Smaller Objects (1:02)
[G/A] Answer 5.3.4: Objects are Containers for Smaller Objects (2:33)
[G/A] Lecture 5.3.5: Objects Have Properties (5:22)
[G/A] Exercise 5.3.5: Objects Have Properties (0:45)
[G/A] Answer 5.3.5: Objects Have Properties (1:50)
[G/A] Lecture 5.3.6: Properties Have Values (2:28)
[G/A] Answer 5.3.6: Properties Have Values (3:58)
[G/A] Exercise 5.3.6: Properties Have Values (0:29)
[G/A] Lecture 5.3.7: Objects Have Methods (2:42)
[G/A] Exercise 5.3.7: Objects Have Methods (0:26)
[G/A] Answer 5.3.7: Objects Have Methods (1:04)
[G/A] Lecture 5.3.8: Methods Perform An Action (2:57)
[G/A] Exercise 5.3.8: Methods Perform An Action (1:40)
[G/A] Answer 5.3.8: Methods Perform An Action (1:44)
[G/A] Lecture 5.3.9: Objects in More Detail (5:22)
[G/A] Exercise 5.3.9: Objects in More Detail (2:16)
[G/A] Answer 5.3.9: Objects in More Detail (4:59)

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

[G/A] Introduction to Section 5.4: Data Types & Coding Structures Part 1 of 2 (18:48)
[G/A] Introduction to Section 5.4: Data Types & Coding Structures Part 2 of 2 (11:22)
[G/A] Exercise 5.4.1: Data Types Explained (#s, Text & More) (1:06)
[G/A] Answer 5.4.1: Data Types Explained (#s, Text & More) (2:07)
[G/A] Exercise 5.4.2: Coding Structures (If Then, Case Etc.) (0:33)
[G/A] Answer 5.4.2: Coding Structures (If Then, Case Etc.) (1:54)

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

[G/A] Introduction to Section 5.5: Functions & Bugs/Errors Part 1 of 2 (17:14)
[G/A] Introduction to Section 5.5: Functions & Bugs/Errors Part 2 of 2 (18:08)
[G/A] Exercise 5.5.1: Functions Explained (Message Box & More) (0:54)
[G/A] Answer 5.5.1: Functions Explained (Message Box & More) (7:51)
[G/A] Exercise 5.5.2: Bugs & Handling Errors (0:39)
[G/A] Answer 5.5.2: Bugs & Handling Errors (3:41)

[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 (1:44)
[G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 1 of 5 (19:05)
[G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 2 of 5 (19:04)
[G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 3 of 5 (14:39)
[G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 4 of 5 (11:53)
[G/A] Lecture 5.6.1: Case Study 1: Download Stock Data Part 5 of 5 (13:57)
[G/A] Exercise 5.6.1: Case Study 1: Download Stock Data (0:34)
[G/A] Answer 5.6.1: Case Study 1: Download Stock Data (11:08)
[G/A] Lecture 5.6.2: Case Study 2: ActiveX Form Controls Part 1 of 2 (19:38)
[G/A] Lecture 5.6.2: Case Study 2: ActiveX Form Controls Part 2 of 2 (18:02)
[G/A] Exercise 5.6.2: Case Study 2: ActiveX Form Controls (0:22)
[G/A] Answer 5.6.2: Case Study 2: ActiveX Form Controls (4:01)
[G/A] Lecture 5.6.3: Additional VBA Topics (11:42)
[G/A] Quiz 5.6.3: Additional VBA Topics (0:29)
[G/A] Answer 5.6.3 Additional VBA Topics (2:32)

[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 (1:56)

How I Made Each Tab

How I Made the Section 1.1 Course Introduction Tab_Part 1 (18:35)
How I Made the Section 1.1 Course Introduction Tab_Part 2 (7:54)
How I Made the Section 1.1 Course Introduction Tab_Part 3 (14:16)
How I Made the Section 1.2 Settings & Security Tab (8:26)
How I Made the Section 1.3 Help Vids,Index etc Tab (11:31)
How I Made the Section 1.4 Downloads of Files Tab (0:36)
How I Made the Section 2 Foundations Tab (2:41)
How I Made the Section 3.1 Defined Names Tab (1:54)
How I Made the Section 3.2 Formulas 101 Tab (2:08)
How I Made the Section 4.1 Charts Tab (2:10)
How I Made the Section 4.2 Pivot Tables Tab (1:43)
How I Made the Section 4.3 Dashboards Tab (1:58)
How I Made the Section 5 Programming Tab (5:20)
How I Made the Section 6 Other Topics Tab (0:59)

Videos on Each Excel Ribbon

All Icons Explained on the Home Ribbon (27:22)
All Icons Explained on the Insert Ribbon (16:36)
All Icons Explained on the Page Layout Ribbon (9:52)
All Icons Explained on the Formulas Ribbon (12:05)
All Icons Explained on the Data Ribbon (22:32)
All Icons Explained on the Review Ribbon (1:48)
All Icons Explained on the View Ribbon (3:59)
All Icons Explained on the Developer Ribbon (11:53)
All Icons Explained on the Picture Format Ribbon (6:11)

How I Made the Section 3.2 Formulas 101 Tab

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock