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.
ChatGPT and Complex Financial and HR Conversations
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Complex and nuanced communications related to:Budget Allocation and Negotiation TechniquesCompensation and Benefits StructuringManaging Financial Performance and LayoffsFinancial and HR Aspects of Mergers and AcquisitionsRegulatory Compliance and Ethical Financial PracticesStrategies for Financial Crisis ManagementEffective Performance Management Systems
Entertainment, Meals & Travel Expenses: Review and Update
-
Virtual
2.00 Credits
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
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.
Monthly Federal Tax Updates - January 2026
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues
SEC Case Studies: Ethical Dilemmas in Finance and Accounting
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Ethics and Ethical DilemmasEthical Codes and Professional StandardsFraud and the Fraud TriangleEthical Decision-Making ModelsFinancial Statement Manipulation TacticsCash Flow and Key Metrics Misrepresentations
Advanced Excel: Hidden Secrets and Gems
-
Virtual
2.00 Credits
The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models
Coping With the Growth of Online Fraud
-
Virtual
4.00 Credits
The major topics covered in this course include:The actuation of online and other cyber fraudsFraudulent acts that are initiated electronicallyAutomated and employee driven methods that can reduce cyber-fraud risk
Financial Decisions that Led Two Businessmen 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
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.
Power BI - Bringing It All Together for Data Analysis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include: Building a Comprehensive Workflow in Power BI: Streamline and enhance your end-to-end data processes for improved efficiency and clarity.Exploring What's Next After Creating Data Models and Measures: Understand advanced strategies to further enhance the value of your existing data models.Best Practices for Performance Optimization: Learn key tips to ensure smooth, fast, and reliable performance in your existing data models.Leveraging Your Data Model Through PowerBI.com/Power BI Services: Explore advanced functionalities of Power BI Services to make your data insights more accessible and impactful.
Coaching the Next Generation of CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Building a high-performing team comprised of multi-generational workers.How to effectively communicate with the millennial worker.Leveraging younger staff in business development opportunities.Measuring the productivity of a millennial workforce.
Forensic Accounting: Investigating Divorce Cases
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court
Using e-Signature Software to Process Agreements-Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Review of the digital document signing process.Key features to evaluate in selecting a solution.Review and distinguish top selling e-signature applications.Best practices for deploying e-signature software in your practice or business.
Comprehensive Audit & SSARS Update
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:AICPA Accounting and Review Services Committee standards update and new practice aidAICPA Auditing Standards Board standards update including recent changes to the audit and attestation standardsAICPA’s new Quality Management Standards - Overview, implementation considerations, timeline, and AICPA implementation resourcesPCAOB, IAASB standard-setting agenda and potential future AICPA ASB standards changesUpdate on AICPA’s Enhancing Audit Quality InitiativeTrends in audit quality including the DOL’s audit quality studyFrequent peer review findings and practice tips for achieving high practice qualityLatest on the DOL’s audit quality study
Exercise Your Ethics: Techniques to Improve Ethical Response
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explore research for common answers to "what does ethics mean to you?" and examine whether those are valid.Identify common ethical barriers - reflecting the latest from the ACFE Report to the Nations.Discover ways to improve ethical response.Practice, using practical advice from leading thinkers in ethics.
Partnership Tax Updates (2025)
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Court decisions covering partnership issues such as TEFRA, Statute of Limitations, Economic Substance, and Sec. 754 Elections.IRS procedural updates on passthrough entities.New developments on conservation easements.
Creating an Ethical Work Environment
-
Virtual
2.00 Credits
Ethical Values and PrinciplesHuman Factors impacting ethical choicesProfessional and organizational responsibilities in creating an ethical work environmentTools for ethical decision making
ChatGPT for Accountants: 50+ Use Cases
-
Virtual
2.00 Credits
Major topics covered in this course include:Introduction to ChatGPT and artificial intelligence chatbot technologiesAutomating frequently asked questions and the onboarding processVerifying and reviewing financial recordsProviding real-time support to clientsGenerating financial reportsAutomating tax return preparation and financial planningProviding guidance on financial decision making
Tactics to Find Work Life Balance in a Complex World
-
Virtual
1.00 Credits
The major topics covered in this class include:How to get more out of one's workHow to achieve greater balance between today's ever more demanding and complex demands of work without losing sight of what is important in daily routinesExample of how to develop and be challenged by your own personal bucket list
