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.
The One Big Beautiful Bill: 2025 tax legislation
-
Online
4.00 Credits
Member Price: $149
The President signed on July 4, 2025, one of most consequential tax legislation in recent years. The well-informed tax practitioner will want to stay abreast of these developments! This course will start with a short background of this legislation as it made its way through Congress and to the President's desk. We will then review the final provisions that was approved by the Senate and passed by the House. 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: 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 CPA Crossings.
You Don't Know What You Don't Know About Microsoft Excel
-
Online
8.00 Credits
Member Price: $239
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. 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.
How to Start a CFO Service
-
Online
1.00 Credits
Member Price: $55
This Masterclass is a one-hour training to show accountants how they can grow their practice this year through CFO and business advisory services. 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.
When You Hear Hoofbeats, It May Be a Zebra
-
Online
1.00 Credits
Member Price: $39
Young doctors sometimes arrive at an exotic medical diagnosis (You've got Kuru!), when a more common place explanation is likely (You've got a cold). These diagnoses are known as Zebras and doctors are taught, "When you hear hoofbeats, think of horses not zebras". Sometimes, the patient really has a rare disease and suffers from misdiagnosis and subsequent improper treatment. Similarly, managers, auditors, and investigators often see indicators of fraud, but dismiss them because they've been taught or assume based upon experience that it is just a mistake that looks like fraud. This session uses case studies to explore some of the more common symptoms of fraud that are often misdiagnosed. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Intermediate
Balancing Employee and Employer Rights
-
Online
1.00 Credits
Member Price: $39
Leaders have the right to exercise customary management functions. Employees have the right to be kept free from discrimination. Neither employer rights nor employee rights are absolute. The courts are equally protective of the rights of employees and employers. A courtroom is the wrong place for anyone to find this out. This course provides practical knowledge on how to effectively balancing these two sets of rights, such that employees and leaders stay out of court. Employers avoid lawsuits, rather than win lawsuits. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Advanced
HR Investigations - Episode 1 - Introduction-Assessing-Planning
-
Online
1.00 Credits
Member Price: $39
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session is an introduction to these differences and provides best practices for assessing allegations of employee misconduct and planning the investigation. Attendees will end the session with takeaways to immediately implement in future HR investigations. Episodes 2 and 3 complete the series. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Intermediate
Leveraging Analytical Procedures to the Fullest on Audits - Case Studies in Strengthening Audit Evidence
-
Online
2.00 Credits
Member Price: $79
Peer review deficiencies commonly relate to the design, documentation, and evaluation of the results of analytical procedures. This course will provide examples of how to strengthen evidence resulting from preliminary, substantive, and final analytics. It will reinforce the elements of strong analytical procedures that may enhance the quality of audits. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Basic
Public Procurement Basics: Protecting the People's Money
-
Online
2.00 Credits
Member Price: $79
Procurement is a critical component of successful government operations. While there are challenges in public procurement, there are a number of guidelines and requirements that will help lead you to success. This course will offer guidance on how governments can meet complicated procurement needs and develop best practices that protect public and Federal funds. Delivery Method: Individual webcastCPE Credit: FinanceProgram Level: Basic
Leases Accounting under Topic 842 - Answers to FAQ After Implementation
-
Online
2.00 Credits
Member Price: $79
Lease accounting under FASB ASC 842 is now fully effective for all entities. Transitioning to new GAAP always leads to implementation issues and concerns. This course will answer the most common questions asked related to the latest lease accounting and financial reporting requirements after adoption and transition. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Basic
Adobe Acrobat Tips for Working with PDF Files
-
Online
2.00 Credits
Member Price: $89
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.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.
K2's Formatting Excel Spreadsheets The Right Way
-
Online
2.00 Credits
Member Price: $79
Some estimates indicate that business professionals spend almost half their time in Excel applying formats. If you want better formatting results in less time, participate in this session to learn the best practices for formatting your Excel spreadsheets. In this session, you will learn best practices for applying formats in your workbooks. More specifically, you will learn about features such as Custom Format Codes, Templates, Styles, the Accounting Format, Precision as Displayed, date formats, and many others, all of which can save you substantial time when working in Excel. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Mergers and Acquisitions: Complete Guide to Relevant Issues
-
Online
2.00 Credits
Member Price: $79
Arthur Werner will provide financial professionals with the information their teams will need to successfully plan and execute mergers and acquisitions. For major topics covered, see below. This course may be customized or tailored based on the needs of your organization. *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: Update
Surgent's Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs
-
Online
2.00 Credits
Member Price: $99
When a purchaser buys an existing partner's partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser's partnership interest (outside basis). If the partnership's assets have appreciated sufficiently, the difference between the new partner's inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect.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.
Surgent's Strategies for Maximizing Social Security Benefits
-
Online
2.00 Credits
Member Price: $99
As the population of the United States ages, tax practitioners will be asked to advise their individual clients with respect to when they should begin to take Social Security benefits. This program will provide you with the background to knowledgeably discuss the benefit options available to Social Security beneficiaries and the alternative payment options available to married couples, dependents, a surviving spouse, and a divorced individual.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.
The Seven High Quality Questions that Lead to Success & Solutions
-
Online
2.50 Credits
Member Price: $79
“How will I EVER get this all done?" It’s a question I often hear from clients and on a particularly stressful day, I can hear myself saying these words! Instead of helping us focus, it's a question that leads to stress, anxiety and overwhelm! Regardless of where we are in business and in life, we will run into challenges and problems as we navigate business growth, leadership, work life balance and our quest for success and happiness. This workshop will explore the 7 HIGH QUALITY questions that lead to relief, enthusiasm and success. It will be an interactive exploration that will leave you with a game plan to use right away, as well as an opportunity to practice the mindset that the most successful and happiest people use daily. This program is for both the entrepreneur who wants to be more effective in their day as well as team leaders who want to stand out in their organization. For the business owner or staff member you can expect a new way to work with your day so that it's profitable, productive and happier. For leaders, you will learn new up- leveled skills to increase your efficiency, communication and productivity. You and your team will shine. Your staff will feel appreciated and connected to their value as well as the company's goals. Albert Einstein said 'we can't solve our problems with the same thinking we used when we created them'. The quality of your question will impact the quality of your solution. Learn the 7 questions that take you from confused and frustrated to creative and focused. Delivery Method: Individual webcastCPE Credit: Personal developmentProgram Level: Basic
Advanced Cybersecurity - Beyond the Basics
-
Online
4.00 Credits
Member Price: $149
A deeper dive into Cybersecurity topics specific to CPAs and Fintech Organizations, expanding on the fundamentals from Cybersecurity 101 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 technology, Specialized knowledgeProgram 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 CPA Crossings.
OBBA 2025 Unpacked: Impact for Taxpayers and Business Owners
-
Online
4.00 Credits
Member Price: $129
Whether you asked for it (or not) and its here! The One Big Beautiful Bill Act was signed on July 4. This program will dig into the meat of the Act that will matter to your clients, including No Tax on Tips, No Tax on Overtime, increased Section 199A Deduction, 100% Section 168(k) Bonus and much, much more! *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
The Original Secure Act and Secure Act 2.0 Retirement Planning Strategies
-
Online
4.00 Credits
Member Price: $129
Congress was EXTREMELY busy. There are over 50 tax-related provisions within SECURE 2.0 which an advisor needs to be able to master. This course will provide the participants with everything that they need to know about SECURE 2.0 so that they will be able to better serve their clients’ retirement planning needs. **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 it to kori.herrera@acpen.com. Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Update
2025 Annual Update for Governments and Not-for-Profits
-
Online
7.00 Credits
Member Price: $209
This comprehensive course provides the essential updates for professionals working with governments and not-for-profit organizations. We'll begin with an in-depth review of recent GASB standards, including compensated absences, certain asset disclosures, risk and uncertainty disclosures, and financial reporting model improvements. For each standard, we'll cover its background, potential impact, and practical strategies for implementation to ensure you're fully prepared. Next, we'll shift focus to the FASB and its implications for nonprofit organizations. While there haven't been recent nonprofit-specific standards, several Accounting Standard Updates (ASUs) significantly impact NFPs. We'll explore these ASUs, evaluate changes to programmatic investments, and discuss their interplay with the CECL standard. Additionally, we'll highlight the movement in IFR4NPO, a global initiative to develop universal financial reporting standards for nonprofits, offering insights into its potential worldwide impact. In the second half, we'll turn to governmental auditing. Key topics include the 2024 Yellow Book updates, the transition from quality control to quality management, and the implementation timelines. For Single Audits, we'll cover the 2024 Uniform Guidance changes, the 2025 Compliance Supplement, GAO reports on improper payments and fraud, the Financial Data Transparency Act (FDTA), and recent Department of Education guidance on related parties. Delivery Method: Individual webcastCPE Credit: Accounting (governmental), Auditing (governmental)Program Level: Update