CPE Catalog & Events
Excel - Working with Text, Date & Time Functions & Formulas
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Using Text functions to join and separate text entriesInserting Text functions to work with imported dataPerform date and time calculations with the Date & Time functions
Awful Ethical Dilemmas - Bringing it to Life, featuring J. Michael Inzina and Don Minges
-
Online
1.00 Credits
Member Price: $39
Following the letter of the Code versus following the spirit of the Code Preparing for conflicts of interest Document your analysis of the situations Five (5) case study examples
S Corporations: Calculating Shareholder Basis
-
Online
2.00 Credits
Member Price: $89
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
Navigating Difficult Conversations with Clients
-
Online
1.00 Credits
Member Price: $39
Communication Negotiation Conflict Persuasion Management Leadership Customer Service
Introduction to Sustainability Accounting
-
Online
1.00 Credits
Member Price: $39
History of Sustainability Accounting Sustainability Metrics for Industry Published Sustainability Standards
Integrate ChatGPT into Your Client Advisory Services-Updated
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:ChatGPT and generative AI technology primerBuilding your generative AI vocabularyDig deeper into your engagement research to develop a higher quality advisory servicePolish your client reporting with the help of ChatGPTDeveloping your ChatGPT client advisory servicesStart with client education. You don’t need to be a technical expert to be an educatorUse AI to help your clients automate their workflows / business processesBuild better spreadsheets with ChatGPT and ExcelHelp your clients identify, evaluate and select applications for their business
Let's End Business Ethics
-
Online
2.00 Credits
Member Price: $79
Ethics defined Are there business ethics? How to identify ethical issues Deciphering your ethical code Why ethical behavior is good for your business How to make ethical decisions
Creating Rapid Rapport for Increased Business
-
Online
4.00 Credits
Member Price: $129
1. How to get people to like you What leads to people liking each other Why people judge you, and how to avoid negative judgments What goes on when we first meet someone How to put someone at ease 2. The Elements of Trust Why we trust someone, and how you can create trust What leads to a "special bond" How to repair "broken trust" How to establish trust in just a few minutes 3. Mastering Non-Verbal Communication Why non-verbal communication is so important How to connect with someone in a non verbal manner How to create trust and rapport through non verbal means 4. What to Say to Establish Immediate Rapport The most effective way to instant intimacy How to handle your fear of rejection How to feel immediately confident when talking to anyone How to get almost anyone to really like you through the use of questions
Independence and Conflicts of Interest
-
Online
1.00 Credits
Member Price: $55
The major topics covered in this class include:AICPA Code of Conduct: Independence, Conflicts of Interest, Case Study: OlympusCase Study: Buca di Beppo
How to Create an ROI-Based Marketing Plan for Your Firm
-
Online
1.00 Credits
Member Price: $55
The major topics covered in this course include:Clarifying and communicating the unique value you provide to your chosen market.Choosing the market(s) you will be successful serving.Developing a successful go-to market and subsequent demand and lead gen strategy.Creating an easy to maintain customer nurture, demand and lead generation system.Determining your marketing budget, goals, objectives, and the right tactics to choose in order to support them.
Risk Management Techniques and Tools
-
Online
2.00 Credits
Member Price: $118
Enterprise risk management ISO 31000:2018 principles COSO ERM framework Tools and techniques in risk awareness and management Value stream perspective for enterprise risk management
Impact of GASB Activities on State and Local Government
-
Online
3.00 Credits
Member Price: $166
GASB statements issued GASB projects
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
Online
4.00 Credits
Member Price: $159
Economic update Leadership and management changes as a result of the pandemic Managing for productivity Hiring the best people for the organization New motivation techniques
Financial Accounting Standards: A Comprehensive Review-Part 1 2024
-
Online
8.00 Credits
Member Price: $299
Application of professional judgment Codification, GAAP and the GAAP hierarchy Recent changes in financial statement presentation Hot Topics in financial reporting & accounting
GAAP Update 2024
-
Online
8.00 Credits
Member Price: $299
Business combinations and consolidations Lease accounting Financial instruments - credit losses (CECL) Intangibles, including goodwill Fair value
Power BI - Advanced Data Analytics with Power Pivot
-
Online
8.00 Credits
Member Price: $239
The major topics that will be covered in this class include:Introduction to Excel Power BI ToolsLoading data into Power Pivot using data modelingCreating "measures" using DAX functions and formulasUsing a date table to create time-intelligent measuresThe DAX calculation processTO SEE OUR FULL PREREQUISITE RECOMMENDATIONS AND INSTRUCTIONS, CLICK HERE
Excel - Advanced Spreadsheet Troubleshooting Techniques
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Learning the art of nesting formulasTechniques to troubleshoot complex formulas Review of the 9 built-in error checking optionsTechniques to resolve rounding errors
6 Practical Strategies To Promote Diversity & Inclusion In Your Workplace
-
Online
1.00 Credits
Member Price: $39
Communication Leadership Character Behavior
Surgent's Artificial Intelligence for Accounting and Finance Professionals
-
Online
2.00 Credits
Member Price: $99
What is artificial intelligence? What are the different forms of artificial intelligence? The difference between artificial intelligence and machine learning The types of problems artificial intelligence can solve The role of algorithms How artificial intelligence will affect accounting and finance careers Data governance, security, and privacy How accounting firms are using AI today The role of artificial intelligence in asset management
Surgent's Ethics for Tax Professionals
-
Online
2.00 Credits
Member Price: $99
What does practicing before the IRS mean? Who may practice before the IRS? What should a tax preparer do if he or she has knowledge of a client's omission of income from a tax return? May a tax preparer rely on the work of other tax return preparers? May a tax preparer rely on and use client-provided information? Standards associated with giving advice to clients Abolition of the disclaimer requirement When must a tax preparer examine a client’s books and records?