Undergrad 2 (11 CPE)

• Opening Information

  • Chapter 1: Overview
  • Chapter 2: Selected Shortcuts

• Conditional Summing

  • Chapter 3: Conditional Summing Basics with SUMIFS
  • Chapter 4: Remove Duplicates

• Lookups

  • Chapter 5: Lookup Basics
  • Chapter 6: Improving VLOOKUP with MATCH
  • Chapter 7: Improving VLOOKUP with VALUE and TEXT
  • Chapter 8: Moving Beyond VLOOKUP with INDEX
  • Chapter 9: Trap Errors with IFERROR
  • Chapter 10: The IF Function
  • Chapter 11: List Comparisons
  • Chapter 12: The ISERROR Function
  • Chapter 13: Multicolumn List Comparisons with COUNTIFS
  • Chapter 14: Indentation
  • Chapter 15: Perform Lookups with SUMIFS

• Date and Text Function Basics

  • Chapter 16: Determine the Last Day of the Month with EOMONTH
  • Chapter 17: Date Parts – MONTH and YEAR
  • Chapter 18: Build Your Own Date with DATE
  • Chapter 19: Concatenation Basics

• Hands-Free Reporting

  • Chapter 20: Improve SUMIFS with CONCATENATE
  • Chapter 21: Dynamic Headers
  • Chapter 22: Horizontal Reports
  • Chapter 23: Mapping Tables
  • Chapter 24: Data Validation and Reporting
  • Chapter 25: Improving Error Check
  • Chapter 26: Concepts Applied

• Author

  Jeff Lenning CPA CITP

• Subject

  Excel University Volume 2

• 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

  Work at your own pace 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 Administration (7:46) Ch 1 Overview (3:52) Ch 2 Selected Shortcuts (7:12) Ch 3 Conditional Summing Basics (4:31) Ch 4 Remove Duplicates (3:38) Homework Activities Excel Version Poll Introductions Forum Post Exercise Workbooks Forum Post Quiz Lesson 1 Quiz Additional Resources Answer Files Shortcut Reference Chapter 2 Solutions Video Chapter 3 Solutions Video Chapter 4 Solutions Video Homework and content related questions forum How to Flatten Data Blog Post	Lesson 2 Lecture Videos Ch 5 Lookup Basics - Part 1 (11:21) Ch 5 Lookup Basics - Part 2 (9:41) Ch 6 Improve VLOOKUP with MATCH (9:01) Homework Activities Lesson 2 Poll Exercise Workbooks Lesson 2 Forum Post Quiz Lesson 2 Quiz Additional Resources Answer Files Chapter 5 Solutions Video Chapter 6 Solutions Video Homework and content related questions forum
Lesson 3 Lecture Videos Chapter 7: Improve VLOOKUP with VALUE and TEXT (7:10) Chapter 8: Moving Beyond VLOOKUP with INDEX (8:30) Chapter 9 Trap Errors with IFERROR (4:15) Chapter 10 The IF Function (3:32) Homework Activities Lesson 3 Poll Exercise Workbooks Lesson 3 Formula Challenge Lesson 3 Forum Post Quiz Lesson 3 Quiz Additional Resources Answer Files Chapter 7 Solutions Video Chapter 8 Solutions Video Chapter 9 Solutions Video Chapter 10 Solutions Video Homework and content related questions forum	Lesson 4 Lecture Videos Chapter 11 List Comparisons (3:30) Chapter 12 The ISERROR Function Chapter 13 Multicolumn List Comparisons with COUNTIFS (6:46) Chapter 14 Indentation (6:14) Homework Activities Lesson 4 Poll Exercise Workbook Lesson 4 Forum Post Quiz Lesson 4 Quiz Additional Resources Answer File Chapter 11 Solutions Video Chapter 12 Solutions Video Chapter 13 Solutions Video Chapter 14 Solutions Video Homework and content related questions forum
Lesson 5 Lecture Videos Chapter 15 Perform Lookups with SUMIFS (8:02) Chapter 16 Determine the Last Day of the Month with EOMONTH (7:50) Chapter 17 Date Parts MONTH and YEAR (2:40) Chapter 18 Build Your Own Date with DATE (5:17) Homework Activities Lesson 5 Poll Exercise Workbooks Lesson 5 Formula Challenge Lesson 5 Forum Post Quiz Lesson 5 Quiz Additional Resources Answer Files Chapter 15 Solutions Video Chapter 16 Solutions Video Chapter 17 Solutions Video Chapter 18 Solutions Video Homework and content related questions forum	Lesson 6 Lecture Videos Chapter 19 Concatenation Basics (7:42) Chapter 20 Improve SUMIFS with CONCATENATE (9:59) Chapter 21 Dynamic Headers (6:44) Chapter 22 Horizontal Reports (4:40) Homework Activities Lesson 6 Poll Exercise Workbooks Lesson 6 Forum Post Quiz Lesson 6 Quiz Additional Resources Answer Files Chapter 19 Solutions Video Chapter 20 Solutions Video Chapter 21 Solutions Video Chapter 22 Solutions Video Homework and content related questions forum
Lesson 7 Lecture Videos Chapter 23 Mapping Tables (5:02) Chapter 24 Data Validation and Reporting (7:19) Chapter 25 Improve Error Check (9:57) Chapter 26 Concepts Applied (4:57) Homework Activities Lesson 7 Poll Exercise Workbooks Lesson 7 Formula Challenge Lesson 7 Forum Post Quiz Lesson 7 Quiz Additional Resources Answer Files Chapter 23 Solutions Video Chapter 24 Solutions video Chapter 25 Solutions video Chapter 26 Solutions video Homework and content related questions forum	Lesson 8 Lecture Videos Graduation (7:25) Exam and Certificate Final Exam Certificate of Completion Homework Activities Course Recap Forum Post Spread the Word 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 2 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 of the book, which is totally optional, you may do so through Amazon.

 

Comments from course participants

• "Very engaging, fun class!"


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


• "SUMIFS function and mapping tables were valuable."


• "Enthusiastic and engaging!"


• "Excellent presenter, would recommend."


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


• "INDEX and VALUE functions were valuable."


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


• "Book is great for my future reference."


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

• Identify which Excel function can be used to perform a multicolumn list comparison
• Recognize which Excel function can return the last day of the month
• Recall at least three keyboard shortcuts and the arguments of at least three functions

Program Level

Intermediate

Prerequisites

Excel University Volume 1

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

11

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.