Commencing the Journey

Course Introduction

Managing Unprocessed Data

Comprehensive Guide to Excel Dashboards

Important Section Instructions

Harnessing MS Excel's Paste Special Feature

Working On Text Visuals Through Proper() Function

Establish Uniformity Using Excel's UPPER() Function

Substituting Nonsensical Data with the CHOOSE() Function

Utilizing the TEXT() Function for Date Value Extraction

Customer Information Lookup

Data Preparation Formatting as a Table

Generating a Dropdown Menu using Data Validation

Data Cleansing using Excel's IF() Function

Data Retrieval using Excel's VLOOKUP() Function

Exploring INDEX() and MATCH() VLOOKUP() Alternative

Incorporating the Order History Table

Exploring Excel's Advanced Filter Functionality

Creating a Macro for Advanced Filtering

Implementing Customer-Triggered Order Record Filtering (VBA)

Adjusting the VBA Filter Code

The Benefits of Utilizing Excel's SUBTOTAL() Function

Applying the SUBTOTAL() Function in Practice

The Advantages of Using PivotTables

Condensing Order Information using PivotTables

Setting Up PivotTable for Customer Filtering

Crafting the VBA Process

Defining Variables in VBA

Setting Values for VBA Variables

Linking the Filter with the PivotTable

Updating Pivot Chart with Customer Selection (VBA)

Handling Errors for Customers with No Orders

Customizing the Chart Slicer

Generating Dynamic Charts using Slicers

Optimizing Excel's Default Configuration

Concealing Redundant Worksheets and Columns

Concealing Chart and Slicer Reset (VBA)

Securing the Dashboard Content

Achievement Unlocked Congratulations!