Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel for Business Analysts
Section 1: Introduction
Introduction to Business Analysis (5:25)
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Support Files
Section 2: The Basics
A Recap of Basic Formulas (12:42)
Absolute vs Relative Referencing (8:15)
Exercise 01 (2:03)
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:25)
Data Validation Lists with Lookups (8:30)
Exercise 02 (6:24)
Section 4: Making Better Decisions with IF
How to use the IF function (5:30)
More Examples of the IF Function (7:08)
Working with Nested Ifs (6:35)
The IFS function (8:47)
Error handling with IFERROR and IFNA (9:21)
Using MAX and MIN instead of the IF function (11:25)
Using SUMIFS and COUNTIFS (11:51)
Exercise 03 (1:32)
Section 5: Preparing Data for Analysis
Splitting data using text functions (16:13)
Using the Flash Fill command (4:39)
Concatenating data (9:03)
Standardizing data (9:00)
Formatting data as a table (9:45)
Exercise 04 (2:28)
Section 6: PivotTables
An introduction to PivotTables (3:15)
Creating a PivotTable (12:40)
Summarizing Data (13:52)
Calculations in PivotTables (15:13)
Using Slicers to filter information (9:55)
Exercise 05 (1:53)
Section 7: Visualizing Data with Charts
Creating a Pivot Chart (10:38)
Formatting a Pivot Chart (14:25)
Using Sparklines (7:52)
A Basic Interactive Dashboard (14:45)
Exercise 06 (2:51)
Section 8: Forecasting
Forecast Sheets (7:18)
The Forecast Function (7:24)
Exercise 07 (1:35)
Section 9: Additional useful tools in Excel
Conditional Formatting (11:28)
The INDIRECT function (13:29)
The OFFSET function (10:32)
Using Histograms (4:55)
Regression (6:41)
Exercise 08 (2:12)
Section 10: WhatIf Analysis
Goal Seek (7:43)
Scenario Manager (8:01)
Data Tables (7:13)
Solver (6:50)
Exercise 09 (1:42)
Section 11: Course Close & Certificate of Completion
Closing
Course Quiz
Combining VLOOKUP and MATCH
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock