CPE Catalog & Events
The Leadership Skills of Tomorrow: Delegate and Listen
-
Virtual
2.00 Credits
The major subjects that will be covered in this course include:Three levels of listeningStrategies to remain focusedBuilding trust through listeningTactics to practice the Titanium RuleDelegating with confidenceEstablishing an accountability system
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.
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.
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
Ethics at Work: Diversity, Equity and Inclusion
-
Virtual
2.00 Credits
The major topics covered in this class include:Overview of ethicsEthical values and principlesDEI working definitionsUnconscious bias, assumptions, microaggressionsStanding Up and Speaking OutDEI and Organizational Responsibility
Surgent's Excel Tables and Conditional Summing
-
Virtual
2.00 Credits
Using the Table object to store data Using the conditional summing function to aggregate Table data Using the Table object to create mapping tables
Building a Better Budget in a Time of Uncertainty
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting
Criminal Tax: How CPAs Bring Value to Defense Attorneys
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The common weaknesses in a criminal tax investigation.The key documents to review (In a sea of thousands of documents).Crafting questions to recommend in court proceeding.
Casualty Losses: Disaster Relief Act of 2024
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Federal Disaster Relief Act provisions enacted in December, 2024Comparison of personal use casualties with business/investment casualtiesWhen to claim casualty lossesHow to postpone casualty gainsBusiness casualty gains and depreciation recapture
Risk Is Increasing - and Risk Management Is Evolving
-
Virtual
1.00 Credits
Risk management Value stream and Plus/Delta techniques Cyber risks Black Swan events
Ethics and Professional Conduct
-
Virtual
2.00 Credits
Discussion of what makes an ethical dilemma. Review of recent ethical violations Practical applications of the independence and conflict of interest rules Current PCAOB concerns
Surgent's Critical Conversations
-
Virtual
2.00 Credits
High stakes conversations where the goal or outcome is paramount A Critical Conversation Worksheet to use as a tool Self-assessment of interpersonal approaches on a continuum from aggressive to silent The stories: mine and yours — are they the same? Contrast statements for ensuring a shared understanding Building confidence in conducting a Critical Conversation
Surgent's Forms 7217 and 7203
-
Virtual
2.00 Credits
Tax treatment of partnership distributions to partners of cash and property other than cash Basis of property received in a partnership distribution IRS’s new regulations regarding basis shifting in favor of high-marginal tax rate related partners Organization and structure of the new Form 7217 Who must file Form 7203 Determining the S corporation shareholder’s initial basis in his or her stock Basis limitations on partnership losses and deductions Organization and structure of Form 7203 — understanding the three parts of Form 7203 Filing criteria for Form 7203 Calculating an S corporation shareholder’s share of S corporation deductions and credits Understanding stock and debt basis
Surgent's Mastering Client Management for Accounting and Finance Professionals
-
Virtual
2.00 Credits
The evolving landscape of client expectations in the accounting profession Building strong and lasting client relationships through effective communication, empathy, and proactive service Implementing efficient client onboarding and engagement processes Leveraging technology to streamline communication, enhance collaboration, and deliver personalized service Effectively resolving client concerns and complaints Utilizing client feedback to continually improve your practice
Synchronize Your Files to the Cloud with SharePoint -Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Overview of the OneDrive Sync app functionalityStep-by-step review and demonstration of how to deploy this appInstalling the Sync app on your local devicesConfiguring the files and folders to synchronize toy your local deviceManage the locally stored filesBest practice tips for using the Sync app and avoiding common mistakes
The Bookkeeper Goes to Prison
-
Virtual
2.00 Credits
The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Surgent's Preparation and Compilation Engagements Under the SSARS
-
Virtual
4.00 Credits
Relevant sections of SSARS No. 21, Clarification and Recodification SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services – 2018 SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements
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
Leadershift: Drive Results Through Ethical Performance Mgmnt
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:How Inspirational leadership is the foundation that ethically drives results.Simplify the complex: Walk through the Results Model and discover practical how-to examples of execution.Hacks for getting great results with specific examples you can leverage in your business:The How: Empower your people to feel like an owner, managing difficult conversations well, leading with empathy and what that looks like, how it should feel, motivational coaching techniques to get your employee relationships back on track, and unleashing the power of appreciation and gratitude.The What: Powerful score-carding, transformational goal-setting conversations, and positive accountable follow- up.
Navigating IRS Collections: The Collection Process
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of the IRS collection process.Taxpayer rights and the Taxpayer Bill of Rights.Collection due process and appeals.Installment agreements and offers in compromise.Wage garnishments, levies, and liens.Penalties and interest.
