CPE Catalog & Events
AI Prompt Engineering Masterclass for Accountants
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction to Prompt Engineering: Basics of structuring effective prompts for meaningful AI responses.Understanding AI's "Lazy" Defaults: Why LLMs provide basic answers and how to push them to deliver richer insights.Multi-Layered Prompting: Techniques to encourage AI to provide responses across beginner to expert levels.Candid and Contrarian Responses: Using prompts that elicit honest and balanced insights, even on controversial topics.Ripple Effect and Cobra Effect: Probing the broader impacts and unintended consequences of financial decisions.Avoid Stupidity Checklist: A practical prompt for reducing mistakes in AI-assisted accounting tasks.Role-Based Perspective Prompts: Crafting prompts that guide AI to respond from specific professional viewpoints.Automation Ideas: Leveraging AI to optimize repetitive accounting tasks.Emotion-Driven Prompting: Exploring how emotion-focused prompts can enhance AI performance and engagement.Practical Applications in Accounting: How to apply prompt engineering in real-world financial analysis and decision-making.
The Controllership Series - The Controller's Skillset
-
Online
1.00 Credits
Member Price: $79
Accounting Finance Skills
AI & Accounting in Manufacturing
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Intelligent automation and dark factoriesPredictive maintenance and real-time cost trackingAI-enabled financial reporting and dashboardsContinuous auditing and anomaly detectionTax compliance automation and transfer pricing AIData governance and cybersecurity in financial systemsWorkforce reskilling and AI-augmented financial roles
The 10 Must Know Excel Features
-
Online
2.00 Credits
Member Price: $89
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.
Surgent's 2025 Tax Update for Client Advisory Services
-
Online
4.00 Credits
Member Price: $159
Common tax deadlines and penalties Employee Retention Credit – new developments Beneficial ownership information reporting Bonus depreciation changes Form 1099 reporting and changes Online accounts and IP PINs Virtual currency updates Green energy credit compliance
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 Metrics and benchmarking Social media's place in our organizations
Surgent's Ethics for the Industry Accountant
-
Online
4.00 Credits
Member Price: $179
What are ethics? Why study ethics? Ethical responsibilities of CPAs Professional code of ethics and conduct AICPA Codification – updated Ethical dilemmas CPA vision Real disciplinary cases to illustrate critical points
The Successful Family Business
-
Online
4.00 Credits
Member Price: $159
Business Management Organization
Complete Guide to Analyze Data with Excel PivotTables
-
Online
4.00 Credits
Member Price: $149
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.
Excel Tips & Tricks for the Non-Accountant
-
Online
2.00 Credits
Member Price: $109
Understanding the workbook and worksheet environment Obtaining and utilizing data Editing and formatting The “Insert” Menu The “Page Layout” Menu The “View” Menu Selecting and using formulas Shortcuts and tricks
Synchronize Your Files to the Cloud with SharePoint -Updated
-
Online
2.00 Credits
Member Price: $89
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
Global Internal Audit Standards (GIAS) - Overview and Contrast to 2017 International Professional Practices Framework (IPPF)
-
Online
1.60 Credits
Member Price: $109
Accounting Internal Controls Internal Audit Standards
Ethical Intelligence for Artificial Intelligence
-
Online
2.00 Credits
Member Price: $109
Benefits and pitfalls of artificial intelligence in the accounting profession Selecting and utilizing artificial intelligence resources Applying professional skepticism to results Maintaining independence while utilizing artificial intelligence Upholding client confidentiality Data security and retention Citation of sources and related reporting considerations
Introduction to Yellow Book
-
Online
2.00 Credits
Member Price: $109
AICPA Code of Professional Conduct Accounting & Auditing Yellowbook
Accounting and Disclosure Issues After a Natural Disaster
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Current and noncurrent asset impairment. Insurance claims and related recoveries. Debt and liquidity issues. Government assistance and relief. Subsequent Events. Lease modifcations. Other matters.
Surgent's Excel Budgeting Ideas
-
Online
2.00 Credits
Member Price: $99
Set up an in-cell drop-down list of budget methods Change the calculations in the cells based on the selected budget method Use names in worksheets
Surgent's Food, Beverage, and Entertainment Expensing
-
Online
2.00 Credits
Member Price: $99
The 50% deduction for meals that are ordinary and necessary in carrying on a trade or business Elimination of the temporary rules that applied for 2021 and 2022 which allowed for 100% deductibility for ordinary and necessary business-related meals When meals are still 100% deductible IRS rules relating to the nondeducibility of activities considered entertainment or amusement What constitutes entertainment/amusement for tax purposes? When employers may deduct food and beverages provided to employees 50% deductibility for occasional employee meals and for overtime meals 50% deductibility for business meals during business meetings Business meals incurred during business travel Invoice meals separately from entertainment
Surgent's Taxation of Tips and Overtime Under OBBBA
-
Online
2.00 Credits
Member Price: $119
$12,500 deduction per individual for qualified overtime pay Payment of overtime under the Fair Labor Standards Act (FLSA) Calculating the “premium portion” of the extra half-time pay Social Security and Medicare withholding Employer furnishing the record of qualified overtime compensation to employees Definition of a qualified tip IRS list of traditionally-tipped occupations $25,000 deduction for reported tips The transition rule allowing employers to indicate the approximate amount designated as tips or overtime State tax issues relating to tips and overtime Changes in the W-2 reflecting new employer reporting responsibilities
SAS No. 122, AU 315, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement
-
Online
3.00 Credits
Member Price: $129
How the effect of a misstatement due to error effects the scope of our audit vs a misstatement due to fraud Inquires of management …….. and others The audit planning process; when we start and when we stop The importance of brainstorming and what two things should a talk about Revisions of our risk assessment Determining materiality
Dashboard and Report Design Principles Using Excel
-
Online
4.00 Credits
Member Price: $159
Principles of Visual Design for Dashboards and Reports Chart Design for Rapid Understanding Table Design for Efficiency Effective Use of Commentary Strategic Layout Techniques Trend Analysis Methods Developing Organizational Design Standards Excel Application Techniques Critical Review Skills Best Practices for Data Presentation