Course curriculum
-
-
1. Welcome to the Course
-
2. Dealing with Raw Data
-
3. The Magic of an Excel Dashboard
-
4. Let's get Started!
-
-
-
1. DOWNLOAD THIS FILE FIRST
-
2. Using Excels PROPER() Function on Text
-
3. Create Consistency with Excels UPPER() Function
-
4. Microsoft Excels Paste Special Feature
-
5. Replace Meaningless Data with Excels CHOOSE() Function
-
6. Extract Date Values Using Excels TEXT() Function
-
-
-
1. Looking Up Customer Info
-
2. Preparing the Data Using Format As Table
-
3. Creating a Drop Down Menu with Data Validation
-
4. Looking Up Data with Excels VLOOKUP() Function
-
5. Cleaning Up Data with Excels IF() Function
-
6. INDEX() and MATCH() an Alternative to VLOOKUP()
-
-
-
1. Adding the Order History Table
-
2. Formatting Orders as a Table
-
3. Using Excels Advanced Filter Feature
-
4. Record Macro for Advanced Filter
-
5. Filter Order Records On Change of Customer (VBA)
-
6. Modify the VBA Filter Code
-
-
-
1. Why Use Excels SUBTOTAL() Function
-
2. Implementing the SUBTOTAL() Function
-
-
-
1. Why Use PivotTables
-
2. Summarizing Order Info with PivotTables
-
3. Prepare PivotTable for Customer Filter
-
4. Creating the VBA Procedure
-
5. Declaring VBA Variables
-
6. Assigning Values to VBA Variables
-
7. Connecting the Filter to the PivotTable
-
8. Update Pivot Chart Based on Customer Selected (VBA)
-
9. Customers with No Orders Error
-
About this course
- Free
- 40 lessons
- 3.5 hours of video content