Visit Our New Website at nacpb.org

Ordering on atunlimited.com expired on Dec 31, 2021

Excel Advanced 2013 Videos

National Registry of CPE Sponsors - NASBA

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 Advanced videos help students continue to develop the knowledge and skills gained in previous lessons. Students will learn to use Excel to perform 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. Advanced Functions and Formulas
  2. Lookups and Data Tables
  3. Advanced Data Management
  4. Advanced Charting
  5. PivotTables and PivotCharts
  6. Exporting and Importing Data
  7. Analytical Tools
  8. Macros and Visual Basic
  9. Accessibility and Language Features

Questions?

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