Excel Intermediate 2013 Videos

Training Access

To access the Practice Tests, Videos, or Quizzes, click Practice Tests, Videos, or Quizzes on the banner above and login.

Overview

The Excel 2013 Intermediate videos build on the knowledge gained in the previous course to further develop Excel knowledge and skill. Students will learn to work effectively with multiple worksheets and workbooks, use advanced formatting, outline and subtotal large amounts of data, and name cells and ranges. The videos also cover tables and filters, Excel's Web sharing features, and advanced charting for effective data presentation. In addition, students will use templates and auditing tools before learning to effectively utilize PivotTables and PivotCharts.

Training Materials

This training includes:

• Pre-assessment Test
• On-demand Video Instruction
• Quizzes
• Post-assessment Test
• Continuing Professional Education (CPE)

Topics

1. Managing Workbooks and Worksheets
2. Advanced Formatting
3. Outlining and Subtotals
4. Cell Range and Names
5. Data Structure and Tables
6. Web and Sharing Features
7. Documenting and Auditing
8. Templates and Settings

Questions?

If you have any questions or need assistance, please Contact Us.