Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Changing Case and Removing Spaces
In this video, you will learn how to change the case and remove spaces.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Removing Blank Rows, Cells, and Duplicates
In this video, you will learn how to remove blank rows, cells, and duplicates.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 04 - ork with the date and time functions
In this video, we will focus on Exercise 04 of this section, where we will work with the date and time functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Calculate Dates with EDATE and EOMONTH
In this video, we will calculate dates with EDATE and EOMONTH.
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.