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 - GETPIVOTDATA
In this video, we will cover GETPIVOTDATA.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating a Calculated Field
In this video, you will learn how to create a calculated field.
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 - Applying Custom Number Formatting
In this video, you will learn how to apply custom number format.
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 - The LAMBDA Function
In this video, we will cover the LAMBDA function.
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 - 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 - 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 - 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 - The OFFSET Function
In this video, we will cover the OFFSET function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Logical Functions (AND, OR, IF)
In this video, we will cover logical functions (AND, OR, IF).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Extract Unique Values with Multiple Criteria
In this video, we will cover extract unique values with multiple criteria.
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 - Data Tables: One Variable
In this video, we will cover data tables with one variable.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using Scenario Manager
In this video, you will learn how to use the Scenario Manager.
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 - Exercise 06 - working with PivotTables
In this video, we will focus on Exercise 06 of this section, where we will be working with PivotTables.