CPE Catalog & Events
Build a Data Model for Analysis in Power BI
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Data Modeling Essentials: Understanding the core concepts of data modeling in Power BI, including integration of various data sources.Building Relationships: Techniques to establish and manage relationships between different data sets.Calculated Columns and Basic DAX Measures: Introduction to DAX (Data Analysis Expressions) and its application in creating calculated columns and basic measures.Calculated Columns vs Measures: Insights into when to use calculated columns and when to opt for measures.Explicit vs Implicit Measures: Understanding the difference and appropriate application of explicit and implicit measures in data analysis.Hierarchies in Data: Creating and utilizing hierarchies to enhance data analysis and reporting.Using Pivot Tables to Validate Measures: Practical skills in using pivot tables within Power BI to validate and refine measures.
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
Current Cybersecurity Risk Management Trends
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of current cybersecurity threats and how to mitigate data breach risk.Describe how to avoid malware and other security threats
How AI Fits into the Accounting World
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:An overview of AI constructs.How artificial intelligence is being used by accountants today.Accounting-centric AI developments on the horizon.
Surgent's Communicating Financial Results to Stakeholders: A Guide for Client Advisory Services
-
Virtual
2.00 Credits
Communicating financial results The role of the accountant in communication The challenges accountants face in communication Creating better awareness of a company’s financials Behavioral biases of stakeholders Tips for staying on-point in communication Case study
Surgent's Depreciation Rules for Bonus and Section 179 Expensing
-
Virtual
2.00 Credits
President Trump’s promise to restore full bonus depreciation effective January 20, 2025 Bonus and Section 179 depreciation rules for 2025 2025 legislative changes that could extend the TCJA depreciation changes for many years or even make them permanent Possible return of 100% bonus depreciation What will the depreciation rules be in 2026 and beyond if the TCJA depreciation rules are not extended beyond 2025 Section 179 expensing rules for 2025 and beyond, including how Section 179 applies to business vehicles 2025 rules for vehicle depreciation
Ethics: How to Give and Receive Criticism the Right Way
-
Virtual
2.00 Credits
The major topics covered in this course include:Entertaining lecture by a professional presenter, illustrated with relevant video clips and photographs, to cover the main points of the webinarWriting exercises, so you can see how these lessons apply to your own CPA practice and personal lifeTrue stories about CPAs and other leaders to show what can happen when apologies and criticism are done right, and the pitfalls of doing them the wrong way
Surgent's The Most Critical Challenges in Not-for-Profit Accounting Today
-
Virtual
4.00 Credits
Key issues related to not-for-profit financial reporting (e.g., presenting a measure of operations, various disclosures, concentrations of risk, and etc.) Key challenges encountered in not-for-profit accounting (e.g., contributed services, restricted contributions, conditional contributions, membership dues, noncash contributions, and etc.) Additional issues in not-for-profit financial reporting
Forensic Accounting: When The Office Is A Crime Scene
-
Virtual
4.00 Credits
The major topics covered in this class include:A step-by-step process from the initial client phone call to you writing a report of your findings for any civil or criminal actions that may be pursuedHow to advise your client in approaching an allegation of embezzlementWhat pitfalls may arise in finding the truthThe best practices to ensure that the evidence is preserved properly for potential civil or criminal actions
Compilation, Preparation and Review Basics and Peer Reviews
-
Virtual
2.00 Credits
The major topics covered in this class include:Basic requirements included in AR-C Section 60, General Principles; AR-C Section 70, Preparation of Financial Statements; AR-C Section 80, Compilation Engagements; and AR-C Section 90, Review of Financial Statements.New requirements included in SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions.Common peer review findings.Practice tips for high-quality engagements.
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Understanding Cost Behavior and Its Impact on Decision-MakingContribution Margin and Break-Even AnalysisMargin of Safety and Its Role in Risk ManagementOperating Leverage and Financial SensitivityAnalyzing Asset Turnover for Operational EfficiencyCash Conversion Cycle and Working Capital InsightsFree Cash Flow Yield as a Valuation Tool
The Ethic of Self-Esteem For Women
-
Virtual
2.00 Credits
The major topics covered in this class include:Self-Esteem: What is it?Belief systemsBenefits of High Self EsteemMinimizing traps of low Self EsteemComponents of High Self Esteem
ChatGPT and Advanced Accounting Research
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The accounting research transformation: Comparing Google vs. AI methodologiesAI ecosystems and specialized models for accounting applicationsAdvanced prompt engineering techniques for financial and tax researchAI-powered search engines and deep research platforms for accounting professionals AI as an ideation and thinking partner for complex accounting problems Specialized accounting research tools and AI superstoresPersona priming and P&P stacking methodologies for optimal AI interactionsEthical considerations and limitations of AI in accounting researchThe compliance chess effect: AI's impact on tax planning and regulatory responseAI-driven automation for regulatory updates and compliance monitoring
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
ChatGPT Vision: How Accountants can Chat with Imagery
-
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.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.
Surgent's Critical Issues Involving Taxation of Construction Contractors
-
Virtual
4.00 Credits
The impact of recent legislation on the construction industry How to qualify for the “small contractor exemption” and its advantages to the taxpayer Options available to the “small” contractor regarding taxation of long-term contracts How the choice of entity impacts taxation of contractors How AMT impacts the construction industry IRC §460 and “large” contractors How “uninstalled materials” impact taxation of contractors How the “look-back” rules impact contractors How the “10 percent method” can allow certain contractors to defer recognizing taxable income Critical tax planning strategies for contractors
Surgent's Government and Nonprofit Frauds and Controls to Stop Them
-
Virtual
4.00 Credits
Examine real-world misappropriations of cash, check frauds, vendor scams, credit card abuse, grant frauds, benefit schemes, inventory thefts, and payroll frauds Consider and develop controls to stop fraud Tailor controls to the size and fit of the government or nonprofit
Deep Dive Into Common Auditing Deficiencies
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Review common deficiencies identified by the AICPA and state boards of accountancy.Feature discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment.Review of the areas of concern and how you can overcome them by employing best practices.
Building Security and Efficiency With Internal Control
-
Virtual
8.00 Credits
The major topics covered in this course include:An overview of control frameworks and conceptsStrategic considerations that can be incorporated into control developmentUnderstanding and controlling risk that arises when organizations change or choose not toThe COSO Internal Control Framework and the COSO ERM Framework
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Virtual
8.00 Credits
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. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Sample comprehensive engagement work programs for preparation, compilation and review engagements Reporting and disclosure illustrations for each level of service, including attesting on personal financial statements, prescribed form, special purpose framework and other engagement variations Other communication requirements, such as sample engagement letters and management representation letters
