Excel 2013

Tutorial videos and training documents provided by Microsoft

Tutorial Videos:

  1. Start Using Excel 2013
  2. Save and Print a Workbook
  3. Insert Columsn and Rows
  4. Add Formulas and References
  5. Advanced Formulas and References
  6. Get Going Fast
  7. A First Look at Excel 2013
  8. How Things are Organized
  9. A Closer Look at the Ribbon
  10. Save, Publis, and Share
  11. Basic Math: Introduction
  12. Basic Math: Using Functions
  13. Basic Math: Operator Order
  14. Basic Math: More Complex Formuas
  15. Add numbers: Introducation
  16. The SUM function
  17. The SUMIF Funcation
  18. Introduction to Drop Down Lists
  19. Drop Down List Settings
  20. Input and Erro Messages for Drop Down Lists
  21. Manage Drop Down Lists
  22. The VLOOKUP Funcation
  23. The Nuts and Bolts of VLOOKUP
  24. Look Up Values on a Different Worksheet
  25. Copy a VLOOKUP Formula
  26. Introducation to IF Functions
  27. Nested IF Functions
  28. IF with AND and OR
  29. COUNTIF and SUMIF
  30. AVERAGEIF and IFERROR
  31. Excel 2013 Flash Fill
  32. Excel 2013 Power View
  33. Excel 2013 Quick Analyis
  34. Excel 2013 Recommended Charts
  35. Excel 2013 Recommended Pivot Tables
  36. Excel 2013 Simplified Sharing

 

Training Documents and Links

  1. Excel Quick Start Guide
  2. What's New in Excel 2013
  3. Training Courses for Excel 2013
  4. Make the Switch to Excel 2013