Section 1: Introduction
Section 2: The Basics
Section 3: Merging and Looking Up Data
-
Merging data from different sources (2:48)
-
Looking up Information with VLOOKUP (Exact) (10:57)
-
Looking up information with VLOOKUP (Approx) (6:27)
-
How to use VLOOKUP with data that expands (10:00)
-
Using HLOOKUP (12:16)
-
Combining VLOOKUP and MATCH (12:25)
-
Using INDEX, MATCH and XLOOKUP (17:26)
-
Data Validation Lists with Lookups (8:30)
-
Exercise 02 (6:24)
-
Practice Questions
Section 4: Making Better Decisions with IF
Section 5: Preparing Data for Analysis
Section 6: PivotTables
Section 7: Visualizing Data with Charts
Section 8: Forecasting
Section 9: Additional useful tools in Excel
Section 10: WhatIf Analysis
Section 11: Course Close
Tip #1 - Join LinkedIn Community
How to Submit a PDU Claim (For Retaining PMP Certificate)
Bonus Lecture - Discount for our paid courses
Important Notice About Certificate of Completion
