Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 2024 Crash Course Online
Introduction
Introduction (3:38)
Getting started on Windows, macOS, Android, and IOS (1:33)
How to ask great questions (1:58)
FAQ (1:29)
Start Excel (6:56)
Top 10 Excel Tips to Save You Time
Overview of top Excel tips (3:30)
Add numbers like a pro (8:56)
Save time by filling cells automatically (4:54)
Did data enter into one column – Split it (4:52)
Switch data around by transposing it (5:50)
Sort and filter for quick results (6:40)
Create a data table for tasks to make it easy (5:21)
Make drop-down list (7:32)
Quick Data Analysis (6:22)
Great charts for your visualization (4:43)
Pivot Tables for Data Analytics (6:08)
Excel essential functions
Introduction (1:14)
Basic formula operations (6:14)
Mathematical functions level – 1 (19:54)
Mathematical functions level – 2 (12:23)
Text functions level – 1 (9:07)
Text functions level – 2 (9:07)
Logical functions (11:03)
Date time functions (6:21)
V Lookup formula (12:12)
HLookup formula (4:07)
HLookup Match formula (4:07)
Match Index formula (5:22)
XLookup only for Excel 2021 and Office 365
Introduction (2:00)
XLookup (7:39)
Handling NA and Approximates match in XLookup (10:31)
Wildcard matching in XLookup (6:12)
Get data and tools
Introduction (1:45)
Split Text into columns (7:03)
Flash Fill (7:03)
Remove Duplicates (7:47)
Data Validation (6:34)
Get – import Data from Text (5:38)
Get – import Data from CSV (3:22)
Pivot Tables
Introduction (1:08)
Creating Pivot Table (6:43)
Value field settings (4:06)
Number format (2:28)
Pivot Table Design (3:20)
Excel Exercise – Pivot Tables (1:30)
Solution for Excel Exercise (1:33)
Excel Charts
Introduction (1:12)
Excel Charts – Categories (2:31)
Elements of a chart (4:12)
Easy way to create charts (1:55)
Column or Bar charts (4:21)
Formatting charts (3:37)
Line charts (2:13)
Area charts (2:04)
Pie and Doughnut charts (3:47)
Format Area Plot or XY chart (7:33)
Scatter or bubble charts (2:08)
Match Index formula
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock