Excel Advanced 2010 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 2010 Advanced videos help students continue to develop the knowledge and skills gained in previous lessons. Students will learn to use advanced functions, including logical, statistical, and financial functions, along with date and lookup functions. The videos also cover advanced data management, exporting and importing, and analytical tools, and will introduce students to macros and custom functions.

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

Questions?

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