Advance Your Excel Skills And Earn 20 CPE Hours
An exclusive offer just for CPAacademy.org members!
Obtain 20 CPE hours with this special discounted bundle. It includes enrollment into the full versions of Undergraduate Volumes 1 and 2. CPE is earned incrementally upon the completion of each volume (9 hrs for V1 and 11 hrs for V2). The certificate of completion date is the date you complete the final exam for each volume. The enrollment period is one year.
Topic List: Undergrad 1
Opening Information
- Overview
- Book Conventions
- Excel Conventions
- How to Make the Most
Foundations
- Foundations Overview
- Selected Shortcuts
- Named References
- Tables
- Data Validation
- Conditional Formatting Basics
- Better Summing
- Skinny Row
- Hide Worksheets
- Highlight Input Cells
- Workbook Organization
- Worksheet Organization
- Nested Functions
- Selection Groups
- Workbook Design Principles
Topic List: Undergrad 2
Opening Information
- Overview
- Selected Shortcuts
Conditional Summing
- Conditional Summing Basics with SUMIFS
- Remove Duplicates
Lookups
- Lookup Basics
- Improving VLOOKUP with MATCH
- Improving VLOOKUP with VALUE and TEXT
- Moving Beyond VLOOKUP with INDEX
- Trap Errors with IFERROR
- The IF Function
- List Comparisons
- The ISERROR Function
- Multicolumn List Comparisons with COUNTIFS
- Indentation
- Perform Lookups with SUMIFS
Date and Text Function Basics
- Determine the Last Day of the Month with EOMONTH
- Date Parts – MONTH and YEAR
- Build Your Own Date with DATE
- Concatenation Basics
Hands-Free Reporting
- Improve SUMIFS with CONCATENATE
- Dynamic Headers
- Horizontal Reports
- Mapping Tables
- Data Validation and Reporting
- Improving Error Check
- Concepts Applied
If you are sincere about improving your Excel skills, you have come to the right place. In this Excel training bundle, you'll learn skills that are sure to help you get your work done faster. Click here to claim this special discounted bundle.
Interested in a full 124 CPE pass for less than $4 per credit? Click here to learn more.
| Company | Excel University |
| Category | DISCOUNT |
| Original Cost | $397.00 |
| Discount | $300.00 |
| Cost | $97.00 |
| Intended Audience | CPA - small firm CPA - medium firm CPA - large firm Attorney Bookkeeper CFO / Controller Enrolled Agent Non-Profit Professional Other Real Estate Professional Small Business Owner |
Excel University
(949) 200-7688
www.excel-university.com/cpaacademy
If you could learn Excel simply and easily at your pace and could learn the features and functions that are relevant and practical to accounting professionals – would you want to? If you are an accounting professional and have taken Excel classes before, you know the pace can be too fast or too slow, and the content may not be relevant to your work. Excel University explores relevant features that allow you to get your work done quicker, in a self-paced, fun, and engaging way. Become more efficient, streamline processes, and save time with Jeff Lenning’s Excel University. Designed by a CPA for CPAs and accounting professionals, this series covers functions you need, and skips those you don’t. The content has been written from scratch integrating everything Jeff knows about Excel training learned over the past decade of providing continuing professional education.