Section 1 : Getting Started

Lecture 1 Welcome to the Course 2:1
Lecture 2 Dealing with Raw Data 4:3
Lecture 3 The Magic of an Excel Dashboard 5:18
Lecture 4 Let's get Started! 0:58

Section 2 : Analyzing Data Effectively with Microsoft Excel

Lecture 5 DOWNLOAD THIS FILE FIRST 1:15
Lecture 6 Using Excels PROPER() Function on Text 4:41
Lecture 7 Create Consistency with Excels UPPER() Function 2:54
Lecture 8 Microsoft Excels Paste Special Feature 3:52
Lecture 9 Replace Meaningless Data with Excels CHOOSE() Function 9:14
Lecture 10 Extract Date Values Using Excels TEXT() Function 6:30

Section 3 : Building the Excel Dashboard - LOOK UP DATA - Part 1

Lecture 11 Looking Up Customer Info 2:14
Lecture 12 Preparing the Data Using Format As Table 4:55
Lecture 13 Creating a Drop Down Menu with Data Validation 3:53
Lecture 14 Looking Up Data with Excels VLOOKUP() Function 7:56
Lecture 15 Cleaning Up Data with Excels IF() Function 7:16
Lecture 16 INDEX() and MATCH() an Alternative to VLOOKUP() 15:6

Section 4 : Building the Excel Dashboard - FILTERING DATA - Part 2

Lecture 17 Adding the Order History Table 5:47
Lecture 18 Formatting Orders as a Table 4:19
Lecture 19 Using Excels Advanced Filter Feature 7:30
Lecture 20 Record Macro for Advanced Filter 9:12
Lecture 21 Filter Order Records On Change of Customer (VBA) 6:26
Lecture 22 Modify the VBA Filter Code

Section 5 : Building the Excel Dashboard - SUBTOTALS - Part 3

Lecture 23 Why Use Excels SUBTOTAL() Function
Lecture 24 Implementing the SUBTOTAL() Function 6:41

Section 6 : Building the Excel Dashboard - PivotTables and Pivot Charts - Part 4

Lecture 25 Why Use PivotTables
Lecture 26 Summarizing Order Info with PivotTables 7:53
Lecture 27 Prepare PivotTable for Customer Filter 5:21
Lecture 28 Creating the VBA Procedure 3:54
Lecture 29 Declaring VBA Variables 4:28
Lecture 30 Assigning Values to VBA Variables 7:28
Lecture 31 Connecting the Filter to the PivotTable 5:9
Lecture 32 Update Pivot Chart Based on Customer Selected (VBA)
Lecture 33 Customers with No Orders Error 5:57

Section 7 : Building the Excel Dashboard - Interactive Buttons - Part 5

Lecture 34 Creating Interactive Charts with Slicers 4:22
Lecture 35 Modifying the Chart Slicer 1:55

Section 8 : Building the Excel Dashboard - Final Touches - Part 6

Lecture 36 Hiding Extra Worksheets and Columns
Lecture 37 Cleaning Up the Excel Default Settings 2:23
Lecture 38 Hiding the Chart and Resetting the Slicer (VBA) 7:54
Lecture 39 Protecting the Dashboard 5:19