CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Partnership and LLC Core Tax Issues From Formation Through Liquidation
Available Until
Online
8.00 Credits
As staff members gain more experience, they are expected to take on more complex assignments with minimal supervision. This course is designed to be a stepping stone for staff interested in pursuing more advanced partnership and LLC issues than mere preparation. The material provides a deep life-cycle study into critical areas of formation, special allocations of income and deductions, basis calculations and implications of recourse and nonrecourse debt, basis step-up under §754 on transfers of ownership interest, distributions, self-employment tax issues, and termination and liquidations of an LLC. With a blend of legal and tax ramifications regarding LLC-specific issues, this course identifies all the major areas that are potential sources of increased complexity.
Surgent's Performing Effective Accounting Research
Available Until
Online
2.00 Credits
Financial accounting can be complex. An integral part of a senior associate's job responsibilities is to perform effective and efficient research using the FASB's Accounting Standards Codification (ASC). In this session, participants will be introduced to the ASC, including how it is structured, organized, and updated. They will also learn about other information that can be accessed from the ASC. Next, the session will cover best practices for effective research using the ASC, including the ASC's search functionality and other tools that will make accounting research easier to perform. (Please Note: This module is part of Surgent's Audit Skills Training: Level 4.)
Surgent's Performing Effective and Efficient Analytical Procedures
Available Until
Online
2.00 Credits
Analytical review procedures are performed in the preliminary and final stages of the audit. Auditors may also choose to perform analytical procedures as substantive tests. It is important to properly design and perform the procedures to ensure an effective and efficient audit engagement. This module will provide detailed guidance and methods for performing these techniques. (Please Note: This module is part of Surgent's Audit Skills Training: Level 2.)
Surgent's Performing Inventory Observations
Available Until
Online
2.00 Credits
Generally Accepted Auditing Standards (GAAS) states that if inventory is material to the financial statements, the auditor should generally obtain evidence regarding the existence and condition of inventory by attending the entity's physical inventory count. The types of inventory an entity might have varies from industry to industry as does the risk of fraud or error related to inventory counts. This module will discuss the procedures and risks involved in observing an entity's physical inventory. (Please Note: This module is part of Surgent's Audit Skills Training: Level 1.)
Surgent's Performing Preparation, Compilation, Review and Engagements
Available Until
Online
2.00 Credits
CPA firms generally perform a significant number of preparation, compilation and review engagements under the Statements of Standards for Accounting and Review Services (SSARS). Compilations and reviews are performed as attest engagements where preparation engagements do not require independence and as such are considered non-attest engagements. Reviews, like audits are considered assurance services. Reviews provide limited assurance that financial statements are free of material misstatement. In addition, the CPA may perform other non-attest services, such as bookkeeping. CPAs must fully understand the professional responsibilities related to each of these varying levels of services, in order to effectively and efficiently satisfy engagement objectives and ensure compliance with professional standards relative to independence. (Please Note: This module is part of Surgent's Audit Skills Training: Level 1.)
Surgent's Performing a Compilation Engagement Under AR-C Section 80
Available Until
Online
1.00 Credits
Be the go-to person for financial statement compilation engagements. Specifically designed for compilation practitioners and their staff, this course will provide you with a hands-on application for performing compilation engagements under AR-C Section 80. You will learn the ins and outs of relevant sections of SSARS No. 21, Clarification and Recodification, the most significant change to the SSARS since their inception over thirty years ago. This course will bring you up to date on all SSARSs requirements and guidance as it relates to compilations, including SSARS No. 25, effective for 2021 reporting. The course will also provide an overview of the different services that an accountant can provide under the SSARS and review the requirements of AR-C Section 60 as it relates to compilation engagements.
Surgent's Performing a Preparation Engagement Under AR-C Section 70
Available Until
Online
1.00 Credits
Be the go-to person for financial statement preparation engagements. Specifically designed for preparation practitioners and their staff, this course will provide you with a hands-on application for performing preparation engagements under AR-C Section 70. You will learn the ins and outs of relevant sections of SSARS No. 21, Clarification and Recodification, the most significant change to the SSARS since their inception over thirty years ago. This course will bring you up to date on all SSARSs requirements and guidance as it relates to preparation, including SSARS No. 25, effective for 2021 reporting. The course will also provide an overview of the different services that an accountant can provide under the SSARS and review the requirements of AR-C Section 60 as it relates to preparation engagements.
Surgent's Performing an Effective Audit Risk Assessment
Available Until
Online
4.00 Credits
Recent feedback from the AICPA has emphasized the importance of performing an effective risk assessment to identify and evaluate the risk of material misstatement in a financial statement audit. SAS 145, the 2023 amendment to AU-C 315, makes significant changes to the extant risk assessment standard and certain changes to other standards as well. The amendments clarify confusion that the AICPA believes auditors experienced under the existing standard and also conforms, for the most part, to the IAASB standard on the same topic. SAS 145 has been effective for two years now starting with December 31, 2023 audits. This course will focus on how to perform the risk assessment process under the new standard, providing participants with a summary of the changes to existing guidance. It will discuss linking the results of the risk assessment to further testing (internal control and substantive testing) and procedures performed in concluding on the evidence obtained. In addition, it will also discuss documentation and audit communications.
Surgent's Planning and Strategy Formulation for Your Organization's Financial Success
Available Until
Online
4.00 Credits
Have you noticed that change is continuing to happen at a more and more rapid pace? Obviously, some organizations survived change far better than others due to their ability to handle unexpected developments. Sick and tired of taking CPE that has no practical application or just regurgitates the same information over and over? Join us for this practical course, which will present a fresh approach to planning and strategy formulation for your organization. Often thought of as a painful process, planning and strategy formulation is probably one of the most important processes any organization undertakes in order to achieve financial success. We'll explore this fresh approach to many different planning stages, including the marketing plan, the technology plan, the capital plan, the five-year operating plan and much more! The pandemic has shown us that our planning process must be far nimbler and allow our organization to shift rapidly. Today's dynamic economic environment requires much more careful planning and strategy execution. Come find out how to make that happen for your organization.
Surgent's Power BI - Bringing It All Together for Data Analysis
Available Until
Online
2.00 Credits
This is an advanced-level course designed for professionals looking to integrate and optimize their use of Microsoft Power Pivot and Power BI. Building on the foundational knowledge from previous courses, this session focuses on the crucial next steps after creating data models and measures, guiding participants on how to fully utilize the potential of these tools to uncover insights and create impactful, actionable visualizations. This course takes a deep dive into the critical aspects of using Power BI to its fullest potential, emphasizing a holistic approach to data analytics. You'll learn how to build a streamlined workflow, ensuring every step in your data journey contributes to actionable insights. The course also focuses on optimizing performance for data models, utilizing advanced features of Power BI Services, and moving beyond basic data models to create advanced solutions tailored to real-world business needs. By the end of the course, you'll be able to synthesize all your Power BI skills to design and deliver powerful analytics solutions tailored to any audience. Whether you're presenting to stakeholders, sharing insights across teams, or managing enterprise-level reporting, this course will equip you with the tools and strategies to succeed.
Surgent's Power BI Desktop: DAX Formulas, Reporting, and Visualizations
Available Until
Online
1.00 Credits
Power BI Desktop is the authoring tool for the Power BI Ecosystem and is an essential component of the Power BI ecosystem. Power BI Desktop is a free application that is available for download. This one-hour course will demonstrate the capabilities of Power BI Desktop as your company continues its journey to increasing its data skills and data literacy.
Surgent's Power BI.com: Empowering Collaborative Data Analytics in Your Organization
Available Until
Online
1.00 Credits
A data-driven culture can only occur when there is collaboration, communication, and cooperation between everyone in your organization. Collaboration can only occur in the Power BI ecosystem when your organization works in the cloud with Power BI.com, also known as the Power BI Service, a software as a service available on the Power Platform. This one-hour course will demonstrate the capabilities of Power BI.com as your company continues its journey to becoming a data-driven organization.
Surgent's Power Query Series: Adding Columns for Data Enrichment
Available Until
Online
1.00 Credits
Using a variety of hands-on exercises, this course enables users to learn how to add columns using Power Query (Excel version). Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the fifth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: Append Queries
Available Until
Online
1.00 Credits
Append queries combine two or more queries into one output query that is a combination of the originals. This course discusses best practices for creating append queries using Power Query (Excel version) and includes hands-on exercises to enable the user to demonstrate what they have learned. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the seventh in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: Data Modeling and Next Steps
Available Until
Online
1.00 Credits
This final course in the series covers advanced features in Power Query (Excel version), including functions and parameters and basics of data modeling in Power BI and Power Pivot. Multiple hands-on examples help to reinforce these concepts. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the last in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: Data Transformations
Available Until
Online
1.00 Credits
This course teaches the user how to perform data transformations in Power Query, using a hands-on approach. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the fourth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: Editor – The User Interface of Power Query
Available Until
Online
1.00 Credits
This course introduces users to the Power Query Editor, using the Excel version of Power Query, and includes a hands-on transformation exercise using the editor. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the third in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: Formulas, M Language, and Error Handling
Available Until
Online
1.00 Credits
Even for experienced Excel users, there is a learning curve to using formulas in Power Query (Excel version). This course presents the fundamentals of this concept. In addition, this webinar introduces users to the "M" language in Power Query, as well as types of errors that users may encounter. Hands-on examples reinforce all of these concepts. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the eleventh in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: Introduction and First Connection
Available Until
Online
1.00 Credits
This course is designed for the Excel user to begin their data analytics journey with an introduction to a product created for their skill set: Power Query, using the Excel version. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the first in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: Making a Connection
Available Until
Online
1.00 Credits
This course explores the workflow of making connections to various data sources using the Excel version of Power Query. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the second in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.