CPE Catalog & Events
Exercise Your Ethics: Techniques to Improve Ethical Response
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explore research for common answers to "what does ethics mean to you?" and examine whether those are valid.Identify common ethical barriers - reflecting the latest from the ACFE Report to the Nations.Discover ways to improve ethical response.Practice, using practical advice from leading thinkers in ethics.
Cost and Pricing Models: Creating an Effective Tool
-
Online
2.00 Credits
Building computer costing models & sub models The importance of volume sensitive models Your twelve most important indirect costs Using rate tables Modeling – Professional Services Job Costs Modeling – Repetitive Manufacturing Why return on sales may be an inferior way to plan for profit
Taking Advantage of Array Formulas in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants
Managing Your Money in Retirement
-
Online
3.00 Credits
Social Security Retirement Asset allocation Fraud
Securing Your Data with a Password Management App - Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Introduction to the world of password management apps and what makes them so secureReview and demonstration of top selling password management appsSoftware features that will be reviewedPassword generationEmergency user accessEntity vs. individual password managementDesktop vs. cloud basedMulti device synchronizationPII (personally identifiable information) forms fillerCredit card storageDigital data vault
Written Information Security Plans
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Introduction to the Gramm-Leach-Bliley Act and its impact on data security.Circular 230 compliance and due diligence for practitioners.AICPA Statements of Standards relevant to WISP requirements.Key components of a Written Information Security Plan.Training requirements for employees, staff, and contractors.Practical guidance for drafting and implementing a WISP.FTC enforcement of data security standards for PTIN holders.Best practices for maintaining and updating WISP compliance.
Navigating Difficult Conversations with Clients
-
Online
1.00 Credits
Communication Negotiation Conflict Persuasion Management Leadership Customer Service
Audit Risk Assessment in Plain English
-
Online
2.00 Credits
Overview of Audit Risk Assessment AICPA's clarified Risk Assessment Standards SAS 145 Assessing the Entity's Environment
Financial Decisions that Led Two Businessmen 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 Annual Update for Defined Contribution Plans
-
Virtual
2.00 Credits
Common risks and pitfalls associated with defined contribution plans Nuances of the fair value disclosures New reporting and disclosure requirements for the current year Results of DOL Audit Quality Study
Surgent's Excel: Mastering PivotTables
-
Virtual
2.00 Credits
Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel
Surgent's Guide to Calculating S Corporation Shareholder Stock and Loan Basis
-
Virtual
2.00 Credits
Introduction to Form 7203 Introduction to the calculation of stock basis Introduction to the calculation of loan basis Taxable and nontaxable S corporation distributions to shareholders The election to reduce basis by deductible losses and expenses before reducing basis by nondeductible expenses
Surgent's Understanding S Corporation Taxation: Compensation Issues and Entity-Level Taxes
-
Virtual
2.00 Credits
Reasonable compensation Fringe benefits for S corporation shareholders Built-in gains tax Excess passive income tax Notice 2020-75: PTE elections
Surgent's Work-Life Balance: Maximizing Productivity and Understanding Related Tax Issues
-
Virtual
2.00 Credits
Discuss how productivity strategies may improve work-life balance Understand the state tax consequences that may arise when working from home Identify and discuss challenges unique to financial professionals Review how some organizations are providing support to improve work-life balance Explore the role of alternative work arrangements Examine challenges unique to auditors versus tax professionals A comparison of work-life balance between public and industry accountants How work-family conflict varies among financial professionals Recommendations for improving work-life balance
Staff Retention Keep the Best People
-
Online
3.00 Credits
Remote workforce Employee retention Staff turnover
Surgent's Coaching Skills for Managers and Supervisors
-
Virtual
4.00 Credits
The definition of “coaching” and the coaching process Characteristics of effective coaches Coaching strategies to support and assist others as they change ineffective behaviors Conducting one-on-one coaching sessions for setting goals and improving performance
Becoming Conflict Competent
-
Virtual
2.00 Credits
Major topics covered in this course include:Levels of conflictStrategies to de-escalate conflictDistinction between miscommunication and conflictResponses to conflictTactics to address, rather than avoid, conflict
Create Visuals in Power BI to Successfully Analyze Data
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Tour of the Power BI Desktop Interface: Understand the layout, tools, and features of Power BI Desktop.Tour of PowerBI.com Interface: Familiarize with the online environment of Power BI for report creation.Importing Power Pivot Data Model: Understand how to integrate Power Pivot models into Power BI for more complex data analysis.Building Visuals: Learn the step-by-step process to create compelling visuals and understand the importance of visual context in data storytelling.Review of Available Visuals: Explore the variety of visuals available in Power BI and their appropriate applications.Power BI Desktop Features: Delve into the advanced features of Power BI Desktop, enhancing data manipulation and visualization capabilities.Building Interactivity into Visuals: Learn to create dynamic and interactive reports that engage and inform.Publishing Reports to PowerBI.com: Gain skills in uploading and managing reports on PowerBI.com for wider access and collaboration.
Transforming Strategic & Financial Management with ChatGPT - Insights for CPAs, CFOs and Controllers
-
Online
2.20 Credits
Recognize the variety of ChatGPT uses in accounting. Determine how to use ChatGPT. Identify how ChatGPT improves customer, vendor, and industry research. Recognize how ChatGPT aids in financial benchmarking. Identify how ChatGPT can assist in financial analysis, budgeting and forecasting.
Advanced Excel: Hidden Secrets and Gems
-
Virtual
2.00 Credits
The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models
