CPE Catalog & Events

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.

Gift taxation is a critical component of estate planning, and Form 709 serves as the key reporting tool. This course provides a comprehensive line-by-line guide to preparing Form 709, ensuring accuracy and compliance. Participants will learn how to determine taxable gifts, apply exclusions, and utilize available deductions. Special attention will be given to valuation techniques, gift-splitting, and generation-skipping transfer tax (GSTT) considerations. Additionally, this course will examine any new legislative changes from the current administration and how they may impact gift tax planning and reporting. *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

This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This 8-hour program covers recent promulgations of the FASB and AICPA with broad applicability. In addition, the course includes the 2-hour Tax Basis Financial Statements, 2-hour SSARS Highlight Reel and 2-hour SQMS programs available as stand-alone courses.

This two-day, interactive workshop reviews the hottest accounting topics and recent changes in areas such as private company accounting, revenue recognition, going concern and other specialized subjects. Refresh your research skills and practice using the Codification. Case studies and real-life examples will help attendees readily apply the information covered.

The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that employers need to know about company retirement plans. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones.  This course will provide a concise look at these hot topics.   **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.

ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course provides practical suggestions for improving leadership skills, including self-awareness, communication, delegation, empowerment, coaching, and counseling. 

You often can perform an audit in accordance with all of the standards, and still have a substandard audit IF you did not get out among the clients employees (let them know you are there and where you located), talk to as many people as you can regardless as to whether you may think that they may have any helpful information; constantly observe your surrounding where ever you are at (you never now what you might see) and lastly, listen to not only what people are saying to you but are also saying around you. This presentation is designed to illustrate the importance of making yourself available to your client’s employees, let them know that you are there and where you can be found. Talk with them because if there is a problem, somebody knows and they will often tell you all about it IF you just ask them.  Look at your surrounding everywhere you go.  What are you looking for?  I don’t know but I’ll know it when I see it. Lastly, listen to what they have to say.  Every word is important because they may say something that you had not asked about.  Remember, you never want to discover something and go to an individual who you determined knew about it and ask, why didn’t you tell me about this and their response was, you never asked me!

GAAP is changing at an increasing rate. Every successful organization has a sound strategy. Financial leaders are faced with the dual challenge of navigating evolving accounting standards while strategically guiding their organizations toward sustainable growth and profitability. What are the newer accounting changes that will impact professional accounting? This seminar will equip finance professionals with the critical skills and practical insights needed to effectively manage the complexities of ever-changing accounting standards and upgrade your essential strategic planning skills. Strategic skills are mandatory today. Strategies that do not keep pace with the market are doomed to fail. If we do not keep up, our successor will.

Starting with tax year 2021, Form 7203, S Corporation Shareholder Stock and Debt Basis Limitation, may be required to accompany shareholders’ Individual Income Tax Returns (Form 1040). This form is essential for reporting a shareholder's outside basis and debt basis to properly apply loss limitations under I.R.C. §461 and at-risk limitations. This course will provide a detailed overview of Form 7203, including its mechanics and strategies for completing it accurately. Additionally, strategies for reconstructing shareholder basis when it has not been maintained in the past will be discussed, helping practitioners handle these scenarios effectively. *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

In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement.  This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- and post-judgement interest, contract claims, among other damages. **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.  

Targets can be a powerful catalyst for remarkable achievements - from landing humans on the moon to eradicating smallpox and repairing the ozone layer. However, poorly designed targets can have severe consequences, potentially leading to executive imprisonment, corporate collapse, or even loss of life. This course uses real-world examples and case studies to guide you through a practical, step-by-step process for crafting robust, effective, and credible targets for your organization. You'll learn how to harness the positive potential of targets whilst avoiding the pitfalls that can derail even the most well-intentioned performance initiatives.

Workpapers are the primary support for findings, conclusions and opinions on any audit or other attest engagement.  This course will provide the essential tips and techniques for ensuring workpaper documentation is of a high quality, yet efficient, nature.

Accounting professionals face a critical technological shift with the discontinuation of QuickBooks Pro and Premier sales in 2024. This course explores the transition to modern platforms, including QuickBooks Online, Xero, Zoho Books, FreshBooks, and more. Participants will gain insights into key features, integration capabilities, add-on solutions, and payroll and reporting functionalities. Learn strategies for seamless implementation and discover how to guide clients effectively through this change. Comparative tables and expert insights will equip you to make informed recommendations for your practice or small business. Attend this session and learn more about platforms available for small businesses.

This course explores the latest tax provisions impacting non-profit entities, including charities, hospitals, and universities, with a focus on common issues CPAs may face when completing their clients Form 990. *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

Part 2 of a 2-part series is an overview of GAAP requirements for nonprofit organizations and will help you become proficient in nonprofit financial reporting. This session focuses on revenue recognition. Be sure to register for part 1 in the series: Nonprofit A&A Series Part 1: Financial Statement Presentation & Disclosure

Our clients' personal financial planning issues are quickly developing and keep us challenged in a new operating environment! Many new approaches are needed in working through, understanding, diagnosing and then adopting innovative and proven strategies. Additional ways of experiencing these client situations are entering the picture. With information overload, part of the CPA's challenge is to help clients stay focused on goals while managing expectations in a rapidly changing environment. This course will update you on the newest personal financial planning changes related to insurance, investments, education, retirement, estate, cash flow management, divorce, closely held businesses and other relevant topics. We'll discuss critical issues, including planning for education, divorce, charitable, exceptional circumstances, business owners and highly compensated executives. Be sure to register for all of our PFP updates: PFP Update: Income Tax, Retirement, and Estate Planning PFP Update: Issues, Exposures, and Developing Client Strategy PFP Update: Investment Planning in This New Era

This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.

This program discusses, in a practical way, how an S corporation shareholder calculates their stock and loan basis on Form 7203. Form 7203 is the IRS Form on which a shareholder is sometimes required to calculate their stock and loan basis. This topic is particularly important when an S corporation has a loss and the shareholders wish to know whether they are entitled to fully utilize the loss that has been allocated to them against their other income.