Working with Nested Ifs | 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

Working with Nested Ifs

Lesson content locked

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

Enroll to Unlock