Instructional Video7:13
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Importing Data Using Get and Transform

Higher Ed
In this video, you will learn how to import data using Get and Transform.
Instructional Video1:37
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Power Query Overview

Higher Ed
In this video, we will have a quick power query overview.
Instructional Video6:00
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 08 - create a formula

Higher Ed
In this video, we will focus on Exercise 08 of this section, where we will create a formula to return ‘Month’ and ‘Sales’ from the table based on the selection in the form control.
Instructional Video5:04
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Scroll Bar - Scroll Through a List

Higher Ed
In this video, you will learn how to use the scroll bar.
Instructional Video5:02
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - List Box - Select from a List of Items

Higher Ed
In this video, you will learn how to use the list box.
Instructional Video5:57
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Spin Button - Move Up and Down a List

Higher Ed
In this video, you will learn how to use the spin button.
Instructional Video6:34
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Option Button - Choose an Option

Higher Ed
In this video, you will learn how to use the option button.
Instructional Video6:51
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Check Box - Check/Uncheck Option

Higher Ed
In this video, you will learn how to use check box.
Instructional Video7:23
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Combo Box - Select from a List

Higher Ed
In this video, you will learn how to use Combo Box.
Instructional Video4:17
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Introduction to Form Controls

Higher Ed
In this video, we will get introduced to form controls.
Instructional Video10:13
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 07 - create and summarize a PivotTable

Higher Ed
In this video, we will focus on Exercise 07 of this section, where we will create and summarize a PivotTable.
Instructional Video5:55
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Adding Totals to a Stacked Column Chart

Higher Ed
In this video, you will learn how to add totals to a stacked column chart.
Instructional Video12:50
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Adding a Dynamic Series to a Pivot Chart

Higher Ed
In this video, you will learn how to add a dynamic series to a pivot chart.
Instructional Video10:44
Curated Video

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

Higher Ed
In this video, you will learn how to create a dynamic pivot chart title.
Instructional Video8:40
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Using GETPIVOTDATA - Dependent Data Validation Lists

Higher Ed
In this video, you will learn how to use GETPIVOTDATA - dependent data validation lists.
Instructional Video12:05
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Adjusting Slicer Settings

Higher Ed
In this video, you will learn how to adjust slicer settings.
Instructional Video5:09
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Applying Multiple Filters to Data

Higher Ed
In this video, you will learn how to apply multiple filters to data.
Instructional Video4:40
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Sorting Using Custom Lists

Higher Ed
In this video, you will learn how to sort using custom lists.
Instructional Video10:05
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Applying Custom Number Formatting

Higher Ed
In this video, you will learn how to apply custom number format.
Instructional Video9:51
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Creating a Custom PivotTable Style

Higher Ed
In this video, you will learn how to create a custom PivotTable style.
Instructional Video14:16
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - The LAMBDA Function

Higher Ed
In this video, we will cover the LAMBDA function.
Instructional Video15:10
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - The LET Function

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

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 05 - use the ROUNDUP function for two decimal places

Higher Ed
In this video, we will focus on Exercise 05 of this section, where we will use the ROUNDUP function for two decimal places.
Instructional Video4:35
Curated Video

Microsoft Excel 2021365 - Beginner to Advanced - Using the AGGREGATE Function

Higher Ed
In this video, you will learn how to use the AGGREGATE function.