Learn Microsoft Excel 2013 Beginner Course
  • Introduction
  • WATCH ME: Essential Information for a Successful Training Experience
  • Excel 2013 Exercise Files
  • What's New
  • Using Touch
  • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
  • Templates; Creating, Opening, and Saving a Workbook
  • Online, Offline, and Contextual Help
  • Excel Options
  • Ribbon Interface
  • Quick Access Toolbar
  • Mini Toolbar
  • Create Backup Option; Auto-Recover and Autosave
  • Entering Text and Numbers
  • Date Formats
  • Formatting Cells; Editing and Deleting Data
  • Fill
  • Flash Fill
  • Themes and Cell Styles
  • Inserting, Deleting, Hiding and Adjusting Rows and Columns
  • Wrap Text and Alignment
  • Merging Cells; Applying Themes and Styles
  • Borders
  • Copy, Cut and Paste
  • Spell checking
  • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
  • Inserting Comments
  • Workbook Views, Zoom and Freeze
  • Printing; Headers, Footers and Margins
  • Overview of Formulas and Functions
  • Cell References
  • Names
  • Finding Errors; New Excel Functions
  • Multiple Workbooks and Windows; Comparing Workbooks
  • Go to; Find and Replace Options
  • Applying, Clearing and Managing Rules
  • Chart Types; Chart Recommendation
  • Basic Formatting
  • Selecting Data, Positioning and Printing Charts
  • Saving Workbooks; PDF and CSV Formats
  • Sorting
  • Filtering
  • Tables
  • VLOOKUP
  • Text Function
  • Date and Time Functions
  • Logical Functions
  • Financial Analysis Case Study - Part 1
  • Financial Analysis Case Study - Part 2
  • Quick Analysis Tool
  • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
  • Protecting Worksheets
  • Protecting Workbooks
  • Sharing and SkyDrive
  • Trust Center; Export; Inspect Workbook
  • Summary; More Help
  • Excel 2013 Quiz
Learn Microsoft Excel 2013 Advanced Training Course
  • Prerequisites of Excel 2013 Advanced Course
  • Excel 2013 Advanced Exercise Files
  • List of Functions; Common Types of Arguments; Basic Use of Functions
  • Advanced Aspects of Functions; Searching for a Function
  • Autosum
  • Payment
  • Future Value
  • Principle Payment
  • Depreciations
  • How Dates and Times are Stored
  • Dates and Times Calculation
  • Exercise on Date and Time Functions; Date and Time Settings
  • Average
  • Percentile
  • Regression
  • LINEST Function
  • Example of Functions for Inferential Statistics
  • Text Function Case Study - 1
  • Text Function Case Study - 2
  • Lookup and Reference Functions
  • Logical Functions
  • Connecting to Other Workbooks
  • Connecting to Access Data
  • Connecting to Web Data
  • Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
  • Inserting Columns and Rows; Resizing Tables
  • Table Reference
  • Table Styles
  • Table Selection
  • Basic Principles of Pivot Tables
  • Presentational Side of Pivot Tables
  • Filtering in Pivot Tables; Slices
  • What if
  • Scenario Manager
  • Goal Seeker
  • Solver
  • Area Charts
  • Surface Charts
  • Stock Charts - Part 1
  • Stock Charts - Part 2
  • Radar Charts