CPE Catalog & Events
Excel Macros
Available Until
Self-study
2.00 Credits
Member Price: $69
Macro recorder Visual basic editor Quick access toolbar
Excel Power User Module 10: Getting, Preparing and Summarizing Data
Available Until
Self-study
2.00 Credits
Member Price: $69
External data Text files Data preparation Accounting system data Getting graphic
Excel Power User Module 1: Fundamental Features
Available Until
Self-study
2.00 Credits
Member Price: $69
Selected shortcuts Named references tables Data validation Conditional formatting basics
Excel Power User Module 2: Fundamental Functions, Concepts, Techniques
Available Until
Self-study
2.00 Credits
Member Price: $69
Better summing Skinny row Hide worksheets Highlight input cells Workbook organization Worksheet organization Nested functions Selection groups Workbook design principles
Excel Power User Module 3: Six Critical Excel Functions
Available Until
Self-study
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
Self-study
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 5: Date and Text Functions
Available Until
Self-study
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
Excel Power User Module 6: Time-Saving Techniques
Available Until
Self-study
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
Self-study
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
Self-study
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
Self-study
2.00 Credits
Member Price: $69
Show values as Sorting Filtering Hybrid reports with GETPIVOTDATA Web data
Family Law Virtual Conference 2022 On-Demand
Available Until
Self-study
7.00 Credits
Member Price: $249
Case Law Update Tax Issues: Technical vs. Practical Searching for Missing Assets and Income: From Cash to Venmo to Crypto-currencies Business Valuation for Family Law Best Practices: Packaging Your Case for Mediation or Trial Judges' Panel
Family Law Virtual Conference 2023 On-Demand
Available Until
Self-study
8.00 Credits
Member Price: $285
Case Law Update Technical Aspects of Business Valuation How Two Reasonable Experts Can Come Up with Different Values Technology Updates The Art of Tracing Brokerage, Investment and Other Financial Accounts Judges' Panel
Family Tax Planning 2022
Available Until
Self-study
2.00 Credits
Member Price: $69
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
Fast Track Retirement Planning (expanded)
Available Until
Self-study
17.00 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
Fast Track Retirement Planning 2022
Available Until
Self-study
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
Fraud Investigation Reporting
Available Until
Self-study
1.00 Credits
Member Price: $49
Fraud Investigation Reporting
Fraud Stories Series: Accounting Fraud
Available Until
Self-study
2.00 Credits
Member Price: $69
Fraud Internal Controls Auditing Ethical Issues Advanced Accounting Issues Risk Management
Fraud Stories Series: Crypto Promises
Available Until
Self-study
2.00 Credits
Member Price: $69
Fraud Internal Controls Auditing Ethical Issues Advanced Accounting Issues Risk Management
Fraud Stories Series: Modern Pirates
Available Until
Self-study
2.00 Credits
Member Price: $69
Fraud Internal Controls Auditing Ethical Issues Advanced Accounting Issues Risk Management