CPE Catalog & Events
The 10 Must Know Excel Features
-
Virtual
2.00 Credits
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.
ACPEN: K2's Ten Questions To Ask Your IT Team
-
Online
1.00 Credits
Ten Strategic Question Frameworks for Technology Assessment Cybersecurity and Infrastructure Oversight Through Targeted Dialogue Cloud Governance and Remote Work Technology Evaluation
AICPA's New SSTS #4 - New Ethics Standard for Tax Resolution
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:This session will provide a comprehensive overview of the ethical guidelines outlined in Circular 230 and the newly updated Statements on Standards for Tax Services (SSTS) #4. Gain insights into how these standards apply to real-world tax resolution scenarios, ensuring compliance and integrity in your practice.
Auditing digital assets: Entity’s use of a service organization
-
Virtual
1.00 Credits
Understanding the entity and its environment and the service organizations role related to digital assets SOC 1® and SOC 2® reports as sufficient appropriate evidence Risks and challenges associated with performing audit procedures involving service organizations.
ACPEN: A Guide to Sampling - Part 1
-
Online
2.00 Credits
Auditing Yellowbook
ACPEN: State Tax Nexus: Frequently Awkward Questions
-
Online
2.00 Credits
Frequently asked questions about income tax and sales tax nexus New developments Key factors in reviewing potential nexus consequences Nexus road trip to eight large states Tax impacts of remote work Free, multistate resources
Cybersecurity: Protecting Your Firm's Data and Reputation
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Assessment of the current cybersecurity threat level and vulnerabilitiesDeveloping your WISP (Written Information Security Program) Deploying a password management app (PMA) to fortify the security of your login credentialsImplementing an incident response plan to minimize the damage from a cybersecurity attackUnderstanding the role of cybersecurity insurance
The Future of Audit: Technology, Talent & Transformation
-
Virtual
1.00 Credits
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Explore AI, blockchain, and data analytics impact on audits Address talent crisis through retention and upskilling strategies Navigate PCAOB standards and regulatory sandbox concepts Expand audits to include ESG and nonfinancial metrics Implement technology solutions for firms of all sizes
ACPEN: Benford’s Law and Other Digital Analysis Techniques
-
Online
1.80 Credits
Benford’s Law Digital Analysis Data analytics
Leveraging ChatGPT for Innovative Business Advisory Services
-
Virtual
2.00 Credits
The major topics covered in this course include:Introduction to ChatGPT and its applications in the business advisory contextIn-depth exploration of enterprise evaluation methodologies like SWOT, PESTLE, BCG Matrix, McKinsey 7S Model, Ansoff Matrix, etc.Practical case studies demonstrating application of ChatGPT in accounting business analysisKey challenges faced by accounting firms and how ChatGPT can help overcome theseBest practices for implementing AI tools in the accounting sectorFuture opportunities and trends in AI-enhanced business advisory services
ACPEN: Key Tax Issues Facing Business & Industry
-
Online
4.00 Credits
Update and review of recent and key tax developments impacting business and industry "Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Other recent legislative, judicial, and IRS developments impacting business taxpayers Current status of Research and Experimentation costs and Interest Expense Limitation Phaseout of Bonus Depreciation and MACRS issues Travel and entertainment expense rules Independent contractor vs. employee
ACPEN: Multistate Taxation - Issues and Planning Opportunities
-
Online
8.00 Credits
Multistate Business Activities Nexus and Implications State Taxable Income Business-Related Issues Formulas and Their Application Audit Defense Strategies State Specific Regulations Choice of Business Entity Interstate Commerce Clauses Domicile in relation to State Death Taxation
Profiles in Fraud
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Real life fraudsters: what they did, how they got away with it, how they finally were caughtProfiles: the characteristics the fraud perpetrators have in commonTechniques to prevent and deter these common schemes
2026/27 Yellow Book Update
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Significant changes related to quality management and updates affecting key audit roles, with an emphasis on how these revisions impact audit planning and execution.The GAO's implementation delay and its implications for 2026 audit planning.Recent leadership changes at the U.S. Government Accountability Office and what those transitions may signal for future guidance and oversight priorities.Overview of recent updates to the Green Book, helping auditors understand changes to internal control guidance that may affect governmental entities and Single Audit engagements.
ACPEN: K2's Automation For Increasing Personal Efficiency And Effectiveness
-
Online
1.00 Credits
What are integration and automation? Exploring Integration Platform as a Service (iPaaS) tools and services Intelligent Voice Assistants (IVAs) and home automation systems Personal automation workflows and time-saving strategies Smart home integration and optimization
Surgent's Public Speaking and Presentation Skills
-
Virtual
0.00 Credits
How experienced speakers manage presentation anxiety The elements of effective persuasion The three styles of speech Strategies to improve speech pace The importance of volume when presenting The art of the pause Methods for using visual aids Best practices for preparing for a presentation Components of an effective presentation
What's Behind the Data?
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Ways in which data and information can be misleadingCommon pitfalls when encountering dataHow to re-evaluate the data to avoid those pitfalls
ACPEN: Compensation Fundamentals and Pay Transparency: Driving Fairness & Engagement
-
Online
1.00 Credits
Compensation
Surgent's Improving Your Profits: Identifying Cost Cutting Opportunities
-
Virtual
2.00 Credits
What keeps companies from becoming streamlined? Behavioral biases Information processing biases Emotional biases How to deal with behavioral biases Connecting behavioral biases to cost cutting Creating a culture of cost cutting Rules of thumb for cost cutting Managing headcount Post-COVID common areas of excess cost Budgeting techniques Budget variances Benchmarking Common size financial statements Horizontal analysis Negotiation and contracting techniques Cash flow and the business cycle
Surgent's Purchase and Sale of a Residence: Critical Tax Issues
-
Virtual
2.00 Credits
General rules relating to the sale of a residence under § 121 Sale of a taxpayer’s main home Qualifying for a partial exclusion of gain on the sale of a home How a taxpayer meets the residence requirement Meeting the look-back requirement Separated, divorced, and widowed taxpayers Work-related moves and unforeseeable events Inherited homes and homes received in a divorce Impact of business or rental use of home on the gain exclusion Reporting gain or loss on the sale of a home
