Excel 2013 Beginners: Introduction
  • Introduction to Excel 2013
  • WATCH ME: Essential Information for a Successful Training Experience
  • Excel 2013 Exercise Files
  • What's New
Excel 2013 Beginners: Using Touch
  • Overview of Principles
Excel 2013 Beginners: Getting Started
  • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
  • Templates; Creating, Opening, and Saving a Workbook
Excel 2013 Beginners: Help
  • Online, Offline, and Contextual Help
Excel 2013 Beginners: Settings and Preferences
  • Excel Options
Excel 2013 Beginners: The Ribbon and Toolbars
  • Ribbon Interface
  • Quick Access Toolbar
  • Mini Toolbar
Excel 2013 Beginners: Backup and Recovery
  • Create Backup Option; Auto-Recover and Autosave
Excel 2013 Beginners: Enterting and Deleting Data
  • Entering and Deleting Data
  • Date Formats
  • Formatting Cells; Editing and Deleting Data
  • Fill
  • Flash Fill
Excel 2013 Beginners: 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
Excel 2013 Beginners: Copy, Paste and Paste Special
  • Copy, Cut and Paste
Excel 2013 Beginners: Proofing
  • Spell checking
Excel 2013 Beginners: Managing Worksheets
  • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
Excel 2013 Beginners: Comments
  • Inserting Comments
Excel 2013 Beginners: Viewing and Printing
  • Workbook Views, Zoom and Freeze
  • Printing; Headers, Footers and Margins
Excel 2013 Beginners: Formulas and Functions
  • Overview of Formulas and Functions
  • Cell References
  • Names
  • Finding Errors; New Excel Functions
Excel 2013 Beginners: Working with Workbooks
  • Multiple Workbooks and Windows; Comparing Workbooks
Excel 2013 Beginners: Find and Replace
  • Go to; Find and Replace Options
Excel 2013 Beginners: Conditional Formatting
  • Applying, Clearing and Managing Rules
Excel 2013 Beginners: Graphing and Charting
  • Chart Types; Chart Recommendation
  • Basic Formatting
  • Selecting Data, Positioning and Printing Charts
Excel 2013 Beginners: File Types
  • Saving Workbooks; PDF and CSV Formats
Excel 2013 Beginners: Managing Data
  • Sorting
  • Filtering
  • Tables
Excel 2013 Beginners: Functions Case Study
  • VLOOKUP
  • Text Function
  • Date and Time Functions
  • Logical Functions
Excel 2013 Beginners: Analyzing Data
  • Financial Analysis Case Study - Part 1
  • Financial Analysis Case Study - Part 2
  • Quick Analysis Tool
Excel 2013 Beginners: Shapes and Pictures
  • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
Excel 2013 Beginners: Sharing and Protecting
  • Protecting Worksheets
  • Protecting Workbooks
  • Sharing and SkyDrive
Excel 2013 Beginners: More Backstage View Options
  • Trust Center; Export; Inspect Workbook
Excel 2013 Beginners: Closing
  • Summary; More Help
  • Excel 2013 Quiz
Excel 2013 Advanced: Introduction
  • Prerequisites of Excel 2013 Advanced Course
  • WATCH ME: Essential Information for a Successful Training Experience
  • Excel 2013 Advanced Exercise Files
  • Course Review
Excel 2013 Advanced: Functions
  • List of Functions; Common Types of Arguments; Basic Use of Functions
  • Advanced Aspects of Functions; Searching for a Function
  • Autosum
Excel 2013 Advanced: Personal and Professional Financial Functions
  • Payment
  • Future Value
  • Principle Payment
  • Depreciations
Excel 2013 Advanced: Date and Time Functions
  • How Dates and Times are Stored