Section 1 : Getting Started
|
|
Lecture 1 | Welcome to the Course | 00:02:01 Duration |
|
|
Lecture 2 | Dealing with Raw Data | 00:04:03 Duration |
|
|
Lecture 3 | The Magic of an Excel Dashboard | 00:05:18 Duration |
|
|
Lecture 4 | Let's get Started! | 00:00:58 Duration |
Section 2 : Analyzing Data Effectively with Microsoft Excel
|
|
Lecture 1 | DOWNLOAD THIS FILE FIRST | 00:01:15 Duration |
|
|
Lecture 2 | Using Excels PROPER() Function on Text | 00:04:41 Duration |
|
|
Lecture 3 | Create Consistency with Excels UPPER() Function | 00:02:54 Duration |
|
|
Lecture 4 | Microsoft Excels Paste Special Feature | 00:03:52 Duration |
|
|
Lecture 5 | Replace Meaningless Data with Excels CHOOSE() Function | 00:09:14 Duration |
|
|
Lecture 6 | Extract Date Values Using Excels TEXT() Function | 00:06:30 Duration |
Section 3 : Building the Excel Dashboard - LOOK UP DATA - Part 1
|
|
Lecture 1 | Looking Up Customer Info | 00:02:14 Duration |
|
|
Lecture 2 | Preparing the Data Using Format As Table | 00:04:55 Duration |
|
|
Lecture 3 | Creating a Drop Down Menu with Data Validation | 00:03:53 Duration |
|
|
Lecture 4 | Looking Up Data with Excels VLOOKUP() Function | 00:07:56 Duration |
|
|
Lecture 5 | Cleaning Up Data with Excels IF() Function | 00:07:16 Duration |
|
|
Lecture 6 | INDEX() and MATCH() an Alternative to VLOOKUP() | 00:15:06 Duration |
Section 4 : Building the Excel Dashboard - FILTERING DATA - Part 2
|
|
Lecture 1 | Adding the Order History Table | 00:05:47 Duration |
|
|
Lecture 2 | Formatting Orders as a Table | 00:04:19 Duration |
|
|
Lecture 3 | Using Excels Advanced Filter Feature | 00:07:30 Duration |
|
|
Lecture 4 | Record Macro for Advanced Filter | 00:09:12 Duration |
|
|
Lecture 5 | Filter Order Records On Change of Customer (VBA) | 00:06:26 Duration |
|
|
Lecture 6 | Modify the VBA Filter Code |
Section 5 : Building the Excel Dashboard - SUBTOTALS - Part 3
|
|
Lecture 1 | Why Use Excels SUBTOTAL() Function | |
|
|
Lecture 2 | Implementing the SUBTOTAL() Function | 00:06:41 Duration |
Section 6 : Building the Excel Dashboard - PivotTables and Pivot Charts - Part 4
|
|
Lecture 1 | Why Use PivotTables | |
|
|
Lecture 2 | Summarizing Order Info with PivotTables | 00:07:53 Duration |
|
|
Lecture 3 | Prepare PivotTable for Customer Filter | 00:05:21 Duration |
|
|
Lecture 4 | Creating the VBA Procedure | 00:03:54 Duration |
|
|
Lecture 5 | Declaring VBA Variables | 00:04:28 Duration |
|
|
Lecture 6 | Assigning Values to VBA Variables | 00:07:28 Duration |
|
|
Lecture 7 | Connecting the Filter to the PivotTable | 00:05:09 Duration |
|
|
Lecture 8 | Update Pivot Chart Based on Customer Selected (VBA) | |
|
|
Lecture 9 | Customers with No Orders Error | 00:05:57 Duration |
Section 7 : Building the Excel Dashboard - Interactive Buttons - Part 5
|
|
Lecture 1 | Creating Interactive Charts with Slicers | 00:04:22 Duration |
|
|
Lecture 2 | Modifying the Chart Slicer | 00:01:55 Duration |
Section 8 : Building the Excel Dashboard - Final Touches - Part 6
|
|
Lecture 1 | Hiding Extra Worksheets and Columns | |
|
|
Lecture 2 | Cleaning Up the Excel Default Settings | 00:02:23 Duration |
|
|
Lecture 3 | Hiding the Chart and Resetting the Slicer (VBA) | 00:07:54 Duration |
|
|
Lecture 4 | Protecting the Dashboard | 00:05:19 Duration |
