Excel Intermediate 2010 Videos

Overview

The Excel 2010 Intermediate videos build on the knowledge gained in the previous course to further increase 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. Using Multiple Worksheets and Workbooks
  2. Advanced Formatting
  3. Outlining and Subtotals
  4. Cell and Range Names
  5. Tables
  6. Web and Sharing Features
  7. Advanced Charting
  8. Documenting and Auditing
  9. Templates and Settings
  10. PivotTables and PivotCharts

Video Access

To access the videos, go to Excel Intermediate 2010 Videos.

Questions?

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