Skip to main content

CPE Catalog & Events

Showing 869 Self-Study Results

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