Undergrad 1 (9 CPE)

• Opening Information

  • Chapter 1: Overview
  • Chapter 2: Book Conventions
  • Chapter 3: Excel Conventions
  • Chapter 4: How to Make the Most

• Foundations

  • Chapter 5: Foundations Overview
  • Chapter 6: Selected Shortcuts
  • Chapter 7: Named References
  • Chapter 8: Tables
  • Chapter 9: Data Validation
  • Chapter 10: Conditional Formatting Basics
  • Chapter 11: Better Summing
  • Chapter 12: Skinny Row
  • Chapter 13: Hide Worksheets
  • Chapter 14: Highlight Input Cells
  • Chapter 15: Workbook Organization
  • Chapter 16: Worksheet Organization
  • Chapter 17: Nested Functions
  • Chapter 18: Selection Groups
  • Chapter 19: Workbook Design Principles

• Author

  Jeff Lenning CPA CITP

• Subject

  Excel University Volume 1: Complete

• 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

  Featuring Microsoft Excel for Windows Versions 2010 and later

• Format

  On-Demand

• Access Begins

  Immediately

• Duration

  You may work at your own speed during the one-year enrollment period.

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

• Enrollment Period

  Your enrollment is valid for one year.

---

Lesson 1 Lecture Videos Introduction (1:39) Course Administration (7:46) Chapters 1-5 (13:08) Chapter 6: Selected Shortcuts (8:52) Homework Activities Excel Version Poll Introductions Forum Post Exercise Workbooks PMT Blog Post Favorite Shortcuts Forum Post Quiz Lesson 1 Quiz Additional Resources Answer Files Shortcut Reference Chapter 6 Solutions Video Homework and content related questions forum Conditional Sum Blog Post	Lesson 2 Lecture Videos Chapter 7: Named References (7:43) Chapter 8: Tables (10:36) Homework Activities Quick Poll Exercise Workbooks Forum Post Quiz Lesson 2 Quiz Additional Resources Go To Special Blog Post Answer Files Chapter 7 Solutions Video Chapter 8 Solutions Video Homework and content related questions forum
Lesson 3 Lecture Videos Chapter 9: Data Validation (11:59) Chapter 10: Conditional Formatting Basics (6:13) Homework Activities Quick Poll Exercise Workbooks Forum Post Quiz Lesson 3 Quiz Additional Resources DV Alert Styles Blog Post Answer Files Chapter 9 Solutions Video Chapter 10 Solutions Video Homework and content related questions forum	Lesson 4 Lecture Videos Chapter 11: Better Summing (7:57) Homework Activities Quick Poll Exercise Workbook Forum Post Quiz Lesson 4 Quiz Additional Resources 25 Years of Excel Video Answer File Chapter 11 Solutions Video Homework and content related questions forum
Lesson 5 Lecture Videos Chapter 12: Skinny Row (7:33) Chapter 13: Hide Worksheets (4:09) Homework Activities Quick Poll Exercise Workbooks Forum Post Quiz Lesson 5 Quiz Additional Resources Answer Files Chapter 12 Solutions Video Chapter 13 Solutions Video Homework and content related questions forum Outline Groups Blog Post Very Hidden Worksheets Blog Post	Lesson 6 Lecture Videos Chapter 14: Highlight Input Cells (6:20) Chapter 15: Workbook Organization (9:26) Chapter 16: Worksheet Organization (10:31) Homework Activities Quick Poll Exercise Workbooks Workbook organization forum post Worksheet organization forum post Cell Style Blog Post Quiz Lesson 6 Quiz Additional Resources Answer Files Chapter 14 Solutions Video Homework and content related questions forum Index Sheet Blog Post External Data Blog Post
Lesson 7 Lecture Videos Chapter 17: Nested Functions (5:13) Chapter 18: Selection Groups (5:26) Chapter 19: Workbook Design Principles (7:08) Homework Activities Quick Poll Exercise Workbooks Forum Post Quiz Lesson 7 Quiz Additional Resources Answer Files Chapter 17 Solutions Video Chapter 18 Solutions video Homework and content related questions forum Last day of the month blog post	Lesson 8 Lecture Videos Graduation (7:06) Exam and Certificate Final Exam Certificate of Completion Homework Activities Recommend Course Recap Forum Post Keep in Touch! Success Stories Course Evaluation Additional Resources Shortcut Reference Contents at a Glance

Materials

This course teaches the content of the Excel University Volume 1 book.  The book chapters are available digitally inside the course during your enrollment period. Obtaining a printed/bound copy of the book is not required.

If you'd like to purchase a printed/bound copy, which is totally optional, you can do so through Amazon.

 

Comments from course participants

• "This course is well organized, user focused, and interactive. I would recommend it to anyone who creates worksheets in Excel or works in Excel frequently."


• "I thoroughly enjoyed this course."


• "This course is very useful to accountants because it gives some insights on how to be efficient on the job. Also, gives many keyboard shortcuts that are not usually known to common users like me."


• "The class is highly recommended to Finance and Accounting personnel. The webinars are short, and very informative. The quiz allows you to absorb the materials better. The book is very helpful as well."


• "Well designed. Broken down to smaller sections, it's easier to follow and practice the newly learnt tips during the homework section."


• Clean & clear demonstration. Jeff really nailed this one. It's very easy to follow and he also made it interactive in the forum section.


• Good combination of videos/book/homework/blog. Videos are easy to follow, book makes it easier to refer later, homework reinforces and blog appeals to those working better with words than videos.


• This course is excellent. Excellent. Excellent. I really like the combination of different media (videos/books/blogs/forum). I also like the smaller sections so you can learn one function at a time. You really understand how we learn and help us get there.


• The strength of this course is the instructor himself. He is an accountant who happens to be an Excel expert. He understands what accountants need from the program and what the program can do for accountants. This course and the following series will teach accountants how to use the MS Excel to improve productivity and efficiency.


• The one chapter that I appreciate the most is the last chapter "Workbook Design Principles". In my opinion, that chapter and chapters on worksheet/workbook organization should be placed at the beginning of the course material.


• It's a GREAT course and it's organized in a format leagues above the usual online learning styles of other e-learning.


• I can't wait to try your other advanced courses.


• The course was very easy to follow.


• It really was one of the best in format I’ve done... I wish all were as well done as that one was!

Objectives

• Recall at least 3 shortcuts to improve your speed
• Identify the dialog box used to change or remove a named reference
• Recognize which feature allows us to control what a user can type into a cell

Program Level

Basic

Prerequisites

None

Advance Preparation Needed

Ensure you have access to Excel for Windows, preferably versions 2010 or higher, so that you may work through the required homework exercises. Excel for Mac is not officially supported, but many students work through using a Mac.

Delivery Method

QAS Self-study

Recommended CPE Credits

9

Field of Study

Computer Software & Applications

Expiration Date

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 additional information regarding administrative policies such as complaint and refund, and cancellation please contact Jeff Lenning at 949-200-7688 or via email at 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.