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
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
Using Slicers to filter information
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll to Unlock