Excel Advanced 2010 Videos


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)


  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 Advanced 2010 Videos.


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