CPE Catalog & Events
Finding Errors in Excel Spreadsheets
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
Surgent's Adapting to OBBBA Changes: A Strategic Review
-
TBD
2.0 Credits
Member Price: $119
Business losses The SALT cap Implementing Section 1202 changes Form 1099 reporting changes Business meals Health care–related issues Family and medical leave Other crucial OBBBA provisions
Surgent's Incident Response and Case Studies in AI-powered Cybersecurity
-
TBD
2.0 Credits
Member Price: $119
Frameworks for incident response (e.g., NIST Cybersecurity Framework) Case studies of notable AI-powered cybersecurity incidents (e.g., ransomware, data breaches) Practical tips for financial professionals to manage crises Post-incident analysis and lessons learned Building organizational resilience through continuous improvement
Current Nonprofit Fraud Trends
-
TBD
0.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Best practices for fraud prevention and detection.Common fraud schemes in nonprofit including cash misappropriation; payroll fraud; vendor fraud; falsified billings; improper use of credit cards or purchase cards; the redirection of cash and non-cash contributions; personal use of assets; the redirection of grant benefits; other grant related fraud; travel and expense reporting fraud; and much more!
ACPEN: Comprehensive Estate Planning: Administration & Postmortem Strategies
-
TBD
8.0 Credits
Member Price: $250
Introduction to Estate Administration How to Read a last will and testament Understanding the Entities Administration the Estate and Orderly Process The Probate process and the courts Special Issues in Estate Administration Postmortem Issues Regarding Income Taxation of Descendants and Estates Post Mortem Opportunities on the Estate Income Tax Return Available Post Mortem Estate Tax Elections Portability Election Disclaimers
2025-2026 Federal Tax Updates - Business Entities
-
TBD
8.0 Credits
Member Price: $239
The major topics that will be covered in this course include:Current 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
ACPEN: K2’s Advanced Excel
-
TBD
8.0 Credits
Member Price: $250
Collaboration and security techniques Tables, data models, and PivotTables Advanced formulas Data queries Creating effective visualizations
ACPEN: The Single Audit from Beginning to End Update
-
TBD
4.0 Credits
Member Price: $250
Introduction Applicable AICPA standards Applicable OMB Circular Gathering information - determining the major programs Identifying risk – identifying the applicable compliance requirements Assessing risk – considering the internal controls over compliance requirements Designing procedures that are responsive to assessed risks – the tests of internal controls and compliance Evaluating single audit evidence
SEC Case Studies: Ethical Dilemmas in Finance and Accounting
-
TBD
2.0 Credits
Member Price: $89
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
ACPEN: Understand Yours and Other People's Styles: Meet Them in the Middle and Be More Effective in Generating Great Results!
-
TBD
1.0 Credits
Member Price: $39
Communications Self-Awareness Leadership
ACPEN: Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
TBD
2.0 Credits
Member Price: $89
Understanding the modern finance and accounting organization chart GAAP accounting changes Why so many changes? The speed of change and complexity Accepting reality Recognizing and fixing the top five accounting problems and errors Leases Revenue Management estimates Why is strategy necessary? What is strategy? The two keys to strategy? Why do some financial leaders lack strategic skills? Balancing strategy with our day-to-day roles
ACPEN: Claims Management Essentials: Cost-Saving Strategies for Employees and Employers
-
TBD
2.0 Credits
Member Price: $89
Medical Claims
ACPEN: K2’s Taking Another Look At Power BI
-
TBD
2.0 Credits
Member Price: $89
Getting started with Power BI Creating effective visualizations in Power BI Publishing Power BI reports to dashboards Optimizing dashboards for viewing on mobile devices
ACPEN: Five Amazing Business Books in 100 Minutes
-
TBD
2.0 Credits
Member Price: $89
Five business books, including, • “Leaders Eat Last”, by Simon Sinek, • “Zero to One” by Peter Thiel, • “American Icon” by Bryce Hoffman, • “Slide:ology” by Nancy Duarte, and • “Brain Rules” by John Molina.
ACPEN: Ethical Practices and Responsibilities Under Circular 230
-
TBD
2.0 Credits
Member Price: $89
Circular 230 (IRS) rules for conducting a tax practice Provide guidelines for registered tax return preparers and tax return preparation Contingent fees Proposed new rules addressing the evolving nature of tax practice Conflict of interest, best practices, errors and omissions, written opinion requirements Evolving rules for CPA "mobility" History and background for Circular 230
ACPEN: Schedule C of Form 1040
-
TBD
2.0 Credits
Member Price: $89
When Schedule C applies Cash v. Accrual method Typical business deductions Business vehicle expenses Section 179 and bonus depreciation
CFO Series: Acute Uncertainty Won't Go Away = More Failures?
-
TBD
1.0 Credits
Member Price: $89
The major topics that will be covered in this course include:How and why ambiguity is good, and how certainty can be harmfulHow the past blinds us to the real futureThe difference between risk and uncertaintyManaging measurable risk and unmeasurable riskWe need to ask what could happen, not what will happenWhy have our current planning approaches failed? What can we do to improve?The need to analyze decisions from multiple perspectives; why we must ‘think twice’?Probabilities are not necessarily predictive. How statistics can be misused and misunderstood, thus increasing riskNot everything can be anticipated, e.g., the success of GoogleWe must focus on our goalOur plans must be flexible!
Staff Retention: Attract and Keep the Best People 26-27
-
TBD
4.0 Credits
Member Price: $99
What a massive Gallup study says is the most important factor in employee retention Hear the logical reasons why professionals leave?
ACPEN: The Art of Marketing for CPAs
-
TBD
4.0 Credits
Member Price: $149
Why marketing and self promotion are so important today What keeps people from learning this skill, and how to overcome those obstacles How to get people (your boss, co-workers or clients) to like working with you How to sell someone on your services in a single minute How to attract more clients or the attention of your boss in a way that "wows" them How to get referrals from your clients or glowing reviews from your boss The 3 communication skills every business person needs to master, and why The 3 principles that really lead to more success in the business world, and how you can use those principles for you company and career
ACPEN: K2’s Business Intelligence, Featuring Microsoft’s Power BI Tools
-
TBD
8.0 Credits
Member Price: $250
The importance of Business Intelligence in today's business climate Differentiating between Power BI licensing options A hands-on approach to creating effective Power BI reports and dashboards