CPE Catalog & Events
K2's Next Generation Excel Reporting
-
Online
8.00 Credits
Member Price: $225
New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to quickly and easily format your spreadsheets to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate
Qualified Business Income (QBI) Deduction (199A) - The Ins & Outs
-
Online
8.00 Credits
Member Price: $300
The Tax Cuts and Jobs Act (TCJA) was a major overhaul of our tax system that lowered the income tax rates for individual and corporate taxpayers and introduced the new 20% qualified business income (QBI) deduction for sole proprietors and pass-through entities. The cornerstone of this course is the comprehensive discussion of the 20% QBI deduction final regulations under IRC §199A. **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
Avoiding the Most Misapplied Audit Concepts
-
Online
8.00 Credits
Member Price: $239
Recent new auditing standards are designed to improve overall audit quality. The course will address the most common misapplied audit concepts in planning and performing effective and efficient financial statement audits. 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: AuditingProgram 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.
Forensic Accounting: Fraud Investigations
-
Online
8.00 Credits
Member Price: $349
In high demand - forensic accounting knowledge and skills (bold) Forensic accounting has been a rapidly growing part of the accounting profession for some time. The rapid expansion in technology and growth in various sectors of business and industry, and the increase in complexity of white-collar crimes, all contribute to this growth. A diverse range of clients, as well as cases involving all types of fraud, make this an attractive profession, and one that is always in high demand. Enhance your knowledge and skills with our Forensic Accounting: Fraud Investigations webcast. Whether you're a forensic accountant, or an aspiring one, this webcast will provide you with the foundational knowledge to successfully identify, investigate, and communicate your findings. You will also receive a copy of the AICPA's Forensic & Litigation Service's Forensic Accounting - Fraud Investigations practice aid for future reference.Delivery Method: Individual webcastCPE Credit: AccountingProgram 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 AICPA.
AI & Accounting in Manufacturing
-
Online
2.00 Credits
Member Price: $89
This course provides a concise overview of how artificial intelligence (AI) is reshaping financial oversight in the global manufacturing sector. With factories evolving into digital ecosystems powered by intelligent automation, predictive analytics, and edge computing, the role of accounting and finance professionals is rapidly transforming. Participants will explore how AI technologies intersect with core financial functions-cost accounting, audit, tax compliance, and financial planning-while enabling real-time reporting, fraud detection, and predictive decision-making. Drawing on current global trends and real-world case studies, the course offers actionable insights into integrating AI into financial operations, elevating the strategic role of accounting in manufacturing enterprises. 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: Information technologyProgram Level: OverviewThis 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.
Leverage PowerBI.com to Create Data Analysis for Others
-
Online
2.00 Credits
Member Price: $89
Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. 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.
Interviewing, Onboarding and Training 101
-
Online
1.00 Credits
Member Price: $39
Master the essential skills to build a high-performing team with our online course on interviewing, onboarding, and training. This comprehensive program dives into proven best practices for identifying top talent, creating a seamless onboarding experience, and fostering a culture of continuous development. Whether you’re a seasoned manager or new to hiring, this course equips you with the tools to make confident decisions, engage new hires effectively, and set your team up for success from day one. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Basic
Analytical Procedures for Nonprofits
-
Online
2.00 Credits
Member Price: $79
Strong analytical procedures are critical for evaluating the fair presentation of financial statements. In addition, Financial statements are only as good as the information and trends that they produce for operational, strategic, or compliance purposes. This course will provide insights into how to determine the strength and efficiency of nonprofits in achieving objectives and knowledge to improve the analysis of the fair presentation of a nonprofit's financial statements. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Intermediate
K2's Office Scripts - The New Macros
-
Online
2.00 Credits
Member Price: $79
Office Scripts is a new feature that allows you to automate tasks in Excel and other Office applications. Unlike VBA, a legacy language that runs only on Windows, Office Scripts can run on any platform and device that supports Office on the web. Further, Office Scripts has a modern and intuitive interface that lets you easily create, edit, and share your scripts. Office Scripts are stored in the Cloud, and they work with Office Online apps and integrate with Power Automate for process automation. Save time and improve productivity using Office Scripts in Excel and other Office applications. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Cost and Pricing Models: Boost Your Bottom Line
-
Online
2.00 Credits
Member Price: $79
If sales increase, so should profits. Yet, the opposite result often leaves executive’s scratching their heads. When organizations work with inferior cost information, they make mistakes in four specific situations. Bad information causes sellers to overprice easy, high-volume work and under-price difficult, low-volume work. This session discusses how to use activity-based costing to build accurate costing models that consider far more than just the labor and materials necessary to provide goods and services. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate
How to Build a Custom AI Chatbot and GPT in Plain English
-
Online
2.00 Credits
Member Price: $89
Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. 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: Information technologyProgram 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.
OBBA of 2025: Business Overview
-
Online
2.00 Credits
Member Price: $79
THE ONE BIG BEAUTIFUL BILL IS NOW THE ONE BIG BEAUTIFUL ACT!!! (Signed into law on July 4, 2025!) This program provides a summary of the major business provisions of the OBBA of 2025 (H.R. 1), focusing on provisions that have been extended and/or made permanent without changes and those provisions which had major changes or are new for 2025 and beyond. *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
Schedule K-1: What is it & What Do I Do with It?
-
Online
2.00 Credits
Member Price: $79
This seminar provides a comprehensive overview of Schedule K-1, which taxpayers may receive from pass-through entities such as Partnerships, Subchapter S Corporations, or Estates/Trusts. The course will cover the most common characteristics of Schedule K-1, including how to report the information on Form 1040. Attendees will also learn about the Qualified Business Income (QBI) Deduction and its reporting criteria. Additionally, relevant topics such as basis and loss limitations, material participation, and integration with the QBI deduction will be addressed, along with a discussion of proposed changes to Schedules K-2 and K-3. *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
Surgent's Defending Firms: Email Fraud, Cloud Risks, Cyber Insurance, and Remote Work Security
-
Online
2.00 Credits
Member Price: $119
Cyber threats targeting accounting and finance professionals are growing more sophisticated, putting sensitive financial data at risk. This session explores the most pressing cybersecurity challenges accounting and finance professionals face today, including email fraud, phishing attacks, cloud security risks, and securing remote work environments. It also addresses the role of cyber insurance. Through real-world case studies and practical strategies, participants will learn how to recognize and mitigate cyber threats, evaluate cyber insurance policies, and implement security measures that protect their firms and clients. Attendees will leave with actionable steps to strengthen their cybersecurity posture and ensure compliance with evolving regulatory and industry standards.Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: OverviewThis 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.
Surgent's Going Out on Your Own: Entity Types and Accounting Methods
-
Online
2.00 Credits
Member Price: $99
Starting a business is tough! There are lots of decisions to be made and things to think about. You may feel like you have a great idea. You have done your marketing research, developed a prototype, and even looked at locations for your new office. Then it dawns on you.. What type of entity do I need to be? Is there really an advantage to choosing one entity type over the other? In this class, we will dig into the differences between entity types - from taxes to liability. We will also look at the advantages and disadvantages of different methods of accounting. Whether you are a small business owner looking to start something new or a practitioner looking to expand your client advisory services, this course is the one for you!Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: OverviewThis 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.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Member Price: $99
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.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 Surgent McCoy.
Guide to Preparing Form 1041 for Estates and Trusts
-
Online
4.00 Credits
Member Price: $129
This program examines the critical issues, rules, and special opportunities when preparing your clients' Form 1041 US Income Tax Return for Estates and Trusts. Learn what is considered taxable income; filing requirements and deadlines; impact of the 3.8 percent Medicare surtax on net investment income; and the 10 principles of tax accounting for trust income. **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
How AI Is Automating Internal Control
-
Online
4.00 Credits
Member Price: $149
The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. 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: AccountingProgram 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.
K2's Technology For CPAs - Don't Get Left Behind
-
Online
8.00 Credits
Member Price: $225
How good are you with the technology you use daily? What new technology tools are available that could save you time and make you more effective? Technology continues to accelerate rapidly, and the need to keep pace is essential. If you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively, this course is for you! In this fast-paced, update-style course, you will survey today’s IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 10), and what they mean for you, and peripheral devices. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends. Examples include the latest Excel features, working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment. Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. Register now for this “don’t miss” opportunity to get the skills required to enhance the value of your IT investment. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Basic
How to Get a Better Return on Financial Statement Audits - Avoiding the Most Misapplied Risk-Based Audit Concept
-
Online
8.00 Credits
Member Price: $225
By far, the biggest contributing factor that leads to a profitable, yet high quality, financial statement audit is the proper identification, evaluation, and response to assessed risk of material misstatement. When designing your detailed audit plan, how and where you decide to spend your time is largely a matter of professional judgment. The proven tips and techniques for critically rethinking how you plan and design your audit taught in this course will help auditors enhance audit quality and manage profitability in all engagements. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Intermediate