Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Ranking Data with Sorting Using RANK.EQ and RANK.AVG
In this video, you will learn how to rank data with sort using RANK.EQ and RANK.AVG.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Finding the Last Occurrence of a Value
In this video, you will learn how to find the last occurrence of a value.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 08 - create a formula
In this video, we will focus on Exercise 08 of this section, where we will create a formula to return ‘Month’ and ‘Sales’ from the table based on the selection in the form control.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Scroll Bar - Scroll Through a List
In this video, you will learn how to use the scroll bar.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - List Box - Select from a List of Items
In this video, you will learn how to use the list box.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Spin Button - Move Up and Down a List
In this video, you will learn how to use the spin button.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Combo Box - Select from a List
In this video, you will learn how to use Combo Box.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Introduction to Form Controls
In this video, we will get introduced to form controls.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using GETPIVOTDATA - Dependent Data Validation Lists
In this video, you will learn how to use GETPIVOTDATA - dependent data validation lists.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating a Calculated Item
In this video, you will learn how to create a calculated item.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Sorting Using Custom Lists
In this video, you will learn how to sort using custom lists.
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 - The COUNTBLANK Function
In this video, we will cover the COUNTBLANK function.
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 - 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).