5. Data Validation | Coursetakers

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Microsoft Excel Crash Course 2024: Masterclass for Weekend

1. Introduction

1. Introduction (3:38)
2. Getting started on Windows, macOS, Android, and IOS (1:33)
3. How to ask great questions (1:58)
4. FAQ (1:29)
5. Start Excel (6:56)
DOWNLOAD these Files First

2. Top 10 Excel Tips to Save You Time

1. Overview of top Excel tips (3:30)
2. Add numbers like a pro (8:56)
3. Save time by filling cells automatically (4:54)
4. Did data enter into one column? Split it (4:52)
5. Switch data around by transposing it (5:50)
6. Sort and filter for quick results (6:40)
7. Create a data table for tasks to make it easy (5:21)
8. Make drop-down list (7:32)
9. Quick Data Analysis (6:22)
10. Great charts for your visualization (4:43)
11. Pivot Tables for Data Analytics (6:08)

3. Excel essential functions

1. Introduction (1:14)
2. Basic formula operations (6:14)
3. Mathematical functions level1 (19:54)
4. Mathematical functions level2 (12:23)
5. Text functions level1 (9:07)
6. Text functions level2 (12:56)
7. Logical functions (11:03)
8. Date time functions (6:21)
9. V Lookup formula (12:12)
10. HLookup formula (4:07)
11. HLookup + Match formula (8:35)
12. Match + Index formula (5:22)

4. XLookup only for Excel 2021 and Office 365

1. Introduction (2:00)
2. XLOOKUP function (7:39)
3. Handling #NA and Approximates match in XLookup (10:31)
4. Wildcard matching in XLookup (6:12)

5. Get Data and tools

1. Introduction (1:45)
2. Split Text into columns (7:03)
3. Flash Fill (7:03)
4. Remove Duplicates (7:47)
5. Data Validation (6:34)
6. Get - import Data from Text (5:38)
7. Get - import Data from CSV (3:22)

6. Pivot Tables

1. Introduction (1:08)
2. Creating Pivot Table (6:43)
3. Value field settings (4:06)
4. Number format (2:28)
5. Pivot Table Design (3:20)
6. Excel Exercise (1:30)
7. Solution for Excel Exercise (1:33)

7. Excel Charts

1. Introduction (1:12)
2. Excel Charts – Categories (2:31)
3. Elements of a chart (4:12)
4. Easy way to create charts (1:55)
5. Column or Bar charts (4:21)
6. Formatting charts (3:37)
7. Line charts (2:13)
8. Area charts (2:04)
9. Pie and Doughnut charts (3:47)
10. Format Area Plot or XY chart (7:33)
11. Scatter or bubble charts (2:08)

Teach online with

5. Data Validation

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock