Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 2019/365 - Beginners Course
Chapter 1: Into to Excel
Intro to Excel (1:00)
What's New In Excel 2019 (7:52)
Course Overview (1:16)
Overview of the Excel window (8:25)
Mouse-Features (3:12)
Back Stage View (2:37)
Course Exercise Files
Chapter 2: Creating Workbooks
Entering Text and Numbers (4:31)
Creating Basic Formulas (6:49)
Relative References (3:01)
Order of Operations (4:48)
Working with Ranges (4:14)
Module 2 - Practice Exercise (1:35)
Chapter 3: Saving Workbooks
Working with the Save and Save As Commands (4:34)
File Extensions, Share, Export and Publish Files (3:44)
Module 3 - Practice Exercise (0:58)
Chapter 4: Navigating Workbooks
Opening a File (5:32)
Working with Larger Files (5:34)
Freeze Panes Option (3:16)
Split Screen Option (3:21)
Module 4 - Practice Exercise (2:49)
Chapter 5: Page Setup & Print Options
Headers and Footers (7:23)
Print Titles (2:52)
Comments (5:23)
Page Setup Options (7:29)
Fit to Print on One Page (3:58)
Printing Workbooks (3:55)
Module 5 - Practice Exercise (1:53)
Chapter 6: Working with Rows, Columns and Cells
Adding and deleting rows columns and cells (6:12)
Changing Column and-Row Widths (3:45)
Module 6 - Practice Exercise (1:11)
Chapter 7: Moving Data
Cut Copy and Paste (7:07)
Copying Formulas (5:09)
Module 7 - Practice Exercise (1:20)
Chapter 8: Formulas & Functions
Overview of Formulas (2:47)
Create Formulas Using Functions Part 1 (10:03)
Create Formulas Using Functions Part 2 (5:24)
Absolute Values (5:16)
Module 8 - Practice Exercise (1:20)
Chapter 9: Working with Sheets
Adding Deleting and Renaming Sheets (4:09)
Additional Sheet Tab Options (5:19)
3 Dimensional Formulas (5:28)
Module 9 - Practice Exercise (1:31)
Chapter 10: Formatting Worksheets
Formatting Cells part 1 (10:04)
Formatting Cells Part 2 (3:38)
Formatting Numbers (9:24)
Borders and Shading (7:08)
Format as Table (6:07)
Using Styles (3:49)
Using Format Painter (4:29)
Protecting Sheets (9:00)
Fill Handle and Custom Lists (7:17)
Module 10 - Practice Exercise (1:10)
Chapter 11: Charts
Creating Charts (9:48)
Types of Charts (5:58)
Editing Charts Part 1 (11:00)
Editing Charts Part 2 (3:12)
Using Graphics to Enhance Charts (5:05)
Linking Chart Titles (2:47)
Module 11 - Practice Exercise (0:53)
Chapter 12: Working with Names
Creating Range Names (7:45)
Managing Names (3:17)
Using Names in Formulas (5:58)
Module 12 - Practice Exercise (1:20)
Chapter 13: Sorting & Filtering
Remove Duplicates (7:45)
Sort Data (10:28)
Filter Data (7:38)
Advanced Filters (4:46)
Module 13 - Practice Exercise (0:57)
Chapter 14: Outlining & Subtotaling
Creating an Outline (6:01)
Subtotals (8:00)
Module 14 - Practice Exercise (1:07)
Chapter 15: Working with Views
Arranging Files (3:14)
New Window Option (2:45)
Custom Views (5:32)
Module 15 - Practice Exercise (1:07)
Chapter 16: Linking Files
Creating Formulas Between Files (6:35)
Working with Links (4:01)
Consolidating Data (5:16)
Module 16 - Practice Exercise (1:30)
Chapter 17: Advanced Formula Creation
If Statements (7:49)
VLookups (7:39)
Data Validation (8:13)
Formula Auditing (5:29)
Module 17 - Practice Exercise (1:19)
Chapter 18: Pivot Tables
Pivot Tables (9:36)
Pivot Charts (3:16)
Module 18 - Practice Exercise (0:56)
Chapter 19: Additional Excel Features
Slicers (4:41)
Goal Seeker (2:56)
Text to Columns (2:49)
Watch Window (2:32)
Customizing Ribbons and Tabs (3:25)
Module 19 - Practice Exercise (1:23)
Chapter 20: Shortcuts
Excel Shortcuts Every User Should Know (12:00)
Chapter 21: Closing
Closing Video (0:37)
Course Quiz and Certificate of Completion
Data Validation
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock