CPE Catalog & Events
Complete Guide to Analyze Data with Excel PivotTables
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
K2's Accountant's Guide To QuickBooks Online
-
TBD
8.0 Credits
Member Price: $225
• Understanding your QBO subscription and licensing options • Recording routine and non-routine transactions in QBO • Importing and exporting data to/from QBO • Creating effective reports • Describing the process for integrating third-party applications with QBO • Troubleshooting issues with QBO reports and data
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
TBD
8.0 Credits
Member Price: $245
Tax considerations in divorce, including support obligations and property division Bankruptcy, debt cancelation, and financial hardship tax implications Tax treatment of cohabitation, premarital agreements, and exemptions Child support, alimony, and dependency issues Business dissolution and tax consequences Filing status options and tax rate comparisons Head of household qualifications and tax advantages Impact of refunds, deficiencies, and marital property rules
Internal Control - Testing for Operating Effectiveness
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this class include:Generally accepted audit requirements related to testing controls for operating effectivenessIdentifying key controls that may prove effective and efficient to test in a control reliance strategyResponses when deviations are discovered when evaluating the design or operating effectiveness of internal controlLeveraging audit evidence available for Service Organization Control (SOC1) ReportsGeneral computer control considerations when evaluating the design and operating effectiveness of internal control over financial reporting
2025 Business Tax Credits
-
TBD
1.0 Credits
Member Price: $55
Research & Development Tax Credit Work Opportunity Tax Credit COVID-19 Tax Credits Opportunity Zones GO-Biz Incentives Employment Training Panel
PowerPoint: Tips & Tricks for Today's Accountant
-
TBD
2.0 Credits
Member Price: $79
Exploration of tabs within PowerPoint’s ribbon Initial creation of a slide deck Using slide masters Utilization of external content SmartArt Alignments and layouts Tips and tricks for efficiency Best practices for effective presentation delivery Other creative uses for PowerPoint
Nonprofit Taxation Rules and Form 990
-
TBD
2.0 Credits
Member Price: $79
Recent tax legislation and developments related to non-profit entities Special sections of Form 990 and various form related changes Nonprofit tax exemption applications Excess compensation excise tax Excess parachute payment excise tax Unrelated business income tax Required profit motive
Ethics and Technology for CPAs
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this class include:The foundational ethical principles CPAs are required to follow and how these principles apply to audit quality, data privacy and security, and the use of emerging technologies.The profession's need to change to meet its ethics standard in a technology-centric environment.Changes being considered by the AICPA and the National Association of State Boards of Accountancy that could impact the profession.
Power BI - Bringing It All Together for Data Analysis
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include: Building a Comprehensive Workflow in Power BI: Streamline and enhance your end-to-end data processes for improved efficiency and clarity.Exploring What's Next After Creating Data Models and Measures: Understand advanced strategies to further enhance the value of your existing data models.Best Practices for Performance Optimization: Learn key tips to ensure smooth, fast, and reliable performance in your existing data models.Leveraging Your Data Model Through PowerBI.com/Power BI Services: Explore advanced functionalities of Power BI Services to make your data insights more accessible and impactful.
Surgent's Tax Research
-
TBD
2.0 Credits
Member Price: $99
Tax code hierarchy Organization of an Internal Revenue Code section Special rules for IRC citation Citing other primary authority Private letter rulings Primary vs. secondary authority Secondary sources of authority Steps in the tax research process Research memoranda
Global IIA Standards (GIAS) Fundamentals and Domain I and II - PART 1
-
TBD
2.2 Credits
Member Price: $79
Accounting Internal Audit Internal Control GIAS Standards Internal Audit Standards
2025 Not-for-Profit Accounting & Auditing Update
-
TBD
3.0 Credits
Member Price: $99
Yellowbook Auditing Accounting
Best Practices: Conducting Meaningful Walkthroughs
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Review of audit procedures.Documentation requirements.Real world examples of red flags that may arise.
HR Investigations - Episode 3 - Gathering-Analyzing-Reporting
-
TBD
1.0 Credits
Member Price: $39
Documentary evidence gathering and analysis Site visits Surveillance Analysis by comparison and contrast Analysis by quantifying and connecting Analysis by identifying patterns Written reports Testifying
Walkin', Talkin', Lookin' & Listenin' - Or Things Most of Us Don't Do Well
-
TBD
2.0 Credits
Member Price: $79
The importance of making yourself available How to start a conversation and what to NOT talk about The art of how to listen When you don’t understand what they just said Don’t fool by equivocations when they respond to a question Materiality and perception
The CFO Series-Artificial Intelligence: A Practical Guide for Financial Leaders and CFOs
-
TBD
2.0 Credits
Member Price: $79
AI Evolution: How has AI evolved and where does it stand today Generative AI: What exactly is & generative AI; and how is it different AI Limitations: What AI can't, shouldn't or won't do AI Applications: How can I practically use AI right now AI Ethics: What are the ethical implications of incorporating AI in my work
Considerations of Fraud
-
TBD
2.0 Credits
Member Price: $79
AU-C 240 Auditing Yellowbook
Profitability Pricing: Boost your Bottom Line
-
TBD
2.0 Credits
Member Price: $79
Competitive bids Achieving target profitability
S Corporations - Overview
-
TBD
2.0 Credits
Member Price: $79
Overview of S Corporation election and compliance requirements Comparison of S Corporations with other business entities Preparing Form 2553 and addressing late filing relief Shareholder stock and debt basis considerations Form 1120S and Schedule K-1: key aspects and reporting requirements Officer reasonable compensation requirements and IRS audit strategies Introduction to Schedules K-2 and K-3 Compliance with corporate formalities and taxable fringe benefits
Surgent's Tax Loss Limitations Imposed on Individuals and Pass-through Entities
-
TBD
3.0 Credits
Member Price: $149
How to calculate a partner or S corporation shareholder’s basis Form 7203 and an S corporation shareholder’s basis The at risk basis rules and Form 6198 The passive activity loss limits The Section 461(l) loss rule The net operating loss limitation rules The Section 163(j) business interest limitation