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.
Internal Controls for Small and Medium-Sized Entities
-
Online
1.00 Credits
Overview of controls Preventative controls Detective controls Controls for SMEs
AI Ethics 2025 (VBOA-Approved)
-
Virtual
2.00 Credits
Ethical principles of AI usage. Strategies for ethical decision making. Compliance and governance in AI adoption. Balance of innovation and responsibility.
Accounting and Disclosure Issues After a Natural Disaster
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Current and noncurrent asset impairment. Insurance claims and related recoveries. Debt and liquidity issues. Government assistance and relief. Subsequent Events. Lease modifcations. Other matters.
Surgent's Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs
-
Virtual
2.00 Credits
How and why a partnership makes a 754 election The effect of the 754 election when an interest in a partnership is sold or inherited How the 754 election applies when a partnership makes a distribution of property to one or more of its partners How to make the 754 basis adjustment
Treasury Circular 230 for EAs and Other Tax Preparers
-
Online
2.20 Credits
Circular 230 Conflicts of interest Loving case RTRP Other Ethical Issues Fees Qualifying continuing education
Preparing and Reviewing Workpapers - Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
-
Online
8.00 Credits
Best practices for documenting complex and subjective procedures and conclusions, such as estimates, substantive analytic procedures, etc. that impact the nature and extent of audit documentation needed to support audit conclusions Discussing the financial statement audit risk concept, including how proper application better ensures a higher quality audit Tips for an efficient workpaper review process that complies with relevant standards Understanding the quality control standards and guidance related to a CPA firm’s responsibilities for its system of quality control Explain the importance of establishing, applying, and monitoring quality control policies and procedures related to audit documentation
2025 Annual Update for Not-for-Profit Accountants & Auditors
-
Virtual
8.00 Credits
The major topics that will be covered in this course include:The Not-for-Profit Advisory Committee (NAC).Accounting Standards Updates (ASUs).Year 2 considerations of the leases standard.Common nonprofit deficiencies identified in peer review.What's going on at the AICPA.
Build Better Budgets: Fundamental Techniques
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Advantages of budgetingThe role of budgetingMaster budgetingFlexible budgetingStandards and variancesCapital budgeting
Managerial Accounting: Your Prescription for Better Decision
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Target profit and Break-even analysis.Relevant costs and decision-making.Standard costs and variances.Activity-based costing.Segment reporting and analysis.Budgeting.
CFO & Controller Critical Skills: Budgeting & Forecasting
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of budgeting toolsOverview of difference between budgeting and forecastingExamples of various budgeting and forecasting techniques
CFO Series: Recognizing Lies: How to Detect and Prevent?
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Lies abound.Why it is so difficult to call out a liar?How do lies devastate?Why do we despise lies?What sets apart liars?Deciphering the signals that indicate dishonesty.How does short-term thinking leads to lies and uncovering lies?Analyzing the cues.Differentiating concerns and guilt.The deception paradox.What makes a great lie so great? Proven processes to uncover lies.
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
Navigating the tax and non-tax dimensions of divorce. Unveiling tax and non-tax considerations in personal bankruptcy, debt cancellation, foreclosure, repossession, and bad debt reporting. Exploring the tax and non-tax aspects of personal relationship matters, encompassing cohabitation, property rights, premarital agreements, filing status, exemptions, and dependents. Grasping the intricacies of support considerations for spouses and former spouses. Addressing support matters for children of divorced or separated parents, alongside the tax treatment of back child support. Delving into the business implications in instances of business dissolution. Tackling specialized topics, including marital property rules, tax rate comparisons for married and unmarried individuals, head of household status, and treatment of refunds and deficiencies.
The Ethical Management of Conflict
-
Virtual
2.00 Credits
The major topics covered in this class include:Professionalism, Conflict and EthicsSources and approaches to conflictManaging Conflict from the Inside: Awareness of human tendencies, human emotions, and gossipGuidelines for managing conflict collaboratively
Ethics Aren't for the Byrdes in Ozark
-
Online
1.00 Credits
Ethical business behavior Ethical business decisions Ethical management decisions Ethical decisions in human resource management
The Ethics Hour: The Single Best and Most Overlooked Source of Fraud
-
Online
1.00 Credits
One key area to look for fraud? It is right in front of you, but some auditors fail to see it Recognize the signals Look for those who exploit or and game the system(s)
Build Better Budgets: Fundamental Techniques
-
Online
2.00 Credits
Advantages of budgeting The role of budgeting Master budgeting Flexible budgeting Standards and variances Capital budgeting
About the TIGTA: Who Watches the IRS?
-
Virtual
2.00 Credits
Major topics covered in this course include:The role of TIGTA in the US tax systemAuditing, investigating, and inspecting and evaluating IRS programs and operationsIdentifying opportunities to improve the administration of tax lawsPromoting integrity, economy, and efficiency in the tax systemResponding to requests from Congress and other external stakeholdersUpholding ethical standards in the accounting professionBuilding trust and confidence in the tax system
Construction Contractors: Auditing Considerations
-
Virtual
4.00 Credits
Auditing contractor accounting and revenue from contracts with customers Planning and risk assessment for construction contractors Key internal controls Substantive procedures for long-term contractors
Lessons on Fraud Prevention from Sam Bankman-Fried's Crypto
-
Virtual
2.00 Credits
Major topics covered in this course include:What starts a government investigation for white-collar crime?What is an indictment?What is extradition?What are pre-trial proceedings?What is a mitigation strategy?What is a plea agreement?What is discovery in a criminal case?What factors influence a sentence in a white-collar crime?What collateral consequences follow for people convicted of business-related crime?
