CPE Catalog & Events
Build a Data Model for Analysis in Power BI
-
Online
4.00 Credits
Member Price: $149
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.Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Comprehensive FASB & AICPA Update for Tax Professionals 25-26
Online
8.00 Credits
Member Price: $329
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.Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Intermediate
Financial Accounting Standards: A Comprehensive Review 25-26
Online
16.00 Credits
Member Price: $589
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.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Overview
See more dates
The SECURE Act 2.0 - Planning Opportunities for Employers
Online
1.00 Credits
Member Price: $39
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. Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Basic
ChatGPT Bootcamp for CPAs with John Higgins
Online
4.00 Credits
Member Price: $149
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.Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Five Ways to Improve Your Leadership Skills
Online
1.00 Credits
Member Price: $39
This course provides practical suggestions for improving leadership skills, including self-awareness, communication, delegation, empowerment, coaching, and counseling. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Basic
See more dates
Walkin', Talkin', Lookin' & Listenin' - Or Things Most of Us Don't Do Well
Online
2.00 Credits
Member Price: $79
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! Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Intermediate
See more dates
Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
Online
2.00 Credits
Member Price: $79
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. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate
See more dates
Form 7203 - How to Calculate Shareholder Basis
Online
2.00 Credits
Member Price: $79
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 Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
See more dates
Taxation of Judgements and Settlements
Online
2.40 Credits
Member Price: $79
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. Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Basic
See more dates
Gamed: Why Performance Targets and Incentives Fail and How to Fix Them
Online
4.00 Credits
Member Price: $129
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. Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: Basic
See more dates
Preparing and Reviewing Workpapers - Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
Online
8.00 Credits
Member Price: $225
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. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Basic
See more dates
K2's After QuickBooks, What's Next?
Online
1.00 Credits
Member Price: $39
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. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Overview
See more dates
AI-Driven Audit Dynamics: Navigating the Standards in a New Era
Online
1.50 Credits
Member Price: $99
Hear how AI is being used in the audit, and learn about the possibilities and pitfalls of emerging technologies. In this session, we'll distinguish the three categories of artificial intelligence (AI) that affect financial statement audits and related assurance services and discuss how they are used. We'll also cover methods for managing AI development and maintenance in audit contexts, exploring how firms can adapt audit procedures for AI-driven client controls. This is a rebroadcast of a session from AICPA & CIMA ENGAGE 2025.This course is being offered by a 3rd party vendor and will not be accessible from your My CPE page. Access information will be emailed directly to you by AICPA.
Nonprofit Taxation Rules and Form 990
Online
2.00 Credits
Member Price: $79
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 Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
See more dates
Nonprofit A&A Series Part 2: Revenue Recognition 25-26
Online
2.00 Credits
Member Price: $99
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 & DisclosureDelivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate
PFP Update: Issues, Exposures and Developing Client Strategy 25-26
Online
2.00 Credits
Member Price: $99
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 EraDelivery Method: Individual webcastCPE Credit: Specialized knowledgeProgram Level: Intermediate
Surgent's Excel Shortcuts for Accountants
Online
2.00 Credits
Member Price: $99
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.Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
See more dates
Surgent's Guide to Calculating S Corporation Shareholder Stock and Loan Basis
Online
2.00 Credits
Member Price: $99
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.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
See more dates
Surgent's Successfully Completing an Income Tax Return for a Trust or Estate -- Form 1041
Online
2.00 Credits
Member Price: $99
Some of your clients have estate plans that provide for testamentary trusts. Other clients make gifts to irrevocable trusts during their lifetime. And some will die with probate estates. Therefore, you should have a basic understanding of how the income tax applies uniquely to trusts and estates. For example, "distributable net income" (DNI) is a trust-only concept that is essential to understand. Plus, the deductions for fiduciary fees, charitable deductions and certain miscellaneous deductions (such as investment advisory fees, and attorney/accountant fees) are treated differently than for individual taxpayers. However, with a decent understanding of the basic income tax and net investment income tax (NIIT) rules, you can add significant value to your clients.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: AdvancedThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.