CPE Catalog & Events
Advanced Excel for Staff - Build Reports and Analyze Data
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Building Reports Workflow: Understand the steps for creating professional and functional reports.Gather and Organize Data: Learn best practices for compiling and cleaning data for accurate analysis.Set Calculations and Key Metrics: Apply formulas and functions to calculate meaningful insights. Format and Structure Report: Use formatting tools to create visually appealing and structured reports.Review and Validate: Verify data accuracy and troubleshoot potential errors.Share the Report: Learn methods for distributing reports effectively within your organization.
Surgent's Time Management for Professionals
-
Virtual
2.00 Credits
Managing interruptions The role of activity logs, to-do lists and a priority matrix The psychology of time management Staying on track of your time management plan Controlling procrastination Blocking out time Creating an effective time management plan
Are You Ready for Your Peer Review?
-
Virtual
3.00 Credits
Peer review process and timeline Quality control standards overview Enhancing Audit Quality initiatives Common issues identified in peer review and how to prevent them Best practices to prepare for your firm's peer review Peer review resources and tools
Understanding Internal Control Constructs
-
Virtual
4.00 Credits
The major topics covered in this course include:Underlying concepts of internal controlThe importance of control measure interdependency
2025 Yellow Book Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Yellow Book engagements.Independence requirements in GAGAS.Quality management in Yellow Book. Common deficiencies found in Yellow Book engagements.
Accountant's Guide to Anti-Money Laundering (AML): People, Patterns and Prosecutions
-
Online
1.00 Credits
Prevalence and Impact of Money Laundering When CPAs Launder Money The Connection between Money Laundering and Fraud Accountant's Duty to be Alert to Fraud and Money Laundering Detection of Money Laundering, Part I Banks and Financial Institutions Detection of Money Laundering, Part II Other Organizations (Example: Casinos) Conclusion
Internal Control Fundamentals
-
Online
2.00 Credits
COSO Yellowbook Auditing
IRS Penalties and Abatements
-
Virtual
2.00 Credits
The major topics covered in this class include:Various types of penalties: Accuracy related, fraud, understatement of valuation, reporting requirement, failure to pay, and pay or deposit penaltiesRules on waiver of penalties and interestsVarious forms and procedures for requesting reliefFirst Time Abatement: Requirements and proceduresHow an individual taxpayer qualifies for Reasonable Cause abatementProcedures for requesting refund of paid penaltiesAvailable administrative options
SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit
-
Online
3.00 Credits
The importance of professional skepticism The dangers of making assumptions How to listen and understanding the answer to a question Why it is important to leave all of your expectations at home Anticipation and why it’s so dangerous Determining materiality The fraud triangle Thinking about, given a set of circumstances, how you would steal Management and the Tone At the Top
Hot Topics Audit & Attest Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Recent quality improvements to the SASs and SSARsOther matters that should be on your radar
Common Audit and Financial Reporting Deficiencies in State and Local Governments
-
Online
2.00 Credits
Financial Statement Preparation Common Mistakes made in Preparing Financial Statements GASB Financial Statement Preparation Standards
Behind the Curtain: Exploring IRS Audit Technique Guides
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of ATGsBest practices for utilizing ATGsSalient provisions of selected ATGsInsights auditors may obtain from analytical proceduresNuances associated with selected industries
Accounting of the Soul: Making the World a Better Place
-
Virtual
1.00 Credits
The major topics covered in this course include:Overview of Virtue Ethics and the Common GoodProfessionalismThe Virtue of CompassionGossip in the WorkplaceGratitude
Nonprofit Taxation Rules and Form 990
-
Online
2.00 Credits
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
Bumper Sticker Ethics v. Professional Ethics
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Introduction: "Bumper Sticker Ethics" Thinking About Ethics: Digging a Little DeeperCompare: Principles of Professional Ethics in AccountingCase Study: Frank v. Dana Corp.Conclusion: The Conceptual Framework as an Ethics Resource
K2's Data Security And Privacy Issues And Solutions
-
Online
2.00 Credits
Understanding the differences between data security and data privacy The major types of security and privacy breaches Key steps you can take to mitigate your risks of becoming another victim
Surgent's U.S. Taxation of Foreign Corporations: A Case Study Approach
-
Virtual
3.00 Credits
Understand how to approach and analyze the U.S. taxation of foreign corporations Using an example, calculate GILTI, Subpart F, and PFIC income inclusions for an individual and C corporation Determine how much foreign tax credit can be claimed against such income inclusions Determine how subsequent dividend distributions from the foreign corporation are taxed Calculate capital gain on the disposition of the foreign corporation Discuss the impact of Section 962 election Compare different outcomes under GILTI, Subpart F, and PFIC regimes for individuals and corporations Identify basic strategies for managing tax liabilities related to foreign corporations
Surgent's 2025 Tax Update for Client Advisory Services
-
Virtual
4.00 Credits
Common tax deadlines and penalties Employee Retention Credit – new developments Beneficial ownership information reporting Bonus depreciation changes Form 1099 reporting and changes Online accounts and IP PINs Virtual currency updates Green energy credit compliance
Common Yellow Book & Single Audit Deficiencies
-
Online
4.00 Credits
Auditing Yellowbook COVID-related funds
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.