CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
White-Collar Crime: What Every CPA Should Know
-
Online
2.00 Credits
Definitions of white-collar crime White-collar crime characteristics and statistics The CPA’s role in combating white-collar crime
Businesses Receiving Government Assistance
-
Online
2.00 Credits
What is Yellow Book? What is different because of Yellow Book? When might Yellow Book apply to a business? Common application of concepts to businesses Answers to common questions
Considerations of Fraud
-
Online
2.00 Credits
AU-C 240 Auditing Yellowbook
Donating Cryptocurrency and Avoiding Traps for the Unwary
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Intro to digital assetsDifferences between cryptocurrency and non-fungible tokens (NFTs)IRS Notice 2014-12Tax implications of contributing digital assetsGift tax rules for donating, gifting or bequeathing cryptocurrency and NFTs.Substantiating charitable contributions of digital assetsTraps for the unwary.
Surgent's A Guide to Gig Economy Tax Issues
-
Virtual
2.00 Credits
Characteristics of a gig economy Who is an employee and who is an independent contractor? Form 1099-NEC and reporting of non-employee compensation Reporting on Form 1099-K Gig workers and the requirement to pay self-employment tax throughout the year State tax implications of remote work for the business owner and workers How remote work creates state tax nexus Tax implications of employee telecommuting for the employer The “convenience of the employer” rule Drivers of both people and of meals or other products Section 199A deduction Implications of the Vizcaino case
Surgent's A Guide to Nonqualified Deferred Compensation
-
Virtual
2.00 Credits
The basics of nonqualified deferred compensation (NQDC) NQDC compliance Taxation of NQDC plans Types of NQDC plans Financing/funding NQDC plans Planning strategies
Surgent's Employee Stock Options: What Financial Professionals Should Know When Advising Their Clients
-
Virtual
2.00 Credits
What stock options are and why they are growing in popularity How stock options work, including the process of conveyance and vesting How to exercise stock options and the implications from doing so The risks associated with stock options and how to manage exposure Tax consequences and updates regarding stock options Strategies for selecting the best time to exercise stock options The difference between the two types of stock options: non-qualified and incentive The basic terminology relevant to owning and exercising options
K2's Excel Tips, Tricks, and Techniques for Accountants
-
Online
8.00 Credits
Fundamental Excel techniques all accounting and financial professionals should know and use Creating date-based calculations in Excel How to create Excel templates Key options you should enable in Excel Linking data in Excel
ACPEN Signature 2025: Single Audit and Uniform Guidance Issues Update
-
Online
8.00 Credits
The nuts and bolts of a Single Audit Overview of the GAO’s Fraud Risk Management Framework and the importance of fraud risk in a Single Audit Specific audit issues arising relating to the continued Pandemic and Infrastructure funding programs Review of unique elements of the 2025 Compliance Supplement (If Available) Recent changes to specific Uniform Guidance rules and regulations
Tax Season Update for Individuals with Steve Dilley
-
Online
8.00 Credits
Update and integration of recent tax legislation impacting 2025 individual returns Update on significant individual tax developments related to cases and rulings Individual tax changes including the earned income credit, child credit, and child and dependent care credit Section 199A changes, including use of carryforward passive activity and 199A losses and latest tax forms Crypto reporting update 2026 tax rate schedule and other inflation adjusted items Passive activity and hobby loss rules changes
Best Practices: Conducting Meaningful Walkthroughs
-
Virtual
2.00 Credits
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.
Fraud Case Studies: 21st Century Professional Misbehavior
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Salient provisions the AICPA Code of Professional ConductExamination of actual fraudsDiscussion of internal controls that could have prevented or mitigated actual fraudsContemplation of epiphanies for your own professional scenarios.Implications for professional conduct and compliance with professional standards
The Controller Function - Inventory Part 1
-
Online
1.80 Credits
Accounting Finance Operations
Section 199A Rules and Forms Reporting
-
Online
2.00 Credits
A deep-dive look at the Section 199A flow-through entities deduction Calculation of qualified business income Self-rental rule for 199A compared to self-rental rule for passive activities Differing impact on the sole proprietorship, partnerships and S corporations Forms reporting in Form 8995 and Form 8995-A 199A flowchart
Yellow Book Ethics
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The concept of public interestEthics, independence, and professional judgmentCompetence and continuing professional educationQuality control and peer reviewProper use of government information, resources, and positionProfessional behavior
360 Budgeting: A Holistic Approach to Process and Solutions
-
Online
8.00 Credits
Defining the budget process Common budgetary cultures and discussion of solutions Does your budget need an overhaul or just a tune up? How to make the budget flexible Making a better budget and maybe even a better you (or at least improving the perception of the budget work itself) How to build a flexible budget model that works? What are the steps we can take to budget for economic and external factors beyond our control? How the right Chart of Accounts can simply your work Budget and GAAP are not the same and why they are fine not to be Efficiently modeling payroll and benefits Identifying controllable and uncontrollable expense Using key variables to stress-test your budget Understanding your own leadership tendencies and applying them to your strengths? Understanding core personality types Learning what type of person you are? Managing and coping with the budget team Effectively dealing with the A, B, C and other players? Identifying the ‘Big Picture’ and your role in effective communication Communicating so others can understand us Understanding a presentation’s anatomy? Tips and tricks for budget presentations
Microsoft Outlook "Must Know" Email Tips
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Using Quick Parts to streamline message composition.Eliminating inefficient back and forth appointment scheduling with the Bookings app.Using category codes and contacts to send bulk emails.Sending emails to Teams and OneNote.Organizing your inbox with custom views, rules and folders.Mastering the search tools to find emails quickly.Review of key option settings to maximize email productivity.
Analytical Procedures for Nonprofits
-
Online
2.00 Credits
How to leverage preliminary and substantive analytic procedures to improve the effectiveness and efficiency of financial statement audits The required elements of a substantive analytic procedures to address detection risk Tips and traps of applying an analytic approach to satisfy audit objectives Explaining the usefulness of analyzing diverse trends and ratios in a nonprofit environment to meet the needs of various financial statement users Common ratios and trends to assess liquidity, operating efficiency, leverage, and more
ChatGPT Vision for Financial Analysis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Vision - Understanding the fundamentals of GPT Vision and its capabilities.Advantages of Vision Mode Research - Exploring the unique benefits of visual data analysis over traditional methods.Accessing GPT Vision - Guidance on how to access and utilize GPT Vision capabilities.Financial Screenshot Analysis - Techniques for analyzing financial documents and reports through screenshots.Operational Insights from Visual Data - Using images to gain insights into operational processes and asset management.Integration with Google Maps - Learning how to combine ChatGPT's vision capabilities with mapping technologies for enhanced spatial analysis.DDPP Analysis - Applying descriptive, diagnostic, predictive, and prescriptive analysis to visual data.Sentiment and Facial Expression Analysis - Techniques for interpreting emotions and sentiments in images to gauge client and employee feedback.Body Language Interpretation - Analyzing body language in images to understand non-verbal cues in business contexts.Effective Photo Capturing Techniques - Best practices for taking photos that provide optimal insights for financial analysis.
