Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - VLOOKUP Approximate Match
In this video, we will cover VLOOKUP approximate match.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 08 - copy-paste data in the blank worksheet
In this video, we will focus on Exercise 08 of this section, where we will first copy-paste data in the blank worksheet, link the data, and finally use 3D referencing.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - 3D Referencing
In this video, we will cover 3D referencing.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Linking to Other Worksheets and Workbooks
In this video, you will learn how to link to other worksheets and workbooks.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Pasting from the Clipboard
In this video, you will learn how to paste from the clipboard.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Paste Options
In this video, you will learn about the paste options.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using Cut and Copy
In this video, you will learn how to use cut and copy.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 07 - format data as a tabl
In this video, we will focus on Exercise 07 of this section, where we need to format data as a table, then sort and filter the data.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating Subtotals in a List
In this video, you will learn how to create subtotals in a list.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using Autofilter to Filter a List
In this video, you will learn how to use Autofilter to filter a list.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Sorting Using a Custom List (Custom Sort)
In this video, you will learn how to sort using a custom list (custom sort).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Sorting a List (Multi-Level Sort)
In this video, you will learn how to sort a list (multi-level sort).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Sorting a List (Single-Level Sort)
In this video, you will learn how to sort a list (single-level sort).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - How to Structure a List
In this video, you will learn how to structure a list.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 06 - format data, apply, and customize themes
In this video, we will focus on Exercise 06 of this section, where we need to format data, apply, and customize themes.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Applying Themes and Styles
In this video, you will learn how to apply themes and styles.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Deleting and Clearing Cells
In this video, you will learn how to delete and clear cells.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Working with Rows and Columns
In this video, you will learn how to work with rows and columns.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 05 -apply number formats and apply formatting to cells
In this video, we will focus on Exercise 05 of this section, where we will need to apply number formats and apply formatting to cells.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using Format Painter
In this video, you will learn how to use Format Painter.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Applying Date and Time Formats
In this video, you will learn how to apply date and time formats.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 04 - work on naming ranges and use named ranges in formulas
In this video, we will focus on Exercise 04 of this section, where we will work on naming ranges and use named ranges in formulas.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using Named Ranges in Calculations
In this video, you will learn how to use named ranges in calculations.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Managing Named Ranges
In this video, you will learn how to manage named ranges.