Creating a PivotTable | Master of Project Academy

Autoplay
Autocomplete

Previous Lesson 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

Teach online with

Creating a PivotTable

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll to Unlock