CPE Catalog & Events
Excel Power User Module 3: Six Critical Excel Functions
Available Until
Online
2.00 Credits
Member Price: $69
Conditional summing basics with SUMIFS Remove duplicates Lookup basics Improving VLOOKUP with MATCH Improving VLOOKUP with VALUE and TEXT Moving beyond VLOOKUP with INDEX
Excel Power User Module 4: Handling Errors and Comparing Lists
Available Until
Online
2.00 Credits
Member Price: $69
Trap errors with IFERROR The IF function List comparisons The ISERROR function Multicolumn list comparisons with COUNTIFS Indentation Perform lookups with SUMIFS
Excel Power User Module 6: Time-Saving Techniques
Available Until
Online
2.00 Credits
Member Price: $69
Dynamic Headers Horizontal Reports Mapping Tables Data Validation and Reporting Improving Error Check with Boolean Values and the Logical AND Function
Excel Power User Module 7: Introduction to PivotTables
Available Until
Online
2.00 Credits
Member Price: $69
PivotTable basics Row fields Value fields Column fields Filter fields Updating data Groups and subtotals Value formats
Excel Power User Module 8: PivotTable vs. Formula-Based Reports
Available Until
Online
2.00 Credits
Member Price: $69
Report type comparison options Report layout and design Multiple value fields Calculated fields Calculated items
Excel Power User Module 9: PivotTable Wrap-Up and Web Data
Available Until
Online
2.00 Credits
Member Price: $69
Show values as Sorting Filtering Hybrid reports with GETPIVOTDATA Web data
Excel Power User Module : Date and Text Functions
Available Until
Online
2.00 Credits
Member Price: $69
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
Family Law : Common Issues in Property Apportionment
Available Until
Online
1.00 Credits
Member Price: $49
Family Law: Case Law Update
Available Until
Online
1.00 Credits
Member Price: $49
Family Law: Common Issues in Support
Available Until
Online
1.00 Credits
Member Price: $49
Family Law: Tracing and Post-Separation Accounting
Available Until
Online
1.00 Credits
Member Price: $49
Fast Track Retirement Planning
Available Until
Online
3.00 Credits
Member Price: $89
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
Fast Track Retirement Planning
Available Until
Online
17.50 Credits
Member Price: $409
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
Fiduciary Accounting Part 1: Fiduciary Duty Basics & Authority-UPIA (UFIPA)
Available Until
Online
2.00 Credits
Member Price: $69
What is fiduciary duty, and how does it apply to a trustee or personal representative? What are the state statutory accounting rules, and where can you find them? What is fiduciary accounting income? What is fiduciary account principal? How does fiduciary accounting impact fiduciary taxation?
Fraud Investigation Reporting
Available Until
Online
1.00 Credits
Member Price: $49
Fraud Investigation Reporting
Fraud Scheme Hunt
Available Until
Online
3.00 Credits
Member Price: $119
Fraud awareness and prevention Define various types of fraud Identify common fraud schemes
Fraud Stories Series 1: Accounting Fraud
Available Until
Online
2.00 Credits
Member Price: $69
Fraud Internal Controls Auditing Ethical Issues Advanced Accounting Issues Risk Management
Fraud Stories Series 2: Crypto Promises
Available Until
Online
2.00 Credits
Member Price: $69
Fraud Internal Controls Auditing Ethical Issues Advanced Accounting Issues Risk Management
Fraud Stories Series 3: Revisiting the Pyramids and Ponzi Schemes
Available Until
Online
2.00 Credits
Member Price: $69
Fraud Internal Controls Auditing Ethical Issues Advanced Accounting Issues Risk Management
Fraud Stories Series 4: Cryptocurrency and Generational Issues
Available Until
Online
2.00 Credits
Member Price: $69
Fraud Internal Controls Auditing Ethical Issues Advanced Accounting Issues Risk Management