Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Importing Data Using Get and Transform
In this video, you will learn how to import data using Get and Transform.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Power Query Overview
In this video, we will have a quick power query overview.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 08 - create a formula
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.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Scroll Bar - Scroll Through a List
In this video, you will learn how to use the scroll bar.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - List Box - Select from a List of Items
In this video, you will learn how to use the list box.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Spin Button - Move Up and Down a List
In this video, you will learn how to use the spin button.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Option Button - Choose an Option
In this video, you will learn how to use the option button.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Check Box - Check/Uncheck Option
In this video, you will learn how to use check box.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Combo Box - Select from a List
In this video, you will learn how to use Combo Box.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Introduction to Form Controls
In this video, we will get introduced to form controls.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 07 - create and summarize a PivotTable
In this video, we will focus on Exercise 07 of this section, where we will create and summarize a PivotTable.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Adding Totals to a Stacked Column Chart
In this video, you will learn how to add totals to a stacked column chart.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Adding a Dynamic Series to a Pivot Chart
In this video, you will learn how to add a dynamic series to a pivot chart.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating a Dynamic Pivot Chart Title
In this video, you will learn how to create a dynamic pivot chart title.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using GETPIVOTDATA - Dependent Data Validation Lists
In this video, you will learn how to use GETPIVOTDATA - dependent data validation lists.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - GETPIVOTDATA
In this video, we will cover GETPIVOTDATA.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Solve Order
In this video, we will cover solve order.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating a Calculated Item
In this video, you will learn how to create a calculated item.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating a Calculated Field
In this video, you will learn how to create a calculated field.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Locking Workbooks but Not Slicers
In this video, you will learn how to lock workbooks but not slicers.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Adjusting Slicer Settings
In this video, you will learn how to adjust slicer settings.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Applying Multiple Filters to Data
In this video, you will learn how to apply multiple filters to data.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Sorting Using Custom Lists
In this video, you will learn how to sort using custom lists.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Applying Custom Number Formatting
In this video, you will learn how to apply custom number format.