CPE Catalog & Events
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.
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
Supervision/Management Competencies: An Ethical Approach
-
Virtual
2.00 Credits
The major topics covered in this course include:Overview of Virtue EthicsMilgram and Zimbardo case studiesNavigating the transition from "Buddy to Boss"Self-Awareness and Regard for OthersSetting Standards and Analyzing PerformanceUnconscious BiasCommunication Skills
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
Shortcuts that Excel Users Love
-
Virtual
2.00 Credits
The major topics covered in this course include:The power of keyboard shortcutsOft used features with more capability than meets the eyeNew helpful featuresNote: This session is taught using Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.
2025 Not-for-Profit GAAP Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Accounting Standard Updates issued by the FASB.Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on.
Surgent's Features and Benefits of SEP IRAs and SIMPLE IRAs
-
Virtual
2.00 Credits
The new Roth SEP IRAs and Roth SIMPLE IRAs created under SECURE Act 2.0 Key factors for choosing a retirement plan for a small business Key questions an advisor must ask a small business owner to help determine which retirement plan is suitable for their business Key questions an advisor must ask a small business owner to help ensure compliance with applicable rules and regulations How SEP and SIMPLE IRAs benefit the small business owner How SEP and SIMPLE IRAs benefit employees of small businesses The tax benefits that help to offset the cost of employer contributions How to determine which business is eligible to adopt a SIMPLE IRA or SEP IRA How to determine which employees must be covered
Surgent's Stock vs. Asset Acquisitions of C Corporations
-
Virtual
2.00 Credits
Advantages and disadvantages to buyer and seller of an asset acquisition and a stock acquisition Tax treatment of consulting agreements and covenants not to compete Sale of personal goodwill associated with an asset acquisition Tax consequences associated with a stock acquisition and an asset acquisition Acquisitive reorganizations Non-tax issues that must be considered when a corporation is acquired
Surgent's Update on Recent AICPA Standard Setting: Staying Current in a Changing Environment
-
Virtual
4.00 Credits
AICPA hot topics and standard setting initiatives Discussion of suite of nine integrated SASs effective for years ended December 31, 2021 Discussion of the standard on audit evidence effective for years ended December 31, 2022 Discussion of the standard on auditing accounting estimates and disclosures effective as of December 31, 2023 Discussion of the two standards on use of specialists and information from a pricing service, and the newly updated risk assessment standard effective for years ended December 31, 2023 Discussion of standards that are effective beginning in 2025, including those dealing with client acceptance and questions asked of the predecessor auditor, the partner’s responsibility for engagement quality, group audits, conforming changes to compliance auditing, and more
S Corporations: Calculating Shareholder Basis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Discuss the calculation of basis when the entity is formed including the impact of contributed propertyExplain the importance of shareholder loans to the entityUses a comprehensive example to illustrate the mechanics of the basis determination processSchedule K-1 Basis and Form 7203Discuss how basis is impacted by distributions of corporation propertyExplain how basis is impacted by sale/or liquidation of the S corporation interestDiscuss how S corporation losses impact Form 1040 Schedule E reportingShow how to get from the Schedule K-1 information to the basis calculations
Surgent's Achieving High Levels of Compliance and Customer Service in Your Organization
-
Virtual
4.00 Credits
Why customer service is not just having nice people; it is truly serving the customer Analysis of the value of the customer to compare it to various costs creating an ROI How to develop a compliance program that adds value to the customer A hard look at several companies and industries that have mastered the dual objectives How recent developments have affected compliance and customer service
Microsoft 365: Save More Time, Make More Money
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Appreciate the full potential of Microsoft 365 to drive efficiency in your businessLearn best practices for harnessing the power of Microsoft 365 Design your Teams app setup to meet the unique attributes of your businessUse SharePoint and OneDrive to organize your files and share them securely internally and externallyOrganize your thoughts, meeting notes and other content centrally in OneNoteManage your projects, large and small, with the Planner appDeploy the Stream app to document processes efficiently and effectively Bonus Content: Understand how to harness the power of AI with Microsoft Copilot
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
Leverage PowerBI.com to Create Data Analysis for Others
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Tour of the PowerBI.com Interface: An in-depth walkthrough of the PowerBI.com environment, focusing on user interface elements, navigation, and customization.PowerBI.com Concepts: Fundamental concepts of PowerBI.com, including its architecture, data handling capabilities, and integration features.Connecting to Data: Techniques for connecting various data sources to PowerBI.com, ensuring seamless data integration and synchronization.Visualizations and Dashboards: Creating impactful visualizations and assembling informative dashboards to present data compellingly.Q&A Feature: Explore the interactive Q&A feature to derive insights through natural language queries.Sharing Datasets, Reports, Dashboards: Best practices for sharing datasets, reports, and dashboards with different audiences so they can leverage your data analysis work.Creating Apps: Learn how to package reports and dashboards into apps for easy distribution and consumption.
Surgent's Going Out on Your Own: Entity Types and Accounting Methods
-
Virtual
2.00 Credits
Financial planning pyramid What to consider when picking an entity Single member LLC vs. sole proprietorship Corporations – S vs. C Double taxation
What's Behind the Data?
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Ways in which data and information can be misleadingCommon pitfalls when encountering dataHow to re-evaluate the data to avoid those pitfalls
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
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
I Spy with My Little Eye ... an Illegality
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Are Accountants the Conscience of Business?Today’s Ethical Duty of ConfidentialityIESBA NOCLAR PronouncementWhere We Go from Here (No Clarity?)Case Discussion and AnalysisConclusion
Cryptocurrency 15 Years Later - A Market Update
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Update on the cryptocurrency marketplaceCryptocurrency exchanges - the good, the bad and the uglyOverview of cryptocurrency taxation regulationsThe technology behind cryptocurrency - Proof of stake, Layer 2, wallets and moreBlockchain technology update
