Instructional Video1:50
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 01 - download all the required files

Higher Ed
In this video, we will focus on Exercise 01 of this section, where we will download all the required files from the course code bundle.
Instructional Video7:31
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Creating Dynamic Drop-Down Lists

Higher Ed
In this video, you will learn how to create dynamic drop-down lists.
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 Video5:33
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Using Map Charts

Higher Ed
In this video, you will learn how to use map charts.
Instructional Video5:08
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Creating a Pivot Chart

Higher Ed
In this video, you will learn how to create a pivot chart.
Instructional Video5:42
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Grouping PivotTable Data

Higher Ed
In this video, you will learn how to group PivotTable data.
Instructional Video3:02
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Applying Number Formatting to PivotTable Data

Higher Ed
In this video, you will learn how to apply number format to PivotTable data.
Instructional Video4:53
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Creating a PivotTable from Scratch

Higher Ed
In this video, you will learn how to create a PivotTable from scratch.
Instructional Video5:03
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Splitting or Combining Cell Data Using Flash Fill

Higher Ed
In this video, you will learn how to split or combine cell data using Flash Fill.
Instructional Video5:23
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Removing Blank Rows, Cells, and Duplicates

Higher Ed
In this video, you will learn how to remove blank rows, cells, and duplicates.
Instructional Video7:25
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Calculate Dates with EDATE and EOMONTH

Higher Ed
In this video, we will calculate dates with EDATE and EOMONTH.
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 Video4:14
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Understanding How Dates are Stored in Excel

Higher Ed
In this video, you will understand how dates are stored in Excel.
Instructional Video6:55
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Using the Advanced Filter

Higher Ed
In this video, you will learn how to use the advanced filter.
Instructional Video9:10
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - The INDIRECT Function

Higher Ed
In this video, we will cover the INDIRECT function.
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 Video6:19
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Section Introduction - 2

Higher Ed
In this video, we have a quick section introduction.
Instructional Video4:24
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Saving the Workbook in Different Formats

Higher Ed
In this video, you will learn how to save the workbook in different formats.
Instructional Video7:23
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Inspecting the Workbook

Higher Ed
In this video, you will learn how to inspect the workbook.
Instructional Video3:47
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Spell Checking

Higher Ed
In this video, we will cover spell checking.
Instructional Video4:35
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Inserting Page Breaks

Higher Ed
In this video, you will learn how to insert page breaks.
Instructional Video5:04
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Arranging Workbooks and Worksheets

Higher Ed
In this video, you will learn how to arrange workbooks and worksheets.
Instructional Video2:59
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Using Zoom in a Worksheet

Higher Ed
In this video, you will learn how to use zoom in a worksheet.