Excel University Certification (40 CPE, 1 Year)

(CEUG)

Overview

The Certified Excel University Graduate program is an Excel Certification specifically designed for accounting and finance professionals. It is a comprehensive training program that developes your Excel skills, and demonstrates your Excel proficiency. 

Notes:

  • • Registration closes on August 31, 2017 or until we reach the max student count
  • • Enrollment includes printed Excel University Volumes 1-4 textbooks 

 

  • Freshman (Volume 1)

    • • Lessons 101 - 102
    • • Covers the foundations for how to build reliable recurring-use workbooks
  • Sophomore (Volume 2)

    • • Lessons 201 - 205
    • • Demonstrates how to build efficient formula-based reports
  • Junior (Volume 3)

    • • Lessons 301 - 304
    • • Examines the details of PivotTables, and discusses when and how they replace formula-based reports
  • Senior (Volume 4)

    • • Lessons 401 - 405
    • • Illustrates how to create efficient internal-use workpapers and workbooks
  • Author

    Jeff Lenning CPA CITP
  • Subject

    Excel University Graduate Certification Program
  • Benefits

    Begin Now: begin training immediately
    Moderated: ask questions in the moderated forums
    Certificate: download and print your certificate instantly upon completion
    Pause and Resume: pause and resume training as needed
    Exam: unlimited exam attempts
  • Software

    Designed for Microsoft Excel for Windows Versions 2010+
  • Format

    Online, on-demand lecture videos and homework.
  • Access Begins

    Immediately
  • Duration

    The enrollment period is one year, as set by NASBA.
  • Certificate of Completion

    Download instantly once a passing score on the final exam is achieved. You may re-attempt the final exam as many times as necessary.

  • Lesson 101

  • Lecture Videos (h:mm:ss)
  • • Freshman Orientation (0:1:58)
  • • Lesson 101 (1:35:35)
  • • Key topics: Named references, Tables, Data validation
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 101 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solutions Videos
  • • Related blog posts
  • • Shortcut Reference / Index / Glossary
  • Lesson 102

  • Lecture Videos
  • • Lesson 102 (1:22:59)
  • • Key topics: Conditional formatting, better summing, design principles
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 102 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solution videos
  • • Related blog posts
  • Lesson 201

  • Lecture Videos
  • • Sophomore Orientation (0:2:18)
  • • Lesson 201 (1:17:30)
  • • Key topics: Conditional summing, Remove duplicates, Lookup basics
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 201 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solutions Videos
  • • Related blog posts
  • Lesson 202

  • Lecture Videos
  • • Lesson 202 (1:01:53)
  • • Key topics: Vlookup, Match, Value, Text, Index
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 202 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solution videos
  • • Related blog posts
  • Lesson 203

  • Lecture Videos
  • • Lesson 203 (0:50:24)
  • • Key topics: Iferror, If, List comparisons
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 203 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solutions Videos
  • • Related blog posts
  • Lesson 204

  • Lecture Videos
  • • Lesson 204 (1:19:40)
  • • Key topics: Formatting, Sumifs, Date functions
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 204 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solution videos
  • • Related blog posts
  • Lesson 205

  • Lecture Videos
  • • Lesson 205 (1:22:37)
  • • Key topics: Dynamic headers, Mapping tables, Applications
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 205 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solutions Videos
  • • Related blog posts
  • Lesson 301

  • Lecture Videos
  • • Junior Orientation (0:2:21)  
  • • Lesson 301 (1:15:30)
  • • Key topics: PivotTable fundamentals, Updating data, Groups
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 301 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solution videos
  • • Related blog posts
  • Lesson 302

  • Lecture Videos
  • • Lesson 302 (1:00:50)
  • • Key topics: Report type comparison, Layout, Design, Multiple value fields
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 302 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solutions Videos
  • • Related blog posts
  • Lesson 303

  • Lecture Videos
  • • Lesson 303 (1:23:07)
  • • Key topics: PivotTable formulas, Sorting, Filtering, Hybrid reports
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 303 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solution videos
  • • Related blog posts
  • Lesson 304

  • Lecture Videos
  • • Lesson 304 (1:16:43)
  • • Key topics: External data, Data preparation, Data visualization
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 304 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solutions Videos
  • • Related blog posts
  • Lesson 401

  • Lecture Videos
  • • Senior Orientation (3:22)
  • • Lesson 401 (1:21:35)
  • • Key topics: Features, Formatting, Protecting, Hyperlinks
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 401 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solution videos
  • • Related blog posts
  • Lesson 402

  • Lecture Videos
  • • Lesson 402 (1:05:56)
  • • Key topics: Lookup functions, Text functions, Date functions
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 402 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solutions Videos
  • • Related blog posts
  • Lesson 403

  • Lecture Videos
  • • Lesson 403 (1:08:30)
  • • Key topics: Techniques, Ribbon review, Conditional formatting, Names
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 403 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solution videos
  • • Related blog posts
  • Lesson 404

  • Lecture Videos
  • • Lesson 404 (0:47:29)
  • • Key topics: Wildcards, Tables, Start Here
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 404 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solutions Videos
  • • Related blog posts
  • Lesson 405

  • Lecture Videos
  • • Lesson 405 (0:58:22)
  • • Key topics: Conditional formatting, better summing, design principles
  • Homework Activities
  • • Excel exercises
  • • Discussion forum
  • Tests
  • • Lesson 405 quiz
  • • Breakout puzzle
  • Additional Resources
  • • Answer workbooks
  • • Lecture videos
  • • Solution videos
  • • Related blog posts

Student Comments

  • Short Video: Student Interview Clips

  • • "Very engaging, fun class!"

  • • "Valuable resource to increase personal organization and productivity."

  • • "Enthusiastic and engaging!"

  • • "Excellent presenter, would recommend."

  • • "Very good training, would recommend to other professionals."

  • • "Being exposed to new formulas and functions was valuable."

  • • "Great course, really going to try to implement new things learned."

  • • "Thank you goes to Jeff for great training- very helpful and useful."

  • • "Really enjoyed Jeff. Very knowledgeable and great presenter. Exercises were also very helpful."

NASBA QAS CPE Microsoft Excel LogoObjectives

  • • State the process to create a PivotTable report
  • • Distinguish between formula-based and PivotTable reports
  • • Identify three Excel features that can graphically communicate information

Program Level

Basic

Prerequisites

None

Advance Preparation Needed

Ensure you have access to Excel for Windows, preferably versions 2010 or later, so that you can work through the required homework exercises. Excel for Mac is not officially supported.

Delivery Method

QAS Self-study

Recommended CPE Credits

40 Total (6 CPE when you complete the Freshman year exam, 12 CPE for the Sophomore exam, 10 CPE for the Junior exam, and 12 when you complete the Senior exam.)

Field of Study

Computer Software & Applications

Expiration

Program enrollment is valid for one year and participant must complete the final exam within this time period.

Refund Policy

Full 30-day refund; full refund for any course cancellations or registration into upcoming session if preferred.

Complaint Resolution

For information regarding adminstrative policies such as complaint resolution, please contact Jeff Lenning CPA CITP at 949-200-7688 or via email info@excel-university.com

 

Price: $687.00
Buy 2 or more for $549.60 each
Quantity: