Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating a Custom PivotTable Style
In this video, you will learn how to create a custom PivotTable style.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 06 - work with the LET function
In this video, we will focus on Exercise 06 of this section, where we will work with the LET function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The LAMBDA Function
In this video, we will cover the LAMBDA function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The LET Function
In this video, we will cover the LET function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 05 - use the ROUNDUP function for two decimal places
In this video, we will focus on Exercise 05 of this section, where we will use the ROUNDUP function for two decimal places.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using the AGGREGATE Function
In this video, you will learn how to use the AGGREGATE function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Specialized Rounding (MROUND, CEILING.MATH, and FLOOR.MATH)
In this video, we will cover specialized rounding (MROUND, CEILING.MATH, and FLOOR.MATH).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Rounding Values Using ROUND, ROUNDUP, and ROUNDDOWN
In this video, you will learn how to round values using ROUND, ROUNDUP, and ROUNDDOWN.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 04 - AVERAGE, MEDIAN, and MODE.
In this video, we will focus on Exercise 04 of this section, where need to find the AVERAGE, MEDIAN, and MODE.
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 - Using MEDIAN, MODE.SNGL, and MODE.MULT
In this video, you will learn how to use MEDIAN, MODE.SNGL, and MODE.MULT.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 03 -work on a two-way XLOOKUP
In this video, we will focus on Exercise 03 of this section, where we will work on a two-way XLOOKUP.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using the SWITCH Function
In this video, you will learn how to use the SWITCH function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using the CHOOSE Function
In this video, you will learn how to use the CHOOSE function.
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 - Exercise 02 - work on the UNIQUE function
In this video, we will focus on Exercise 02 of this section, where we will work on the UNIQUE function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using XMATCH
In this video, you will learn how to use XMATCH.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using XLOOKUP to Perform Complex Lookups
In this video, you will learn how to use XLOOKUP to perform complex lookups.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using RANDARRAY and RANDBETWEEN to Randomize Data
In this video, you will learn how to use RANDARRAY and RANDBETWEEN to randomize data.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - FILTER with Logic: - Operator (One or the Other)
In this video, we will cover FILTER with logic and learn about - Operator (One or the Other).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - FILTER with Logic: = Operator (Both or Neither)
In this video, we will cover FILTER with logic and learn about = Operator (Both or Neither).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Simple SEQUENCE and Unstacking Records
In this video, we will cover simple SEQUENCE and unstacking records.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Introduction to Spills and Arrays
In this video, we will get introduced to Spills and Arrays.