CPE Catalog & Events
ACPEN: Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Virtual
2.00 Credits
GETPIVOTDATA Text Files and Power Query Data Preparation PivotCharts
Surgent's Controllership Skills Update – Budgeting, Forecasting, and Big Data
-
Virtual
1.00 Credits
Why forecasts and budgets are frequently wrong: behavioral finance; improper goal setting, games, continuing the status quo, traditional budgeting techniques Incorporating strategy into budgets: improving measurement systems; common errors, developing strategies and appropriate measurements Expanding the budgeting framework: rolling forecasts; mission-based budgeting, zero-based budgeting, post-completion evaluations, contingency planning, black swan events, identifying improvements Big data: definition, challenges, goals, current uses/examples, sources of information Analytical tools: ration analysis, benchmarking, Pareto analysis, trend analysis, regression, simulation, dashboards
Accounting for and Auditing Cryptocurrency & Digital Assets
-
Virtual
2.00 Credits
The major topics covered in this class include:Common applications related to initial recognition and measurement, subsequent measurement or derecognition, presentation, and disclosure of cryptocurrency and other digital assetsFeedback from the AICPA's Digital Assets Working Group intended to assist auditors with opining on these digital records
ACPEN: Generation Intelligence: Navigating the Generational Divide
-
Online
1.00 Credits
Generations
ACPEN: Current Fraud Trends - Nonprofit and Government Entities
-
Online
2.00 Credits
Best practices for fraud prevention and detection Common fraud schemes in nonprofit and government entities including cash misappropriation, payroll fraud, vendor fraud, falsified billings, improper use of credit cards or purchase cards, the redirection of cash and non-cash contributions, personal use of assets, the redirection of grant benefits, other grant related fraud, travel and expense reporting fraud
Ethics: How to Run Your Business Well
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The five principles of ethical intelligenceHow to make the right decisions in a range of challenging situationsThe fundamental ethical principal, "Do No Harm"
Surgent's Privacy and Security Training: Obligations of Confidentiality and Safekeeping
-
Virtual
0.00 Credits
Obligations of confidentiality and safekeeping Security best practices to apply beyond work Likely causes and effects of a large-scale cyberattack Email security best practices Remote work security Mobile device security Internet of Things (IoT) risks Public Wi-Fi risk and the importance of using a VPN Recognizing and avoiding text message/phone call phishing Data loss prevention (DLP)
Surgent's The Accountant as the Expert Witness
-
Virtual
2.00 Credits
Becoming qualified as an expert witness Best practices for testifying at trial Understanding the different roles accountants can play in litigation Working with attorneys to prepare and present a case at trial The role of experts in commercial versus personal injury litigation Confidentiality orders Compensation for expert witnesses Preparing for and attending depositions Daubert challenges to experts Expert reports The role of experts in antitrust, securities litigation, and professional liability cases Credibility as a witness
Business Transformation: Critical Skills for CFOs and Controllers
-
Virtual
4.00 Credits
ACPEN: Federal Tax Update - C & S Corporations, Partnerships & LLCs (Forms 1120, 1120S & 1065)
-
Online
8.00 Credits
Discuss the most recent business income tax legislation passed to date Review numerous business income tax provisions including but not limited to the 20% qualified business income (QBI) deduction; changes to NOLs, §461(l) business loss limitations, §163(j) business interest deduction limitations, accounting method changes, depreciation, fringe benefits and entertainment expenses Brush up on issues related to compensation, distributions, liquidations, self-employment taxes and retirement plan Look at any changes to the Forms 1120, 1120S, and 1065 and other related schedules and forms
Surgent's Managing People Through Motivation
-
Virtual
0.00 Credits
What it means to engage people; discuss the meaning of motivation by getting to the core of what impacts your employees’ productivity Get your employees charged; find out what makes them tick through examining and understanding some of the classics in motivational theory Learn how to drill down to what truly motivates your employees Using the C.A.R.E. model to improve employee motivation through case studies
Surgent's Reasonable Suspicion
-
Virtual
0.00 Credits
The psychosocial, physiological, and behavioral aspects of drug and alcohol abuse in the workplace The impact of drug and alcohol abuse on workplace safety The possible connection between performance issues and drug or alcohol abuse The role of documentation in reasonable suspicion testing Confidentiality concerns in the testing process
AI & Accounting in Retail
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:AI-powered personalization and its impact on revenue recognitionDynamic pricing models and tax compliance risksAI in demand forecasting, inventory valuation, and COGS calculationsIntegration challenges with ERP and POS systemsGovernance, ethics, and auditability of AI decisionsData quality, audit trails, and regulatory documentationAI-assisted fraud detection, financial controls, and oversight
Individual Tax Update: OBBA and Recent Developments
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Legislation impacting individual taxpayersThe One Big Beautiful Bill ActExtenders legislation updateChild tax and dependent care creditsSection 199A deductionCapital gains and lossesRental real estateOther passive activities losses
Surgent's Real Estate for Accounting and Finance Professionals
-
Virtual
2.00 Credits
Rental income and expense calculation and reporting Deciphering Schedule E (Form 1040) Nuances of vacation home rules Passive activity loss rules: foundations and implications Active vs. material participation in rental activities Tax reporting: how to group passive activities Limitations on passive losses: at-risk rules and deductions Classifying rental real estate activities Navigating exceptions in rental real estate taxation
Surgent's Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business
-
Virtual
3.00 Credits
Due diligence checklist items Asset sales and stock sales and their attendant results to buyers and sellers Section 1060 and the residual method Selling sole proprietorships, partnerships, and corporations Consequences of making a Section 754 election with adjustments under Sections 743(b) and 734(b) Section 338 and Section 338(h)(10) elections Allocating some of the purchase price of a business to personal goodwill Partnership distributions to retiring partners under Section 736(a) and 736(b) Consulting agreements and employment agreements as between buyers and sellers Advantages of a C corporation having Section 1202 stock
ACPEN: Not Just Your Everyday FASB Update
-
Online
4.00 Credits
Analysis of relevant GAAP provisions Reminders regarding the continuing importance of ASC 606 for revenue recognition Fresh perspectives of lease accounting in the wake of ASC 842 implementation Overview of U.S. GAAP alternatives for certain entities Summary of selected, salient standards for today’s audit, review, and compilation engagements
Complete Guide to Analyze Data with Excel PivotTables
-
Virtual
4.00 Credits
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.
Cybersecurity: Protecting Your Firm's Data and Reputation
-
Virtual
2.00 Credits
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