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 Video5:06
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Formatting Error Values and Empty Cells

Higher Ed
In this video, you will learn how to format error values and empty cells.
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 Video5:53
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Show Values As and Summarize Values By

Higher Ed
In this video, we will cover Show Values As and Summarize Values By.
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 Video3:17
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Applying Subtotals and Grand Totals

Higher Ed
In this video, you will learn how to apply subtotals and grand totals.
Instructional Video5:34
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Pivoting the PivotTable Fields

Higher Ed
In this video, you will learn how to pivot the PivotTable fields.
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 Video8:36
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Formatting Data as a Table

Higher Ed
In this video, you will learn how to format data as a table.
Instructional Video7:32
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Joining Data Using CONCAT

Higher Ed
In this video, you will learn how to join data using CONCAT.
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 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 Video7:06
Curated Video

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

Higher Ed
In this video, you will learn how to split data using text to columns.
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 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 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 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 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.