#### 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