Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel Data Analysis and Dashboard Reporting
Getting Started
Welcome to the Course (2:01)
Dealing with Raw Data (4:03)
The Magic of an Excel Dashboard (5:18)
Let's get Started! (0:58)
Analyzing Data Effectively with Microsoft Excel
DOWNLOAD THIS FILE FIRST (1:14)
Using Excels PROPER() Function on Text (4:41)
Create Consistency with Excels UPPER() Function (2:54)
Microsoft Excels Paste Special Feature (3:52)
Replace Meaningless Data with Excels CHOOSE() Function (9:14)
Extract Date Values Using Excels TEXT() Function (6:30)
Building the Excel Dashboard - LOOK UP DATA - Part 1
Looking Up Customer Info (2:14)
Preparing the Data Using Format As Table (4:54)
Creating a Drop Down Menu with Data Validation (3:53)
Looking Up Data with Excels VLOOKUP() Function (7:55)
Cleaning Up Data with Excels IF() Function (7:15)
INDEX() and MATCH() an Alternative to VLOOKUP() (15:05)
Building the Excel Dashboard - FILTERING DATA - Part 2
Adding the Order History Table (5:46)
Formatting Orders as a Table (4:19)
Using Excels Advanced Filter Feature (7:30)
Record Macro for Advanced Filter (9:11)
Filter Order Records On Change of Customer (VBA) (6:25)
Modify the VBA Filter Code (8:25)
Building the Excel Dashboard - SUBTOTALS - Part 3
Why Use Excels SUBTOTAL() Function (7:00)
Implementing the SUBTOTAL() Function (6:40)
Building the Excel Dashboard - PivotTables and Pivot Charts - Part 4
Why Use PivotTables (6:43)
Summarizing Order Info with PivotTables (7:52)
Prepare PivotTable for Customer Filter (5:20)
Creating the VBA Procedure (3:54)
Declaring VBA Variables (4:27)
Assigning Values to VBA Variables (7:27)
Connecting the Filter to the PivotTable (5:08)
Update Pivot Chart Based on Customer Selected (VBA) (4:41)
Customers with No Orders Error (5:57)
Building the Excel Dashboard - Interactive Buttons - Part 5
Creating Interactive Charts with Slicers (4:22)
Modifying the Chart Slicer (1:54)
Building the Excel Dashboard - Final Touches - Part 6
Hiding Extra Worksheets and Columns (4:50)
Cleaning Up the Excel Default Settings (2:23)
Hiding the Chart and Resetting the Slicer (VBA) (7:53)
Protecting the Dashboard (5:18)
Congratulations and Bonus!
Congratulations You Finished the Course (1:21)
Connecting the Filter to the PivotTable
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock