Excel Secrets (2 CPE)

Excel Secrets: 4 Time-Saving Features

Do you feel like there is a faster way of doing things, but don't have time to figure it out? If so, I'd like to invite you to enroll into this free course. There are 5 lessons that demonstrate features that will help you use Excel to get your work done faster.


The following lesson include a short video, practice files, a quiz, and additional resources. Pass the final exam with a score of 70% or better to download the certificate of completion.

  • Lesson 1 - Flash Fill
  • Lesson 2 - Tables
  • Lesson 3 - PivotTable Intro
  • Lesson 4 - Power Query Intro
  • Lesson 5 - Connecting the Dots

Note: registering for this course will also subscribe you to the Excel University weekly email newsletter.

If you are a CPA, this program is offered for 2 CPE credits.

Learning Objectives

  • Recall the special properties of Tables
  • Identify the Excel feature that summarizes values and displays them in rows and columns and includes totals
  • Recall which tool is designed to get and transform data

Additional Information

  • Recommended CPE Credits: 2 Hours
  • Program Level: Basic
  • Prerequisites: None
  • Advance preparation needed: None
  • Delivery method: QAS Self-Study
  • Field of Study: Computer Software & Applications
  • Expiration: 30 days
  • Registration: To register, click the Buy Now button and complete the checkout process
  • Complaint Resolution: jeff@excel-university.com or 949-200-7688
Excel University, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the national Registry of CPE Sponsors through its website: www.nasbaregistry.org
Price: $0.00