CPE Catalog & Events
Clean, Transform & Load Data in Power BI
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.Data Loading: Efficiently loading data into the Power BI data model.Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.
Internal Control Changes for Remote Workers
-
Virtual
2.00 Credits
The major topics covered in this course include:The benefits and pitfalls of remote employees.How to maximize the value provided by distance workers.Policies, procedures, and control measures designed for a more geographically dispersed workforce.
Forensic Accounting: Crafting Expert Reports
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Introduction to Forensic Accounting: Gain an understanding of the fundamentals, roles, and responsibilities of forensic accountants in uncovering financial discrepancies, fraud, and economic damages.Maintain Ethical Integrity: Learn the importance of ethics in forensic accounting and strategies for ethical decision-making.Expert Report Preparation: Learn the essential components, best practices, and common pitfalls in writing clear, concise, and objective expert reports for legal proceedings.Investigation Report Writing: Explore the methodologies for conducting investigations, gathering evidence, and crafting thorough and accurate investigation reports.Economic Damages Writing: Understand the methodologies and best practices for calculating economic damages, including lost profits, business valuation, and other financial impacts.Reviewing Investigation Reports and Economic Damages: Analyze real-world examples to review and critique investigation reports and damage calculations, highlighting key insights and lessons learned.
ChatGPT and Advanced Policy Manual Development for ACCTs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Fundamentals of accounting policy manuals in traditional and AI contextsThe PRIME Method framework for AI-assisted policy developmentStrategic implementation of AI tools including ChatGPT, Claude, and CopilotInternal control and risk management policy creationAI and generative AI usage policies for accounting firmsSustainability and ESG reporting policy frameworksPredictive analytics and forecasting policy developmentRegulatory compliance considerations in AI-generated policies
Keeping Up with the FASB
-
Virtual
2.00 Credits
The major topics covered in this class include:Review of current items on the FASB agendaDiscuss the new revenue recognition standardProvide an update on the new lease accounting standardAddress U.S. GAAP alternatives for certain entities
Installment sales: Maximize Tax Benefits and Stay Compliant
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Installment sale treatment eligibilityWhen to elect out of installment sale treatmentInstallment sale of business assetsInstallment sale default and the rules for personal property versus real propertyInstallment sales and depreciation recapture
Microsoft Outlook "Must Know" Email Tips
-
Virtual
2.00 Credits
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.
Surgent's A Complete Guide to Form 1099-K
-
Virtual
2.00 Credits
What Form 1099-K is designed to do Filing thresholds for the Form 1099-K Who sends and who receives Form 1099-K Form 1099-K reporting thresholds Personal payments from family and friends Personal items sold at a gain or a loss Reporting provisions for gig workers, partnerships, and corporations Mistaken receipt of a Form 1099-K What to do when the Form 1099-K has a mistake Situations when the gross amount on a Form 1099-K must be shared How to handle the receipt of multiple Forms 1099-K
Surgent's The Risks and Benefits of ChatGPT and Artificial Intelligence
-
Virtual
2.00 Credits
What are AI tools? Where are we with AI tool development? What is ChatGPT? ChatGPT – what kind of queries are possible? Copyright and intellectual property issues Benefits of AI tools Concerns with AI tools Impact on business use of AI Policy on AI tools
Surgent's Business Law for Small Business Owners
-
Virtual
4.00 Credits
Contract principles Legal issues related to various types of business organizations Worker classification Employee rights and the duties of employers Real property law
The Bottom Line on the New Lease Accounting Requirements
-
Virtual
4.00 Credits
Lease classification Amortization of the leased asset Derecognition of the underlying asset Recognition of lease receivables Lease modifications Sale and leaseback transactions
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.
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
Hot Topics Accounting Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:New accounting standards.The impact on Financial Reporting.Hot topics in financial reporting.Current and emerging US GAAP requirements.
Surgent's Introduction to Required Minimum Distributions
-
Virtual
2.00 Credits
How SECURE Act 1.0 and SECURE Act 2.0 changed the RMD rules What is an RMD? Who is subject to RMDs? The types of accounts subject to RMDs How to calculate an RMD How to determine if a distribution can be an RMD How to determine which life expectancy table must be used when calculating an RMD The rollover and transfer rules during an RMD year IRS penalties for non-compliance with RMD regulations Applying RMD strategies to different plan types When RMDs can and cannot be aggregated How to correct an RMD shortfall How to get a waiver of the excise tax on an RMD failure The tax implication of an RMD How to donate an RMD tax-free How to determine the RMD rules that apply to a beneficiary
How AI Is Automating Internal Control
-
Virtual
4.00 Credits
The major topics covered in this class include:An explanation of Artificial Intelligence (AI).Specific ways AI is replacing human cognition. What is on the internal control horizon related to AI and other technologies.
Improve Spreadsheets by Building Controls in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Learn best practices when designing your spreadsheets How to create a proper worksheet structureLearn to use Excel's built in features to find errorsHow to create your custom controls to prevent and find errorsUsing links to quickly move to controlsUsing Conditional Formatting to highlight errors
Ethics Case Studies: Remaining Ethical in the Age of Oversharing
-
Virtual
2.00 Credits
Risks Associated with Social MediaSections of the AICPA Code of Professional Conduct That Might Be Violated Using Social MediaCase Study Discussions
Fraud & Embezzlement: Case Studies from the Trenches
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:How organizations can find themselves defrauded due to lax oversight and weak internal controls.How the existence of the "trusted advisor" creates situations where CPAs can drop their professional skepticism.Illustrations of the issues companies should look for in preventing fraud and embezzlement.
Generative AI Strategy for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Evolution and current state of AI technologies in accountingDevelopment of comprehensive AI usage policies and guidelinesImplementation frameworks for integrating AI into accounting workflowsStrategic approaches to AI-driven process automation and optimizationMethods for identifying and capitalizing on AI opportunitiesBest practices for human-AI collaboration in accountingRisk management and ethical considerations for AI implementation
