Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Tabulate Date Differences with the DATEDIF Function
In this video, we will tabulate date differences with the DATEDIF function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using the NETWORKDAYS and NETWORKDAYS.INT Function
In this video, you will learn how to use the NETWORKDAYS and NETWORKDAYS.INT functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using the WORKDAY and WORKDAY.INT Functions
In this video, you will learn how to use the WORKDAY and WORKDAY.INT functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Applying Custom Date Formats
In this video, you will learn how to apply custom date formats.
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.