CPE Catalog & Events
Self Study: Excel Power User Module 3: Six Critical Excel Functions
Available Until
Self-Study
2.0 Credits
Conditional summing basics with SUMIFS Remove duplicates Lookup basics Improving VLOOKUP with MATCH Improving VLOOKUP with VALUE and TEXT Moving beyond VLOOKUP with INDEX
Self Study: Excel Power User Module 4: Handling Errors and Comparing Lists
Available Until
Self-Study
2.0 Credits
Trap errors with IFERROR The IF function List comparisons The ISERROR function Multicolumn list comparisons with COUNTIFS Indentation Perform lookups with SUMIFS
Self Study: Excel Power User Module 5: Date and Text Functions
Available Until
Self-Study
2.0 Credits
Determine the last day of the month with EOMONTH Date parts: MONTH and YEAR Build your own date with DATE Concatenation basics Improve SUMIFS with CONCATENATE
Self Study: Excel Power User Module 6: Time-Saving Techniques
Available Until
Self-Study
2.0 Credits
Dynamic Headers Horizontal Reports Mapping Tables Data Validation and Reporting Improving Error Check with Boolean Values and the Logical AND Function
Self Study: Excel Power User Module 7: Introduction to PivotTables
Available Until
Self-Study
2.0 Credits
PivotTable basics Row fields Value fields Column fields Filter fields Updating data Groups and subtotals Value formats
Self Study: Excel Power User Module 8: PivotTable vs. Formula-Based Reports
Available Until
Self-Study
2.0 Credits
Report type comparison options Report layout and design Multiple value fields Calculated fields Calculated items
Self Study: Excel Power User Module 9: PivotTable Wrap-Up and Web Data
Available Until
Self-Study
2.0 Credits
Show values as Sorting Filtering Hybrid reports with GETPIVOTDATA Web data
Self Study: Family Tax Planning 2022
Available Until
Self-Study
2.0 Credits
Filing status and exemptions Divorce costs Child, dependent care and adoption credits Education expenses, credits and deductions Medical costs Charitable contributions Casualty and theft losses Home sales and mortgage interest Property rights Elderly, disabled and estate planning
Self Study: Fast Track Retirement Planning (expanded)
Available Until
Self-Study
17.0 Credits
Popular retirement myths Defining retirement & determining retirement income needs Savings Assets Social Security Retirement plans Distributions from retirement plans Nonqualified deferred compensation Life insurance Estate planning
Self Study: Fast Track Retirement Planning 2022
Available Until
Self-Study
3.0 Credits
Popular retirement myths Defining retirement & determining retirement income needs Savings Assets Social Security Retirement plans Distributions from retirement plans Nonqualified deferred compensation Life insurance Estate planning
Self Study: Fraud Investigation Reporting
Available Until
Self-Study
1.0 Credits
Fraud Investigation Reporting
Self Study: Fraud Stories Series: Accounting Fraud
Available Until
Self-Study
2.0 Credits
Fraud Internal Controls Auditing Ethical Issues Advanced Accounting Issues Risk Management
Self Study: Fraud Stories Series: Crypto Promises
Available Until
Self-Study
2.0 Credits
Fraud Internal Controls Auditing Ethical Issues Advanced Accounting Issues Risk Management
Self Study: Fraud Stories Series: Modern Pirates
Available Until
Self-Study
2.0 Credits
Fraud Internal Controls Auditing Ethical Issues Advanced Accounting Issues Risk Management
Self Study: Fraud Stories Series: Revisiting the Pyramids and Ponzi Schemes
Available Until
Self-Study
2.0 Credits
Fraud Internal Controls Auditing Ethical Issues Advanced Accounting Issues Risk Management
Self Study: Getting Cash Out of Your Business 2022
Available Until
Self-Study
3.0 Credits
Deferral of income Avoiding taxable income Unreasonable compensation Nonqualified deferred compensation Basic types of corporate retirement plans Individual plans Fringe benefits Employer provided automobile Business entertainment Business travel & transportation
Self Study: High Performance Communication
Available Until
Self-Study
2.0 Credits
Elements of high-impact communications. Effective vs. less effective communication channels. Giving and receiving feedback. Nonverbal communication. Impactful presentations
Self Study: How To Run a Kick-Ass Meeting
Available Until
Self-Study
1.0 Credits
The 40-20-40 approach to meeting engagement. How to build an engaging audience. Top two essentials for leadership skills. Tips for an impressive virtual meeting presence.
Self Study: How a Subordinate's Gender Influences Supervisors' Use of Past Performance Info
Available Until
Self-Study
1.0 Credits
Performance measurement Performance appraisals Potential appraisals High-potential employees Gender and attributions
Self Study: In-depth with Excel Names
Available Until
Self-Study
2.0 Credits
Named ranges Named contstants Named formulas