Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Microsoft Excel for Business Analysts
Section 1: Introduction
Welcome to Master of Project Academy (1:19)
How to Utilize Microsoft Excel for Business Analysts Training?
Introduction to Business Analysis (5:25)
Course Support Files
Section 2: The Basics
A Recap of Basic Formulas (12:42)
Absolute vs Relative Referencing (8:15)
Exercise 01
Practice Questions
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
More Examples of the IF Function (7:08)
How to use the IF function (5:30)
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:52)
Exercise 03 (1:32)
Practice Questions
Section 5: Preparing Data for Analysis
Using the Flash Fill command (4:39)
Splitting data using text functions (16:13)
Concatenating data (9:03)
Standardizing data (9:00)
Formatting data as a table (9:45)
Exercise 04 (2:28)
Practice Questions
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)
Practice Questions
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)
Practice Questions
Section 8: Forecasting
The Forecast Function (7:24)
Forecast Sheets (7:18)
Exercise 07 (1:35)
Practice Questions
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:13)
Practice Questions
Section 10: WhatIf Analysis
Scenario Manager (8:01)
Goal Seek (7:43)
Data Tables (7:13)
Solver (6:50)
Exercise 09 (1:42)
Practice Questions
Section 11: Course Close
Interactive: Ridgeline Hospitality — Optimizing 6 Boutique Hotels in Excel Case Study
Course Close (0:44)
Tip #1 - Join LinkedIn Community
Join LinkedIn Community & Follow Latest Updates
How to Submit a PDU Claim (For Retaining PMP Certificate)
How to Submit PDUs
Bonus Lecture - Discount for our paid courses
Bonus Lecture - Discount for our paid courses
Important Notice About Certificate of Completion
Important Notice About Certificate of Completion
Interactive: Ridgeline Hospitality — Optimizing 6 Boutique Hotels in Excel Case Study
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll to Unlock