Title: Excel 2013
Duration: 10 hours
Videos: 54
Learn Excel 2013
Course Description
From data entry and worksheet formatting to graphing and data analysis, you’ll master Excel 2013 with this 10-hour video training course:
- Learn how to get started with workbooks whether using a mouse or touch device.
- Discover how to create sophisticated charts and graphs using custom visuals or templates.
- Set-up preferences and create back-up options.
- Use flash fill to enter data quickly.
- Learn how to apply themes and cell styles
- Find out how to work with multiple sheets at once—and on more than one screen.
- Discover how to create formulas and functions that help you analyze your data.
- Share and protect your information with SkyDrive and other collaborative tools.
- Practice with bonus Excel 2013 exercise files.
Chapter 1: Introduction
-
9:13
-
7:32
Chapter 2: Using Touch
-
3:39
Chapter 3: Getting Started
-
11:20
-
10:55
Chapter 4: Help
Chapter 5: Settings and Preferences
-
Excel Options11:22
Chapter 6: The Ribbon and Toolbars
-
Ribbon Interface15:00
-
Mini Toolbar2:58
Chapter 7: Backup and Recovery
Chapter 8: Entering and Deleting Data
-
Date Formats15:58
-
Fill12:51
-
Flash Fill5:08
Chapter 9: Formatting a Worksheet
-
Borders9:26
Chapter 10: Copy, Paste and Paste Special
-
Copy, Cut and Paste17:06
Chapter 11: Proofing
-
Spell checking11:57
Chapter 12: Managing Worksheets
Chapter 13: Comments
Chapter 14: Viewing and Printing
Chapter 15: Formulas and Functions
-
Cell References14:51
-
Names15:39
Chapter 16: Working with Workbooks
Chapter 17: Find and Replace
Chapter 18: Conditional Formatting
Chapter 19: Graphing and Charting
-
Basic Formatting14:43
Chapter 20: File Types
Chapter 22: Functions Case Study
-
VLOOKUP12:58
-
Text Function5:17
-
Logical Functions18:31
Chapter 23: Analyzing Data
Chapter 24: Shapes and Pictures
Chapter 25: Sharing and Protecting
-
Protecting Workbooks10:06
-
Sharing and SkyDrive14:25
Chapter 26: More Backstage View Options
Chapter 27: Closing
Chapter 28: Bonus material
Online Quiz and Certificate of Completion
Excel 2013 Online Training Course Overview
Watch our Microsoft Excel 2013 training tutorials from any computer, iPad, or iPhone. Without the physical limitations of a training CD or DVD, our Excel 2013 training course can be accessed anytime, anywhere.
From data entry and worksheet formatting to graphing and data analysis, you’ll master Excel 2013 with this 10-hour video training course:
- Learn how to get started with workbooks whether using a mouse or touch device.
- Discover how to create sophisticated charts and graphs using custom visuals or templates.
- Set-up preferences and create back-up options.
- Use flash fill to enter data quickly.
- Learn how to apply themes and cell styles.
- Find out how to work with multiple sheets at once—and on more than one screen.
- Discover how to create formulas and functions that help you analyze your data.
- Share and protect your information with SkyDrive and other collaborative tools.
- Practice with bonus Excel 2013 exercise files.
