This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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)
2. Basic formula operations
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock