CPE Catalog & Events
The 10 Must Know Excel Features
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
Building a Better Budget in a Time of Uncertainty
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting
OBBA 2025 Unpacked: Impact for Taxpayers and Business Owners
-
Online
4.00 Credits
Member Price: $129
An overview of provisions of existing law extended, made permanent without substantial change and/or WITH substantial changes, including casualty losses, individual tax rates, alternative minimum tax, bonus depreciation, Sec. 179 immediate expense deduction, deduction of research and experimentation expenses New law provisions for individuals and businesses Review of existing law provisions that have been repealed, including electric car credit, home energy credits, commercial clean vehicle credit and electric car charger credit
Federal Tax Update - C & S Corporations, Partnerships & LLCs (Forms 1120, 1120S & 1065)
-
Online
8.00 Credits
Member Price: $400
Discuss the most recent business income tax legislation passed to date Review numerous business income tax provisions including but not limited to the 20% qualified business income (QBI) deduction; changes to NOLs, §461(l) business loss limitations, §163(j) business interest deduction limitations, accounting method changes, depreciation, fringe benefits and entertainment expenses Brush up on issues related to compensation, distributions, liquidations, self-employment taxes and retirement plan Look at any changes to the Forms 1120, 1120S, and 1065 and other related schedules and forms
Estate Planning Strategies: Advanced Techniques and Tools
-
Online
8.00 Credits
Member Price: $295
Legislative and regulatory changes in estate and gift taxation Wealth transfer strategies under the new administration Charitable deduction planning and compliance requirements Advanced estate planning tools, including split-interest trusts Using closely held stock for charitable contributions Generation-skipping transfer tax planning Strategic use of life insurance in estate planning
The Single Audit from Beginning to End Update
-
Online
8.00 Credits
Member Price: $275
Introduction Applicable AICPA standards Applicable OMB Circular Gathering information - determining the major programs Identifying risk – identifying the applicable compliance requirements Assessing risk – considering the internal controls over compliance requirements Designing procedures that are responsive to assessed risks – the tests of internal controls and compliance Evaluating single audit evidence
Partnership Property Distributions and the New Form 7217
-
Online
1.00 Credits
Member Price: $59
Property distributions in liquidation of a partner's interest Section 751 and its impact on property distributions from a partnership Mechanics of completing Form 7217 - new for 2024 The Section 754 election and its role in partnership property distributions
Global Internal Audit Standards (GIAS) Domain IV - Part 1
-
Online
2.40 Credits
Member Price: $109
Internal Audit GIAS Standards Institute of Internal Auditors Accounting Auditing
Managing Your Money in Retirement
-
Online
3.00 Credits
Member Price: $129
Social Security Retirement Asset allocation Fraud
Corporate Fraud Risk & Investigations 25-26
-
Online
4.00 Credits
Member Price: $175
Types of Corporate Fraud Introduction to fraud risk Fraud risk prevention programs Fraud investigations
2025 A&A Update With Technology Implementation
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Deep dive into the Accounting Standards Updates (ASUs) effective in 2025.Insights from the FAF's 2024 PCC Review.Overview of FASB's Invitation to Comment - Agenda Consultation.The essential changes in quality management standards that firms must implement by the end of 2025. Common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB).
ABC Trust Planning and the Portable Exclusion 25-26
-
Online
8.00 Credits
Member Price: $329
The interplay of the estate, gift, generation-skipping, and income taxes Claiming and protecting the portable exclusion Marital deduction planning: rules for and reasons to use Survivor s and QTIP trusts B (Bypass) trusts A (Survivor s)/ C (QTIP) trusts planning What planners should tell their wealthy clients after the issuance of the Clawback Regulations
Federal Tax Update: Business Comprehensive 25-26
-
Online
8.00 Credits
Member Price: $329
Review of recent federal legislation and administrative rulings Review of recent modifications to tax forms Review of small business tax law and administrative update changes Review of retirement plan changes Overall review of tax practice and procedures
Leases: ASC Topic 842 in Depth 25-26
-
Online
8.00 Credits
Member Price: $329
FASB ASC 842, Leases All recently released updates to ASC 842, Leases
Titans Annual Federal Tax Planning: Business & Estate Update 25-26
-
Online
8.00 Credits
Member Price: $329
New law provisions and guidance and tax form changes affecting business entities, tax-exempts and estates and trusts with emphasis on details of relevant energy and research credits, loss limitation and any federal law changes in 2025 Key cases and IRS and FTB guidance affecting partnerships, LLCs, C corporations, and S corporations Employment taxes and worker classification matters Accounting method developments Tax credits updates Federal and California The state of California and multistate significant developments, including nexus and sourcing Expired and expiring provisions Inflation-adjusted amounts for 2026
Ethics: Giving Thanks - How to Master the Art of Gratitude
-
Online
2.00 Credits
Member Price: $89
We'll explore what gratitude is and how expressions of it can vary from culture to culture. We'll also unpack several ways you can regularly say "thank you" to valued clients and colleagues, and we'll examine methods for evaluating gratitude in prospective and current employees.
The New Quality Management Standards - What Everyone Needs to Know
-
Online
2.00 Credits
Member Price: $109
Overview of the new quality management standards Focus on the most important elements of a quality management system Implementation tips that everyone in the firm should know Audit and attest standards impacted
Introduction to Single Audit
-
Online
2.00 Credits
Member Price: $109
Single Audit Accounting & Auditing Yellowbook
Auditing For Fraud
-
Online
2.00 Credits
Member Price: $109
Auditing Fraud
Staff Retention Keep the Best People
-
Online
3.00 Credits
Member Price: $129
Remote workforce Employee retention Staff turnover