Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 01 - download all the required files
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.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Section Introduction - 3
In this video, we have a quick section introduction.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Section Summary - 2
In this video, we will summarize the learnings from this section.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Data Tables: Two Variables
In this video, we will cover data tables with two variables.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Data Tables: One Variable
In this video, we will cover data tables with one variable.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using Scenario Manager
In this video, you will learn how to use the Scenario Manager.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Goal Seek and the PMT Function
In this video, we will cover Goal Seek and the PMT function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 11 - data validation
In this video, we will focus on Exercise 11 of this section, where we will work on data validation.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Other Types of Data Validation
In this video, we will cover other types of data validation.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating Dynamic Drop-Down Lists
In this video, you will learn how to create dynamic drop-down lists.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 10 - formula auditing
In this video, we will focus on Exercise 10 of this section, where we will work on formula auditing.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Tracing Precedents and Formula Auditing
In this video, you will learn how to trace precedents and formula audit.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Troubleshooting Common Errors
In this video, you will learn how to troubleshoot common errors.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 09 - nteractive dashboards
In this video, we will focus on Exercise 09 of this section, where we will work on interactive dashboards.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Assembling a Dashboard - Part 3
In this video, you will learn how to assemble a dashboard - part 3.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - What Is a Dashboard?
In this video, we will understand the dashboard.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 08 - adding interaction
In this video, we will focus on Exercise 08 of this section, where we will work on adding interaction.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Updating PivotTable Data
In this video, you will learn how to update PivotTable data.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Connecting Slicers to Pivot Charts
In this video, you will learn how to connect slicers to pivot charts.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Inserting Timeline Slicers
In this video, you will learn how to insert timeline slicers.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Inserting and Formatting Slicers
In this video, you will learn how to insert and format slicers.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 07 - working with pivot charts
In this video, we will focus on Exercise 07 of this section, where we will be working with pivot charts.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using Map Charts
In this video, you will learn how to use map charts.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating a Pivot Chart
In this video, you will learn how to create a pivot chart.