IFS and nested IF | Excelshed

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Putting Excel to work (Full Excel course)

Relative, Absolute and Mixed cell references

Relative cell references (3:55)
Absolute cell references (7:04)
Mixed cell references (7:01)
Practice exercises
PDF summary

Working with Worksheets

Worksheet basics (2:41)
Moving worksheets, Ranges, Groups and Protection (16:03)
Hiding, Unhiding and protecting structure (4:34)
Practice exercises
PDF summary

Working with lists

Sorting (9:06)
Filtering (10:05)
Subtotaling (5:17)
Practice exercises
PDF summary

Printing from Excel

Print Preview (4:45)
Headers and Footers (6:56)
Large worksheets (6:06)
Practice exercises
PDF summary

Using named ranges

Named range basics (10:14)
Drop-down lists and reporting (11:06)
Managing Names (7:12)
Practice exercises
PDF summary

The IF function

IF basics - Numbers, text and formulas (9:30)
ANDs ORs and NOTs (9:33)
IFS and nested IF (12:22)
Practice exercises
PDF summary

Dates and Time

Dates are numbers (4:04)
Date functions (11:32)
Date formats (1:22)
Times are numbers (12:19)
Time functions (5:45)
Date and Time combos (2:51)
Practice exercises
PDF summary

Lookup techniques with XLOOKUP

Do I use XLOOKUP or VLOOKUP? (0:47)
XLOOKUP Basics (8:30)
Matching and More about Return arrays (9:23)
Using Tables with XLOOKUP (4:38)
Nested XLOOKUPs (5:03)
Practice exercises
PDF summary

Lookup techniques with VLOOKUP

Do I use VLOOKUP or XLOOKUP? (0:47)
VLOOKUP with Exact match (7:08)
VLOOKUP with Approximate match (4:27)
Using Named ranges (5:02)
Using Tables (4:04)
HLOOKUP (2:22)
Practice exercises
PDF summary

Conditional formatting

Basic formatting rules (5:59)
Tweaking the rules (5:52)
Using formulas for rules (5:40)
Rules management (6:05)
Practice exercises
PDF summary

Data validation and drop-down lists

Basic validation techniques (12:42)
Using formulas in validation (11:24)
Practice exercises
PDF summary

The magic of Tables

Creating a Table (11:32)
Using Tables with functions (6:44)
Practice exercises
PDF summary

Charts

Line charts (10:39)
Column and Pie charts (11:00)
Combo charts and Templates (5:27)
Practice exercises
PDF summary

Massaging data

Splitting and joining (7:24)
Manipulating text (9:41)
Trimming and converting text (5:35)
Practice exercises
PDF summary

Consolidating data

Simple linking (10:03)
The CONSOLIDATE function (11:16)
Practice exercises
PDF summary

PivotTables

Creating a PivotTable (8:37)
PivotTable Calculations (7:02)
Sprucing up PivotTables and PivotCharts (6:44)
Practice exercises
PDF summary

Custom number formatting

Built-in formats (17:32)
Writing custom formats (10:13)
Practice exercises
PDF summary

Get & Transform (Power Query)

Introduction to Power Query (15:05)
Combining Queries (14:43)
Practice files

Teach online with

IFS and nested IF

Lesson content locked

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

Enroll in Course to Unlock