Course curriculum

    1. 1. Welcome to the Course

    2. 2. Dealing with Raw Data

    3. 3. The Magic of an Excel Dashboard

    4. 4. Let's get Started!

    1. 1. DOWNLOAD THIS FILE FIRST

    2. 2. Using Excels PROPER() Function on Text

    3. 3. Create Consistency with Excels UPPER() Function

    4. 4. Microsoft Excels Paste Special Feature

    5. 5. Replace Meaningless Data with Excels CHOOSE() Function

    6. 6. Extract Date Values Using Excels TEXT() Function

    1. 1. Looking Up Customer Info

    2. 2. Preparing the Data Using Format As Table

    3. 3. Creating a Drop Down Menu with Data Validation

    4. 4. Looking Up Data with Excels VLOOKUP() Function

    5. 5. Cleaning Up Data with Excels IF() Function

    6. 6. INDEX() and MATCH() an Alternative to VLOOKUP()

    1. 1. Adding the Order History Table

    2. 2. Formatting Orders as a Table

    3. 3. Using Excels Advanced Filter Feature

    4. 4. Record Macro for Advanced Filter

    5. 5. Filter Order Records On Change of Customer (VBA)

    6. 6. Modify the VBA Filter Code

    1. 1. Why Use Excels SUBTOTAL() Function

    2. 2. Implementing the SUBTOTAL() Function

    1. 1. Why Use PivotTables

    2. 2. Summarizing Order Info with PivotTables

    3. 3. Prepare PivotTable for Customer Filter

    4. 4. Creating the VBA Procedure

    5. 5. Declaring VBA Variables

    6. 6. Assigning Values to VBA Variables

    7. 7. Connecting the Filter to the PivotTable

    8. 8. Update Pivot Chart Based on Customer Selected (VBA)

    9. 9. Customers with No Orders Error

About this course

  • Free
  • 40 lessons
  • 3.5 hours of video content