Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Entering and Editing Data
In this video, you will learn how to enter and edit data.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 12 - work on two assignments
In this video, we will focus on Exercise 12 of this section, where we will work on two assignments: first to separate text and the other to find the closest value.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Extract Data from the Middle of a String
In this video, you will learn how to extract data from the middle of a string.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Loading Files into Excel
In this video, you will learn how to load files into Excel.
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 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 - 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 - Applying Custom Number Formatting
In this video, you will learn how to apply custom number format.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Custom Data Validation
In this video, we will cover custom data validation.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using Date and Time Functions
In this video, you will learn how to use date and time functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 12 - insert pictures and edit them
In this video, we will focus on Exercise 12 of this section, where we will insert pictures and edit them.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating Diagrams using SmartArt
In this video, you will learn how to create diagrams using SmartArt.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 09 - VLOOKUP formula
In this video, we will focus on Exercise 09 of this section, where we will apply the VLOOKUP formula.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Working with Time and Date Functions
In this video, you will learn how to work with time and date functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Inserting Hyperlinks to Worksheets
In this video, you will learn how to insert hyperlinks to worksheets.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Aligning Text and Numbers
In this video, you will learn how to align text and numbers.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The SORT Function - Horizontal SORT
In this video, we will cover the SORT function - horizontal SORT.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Joining Data Using CONCAT
In this video, you will learn how to join data using CONCAT.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Splitting or Combining Cell Data Using Flash Fill
In this video, you will learn how to split or combine cell data using Flash Fill.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Splitting Data Using Text Functions
In this video, you will learn how to split data using text functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Splitting Data Using Text to Columns
In this video, you will learn how to split data using text to columns.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Changing Case and Removing Spaces
In this video, you will learn how to change the case and remove spaces.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 04 - ork with the date and time functions
In this video, we will focus on Exercise 04 of this section, where we will work with the date and time functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Error Handling with IFERROR and IFNA
In this video, we will cover error handling with IFERROR and IFNA.