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 - Using LARGE and SMALL
In this video, you will learn how to use LARGE and SMALL.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using MEDIAN, MODE.SNGL, and MODE.MULT
In this video, you will learn how to use MEDIAN, MODE.SNGL, and MODE.MULT.
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 - Performing Two-Way Lookups
In this video, you will learn how to perform two-way lookups.
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 - Using XMATCH
In this video, you will learn how to use XMATCH.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using XLOOKUP to Perform Complex Lookups
In this video, you will learn how to use XLOOKUP to perform complex lookups.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using RANDARRAY and RANDBETWEEN to Randomize Data
In this video, you will learn how to use RANDARRAY and RANDBETWEEN to randomize data.
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 - FILTER with Logic: = Operator (Both or Neither)
In this video, we will cover FILTER with logic and learn about = Operator (Both or Neither).
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 - Exercise 12 - perform a WhatIf analysis
In this video, we will focus on Exercise 12 of this section, where we will perform a WhatIf analysis.
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 - Assembling a Dashboard - Part 2
In this video, you will learn how to assemble a dashboard - part 2.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Assembling a Dashboard - Part 1
In this video, you will learn how to assemble a dashboard - part 1.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Formatting a Pivot Chart - Part 2
In this video, you will learn how to format a pivot chart - part 2.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Importing Data into Excel
In this video, you will learn how to import data into Excel.
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.