CPE Catalog & Events

Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.

This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities.  We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.

This program will examine the key provisions of the Inflation Reduction Act of 2022 that was enacted to not only curb inflation, but reduce the deficit, promote clean energy solutions, and much more.  Learn how this new legislation can provide tax savings for both your individual and business clients.  **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.

Many don't realize it, but one's health is one's greatest wealth. Health-related decisions can have a major impact on personal happiness and financial success. Acquire a better understanding of medical insurance options, including government exchanges, workplace plans, and health savings accounts. Managing the risk of a financially catastrophic illness requires thoughtful analysis of personal, tax, and financial factors.

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn't it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

Ready to elevate your practice? This series is designed for professionals who have yet to explore outsourcing in their audit, tax, or CAS practice. Part 3 will dive into the aspects of your internal and external teams, taking KPIs and workflows into consideration. Companion courses: Unlocking the Potentials of Outsourcing Part 1 - The Basics Unlocking the Potentials of Outsourcing Part 2 - Starting The Process Unlocking the Potentials of Outsourcing Part 4 - The Intersection of Outsourcing and AI

This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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.

Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.

Business intelligence efforts continue to grow, and Microsoft’s Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.

Ready to elevate your practice? This series is designed for professionals who have yet to explore outsourcing in their audit, tax, or CAS practice. Part 4 is for those who already have an outsourcing team and want to understand how Artificial Intelligence can be incorporated with their outsourced team to maximize the benefits of an outsourcing strategy. Companion courses: Unlocking the Potentials of Outsourcing Part 1 - The Basics Unlocking the Potentials of Outsourcing Part 2 - Starting The Process Unlocking the Potentials of Outsourcing Part 3 - The Next Level

This program provides in-depth coverage of SAS 145, a major standard that helps auditors enhance risk assessment procedures through improved techniques for identifying and assessing risks of material misstatement. This session is essential for CPAs that perform audits. The discussion will also be insightful for auditees and other professionals who want to maintain awareness of current auditing guidance.

This course addresses the most recent legislative developments impacting individual taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns.    **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.

Developments in U.S. federal tax In this Tax Rewind quarterly, join Art Auerbach, CPA, CGMA, to discuss the latest U.S. federal tax and its impacts on individuals and businesses. Art will also cover: Tax planning strategies Legislative changes The latest IRS tax practices and procedures

The IRS defines the "gig economy" as people earning income providing on-demand work, services, or goods on either a part-time or full-time basis. The economic times we live in are changing and tax practitioners must learn how the rules apply in this new gig economy. The tax rules that apply to gig workers challenge traditional ideas of who is an employee and who is an independent contractor, and tax practitioners must have the knowledge to make this determination. This program addresses federal and state tax issues tax practitioners must address with clients and their own workers.

In 2006, Congress passed the Tax Relief and Health Care Act. Prior to the Act's passage, rewards to individuals who provided information to the IRS regarding tax fraud were capped at $10 million. The Tax Relief and Health Care Act authorized the IRS to create a Whistleblower Office dedicated to investigating, processing and recovering claims concerning the underpayment of taxes. Under the IRS' new program, whistleblowers may recover 15 to 30 percent of the amount collected provided the taxes and amounts in dispute exceed $2 million. If the whistleblower's claim does not meet these criteria, the IRS may still consider granting an award under its pre-2006 Tax Relief Act discretionary authority. Given the rapid growth of this program, practitioners should have a basic understanding of the procedure and content for IRS Whistleblower claims, both from the perspective of a claimant's potential to recover and a taxpayer's exposure to liability.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

A multitude of tax changes have are currently taking place, challenging tax practitioner to stay well-informed. This 4 hour program will cover tax developments specific to business, including new court decisions, recent IRS publications, and the latest tax legislation that will impact individuals.  The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner.  **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.  

CPAs often face difficult, unusual, and challenging situations when dealing with clients, employers, and regulatory authorities.  The objective of this course is to remind you that a framework exists that you can refer to for guidance to determine the expectations for your behavior as a Florida CPA.  That framework is based on the Florida Statutes, the Rules of the Florida Board of Accountancy, and the AICPA Code of Professional Conduct.  Through interactive dialogue and discussion we will focus on the application of specific rules and requirements within that framework and recent trends in business and professional ethics.  This course is especially designed for CPAs working in Industry and fulfills the biennial ethics requirements for Florida CPAs. If you are attending the Industry Insights Conference 2025, please register for Ethics as part of your IIC registration. IIC Registration Page

If you find yourself working with PDF files consistently throughout the day, this course will teach you how to review, annotate, format and organize PDF files more effectively and in less time. You will also learn how to use Adobe Acrobat for e-signatures to reduce document processing time significantly and enhance confidentiality. Adobe Acrobat has many features that you can take advantage of and this course will explain and demonstrate how to use them. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.