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 - 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.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using Named Ranges in Calculations
In this video, you will learn how to use named ranges in calculations.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Managing Named Ranges
In this video, you will learn how to manage named ranges.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating Named Ranges
In this video, you will learn how to create named ranges.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - What Are Named Ranges?
In this video, we will understand named ranges.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Working with the MIN and MAX Functions
In this video, you will learn how to work with the MIN and MAX functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Counting Values and Blanks
In this video, you will learn how to count values and blanks.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Performing Calculations with the SUM Function
In this video, you will learn how to perform calculations with the SUM function.