Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Comprehensive Microsoft Excel
Excel Basics
Intro to Excel Tutorial (2:22)
How to Configure Excel (3:54)
How to Design and Format an Excel Spreadsheet (4:09)
Sorting and Filtering Data in Excel (5:00)
Text Formatting (6:33)
Connecting Text Columns in Excel (4:46)
Managing Tabs (5:36)
How to Pull Data from Tabs in Excel (4:32)
How to Use the Format Painter (2:59)
How to Freeze the Top Row in Excel (4:11)
How to Add a Header and Footer (3:35)
How to Print an Excel Spreadsheet on One Page (2:48)
Intermediate Excel Techniques
Excel Tips, Tricks and Shortcuts (11:51)
How to Use Math Formulas (3:59)
How to Use Formulas - Creating Sums (3:29)
How to Create Tables Automatically in Excel (3:43)
How to Round in Excel (1:57)
How to Calculate Averages (1:54)
How to Calculate Ages (3:30)
How to Use Themes (2:04)
Splitting Text Fields in Excel Automatically (4:31)
Advanced Excel Techniques
How to Add and Manage Sparklines (5:11)
How to Use Conditional Formatting (5:37)
How to Use the Count Formula (1:17)
How to Use If Then Statements (4:04)
How to Add and Design Charts (11:51)
Adding Comments (3:50)
How to Create Financial Scenarios (15:40)
How to Add SmartArt (5:34)
How to Pull in Data from a Website into an Excel Spreadsheet (4:07)
How to Create and Customize Pivot Tables (9:51)
How to Use the Format Painter
Download
Complete and Continue