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 