Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Understanding How Dates are Stored in Excel
In this video, you will understand how dates are stored in Excel.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 03 - sort the given data
In this video, we will focus on Exercise 03 of this section, where we need to sort the given data.
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 - Using the Advanced Filter
In this video, you will learn how to use the advanced filter.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Sorting Using a Custom List
In this video, you will learn how to sort using a custom list.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Performing Sorts on Multiple Columns
In this video, you will learn how to perform sorts on multiple columns.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 02 - apply the Lookup functions
In this video, we will focus on Exercise 02 of this section, where we need to apply the Lookup functions.
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 Horizontally Using HLOOKUP
In this video, you will learn how to look up information horizontally using HLOOKUP.
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 - Error Handling with IFERROR and IFNA
In this video, we will cover error handling with IFERROR and IFNA.
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 - The IFS Function
In this video, we will cover the IFS function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The IF Function
In this video, we will cover the IF function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Controlling Data Input
In this video, you will learn how to control data input.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Improving Readability with Cell Styles
In this video, you will learn how to improve readability with cell styles.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Section Introduction - 2
In this video, we have a quick section introduction.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Section Summary - 1
In this video, we will summarize the learnings from this section.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 15
In this video, we will focus on Exercise 15 of this section, where we will be doing spell check and applying protection to the worksheet.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Sharing a Workbook
In this video, you will learn how to share a workbook.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Saving the Workbook in Different Formats
In this video, you will learn how to save the workbook in different formats.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Inspecting the Workbook
In this video, you will learn how to inspect the workbook.