Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Career Accelerator
Welcome!
Welcome! (0:48)
Course Guide & Downloadables
Basics
Anatomy of a Workbook (3:49)
Exploring the File Tab (2:12)
Working with Sheet Tabs (3:24)
Manipulating Columns, Rows, & Ranges (4:50)
Copy, Cut, & Paste (2:00)
Paste Special (3:06)
AutoFill & Custom Lists (5:18)
Flash Fill (3:31)
All About Dates (3:23)
Data Entry
Data Entry & Navigation (4:17)
Data Validation (10:18)
Formatting
Formatting (7:21)
Custom Number Formatting (7:46)
Conditional Formatting (10:00)
Formulas & Functions
Formula & Function Basics (6:33)
Order of Operations (6:03)
Cell References (8:07)
Text Functions (8:59)
Count Functions (3:03)
Round Functions (7:06)
IF Function (3:05)
Logical Functions (5:05)
Date Functions (6:58)
Calculating Time (5:32)
MAX, MIN, MAXIFS, & MINIFS (6:55)
SUM, AVERAGE, COUNT, and their Conditional Variants (9:49)
Dynamic Arrays (3:23)
Array Manipulation Functions (5:56)
FILTER Function (9:42)
VSTACK & HSTACK (7:48)
VLOOKUP & HLOOKUP (6:01)
INDEX MATCH (5:13)
XLOOKUP (13:02)
Named Ranges
Named Ranges Intro (3:22)
Named Range Basics (4:31)
Named Constants & Formulas (3:48)
Making Dynamic Named Ranges (3:00)
Excel Tables
Introduction to Tables (7:22)
Filtering & Sorting (Tables) (5:40)
Structured References (Tables) (7:12)
Pivot Tables & Pivot Charts
Introduction to Pivot Tables (4:13)
Create, Use, & Design Pivot Tables (10:30)
Sorting Pivot Tables (3:38)
Pivot Table Filters (3:05)
Refreshing Pivot Tables (2:43)
GETPIVOTDATA (4:22)
Conditional Formatting (Pivot Tables) (2:02)
Pivot Table Aggregations (3:38)
Pivot Table Grouping (5:57)
Calculated Fields (Pivot Tables) (5:42)
Calculated Items (Pivot Tables) (2:48)
Pivot Charts (3:33)
Slicers & Timelines (Pivot Tables) (4:53)
Get up to 90% off a future course!
Charts
Chart Types (7:48)
Chart Formatting (6:50)
Changing Chart Data Source (3:53)
Secondary Axis (Charts) (3:41)
Introduction to Power Query
Just an Introduction
Intro to Power Query (1:35)
Getting Data from PDFs (Power Query) (6:08)
Combine Tables from Different Files (Power Query) (6:12)
Miscellaneous
Checkboxes (4:24)
Comments & Notes (4:24)
Delete Empty Rows (4:47)
Freeze Panes & Split (4:44)
Go To Special (3:22)
Hiding, Grouping, & Subtotals (7:44)
Hyperlinks (6:10)
Justify Text (1:41)
Print Settings (2:38)
Page Numbers & More (2:44)
Printing Spacious Data (3:11)
Protecting Workbooks, Sheets, & Ranges (5:30)
Removing Duplicates (2:31)
Sparklines (3:27)
Get up to 90% off a future course!
SUM, AVERAGE, COUNT, and their Conditional Variants
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock