CPE Catalog & Events
The 10 Must Know Excel Features
-
TBD
2.0 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.
The Competent Accountant - Mastering the Role of the Controller/ CFO
-
TBD
4.0 Credits
Member Price: $129
Business Management Organization
New Mergers & Acquisitions: Tricks, Traps, & Terrors
-
TBD
4.2 Credits
Member Price: $129
Business Management Organization
A Practical Guide to Trusts
-
TBD
8.0 Credits
Member Price: $245
Trustee responsibilities and trust administration Strategies for probate avoidance and efficient asset distribution Tax treatment of revocable living trusts Marital deductions and bypass trusts Uses of irrevocable trusts in estate planning Benefits of irrevocable life insurance trusts Multi-generational wealth planning with dynasty trusts Overview of estate planning tools: GRIT, GRAT, GRUT, and QPRT
ACPEN Signature 2025: Critical Real Estate Taxation Issues
-
TBD
8.0 Credits
Member Price: $250
The importance of correctly classifying property as capital gains property, inventory real estate, development real estate and real estate used in trade or business and applicable cost recovery recapture rules Preserving capital gains treatment for pre-development appreciation with a related party lot developer Cost Segregation Studies for Real Estate and their Tax Consequences Qualified Nonrecourse Debt under the At-Risk Rules Distinguishing repairs from improvements and the tax consequences of the difference Tax consequences of renting real estate Common issues in Ground Leases, Percentage Leases and Net Leases Classification as a Real Estate Professional under the PAL Rules and Interaction with the Rental Real Estate Rules and the Aggregation Election for rental real estate Review of current actions by Congress and the IRS affecting real estate.
K2's Advanced Excel
-
TBD
8.0 Credits
Member Price: $225
Collaboration and security techniques Tables, data models, and PivotTables Advanced formulas Data queries Creating effective visualizations
K2's Ten Must Know Features In Excel
-
TBD
2.0 Credits
Member Price: $79
How to securely and efficiently collaborate with others Using Excel for optimization scenarios Creating “audit trails” in Excel Define “dynamic arrays” and list examples of their benefits
Using e-Signature Software to Process Agreements-Updated
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this course include:Review of the digital document signing process.Key features to evaluate in selecting a solution.Review and distinguish top selling e-signature applications.Best practices for deploying e-signature software in your practice or business.
Be the Sun, Not the Salt, featuring Harry Cohen and John Daly
-
TBD
1.0 Credits
Member Price: $39
What is the Heliotropic Effect? Be the Six Sun Pearls. Today is a good day to do good Be the bright spot in the room Be your own sun Do the next right thing Pet peeves bite Knowing isn't doing
Revenue Recognition - Recognize Revenue
-
TBD
1.0 Credits
Member Price: $39
Revenue Recognition Accounting
The Controller Function - Cash and Investments
-
TBD
1.4 Credits
Member Price: $39
Accounting Finance
To Verify or Let It Fly: What to Do About Questionable Tax Return Information
-
TBD
2.0 Credits
Member Price: $79
Clear Reflection of Income: Really? The Verification Drill Tax Ethics and the Conceptual Framework The Tax Uncertainties Dance (Tax and Financial Reporting) Cases and Controversies Blanco v. United States U.S. v. Fairchild Conclusion
Accounting & Attestation for ESG
-
TBD
2.0 Credits
Member Price: $79
ESG Accounting & Auditing Yellowbook
Employee Theft: Understanding the Why and Preventing the Loss with Terry Shulman
-
TBD
2.0 Credits
Member Price: $79
Employee Theft Prevention
CFO Series: Changing Corporate Culture: How to Improve it?
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:The eight types of corporate cultures.Determining which culture(s) exist in your organization.How to introduce change in an acceptable way.What are core values, and why they are so important?What kind of culture(s) fits in the organization?Where do you need the culture to develop so the organization can thrive?Why people are so resistant to change?What is the 'right' speed for change?How to grow your team into a better culture.
Navigating IRS Collections: Overview of Form 433 & OIC
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of the IRS collection process and enforcement actions.Initial notices, taxpayer rights, and IRS timelines.When to use Forms 433-A or 433-B and required documentation.Offer in Compromise (OIC): criteria, process, and practical considerations.Payment options: installment agreements, partial payment plans, and OIC.Advising clients on IRS collections and avoiding penalties.Compliance strategies for minimizing tax liabilities.Real-world scenarios and examples for tax debt resolution.
Tax Season Update for Individuals with Steve Dilley
-
TBD
4.0 Credits
Member Price: $149
The major topics covered in this class include:2024/25 legislative developments, cases and rulings impacting individual taxpayersChanges to Form 1040 and other related forms, worksheets and schedulesIndividual income items, itemized deductions and creditsUpdated tax rate schedule and other inflation adjusted itemsImplications for self-employed taxpayers of various legislationSection 199A changes, including use of carryforward passive activity and 199A lossesCapital gains and lossesPassive activity and hobby loss rules changes
Ethics: How to Give and Receive Criticism the Right Way
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this course include:Entertaining lecture by a professional presenter, illustrated with relevant video clips and photographs, to cover the main points of the webinarWriting exercises, so you can see how these lessons apply to your own CPA practice and personal lifeTrue stories about CPAs and other leaders to show what can happen when apologies and criticism are done right, and the pitfalls of doing them the wrong way
Two Types of Goals You Need to Be Successful
-
TBD
1.0 Credits
Member Price: $79
Common obstacles to goal achievement The limitations of SMART goals Characteristics of effective outcome goals Process Goals: The Roadmap to Achievement Integrating Outcome and Process Goals for Maximum Impact
Written Information Security Plans
-
TBD
1.0 Credits
Member Price: $39
Introduction to the Gramm-Leach-Bliley Act and its impact on data security Circular 230 compliance and due diligence for practitioners AICPA Statements of Standards relevant to WISP requirements Key components of a Written Information Security Plan Training requirements for employees, staff, and contractors Practical guidance for drafting and implementing a WISP FTC enforcement of data security standards for PTIN holders Best practices for maintaining and updating WISP compliance