CPE Catalog & Events
Advanced Excel: Hidden Secrets and Gems
-
Virtual
2.00 Credits
The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models
Controller Series: Communicating for Connections with Coworkers, Customers, and Stakeholders
-
Virtual
1.00 Credits
What are the three types of misconceptions of communication? What are the different types of personality styles in the workplace? Recognize how to communicate with the different types of personality styles effectively Key takeaways
Promote Internal Whistleblowing and Succeed in Creating a Strong Speak Up Culture
-
Online
1.00 Credits
Speak up culture Encouraging internal whistleblowing Ethical culture Internal complaint reporting processes
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
Better Forecasts: Be a Better Predictor
-
Online
2.00 Credits
Why an open mind and the ability to doubt helps make great predictions Why it is better to be a fox than a hedgehog How non-conformists change the world How to focus on what matters How to learn from the past without hindsight bias
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
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Virtual
2.00 Credits
Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations
Surgent's Found It! Reporting Findings in Yellow Book and Single Audits
-
Virtual
2.00 Credits
The types of findings reported in Yellow Book and single audits The Yellow Book and Uniform Guidance requirements for reporting findings How to really think through the elements of a finding to assist report users
Surgent's Top Individual Tax Planning Strategies
-
Virtual
2.00 Credits
New Clean Vehicles (CV) and the Clean Vehicle Credit What the CV seller must provide to the buyer Credit for previously owned CVs Energy efficient home improvement credit Increase in age for required beginning date for RMDs Reduction in excise tax on RMD failures Indexing IRA catch-up limit Higher catch-up limit to apply at age 60, 61, 62 and 63 Withdrawals for certain emergency expenses Qualifying longevity annuity contracts (QLACs) One-time election for qualified charitable distribution (QCD) to split-interest entity; increase in QCD limitation
Surgent's Virtual Currency: Keeping Up with the Tax Code
-
Virtual
2.00 Credits
Overview of virtual currency Property transactions with virtual currency Receiving virtual currency as payment Paying using virtual currency Charitable donations with virtual currency Gifting of virtual currency Form 8300 reporting
2025 Accounting & Auditing Update
-
Online
3.00 Credits
Accounting Standards Updates Auditing & Accounting Yellowbook
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The rules of IRS disclosure of tax informationUnderstanding the role of IRS transcriptsInterpreting the actions of the IRS in transcriptsFOIA requestsAnalyzing tax information and returns for financial leads
IRAs - Contributions & Distributions for Traditional, Roth, SEP & SIMPLE IRAs
-
Online
8.00 Credits
An emphasis on newly enacted tax legislation affecting IRAs including the NEW final required minimum distribution (RMD) regulations Contribution limits to and tax treatment of distributions from Traditional, Roth, SEP and SIMPLE IRAs Deductible phase-out limits for Traditional IRA contributions for taxpayers that are active participants in qualified retirement plans Roth IRA contribution phase-out limits as well as tax-free qualified distributions Planning opportunities for conversions to ROTH IRAs Rollover rules to/from different retirement accounts and the one-rollover-per-year limitation The different options of receiving IRA distributions before age 59 ½ and avoiding the 10% early distribution penalty (including substantially equal periodic payments) The required minimum distribution (RMD) rules from IRAs needed to avoid the 50% penalty after the account owner turns age 72 or dies The tax ramifications of spouse and non-spouse beneficiaries and how this affects the RMD calculation after the account owner’s death Overview of health savings account (HSA) eligibility rules, contribution limits and distribution rules
Coaching the Next Generation of CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Building a high-performing team comprised of multi-generational workers.How to effectively communicate with the millennial worker.Leveraging younger staff in business development opportunities.Measuring the productivity of a millennial workforce.
Revenue Recognition - Topic 606 Disclosures
-
Online
1.20 Credits
Revenue Recognition Accounting
How to Gain Efficiencies in Your Accounting Processes and Program Operations
-
Virtual
1.50 Credits
Financial reporting, accounting operations, accounting processes, automation, outsourcing, technology.
Like-Kind Exchanges
-
Online
2.20 Credits
Like-kind exchanges (LKE) Qualified third party intermediaries (QI)
Securing Your Data with a Password Management App - Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Introduction to the world of password management apps and what makes them so secureReview and demonstration of top selling password management appsSoftware features that will be reviewedPassword generationEmergency user accessEntity vs. individual password managementDesktop vs. cloud basedMulti device synchronizationPII (personally identifiable information) forms fillerCredit card storageDigital data vault
Build a Data Model for Analysis in Power BI
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Data Modeling Essentials: Understanding the core concepts of data modeling in Power BI, including integration of various data sources.Building Relationships: Techniques to establish and manage relationships between different data sets.Calculated Columns and Basic DAX Measures: Introduction to DAX (Data Analysis Expressions) and its application in creating calculated columns and basic measures.Calculated Columns vs Measures: Insights into when to use calculated columns and when to opt for measures.Explicit vs Implicit Measures: Understanding the difference and appropriate application of explicit and implicit measures in data analysis.Hierarchies in Data: Creating and utilizing hierarchies to enhance data analysis and reporting.Using Pivot Tables to Validate Measures: Practical skills in using pivot tables within Power BI to validate and refine measures.
Becoming Conflict Competent
-
Virtual
2.00 Credits
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
