Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 365 Essentials
Section 1: Excel Overview
Course Welcome (2:06)
DOWNLOAD ME: Course Files
DOWNLOAD ME: Exercise Files
Ribbon Overview (4:08)
Cursor Options (2:11)
Data Entry Basics (3:12)
Layout Options (5:17)
Section 2: Formatting
Intro to Formatting (5:56)
Number Formatting (7:06)
Formatting with Styles (7:07)
Formatting with Tables (12:24)
Exercise 1 (1:39)
Section 3: Formulas
Intro to Formulas (8:05)
Relative and Absolute References (5:13)
Exercise 2 (0:57)
Section 4: AutoFill
AutoFill (14:17)
Creating Custom Lists (5:18)
Exercise 3 (1:08)
Section 5: Conditional Formatting
Conditional Formatting Intro (7:40)
Conditional Formatting: Blank Cells (3:41)
Conditional Formatting: Icons and Color Scales (7:13)
Exercise 4 (1:31)
Section 6: Sorting and Filtering
Sorting Data (7:15)
Filtering Data (5:15)
Text to Columns (4:29)
Conditional Formatting: Sorting and Filtering (3:24)
Exercise 5 (0:37)
Section 7: Working with Large Workbooks
Freeze Panes (3:36)
Splitting (3:50)
Printing (4:10)
Print Titles (3:53)
Page Break Settings (3:14)
Center Align Sheets (1:51)
Headers & Footers (11:51)
Exercise 6 (1:12)
Section 8: Charts
Intro to Charts (4:09)
Column Charts (7:26)
Chart Elements (6:33)
Chart Formatting (3:50)
Pie Chart (10:16)
Inserting Charts into PowerPoint (7:00)
Exercise 7 (0:48)
Course Close
Course Close (2:36)
Course Quiz and Certificate of Completion
Cursor Options
Complete and Continue