CPE Catalog & Events

Simplify Outlook Meeting Scheduling with Office 365 Bookings

The major topics covered in this course include: Overview of the Bookings app functionalityStep by step demonstration of how to setup your private Bookings web pageDefining your meeting types / servicesConfiguring text message reminder notificationsSetting your scheduling policiesCustomize your Bookings page form to capture important information while booking an appointment.Integrate with Microsoft Teams Meetings

Excel for Accounting Professionals Session 4: Conditional Summing and Lookups

Building Security and Efficiency With Internal Control

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

How-To Guide to Fraud Investigations

The major topics covered in this class include:Typical asset misappropriation schemes and how they are carried outRed flags of asset misappropriation schemesData analysis, including financial ratios that may identify irregularitiesAnalyzing financial statements for fraud investigationsIn-depth asset misappropriation case study

Surgent's A Complete Tax Guide to Exit Planning

Gain exclusion and tax-free reorganization planning Gain exclusion with sales of C corporation stock – Section 1202 Deferral of gain with installment reporting Gain planning with partnerships Basis planning – basis step-up at death, gifts of interests to family Restructuring the business entity – C vs. S corporation, partnerships, LLCs Real estate planning – retention vs sales, like-kind exchanges Employee stock ownership plans – special tax incentives Employee benefit planning with ownership change Taxes other than the federal income tax – state tax, estate, gift and generation-skipping taxes, and property taxes Prospects for tax law change

Surgent's Opportunities in the Metaverse for Accounting and Other Professionals

Understanding what the metaverse is and what it is not How to access the metaverse Why accounting and other professionals should use the metaverse Where accountants can find their space in the metaverse How the metaverse is changing the way we work Ownership opportunities in the metaverse Work and taxation in the metaverse

Surgent's The Art of Delegation: Strategies for Improving Your Skills

What is delegation? Why is delegation important? When and to whom should tasks be assigned? How can you delegate effectively? How do you deal with problems and issues when they arise?

Circular 230 and Rogue Return Preparers

The major topics covered in this class include:The authority of Circular 230 on return preparersThe possible penalties for violating Circular 230How to answer ethical situations with clientsCharacteristics of return preparers who prepare false tax returnsHow to identify the violations in real life examples

Audit 205: Auditing Liabilities and Long-Term Debt Risks

The major topics covered in this course include:Typical audit procedures related to accounts payable and accrued expenses, including the search for unrecorded liabilitiesKey controls related to liabilitiesAuditing long-term debt, including compliance with covenantsDetermining the proper classification of financing arrangementsProper form of noncompliance waiver lettersImpact of noncompliance on disclosures

Excel - Using PivotTables for Data Analysis

The major topics that will be covered in this class include:The advantages of PivotTable for Data AnalysisStep-by-Step PivotTable creationCreating PivotCharts

Payroll Essentials: Ethics in Payroll

The major topics covered in this class include:Ethical framework in the payroll processThe role of ethics by stakeholders involved in the payroll processReal-life examples of what happens when stakeholders in the payroll process make the decision to decouple ethics from payroll

Key Cybersecurity Controls for CPAs

The major topics that will be covered in this class include:The five key tenets of cybersecurity:A Identify, Detect, Protect, Respond, RecoverReview specific cybersecurity controls within each of the five cybersecurity tenetsHow to appropriately assess key cybersecurity controls

Surgent's Data Analytics Toolkit - Tools and Applications

Definition of Data Analytics Assessing your organization’s current status and establishing an environment for success Financial staff’s core activities Common uses of analytics and current examples Behavioral forces that impact decisions Examples of inaccurate forecasts  Identifying strategic measurements (KPIs) Improving budgeting and forecasting and addressing Black Swan events Collecting and using data from traditional and non-traditional data sources Statistical tools, including Median, Mode, Moving average, Ratio analysis, Pareto analysis, Rolling forecast, Mission-based budgeting, Trend analysis, Regression, Z-Score (public and private organizations), and Simulation Analytical techniques, including Brainstorming, Mind mapping, and Delphi technique Software tools that are readily available and can assist in visually exploring data; expanding the scope of available data, as well as collecting, analyzing and presenting results (including Dashboards). Specific ideas for using Data Analytics, including immediate opportunities and areas for further consideration Expanded lists of readings and next level software for a participants’ future reference

Excel - Functions and Formula Shootout

The major topics that will be covered in this class include:Review of formula creation best practicesDemonstration of various ExcelA functions to enhance calculationsUsing Excel functions to perform advanced calculations

Surgent's Ensure Your Accounting Team Is Operating at Peak Performance Through Engagement and Motivation

Increase productivity and profitability Communicate better and resolve conflict Learn teamwork principles in today's changing accounting workplace Motivate yourself and your team

Surgent's Mastering Client Management for Accounting and Finance Professionals

The evolving landscape of client expectations in the accounting profession Building strong and lasting client relationships through effective communication, empathy, and proactive service Implementing efficient client onboarding and engagement processes Leveraging technology to streamline communication, enhance collaboration, and deliver personalized service Effectively resolving client concerns and complaints Utilizing client feedback to continually improve your practice

Audit 206: Analytical Procedures - Audit Fundamentals

The major topics covered in this course include:Identifying risk of material misstatement through preliminary analytic review proceduresEnsuring sufficient appropriate audit evidence is gathered through final overall analytic reviewEstablishing expectations for analytic proceduresProperly designing, documenting and evaluating the results of substantive analytic review proceduresDisaggregating substantive analytics for stronger resultsFactors impacting the design of substantive analytic proceduresCommon pitfalls in performing substantive analytic procedures

Microsoft Outlook "Must Know" Email Tips

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.

Power BI - Create Excel Dashboards for Maximum Impact

Dashboard design guidelines Using Excel features to create visuals Using visuals to create dashboards Introduce new Power BI tools that enhance visual and dashboard creation

Entertainment, Meals & Travel Expenses: Review and Update

The major topics that will be covered in this class include:Definition of what qualifies as an entertainment expenseStrategies to deduct business entertainment expensesDeductibility of mealsSituations not subject to the 50% meals and entertainment reductionHow to handle automobile issues related to employer-provided parkingProper accounting for deductible vs. non-deductible expendituresThe four steps to analyze business expensesThe latest federal legislation, cases and rulings