Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 2013 Beginners/Intermediate Training
Introduction
Introduction to Excel 2013 (9:12)
What's New (7:31)
Course Exercise Files
Using Touch
Overview of Principles (3:39)
Getting Started
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns (11:20)
Templates; Creating, Opening, and Saving a Workbook (10:54)
Help
Online, Offline, and Contextual Help (8:00)
Settings and Preferences
Excel Options (11:22)
The Ribbon and Toolbars
Ribbon Interface (15:00)
Quick Access Toolbar (8:03)
Mini Toolbar (2:58)
Backup and Recovery
Create Backup Option; Auto-Recover and Autosave (6:54)
Entering and Deleting Data
Entering Text and Numbers (15:15)
Date Formats (15:57)
Formatting Cells; Editing and Deleting Data (15:15)
Fill (12:51)
Flash Fill (5:08)
Formatting a Worksheet
Themes and Cell Styles (14:01)
Inserting, Deleting, Hiding and Adjusting Rows and Columns (13:28)
Wrap Text and Alignment (15:02)
Merging Cells; Applying Themes and Styles (11:36)
Borders (9:25)
Copy, Paste and Paste Special
Copy, Cut and Paste (17:06)
Proofing
Spell checking (11:57)
Managing Worksheets
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets (14:51)
Comments
Inserting Comments (6:54)
Viewing and Printing
Workbook Views, Zoom and Freeze (11:17)
Printing; Headers, Footers and Margins (12:57)
Formulas and Functions
Overview of Formulas and Functions (14:08)
Cell References (14:50)
Names (15:38)
Finding Errors; New Excel Functions (14:13)
Working with Workbooks
Multiple Workbooks and Windows; Comparing Workbooks (10:39)
Find and Replace
Go to; Find and Replace Options (11:14)
Conditional Formatting
Applying, Clearing and Managing Rules (15:35)
Graphing and Charting
Chart Types; Chart Recommendation (13:35)
Basic Formatting (14:41)
Selecting Data, Positioning and Printing Charts (15:47)
File Types
Saving Workbooks; PDF and CSV Formats (11:21)
Managing Data
Sorting (9:06)
Filtering (10:43)
Tables (12:25)
Functions Case Study
VLOOKUP (12:58)
Text Function (5:17)
Date and Time Functions (5:32)
Logical Functions (18:31)
Analyzing Data
Financial Analysis Case Study - Part 1 (16:03)
Financial Analysis Case Study - Part 2 (9:23)
Quick Analysis Tool (7:57)
Shapes and Pictures
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt (14:27)
Sharing and Protecting
Protecting Worksheets (7:42)
Protecting Workbooks (10:02)
Sharing and SkyDrive (14:24)
More Backstage View Options
Trust Center; Export; Inspect Workbook (5:33)
Closing
Summary; More Help (1:49)
Downloadable course MP3 audio files
MP3 audio files
Course Transcripts
Course Quiz and Certificate of Completion
VLOOKUP
Complete and Continue