Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Speed Training
Introduction DEMO: Fast-track Course Overview
Demo - Overview (9:12)
Section 1: Excel Fundamentals - Quick Start
Top 10 Must-Know Excel Shortcuts (7:32)
Filter (6:49)
Section 2: Data Cleaning
Text to Columns (9:25)
Flash Fill (MS Excel 2013+ feature) (6:21)
Text Formulas - LEN() and TRIM() (1:27)
Excel Speed Training Feedback
Section 3: Essential Functions
Using Cell Reference ($) (6:05)
VLOOKUP (7:52)
SUMIFS and COUNTIFS (10:36)
Logical Functions (7:58)
Date Formulas - DATE, DAY, MONTH, YEAR (2:09)
SUMPRODUCT (3:27)
Section 4: Pivot Table
Pivot Table Tricks (10:31)
Excel Speed Training Feedback
Text to Columns
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock