Instructional Video11:45
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Formulas and Functions Explained

Higher Ed
In this video, you will learn some formulas and functions.
Instructional Video5:42
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - FILTER with Logic: * Operator (AND)

Higher Ed
In this video, we will cover FILTER with Logic and learn about * Operator (AND).
Instructional Video4:51
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - FILTER with Logic: + Operator (OR)

Higher Ed
In this video, we will cover FILTER with logic and learn about + Operator (OR).
Instructional Video8:55
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - The SORT Function

Higher Ed
In this video, we will cover the SORT function.
Instructional Video5:36
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Goal Seek and the PMT Function

Higher Ed
In this video, we will cover Goal Seek and the PMT function.
Instructional Video6:57
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 11 - data validation

Higher Ed
In this video, we will focus on Exercise 11 of this section, where we will work on data validation.
Instructional Video7:33
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 10 - formula auditing

Higher Ed
In this video, we will focus on Exercise 10 of this section, where we will work on formula auditing.
Instructional Video7:47
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Tracing Precedents and Formula Auditing

Higher Ed
In this video, you will learn how to trace precedents and formula audit.
Instructional Video8:14
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Troubleshooting Common Errors

Higher Ed
In this video, you will learn how to troubleshoot common errors.
Instructional Video8:08
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Splitting Data Using Text Functions

Higher Ed
In this video, you will learn how to split data using text functions.
Instructional Video4:54
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 04 - ork with the date and time functions

Higher Ed
In this video, we will focus on Exercise 04 of this section, where we will work with the date and time functions.
Instructional Video6:17
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Tabulate Date Differences with the DATEDIF Function

Higher Ed
In this video, we will tabulate date differences with the DATEDIF function.
Instructional Video3:00
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Using the NETWORKDAYS and NETWORKDAYS.INT Function

Higher Ed
In this video, you will learn how to use the NETWORKDAYS and NETWORKDAYS.INT functions.
Instructional Video3:52
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Using the WORKDAY and WORKDAY.INT Functions

Higher Ed
In this video, you will learn how to use the WORKDAY and WORKDAY.INT functions.
Instructional Video7:12
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Applying Custom Date Formats

Higher Ed
In this video, you will learn how to apply custom date formats.
Instructional Video5:45
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 03 - sort the given data

Higher Ed
In this video, we will focus on Exercise 03 of this section, where we need to sort the given data.
Instructional Video5:06
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 02 - apply the Lookup functions

Higher Ed
In this video, we will focus on Exercise 02 of this section, where we need to apply the Lookup functions.
Instructional Video6:04
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Error Handling with IFERROR and IFNA

Higher Ed
In this video, we will cover error handling with IFERROR and IFNA.
Instructional Video7:15
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS)

Higher Ed
In this video, we will cover multiple criteria (SUMIFS, COUNTIFS, AVERAGEIFS).
Instructional Video6:48
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Conditional IFs (SUMIF, COUNTIF, AVERAGEIF)

Higher Ed
In this video, we will cover conditional IFs (SUMIF, COUNTIF, AVERAGEIF).
Instructional Video6:07
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - The IFS Function

Higher Ed
In this video, we will cover the IFS function.
Instructional Video5:30
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - The IF Function

Higher Ed
In this video, we will cover the IF function.
Instructional Video3:32
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 15

Higher Ed
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.
Instructional Video5:16
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Inserting Comments

Higher Ed
In this video, you will learn how to insert comments.