Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Specialized Rounding (MROUND, CEILING.MATH, and FLOOR.MATH)
In this video, we will cover specialized rounding (MROUND, CEILING.MATH, and FLOOR.MATH).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Rounding Values Using ROUND, ROUNDUP, and ROUNDDOWN
In this video, you will learn how to round values using ROUND, ROUNDUP, and ROUNDDOWN.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 04 - AVERAGE, MEDIAN, and MODE.
In this video, we will focus on Exercise 04 of this section, where need to find the AVERAGE, MEDIAN, and MODE.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The COUNTBLANK Function
In this video, we will cover the COUNTBLANK function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Ranking Data with Sorting Using RANK.EQ and RANK.AVG
In this video, you will learn how to rank data with sort using RANK.EQ and RANK.AVG.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using LARGE and SMALL
In this video, you will learn how to use LARGE and SMALL.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 03 -work on a two-way XLOOKUP
In this video, we will focus on Exercise 03 of this section, where we will work on a two-way XLOOKUP.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using the SWITCH Function
In this video, you will learn how to use the SWITCH function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using the CHOOSE Function
In this video, you will learn how to use the CHOOSE function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 02 - work on the UNIQUE function
In this video, we will focus on Exercise 02 of this section, where we will work on the UNIQUE function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - FILTER with Logic: - Operator (One or the Other)
In this video, we will cover FILTER with logic and learn about - Operator (One or the Other).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Simple SEQUENCE and Unstacking Records
In this video, we will cover simple SEQUENCE and unstacking records.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Introduction to Spills and Arrays
In this video, we will get introduced to Spills and Arrays.
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 - The OFFSET Function
In this video, we will cover the OFFSET function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information Using VLOOKUP (Exact Match)
In this video, you will learn how to look up information using VLOOKUP (Exact Match).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Nested IFs
In this video, we will cover nested IFs.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Protecting Workbooks and Worksheets
In this video, you will learn how to protect workbooks and worksheets.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Basic Logical Functions (IF, AND, OR)
In this video, we will cover basic logical functions (IF, AND, OR).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Formulas and Functions Explained
In this video, you will learn some formulas and functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - FILTER with Logic: * Operator (AND)
In this video, we will cover FILTER with Logic and learn about * Operator (AND).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - FILTER with Logic: + Operator (OR)
In this video, we will cover FILTER with logic and learn about + Operator (OR).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The SORT Function
In this video, we will cover the SORT function.
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.