Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The COUNTBLANK Function
In this video, we will cover the COUNTBLANK function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using LARGE and SMALL
In this video, you will learn how to use LARGE and SMALL.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Performing Two-Way Lookups
In this video, you will learn how to perform two-way lookups.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Assembling a Dashboard - Part 1
In this video, you will learn how to assemble a dashboard - part 1.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The FILTER Function - 1
In this video, we will cover the FILTER function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The SORT and SORTBY Functions
In this video, we will cover the SORT and SORTBY functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The OFFSET Function
In this video, we will cover the OFFSET function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Performing Flexible Lookups with INDEX And MATCH
In this video, you will learn how to perform flexible lookups with INDEX And MATCH.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information Using VLOOKUP (Exact Match)
In this video, you will learn how to look up information using VLOOKUP (Exact Match).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 09 - VLOOKUP formula
In this video, we will focus on Exercise 09 of this section, where we will apply the VLOOKUP formula.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Unique Versus Distinct
In this video, we will understand the difference between unique and distinct.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Extract and Count Unique Entries
In this video, you will learn about extract and count unique entries.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - What Are Dynamic Arrays?
In this video, we will understand dynamic arrays.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating Dynamic Drop-Down Lists
In this video, you will learn how to create dynamic drop-down lists.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Troubleshooting Common Errors
In this video, you will learn how to troubleshoot common errors.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Extracting Unique Values - The UNIQUE Function
In this video, you will learn how to extract unique values - the UNIQUE function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The INDIRECT Function
In this video, we will cover the INDIRECT function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information Using VLOOKUP (Approx Match)
In this video, you will learn how to look up information using VLOOKUP (Approx Match).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 01 - apply logical functions
In this video, we will focus on Exercise 01 of this section, where we need to apply logical functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS)
In this video, we will cover multiple criteria (SUMIFS, COUNTIFS, AVERAGEIFS).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Conditional IFs (SUMIF, COUNTIF, AVERAGEIF)
In this video, we will cover conditional IFs (SUMIF, COUNTIF, AVERAGEIF).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Color Scales
In this video, we will cover color scales.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - VLOOKUP Approximate Match
In this video, we will cover VLOOKUP approximate match.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - 3D Referencing
In this video, we will cover 3D referencing.