Graduate Certification Program (40 CPE)

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

Subject

• Excel University Graduate Certification Program

Textbooks

• Textbooks included (If Amazon ships to your address, elect printed or Kindle version, otherwise, we'll deliver the Kindle version)

Benefits

• Begin Now: begin training immediately
• Moderated: ask questions in the moderated forums
• Certificate: download and print your certificate 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 Reviews

Student Testimonial Video

• Student Interview Clips

Comments

• "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."

Objectives

• 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.

Registration

To register, add this course to your cart by clicking the Buy Now button and then complete the checkout process.

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

Official Registry Statement

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 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.