CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Avoiding Deficiencies in Peer Reviews: Focus on Engagement Quality
-
Online
4.00 Credits
With the AICPA's heightened focus on enhancing audit quality, increased oversight of the peer review process and the auditor's overall responsibility to provide high quality services, the focus on compliance with professional standards has never been greater. Add to that the requirement to implement the revised risk assessment standards (SAS 145) and it's easy to see why it's more important than ever to ensure that auditors have a good understanding of the requirements and comply with documentation standards. Recent peer reviews have indicated that auditors are often failing to perform and/or document certain critical components of an audit such as the auditor's assessment of risk and linking the results of the assessment to substantive procedures performed. In addition, auditors are not adequately documenting their consideration of fraud, expectations in analytical procedures and the appropriate level of work needed to understand an entity's internal control. The AICPA issued its Quality Management Standards in 2022. Firms are required to implement the standards by December 15, 2025. And the firm's evaluation of the System of Quality Management is required within one year after that. This is not just a matter of tweaking the firm's existing QM document, the standard requires a risk assessment process to identify risk. The objective of the course is to provide the insights necessary to help auditors and accountants improve not just the quality of their work but also the perception of the accounting profession as a whole. We will focus on the most significant items resulting in deficiencies identified in the peer review process. We will also discuss the applicable audit standards, documentation requirements, and best practices. We will address the new QM standards.
Complete Guide to Analyze Data with Excel PivotTables
-
Online
4.00 Credits
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's Next Generation Excel Reporting
-
Online
8.00 Credits
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.
You Don't Know What You Don't Know About Microsoft Excel
-
Online
8.00 Credits
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.
Written Information Security Plans
-
Online
1.00 Credits
Thsi course provides a comprehensive overview of Written Information Security Plans (WISP), focusing on their purpose, requirements, and implentation. All PTIN holders must certify they have a WISP prior to renewal, along with certifying the training of employees, staff and contractors as necessary. Participants will explore the history and legal foundation of WISP under the Gramm-Leach-Bliley Act, and how compliances is enforsed through IRS Circular 230, AICPA Statments of Standards, The American Bar Associations and the Federal Trade Commission (FTC). This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics: IRS Behavioral Insights for Accountants
-
Online
2.00 Credits
This course provides a concise overview of how the Internal Revenue Service (IRS) thinks. The session reviews how the agency uses behavioral insights -- the study of how people reflect and behave -- to drive compliance, positively impact taxpayer engagement, and reduce taxpayer burden. While the IRS is governed by federal tax law, it's also shaped by social norms. As part of their mission to collect taxes and administer the Internal Revenue Code, the agency utilizes human psychology to achieve their goals. These activities include public identity (using the IRS logo, seal, and symbol), voluntary compliance (using public shaming and the "Wesley Snipes" effect), trust building (using a Taxpayer Bill of Rights), and error reductions (using alerts and reminders to nudge behaviors). The session reveals how to "get into the head" of the agency and better understand the key psychological factors (individual, environmental, social) that drive leading IRS operations and decisions. The course also spotlights the leading issues and pain-points that are currently "top of mind" for the agency and how practitioners can be more mindful in their interactions with the IRS to improve outcomes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Interviewing, Onboarding and Training 101
-
Online
1.00 Credits
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.
Securing Your Data with a Password Management App - Updated
-
Online
2.00 Credits
Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's A Complete Guide to Reporting Form 1099-DA
-
Online
2.00 Credits
For each digital asset sale that a broker has affected for a customer in 2025, the broker must complete Form 1099-DA. A broker includes any person who, in the ordinary course of a trade or business, stands ready to affect sales of digital assets to be made by others. This program covers the required rules for reporting digital asset transactions on Form 1099-DA.This course qualifies for IRS credit.
Surgent's Contract Law for Accounting and Finance Professionals
-
Online
2.00 Credits
Accounting and finance professionals routinely encounter a broad range of legal issues while advising clients or performing routine job functions. Contract law tops the list as the most frequent issue that intersects with the accounting and finance professions. As trusted advisors, it is wise to understand the fundamentals of contract law for both personal and professional benefit. This course provides a broad overview of contract law basics geared specifically toward the accounting and finance professions. From contract formation to enforceability, this course offers an interesting look at how contract law intersects with accounting and finance. Participants should walk away with a better understanding of common issues that arise when reviewing contracts.
Surgent's Controllership Skills Update - Budgeting, Forecasting, and Big Data
-
Online
2.00 Credits
Budgets are the vehicle for allocating resources, measuring activities, and identifying needed changes and improvements. An organization's strategy is the primary driver of costs. To be effective, the budget must be linked to strategy and long-term plans. Numerous organizations have achieved a series of short-term targets (budgets) but failed longer term, demonstrating the lack of this necessary linkage. Forecasting, a critical part of any successful budgeting process, can be flawed by technical errors, organizational structure, or emotional forces. The establishment of a system to collect, process, and analyze big data can provide significant insights into the budgeting and forecasting process. An efficient system of incorporating big data and analytics into normal activities will improve management's decision-making. This brief program offers specific actions to improve your forecasting and budgeting activities. In addition, more advanced techniques are identified for the participant's further review, which can be applied throughout an organization. Good budgets effectively allocate resources, provide information for decision-making and serve as an early warning system for unforeseen events. A poor budgeting process fosters a false sense of security, provides inappropriate or inaccurate data, and reinforces the status quo. Budgets are about the organization's story, not just the raw numbers!
Surgent's Excel: Mastering PivotTables
-
Online
2.00 Credits
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.
Surgent's Implementing Subscription Pricing to Your Practice
-
Online
2.00 Credits
This course is designed to provide accountants with a comprehensive understanding of the subscription pricing model. As the business world increasingly shifts toward subscription-based models, it's crucial for accountants to understand the financial implications and strategies associated with this pricing approach. This course will cover the basics of subscription pricing, how to set prices, and how to analyze the financial impacts of these decisions, as well as the specific impacts to your business. By the end of this course, participants will be equipped with the knowledge and skills to effectively manage the implementation of subscription pricing to their practice.
Public Speaking Secrets That Wow Audiences
-
Online
4.00 Credits
In this course, you'll learn why being able to do public speaking well is a major advantage in becoming successful in your career. You'll learn how to write a good talk, how to present it well, and how to use your new found ability to get more clients and/or a promotion. In addition, you'll learn how to overcome your nervousness, and how to overcome stress in less than a minute.
Interpreting the FASB Revenue Recognition Standard: What All CPAs Need to Know
-
Online
4.00 Credits
Well-defined revenue recognition guidelines, insights and practical management tips designed to address the complexities of FASB ASC 606.
K2's Data Analytics for Accountants and Auditors
-
Online
4.00 Credits
In the world of “Big Data,” virtually all business professionals have become data analysts, at least to some extent. However, that is particularly true in the field of auditing, where internal and external auditors are increasingly turning to data analytics to identify situations requiring follow-up and investigation. Those who understand how to take advantage of various tools to assist in these efforts benefit by conducting more thorough analyses and achieving superior results in less time. In this session, you will learn about various tools and techniques you can use for more thorough data analyzes. The discussion includes Excel as a data analysis tool, multiple Excel add-ins, and Microsoft’s Power BI application. If you're seeking to improve your skills in the field of data analytics, this session is the one for you!
What's Going on at the GASB
-
Online
4.00 Credits
The GASB has been working on some big projects lately. This course starts with a look at the GASB standards effective this year, including GASB 94, Public Private Partnerships and GASB 96, Subscription Based IT Arrangements. We will include practical applications in the form of case studies to apply the topics. We will then switch gears to the GASB standards coming down the pike, including the major projects of the GASB.
K2's Technology For CPAs - Don't Get Left Behind
-
Online
8.00 Credits
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.
Leases: Mastering the New FASB Requirements
-
Online
8.00 Credits
FASB ASC 842, *Leases*, standards decoded By learning essential information about lease accounting requirements, you'll understand the core principles of the standards and how to apply them. You'll explore topics, such as: Identification Recognition Measurement Presentation and disclosure requirements Deliberate application of lessee accounting model You'll also learn about classifying leases, the amortization of the right-of-use asset, and the interest on a lease liability. Additional topics include: Short-term leases Purchase options Variable lease payments Sale and leaseback transactions Leveraged leases
Business Tax Update for Industry
-
Online
2.00 Credits
This course focuses on the key federal tax issues affecting businesses from the internal accountant's point of view, with a focus on recent tax legislation and developments. Planning alternatives and the potential risks associated with those strategies will also be discussed. **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.