CPE Catalog & Events
The 10 Must Know Excel Features
-
Webinar
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.
AICPA's New SSTS #4 - New Ethics Standard for Tax Resolution
-
Webinar
0.00 Credits
Member Price: $55
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
-
Webinar
1.00 Credits
Member Price: $49
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.
Corporate Transparency Act Developments
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Background of the Corporate Transparency ActBeneficial Ownership Information Reporting (BOIR) Rule Entities required to report.Reporting requirements imposed by the CTADue dates of reportsInformation needed to satisfy the BOIRImpact of failure to reportHow to submit a reportCourt rulings on CTA’s unconstitutionalityImplications to entities as a result of the ruling in NSB.Potential reporting requirements due to FinCen’s proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers.
Accounting and Tax Ethics: Standards, Issues, & Case Studies 26-27
-
Webinar
4.00 Credits
Member Price: $175
AICPA Code of Professional Conduct Threats to compliance with Code of Ethics Updated Statement of Standards for Taxpayer Services (SSTS) Ethical challenges in selecting appropriate GAAP alternatives
Firm Ethics—A Practical Approach 26-27
-
Webinar
4.00 Credits
Member Price: $175
AICPA Code of Professional Conduct Ethics requirements for CPA firms
K2's Mastering Advanced Excel Functions 26-27
-
Webinar
4.00 Credits
Member Price: $175
Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays How to use "legacy" features and functions such as AGGREGATE Creating effective forecasts in Excel
Cybersecurity: Protecting Your Firm's Data and Reputation
-
Webinar
2.00 Credits
Member Price: $89
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
-
Webinar
1.00 Credits
Member Price: $55
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
Leveraging ChatGPT for Innovative Business Advisory Services
-
Webinar
2.00 Credits
Member Price: $89
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
Profiles in Fraud
-
Webinar
1.00 Credits
Member Price: $89
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
-
Webinar
1.00 Credits
Member Price: $55
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.
Surgent's Public Speaking and Presentation Skills
-
Webinar
2.00 Credits
Member Price: $99
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?
-
Webinar
2.00 Credits
Member Price: $89
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
Leadershift: Drive Results Through Ethical Performance Mgmnt
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:How Inspirational leadership is the foundation that ethically drives results.Simplify the complex: Walk through the Results Model and discover practical how-to examples of execution.Hacks for getting great results with specific examples you can leverage in your business:The How: Empower your people to feel like an owner, managing difficult conversations well, leading with empathy and what that looks like, how it should feel, motivational coaching techniques to get your employee relationships back on track, and unleashing the power of appreciation and gratitude.The What: Powerful score-carding, transformational goal-setting conversations, and positive accountable follow- up.
Taxation of the Cannabis Industry
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Industrial hemp vs. marijuana.Income definitions under I.R.C. §61.Tax code restrictions: §280E and §471.State-specific marijuana laws.Cash management in cannabis businesses.Federal court case analysis.
Forensic Accounting: Investigating Divorce Cases
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court
Becoming Conflict Competent
-
Webinar
2.00 Credits
Member Price: $89
Major topics covered in this course include:Levels of conflictStrategies to de-escalate conflictDistinction between miscommunication and conflictResponses to conflictTactics to address, rather than avoid, conflict
Surgent's Improving Your Profits: Identifying Cost Cutting Opportunities
-
Webinar
2.00 Credits
Member Price: $99
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
-
Webinar
2.00 Credits
Member Price: $99
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