All Icons Explained on the Review Ribbon

2021 Haroun MBA Degree Program® Gold Version

Welcome Message from Chris

Welcome! Please read this message from Chris

Excel & Programming Elective: 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:44)
[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] Exercise 5.3.6: Properties Have Values (0:29)
[G/A] Answer 5.3.6: Properties Have Values (3:58)
[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 (14:45)
[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 (3:52)

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 Secton 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 to Access the AI, ChatGPT, Excel, Sales & More Courses for free (as an enrolled MBA student, you receive these courses for free)

100% off coupon is in this lecture for the Complete Python Course
100% off coupon is in this lecture for the Complete Artificial Intelligence and ChatGPT Course
100% off coupon is in this lecture for the ChatGPT for Investing in Stocks Course
100% off coupon is in this lecture for the Complete Microsoft Excel Course
100% off coupon is in this lecture for the Sales 101 Course Course
100% off coupon is in this lecture for the 30 Day Challenge to a More Productive and Much Happier You Course
100% off coupon is in this lecture for the Introduction to Finance, Accounting, Modeling and Valuation Course

All Icons Explained on the Review Ribbon

Lesson content locked

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

Enroll in Course to Unlock