CPE + Events Catalog
Taking Advantage of Array Formulas in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
ChatGPT and Advanced Financial Analysis for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of how to utilize ChatGPT for advanced financial analysis in accounting. The session reveals how to combine sophisticated evaluation and interpretation of financial data with the cutting-edge AI capabilities of ChatGPT. Aimed at enhancing the understanding of an entity's performance, predicting future financial health, and aiding in informed business decision-making, this course goes beyond basic financial statement analysis to include a wide array of techniques and tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
The Controllership Series - The Controller's Role in Pro Forma Financial Statements (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
Pro forma statements are used by businesses to make decisions on planning and control, as well as for external reporting to owners, investors, and creditors. For example, giving financial estimates for a given period in a standardized manner is known as “presenting pro forma,” a Latin phrase that means “as a matter of form.” Pro forma statements can be helpful tools for business owners, investors, creditors, or decision-makers to analyze various scenarios of future events based on certain financial assumptions. It might aid in making predictions performance of the company. A pro forma income statement displays a firm’s anticipated sales and revenue. It also highlights anticipated fixed or variable operational expenses and, in the end, displays the potential profits and retained earnings for a future financial quarter. There are various types of pro-forma statements and methods to develop them. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years. However, the creation of pro forma financial statements is still a core part of their responsibility.
More Dates
Best Practices in Obligating Coronavirus State and Local Fiscal Recovery Funds (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
Obligating Coronavirus State and Local Fiscal Recovery Funds (SLFRF) by December 31, 2024 is essential to ensure a recipient does not have to return funds to the Treasury. There are a number of requirements to properly obligate SLFRF funds and opportunities to make changes to projects after the obligation deadline. In this course, we will define what an obligation is under SLFRF, review guidance from the Treasury, learn how to meet the SLFRF obligation deadline in multiple areas, and identify when changes can be made to estimates, contracts, and subawards after the obligation deadline.
More Dates
Integrity, Objectivity and Judgment: Values in Action (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
This course focuses on how to integrate integrity and objectivity in situations accounting professionals face daily. The participant will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action! As part of this course, we will also walk through real world examples of individuals and companies faced with these dilemmas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Build Better Budgets: Fundamental Techniques (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This session provides insights for enhancing the preparation and utilization of budgets. Seasoned accountants will benefit from a refreshed awareness of popular techniques. Budding financial professionals will obtain novel insight regarding fundamental budgeting concepts. All participants will develop an appreciation for the holistic nature of budgeting as an integral tool for planning and control. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
The Preparation of Forms 706 and 709 - Understanding the Law (3 hours)
-
Online
3.0 Credits
Member Price: $99
See more dates
A solid understanding of the laws governing estate and gift taxation is essential for tax professionals handling Forms 706 and 709. This course provides an in-depth analysis of the legal framework surrounding estate and gift taxes, including key regulations, IRS guidance, and court rulings. Participants will explore how estate and gift tax rules interact, learn strategies for minimizing tax liabilities, and gain insight into compliance challenges. The course will also provide a thorough review of any new legislative changes introduced by the current administration and their implications for estate and gift tax planning. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com
More Dates
A Culture of Regulatory Ethics: A Competitive Advantage (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
In a competitive market, every company is looking for anyway to differentiate themselves from their competition. While we often look to new markets and data for a competitive advantage, ethics can be the factor that makes the biggest difference to customers, employees, and the public at large. Using surveys, research, case studies, and examples, this course will explore why the CPA credential and the AICPA Code of Professional Conduct is so different. We will discuss why CPA's are in a unique position of trust and how this can put their companies ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Annual Accounting and Auditing Update
-
Online
8.0 Credits
Member Price: $299
See more dates
Designed as an all-you-need-to-know update for accounting, auditing, and attestation practitioners at all levels in public accounting and industry, this course provides a comprehensive review of recent standard-setting and rulemaking activities of the Financial Accounting Standards Board (FASB), American Institute of Certified Public Accountants (AICPA), Public Company Accounting Oversight Board (PCAOB), and Securities and Exchange Commission (SEC). On the financial accounting front, we will cover the FASB's Post-Implementation Review (PIR) report for revenue recognition under ASC 606 and discuss the best practices in applying the standard and identifying any ongoing issues practitioners are experiencing with applying the standard. We will also discuss the more than a dozen ASUs the FASB has issued since the beginning of 2023 and into 2025 covering crypto assets, disaggregated expenses, business combinations, and leases for entities under common control. Our focus on AICPA standards includes a detailed discussion of revamped AICPA quality management standards. The AICPA updated and modernized the standards by issuing Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, and SAS 146, Quality Management for an Engagement Conducted in Accordance with Generally Accepted Auditing Standards (SAS 146). These standards, effective December 15, 2025, modernize quality management standards to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on engagements. We will also cover new rules impacting public company audits and present case studies on recent fraudulent accounting stories and best practices for detecting and preventing such frauds. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.
More Dates
2025 Not-for-Profit GAAP Update (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course will review the Accounting Standard Updates issued by the FASB that impact nonprofit entities. We will also look at the work of the Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
The New Quality Management Standards - What Everyone Needs to Know (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
The AICPA issued the new Quality Management Standards as a part of its overall quality improvement initiative. This course will highlight the foundational principles within the new approach that everyone in the CPA firm should know.
More Dates
CFO Solutions to IRS Problems (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
The Yellow Book: From Beginning to End
-
Online
8.0 Credits
Member Price: $225
See more dates
A comprehensive review of the newest version of the U.S. Government Accountability Office’s Government Auditing Standards, otherwise known as “the Yellow Book.” The standard will affect all auditors who perform audits of government and nonprofit organizations who receive federal funds, or where application of GAO standards is required by law, regulation or contract. It does not address the standards applicable to performance audits.
More Dates
The 10 Must Know Excel Features (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
SAS 145 - Risk Assessment (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. This audit standard amends AU-C 315, making many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315.
More Dates
Ethics for CPAs: The Practical and the Possible (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Award winning discussion leader, former AICPA Council Member, and former state accountancy board member Mark Hugh will review the AICPA Code of Professional Conduct and its interpretations; discuss new developments in regulation at the national and state level; and discuss examples of best practices, case studies, and disciplinary actions.
More Dates
The Ethics of Care in the Workplace (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Ethics involve relationship to self, others, and the world in which we live. In the busyness of our world we often act out of habit without realizing that what we do truly matters. We matter! This session explores ethical values and principles as they apply to creating an Ethic of Care in the workplace with specific emphasis on compassion, accountability and respect. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Synchronize Your Files to the Cloud with SharePoint -Updated (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
One of the most cost effective methods for storing your files safely and economically in the cloud is with Microsoft 365 OneDrive and SharePoint apps. If you use either or both of these cloud storage apps, this course is a "must take." There are often times when you want or need cloud based files to be stored on your local laptop or desktop PC. With the OneDrive Sync app, you can have the best of both worlds. You can have copies of a file stored locally and in the cloud simultaneously. The Synch app will update both copies of the file in real time for any changes that are made in the local or cloud copy of the file. A classic example is if you have a QuickBooks Desktop data file that you need to store locally to work with the files in QuickBooks. However, you also want the file stored in the cloud for anytime, anywhere access and enhanced security. The Sync app facilitates this scenario effortlessly. Nationally recognized accounting technology advisor and thought leader, John Higgins, will take you through the step-by-step process of setting up and using the Sync app. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Cryptocurrency Transactions: Navigating Federal Tax Rules (1 hour)
-
Online
1.0 Credits
Member Price: $29
See more dates
As cryptocurrencies like Bitcoin, Ethereum, and others become more popular, tax authorities around the world are working to create regulations for their use and transactions. This session will address cryptocurrency tax issues and their complexities and challenges that individuals and businesses face when dealing with the taxation of digital currencies. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com
More Dates
AI Lessons Learned for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
