CPE Catalog & Events
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.
The Ethics of Care in the Workplace
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Ethical Values and PrinciplesCompassionManaging ExpectationsRespect and HumilityAttribution Theory
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
AI Lessons Learned for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to AI R&D in Accounting: Why internal AI research is essential for modern firms.Theory to Practice: Moving quickly from speculative AI concepts to actionable strategies.Managing Exponential Change: Understanding the urgency of adapting to AI’s rapid evolution.Proactive AI Engagement: Conducting in-house AI benchmarks, research, and hackathons.The Dual Role in AI Development: Balancing innovation with data security and ethical responsibilities.Internal AI Tools Creation: Encouraging accountants to develop AI solutions tailored to their needs.Data Security and Cyber Threats: Addressing AI-enabled cybercrime and protecting against internal risks.Mitigating AI Misuse: Recognizing abuse patterns and implementing safe practices.Challenges in AI Integration: Handling resistance, management concerns, and rapid technological shifts.Continuous Learning and Adaptation: Building a resilient, R&D-focused AI culture in accounting.
How to Start a CFO Service
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:What business owners really want from a CFO/business advisory service (it's not what you think).How to determine if you're qualified to provide CFO/business advisory services.Why now is the right time to be providing CFO/business advisory services.How to get new clients to your practice and how to approach existing clients.Why clients need you and why you need them.How much you should be charging for this type of service.How to provide a CFO/business advisory service in the most efficient way possible.
Ethical Considerations in Working with Cannabis
-
Virtual
1.00 Credits
The major topics covered in this class include:Framework for assessing the propriety of offering services within the state legal, regulated cannabis industryAssist in identifying key stakeholders to be considered in conjunction to providing cannabis industry services, including:partnersstaffclientsBanking relationshipsMalpractice insurance
Technology Trends Update for CPAs with John Higgins
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Role of cloud computing as the foundation for all tech trendsBig data and data analytics the new frontier for CPAsWorkflow automation with RPA, ML and AI with a focus on ChatGPTBlockchain technology, the revolutionary data storage modelCryptocurrency 15 years later, an update on the market and technologyMetaverse - what's it all aboutCloud based financial and ERP software market update
Form 990: Best Practices for Accurate Preparation
-
Virtual
8.00 Credits
Primacy of the Form 990 as a "one size fits all" reporting mechanism Form 990 preparation sequencing and data gathering; and keys to getting Form 990 preparation right the first time Addressing presence of "related organizations" Identification of managers and measurements of their compensation 990 versus books-and-records financial statement detail Disclosures of governance inputs and Boards' employ of policies
Surgent's Business Law Essentials for Practitioners and Controllers
-
Virtual
8.00 Credits
Contract principles Partnerships and limited liability entities Legal issues related to various types of business organizations Worker classification Employee rights and the duties of employers Intellectual property Real property law Bankruptcy basics Environmental Law Merger basics
Surgent's Latest Developments in Government and Nonprofit Accounting and Auditing
-
Virtual
8.00 Credits
Developing issues related to the 2024 Yellow Book revision and the 2024 revision to the Uniform Guidance for Federal Awards Key AICPA developments affecting audits of governments and nonprofits (including SAS No. 146 on quality management) Recent GASB activities directed toward state and local governments (e.g., the implementation of GASB No. 101 on compensated absences, GASB No. 102 on certain risk disclosures, GASB No. 103 on improvements to the financial reporting model, and additional GASB projects) Critical, but sometimes overlooked, FASB ASC 958 implementation guidance and illustrations for not-for-profits)
Walter Haig's AICPA Auditing Standards Update
-
Virtual
8.00 Credits
The major topics that will be covered in this class include:AICPA auditing standards issued during the 18-month period prior to the program that impact audits of Small- and Medium- sized entities (SMEs)The new SAS 145 risk assessment requirementsThe new SAS 134 as amended audit reportsHow to fulfill responsibility to detect fraud under AU-C Section 240How to help clients design, implement and maintain their internal controlsTroublesome areas in the audits of Small- and Medium-sized Entities (SMEs) as identified in peer reviews and litigationHow to perform profitable audits of Small- and medium-Sized Entities (SMEs)
Navigating IRS Authorizations: Form 2848 & Form 8821
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of IRS Power of Attorney (POA) rules.Form 2848: Authority to Represent Clients before the IRS.Form 8821: Accessing Tax Information Without Representation.Identifying errors and compliance risks in POA filings.Rules for revoking or updating POA authorizations.Managing authorizations through the CAF system.Electronic submissions and the IRS online authorization process.Ethical responsibilities when holding a POA.
Coaching the Next Generation of CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Building a high-performing team comprised of multi-generational workers.How to effectively communicate with the millennial worker.Leveraging younger staff in business development opportunities.Measuring the productivity of a millennial workforce.
Surgent's Employee vs. Independent Contractor: Achieving Success in a Worker Classification Audit
-
Virtual
2.00 Credits
The 20 common law factors in a worker classification audit that are used to distinguish an employee from an independent contractor How disgruntled independent contractors can use IRS Form 8919 against a former employer When and how to use §530 as a defense in worker classification audits What is "industry practice" for §530 purposes Common sense steps that will avoid the recharacterization of workers treated as independent contractors to employees The IRS’s Voluntary Classification Settlement Program — advantages and disadvantages The DOL Final Rule
Surgent's Unconscious Bias for Managers, Supervisors, and Executives
-
Virtual
2.00 Credits
Unconscious bias, including the five defining characteristics of unconscious bias The real-world impacts of unconscious biases, including impacts on racial minorities, women, and older workers The concept of microaggressions, with examples An effective strategy for adult learning that can be applied to change unconscious biases, which can also be used to learn other skills A framework for handling mistakes and using them to build trust and respect in the workplace. We call this the “oops, did I just say that?” section.
The Role of Internal Control in the Risk-Based Audit
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Specific matters auditors should consider when obtaining and documenting an understanding of the client's internal control systemDevelopment of a tailored audit approach that considers the potential reliance on internal controlsGuidance for establishing an adequate basis for reliance on internal controls of less formal, smaller clients
Best Non-Google Search Tools for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Why Advanced Search Skills Are So Critical for AccountantsWhy You Need More than Google to Search the InternetGARP: Generally Accepted Research PrinciplesAlternatives to GoogleAdvisory SearchSocial SearchSpecialty searchSearch Engine resourcesWhat's Ahead in Search
Monthly Federal Tax Updates - July 2025
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues
2025 Accounting & Auditing Update for Small Businesses
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Accounting Standards Updates (ASUs) that are most likely to impact small businesses.ASUs initiated by the Private Company Council (PCC).Alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs.Audit standards that small business auditors will need to implement.
Get started with Power BI
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Overview of the Power BI Tools: Introduction to the Power BI ecosystem, including Excel’s Power BI features (Power Pivot and Power Query) and standalone tools (Power BI Desktop, Power BI Service, Power BI Report Builder and Power BI Report Server).Tour of the Tools: Introduction to the interfaces of Power Pivot, Power Query, Power BI Desktop and Power BI Services.Comparative Analysis: Understand the strengths and limitations of Excel’s Power BI features versus standalone Power BI tools.Strategic decision-making on when to use each tool for optimal efficiency and accuracy in data analysis tasks.
