Introduction
  • Introduction to Excel 2013
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course exercise files & Excel 2013 keyboard shortcuts
  • What's New
  • Course transcripts
Using Touch
  • Overview of Principles
Getting Started
  • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
  • Templates; Creating, Opening, and Saving a Workbook
Help
  • Online, Offline, and Contextual Help
Settings and Preferences
  • Excel Options
The Ribbon and Toolbars
  • Ribbon Interface
  • Quick Access Toolbar
  • Mini Toolbar
Backup and Recovery
  • Create Backup Option; Auto-Recover and Autosave
Entering and Deleting Data
  • Entering Text and Numbers
  • Date Formats
  • Formatting Cells; Editing and Deleting Data
  • Fill
  • Flash Fill
Formatting a Worksheet
  • Themes and Cell Styles
  • Inserting, Deleting, Hiding and Adjusting Rows and Columns
  • Wrap Text and Alignment
  • Merging Cells; Applying Themes and Styles
  • Borders
Copy, Paste and Paste Special
  • Copy, Cut and Paste
Proofing
  • Spell checking
Managing Worksheets
  • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
Comments
  • Inserting Comments
Viewing and Printing
  • Workbook Views, Zoom and Freeze
  • Printing; Headers, Footers and Margins
Formulas and Functions
  • Course Review
  • Overview of Formulas and Functions
  • Cell References
  • Names
  • Finding Errors; New Excel Functions
Working with Workbooks
  • Multiple Workbooks and Windows; Comparing Workbooks
Find and Replace
  • Go to; Find and Replace Options
Conditional Formatting
  • Applying, Clearing and Managing Rules
Graphing and Charting
  • Chart Types; Chart Recommendation
  • Basic Formatting
  • Selecting Data, Positioning and Printing Charts
File Types
  • Saving Workbooks; PDF and CSV Formats
Managing Data
  • Sorting
  • Filtering
  • Tables
Functions Case Study
  • VLOOKUP
  • Text Function
  • Date and Time Functions
  • Logical Functions
Analyzing Data
  • Financial Analysis Case Study - Part 1
  • Financial Analysis Case Study - Part 2
  • Quick Analysis Tool
Shapes and Pictures
  • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
Sharing and Protecting
  • Protecting Worksheets
  • Protecting Workbooks
  • Sharing and SkyDrive
More Backstage View Options
  • Trust Center; Export; Inspect Workbook
Closing
  • Summary; More Help
Downloadable course MP3 audio files
  • MP3 audio files
Assessment
  • Course Quiz