Instructional Video4:28
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Updating PivotTable Data

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

Microsoft Excel 2021365 - Beginner to Advanced - Applying PivotTable Styles

Higher Ed
In this video, you will learn how to apply PivotTable styles.
Instructional Video4:39
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Choosing a Report Layout

Higher Ed
In this video, you will learn how to choose a report layout.
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 Video2:15
Instructional Video5:45
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 05 - preparing data for analysis

Higher Ed
In this video, we will focus on Exercise 05 of this section, where we will be preparing data for analysis.
Instructional Video9:07
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Changing Case and Removing Spaces

Higher Ed
In this video, you will learn how to change the case and remove spaces.
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 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 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 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 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 Video5:41
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information Horizontally Using HLOOKUP

Higher Ed
In this video, you will learn how to look up information horizontally using HLOOKUP.
Instructional Video4:28
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information Using VLOOKUP (Approx Match)

Higher Ed
In this video, you will learn how to look up information using VLOOKUP (Approx Match).
Instructional Video7:32
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 01 - apply logical functions

Higher Ed
In this video, we will focus on Exercise 01 of this section, where we need to apply logical functions.
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).