CPE Catalog & Events
Advanced Cybersecurity - Beyond the Basics
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Understanding Cyber Threats and Risks in FinanceCybersecurity Frameworks and Best Practices for Financial ProfessionalsFinancial Data Security and Encryption TechniquesCybersecurity Auditing and Forensic InvestigationsEmerging Technologies and Trends in Financial CybersecurityLeadership and Governance in Cybersecurity for Financial Executives
Walter Haig's Business Financial Health Checkup
-
Virtual
8.00 Credits
The major topics that will be covered in this class include:How to use analytical procedures as a management tool to identify areas hindering the profitability of the entityHow to use analytical procedures to identify misstatements in financial informationTechniques for developing a "workable" business planRecasting GAAP financial statements into powerful management toolsDeveloping and using benchmarks to identify profitability problemsIdentifying profitability key factorsThe relationship of internal controls and the health of an entityCommon weaknesses in the internal controls of SMEs using the guidelines in the COSO Report on Internal Controls and common internal controls to address those weaknessesHow to create "goal" statements that achieve results
What If Your Client Didn't Take Reasonable Compensation
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Review best practices to help your client evaluate if an S election is an appropriate choiceHow to be proactive and head off common reasonable compensation issues before they happenExplore strategies for cash management if cash isn't available at year endExplore what’s at stake when reasonable compensation isn’t paid timely
AI Privacy, Security, and Compliance Masterclass
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction: What is AI Security, Privacy and Compliance (AISPC)?Why AI Security, Privacy and Compliance (AISPC) is Increasingly Important for AccountantsAISPC Policy Best PracticesKey Tactical Questions for Addressing Data Security and PrivacyOpenAI and Compliance with Government RegulationsOpenAI and Two-Factor AuthenticationOther OpenAI Security, Privacy and Compliance ConsiderationsBest Practices for Secure Data Sharing with GPT How to Create a GenAI and ChatGPT Usage Policy for Your OperationsGeneral AI Policy Do’s and Don’tsAI Copyright Compliance & Protection GuideDeepfakes and Synthetic Media: A New Frontier for Fraud and MisinformationFrom Financial Oversight to AI Governance: The Sarbanes-Oxley Legacy and Accountants' New Frontier in AI Security, Privacy, Compliance and EthicsKey Takeaways
Create Paginated Reports with Power BI Report Builder
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to Power BI Report Builder: Overview of the tool, its interface, and integration with the Power BI ecosystem.Designing Report Layouts: Techniques for setting up professional layouts, including headers, footers, and managing pagination.Data Connection and Management: Connecting to various data sources and preparing data for reporting.Creating Visualizations: Utilizing Power BI’s visualization tools for impactful data presentation.Advanced Report Features: Exploring sub-reports, drill-through capabilities, and dynamic expressions.Publishing and Sharing: Guidelines for publishing reports to the Power BI service and sharing them with relevant stakeholders.
Microsoft Outlook "Must Know" Email Tips
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Using Quick Parts to streamline message composition.Eliminating inefficient back and forth appointment scheduling with the Bookings app.Using category codes and contacts to send bulk emails.Sending emails to Teams and OneNote.Organizing your inbox with custom views, rules and folders.Mastering the search tools to find emails quickly.Review of key option settings to maximize email productivity.
Retirement Planning: Next Stage for You or Your Client
-
Virtual
2.00 Credits
The major topics covered in this class include:Welcome to Your Next Stage -- Developing a new perspective on what this next stage is really all aboutIt's About Time -- Discovering a new sense of purposeMoney Matters -- Assessing your financial conditionsRelationships Matter Too -- Addressing needed or potential changes in your relationshipsHealthy Habits -- Examining new or renewed ways to stay healthyWho I Am -- Creating a new identity, and answering "So what do you do?"My Master Plan -- Figuring out what to do next
Coping With the Growth of Online Fraud
-
Virtual
4.00 Credits
The major topics covered in this course include:The actuation of online and other cyber fraudsFraudulent acts that are initiated electronicallyAutomated and employee driven methods that can reduce cyber-fraud risk
Creating an Ethical Work Environment
-
Virtual
2.00 Credits
Ethical Values and PrinciplesHuman Factors impacting ethical choicesProfessional and organizational responsibilities in creating an ethical work environmentTools for ethical decision making
AI-Powered Excel: Leveraging AI and ChatGPT for Supercharged Productivity
-
Virtual
1.00 Credits
Harnessing AI to streamline your Excel workflows, achieving unparalleled productivity. Discover Excel's integrated AI features and learn how to utilize ChatGPT for researching, creating, understanding and troubleshooting Excel functions and formulas. Transform tasks that typically take two hours into mere minutes. Explore using ChatGPT for efficient research and learning, enabling quick access to answers for Excel-related inquiries. Optimize your Excel work, research and documentation, significantly saving time and effort in your daily tasks.
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 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
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.
Internal Control - Testing for Operating Effectiveness
-
Virtual
2.00 Credits
The major topics covered in this class include:Generally accepted audit requirements related to testing controls for operating effectivenessIdentifying key controls that may prove effective and efficient to test in a control reliance strategyResponses when deviations are discovered when evaluating the design or operating effectiveness of internal controlLeveraging audit evidence available for Service Organization Control (SOC1) ReportsGeneral computer control considerations when evaluating the design and operating effectiveness of internal control over financial reporting
Ethics and Technology for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:The foundational ethical principles CPAs are required to follow and how these principles apply to audit quality, data privacy and security, and the use of emerging technologies.The profession's need to change to meet its ethics standard in a technology-centric environment.Changes being considered by the AICPA and the National Association of State Boards of Accountancy that could impact the profession.
Power BI - Bringing It All Together for Data Analysis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include: Building a Comprehensive Workflow in Power BI: Streamline and enhance your end-to-end data processes for improved efficiency and clarity.Exploring What's Next After Creating Data Models and Measures: Understand advanced strategies to further enhance the value of your existing data models.Best Practices for Performance Optimization: Learn key tips to ensure smooth, fast, and reliable performance in your existing data models.Leveraging Your Data Model Through PowerBI.com/Power BI Services: Explore advanced functionalities of Power BI Services to make your data insights more accessible and impactful.
Surgent's Successfully Completing an Estate Tax Return -- Form 706
-
Virtual
2.00 Credits
Changes to the IRS Form 706 How to successfully navigate the form The ins and outs of the “portability” rules, including how the rules actually work using common examples Income tax consequences How to avoid malpractice traps Overlooked GST issues
Surgent's Tax Research
-
Virtual
2.00 Credits
Tax code hierarchy Organization of an Internal Revenue Code section Special rules for IRC citation Citing other primary authority Private letter rulings Primary vs. secondary authority Secondary sources of authority Steps in the tax research process Research memoranda
Best Practices: Conducting Meaningful Walkthroughs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Review of audit procedures.Documentation requirements.Real world examples of red flags that may arise.
Surgent's Tax Loss Limitations Imposed on Individuals and Pass-through Entities
-
Virtual
3.00 Credits
How to calculate a partner or S corporation shareholder’s basis Form 7203 and an S corporation shareholder’s basis The at risk basis rules and Form 6198 The passive activity loss limits The Section 461(l) loss rule The net operating loss limitation rules The Section 163(j) business interest limitation
