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
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!
Intro to Power Query
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock