CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Power BI - Prepare Your Data Efficiently for Excel Analysis
-
Online
2.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. Before you can analyze data, you first must get the data. This webcast focuses on getting data into Excel using different data sources. Whether your data is text, comma delimited (CSV), reports, Excel, databases, web, applications and/or many others, Excel provides the ability to access that data. You will learn about tools that have been added to Excel that will make accessing that data even easier, such as data models and Power Query (Get and Transform). After this webcast you will finally be able to get the data you need to perform data analysis. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com
Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check
-
Online
2.00 Credits
The Excel for Accounting Professionals webcast series concludes by applying many of the items covered at the same time. We start by discussing dynamic headers, and how important they are when automating reporting workbooks. Next, we review how to transpose the orientation of the conditional summing function to produce horizontal or crosstab reports. We review the idea of mapping tables and show how they are the key to unlocking major efficiency gains. Lastly, we use data validation in our digital reports and review a critical worksheet that belongs in just about every recurring-use workbook: ErrorCk. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
New Quality Management Standards: What's New for Firms' Monitoring and Remediation Processes
-
Online
1.00 Credits
Boost quality management through improved processes (bold) With an emphasis on more proactive and continual improvement, the monitoring and enforcement of quality management (QM) systems for audit and accounting practices have changed. The revised QM standards take a proactive approach to quality management, with an increased emphasis on monitoring, remediation and improvement. Firms are now required to evaluate their system and annually conclude on its effectiveness. Third in a four-part webcast series (bold) This is the third webcast in a four-part series on the Auditing Standard Board's (ASB) new quality management standards. In this webcast, you'll take a deep dive into the monitoring and remediation component of the ASB's Statement on Quality Management Standards (SQMS) No. 1, A Firm's System of Quality Management (ital). Attendance in each webcast in this four-part series will earn you one CPE credit. You can participate in one or all based on your interest in the topics. A rebroadcast of this webcast is scheduled for Dec. 13, 2022, at 2:00pm ET.
Auditing, Assurance, and Ethics Update for Governments and Not-for-Profits
-
Online
3.00 Credits
The right tools Change can be difficult if you do not have the right tools. You can gain those tools through this course, which includes case studies that provide more insight into the changes in the auditor's report and key areas to focus on during your audits.
Power BI - Analyze Your Data With Excel Pivot Tables
-
Online
4.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This webcast is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analysis an easy task for all accountants. You will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. Explore the other webcasts in the Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com
Accounting for Digital Assets Under U.S. GAAP, Part III
-
Online
2.00 Credits
Derivatives, embedded derivatives and mining (Bold) Complexities with digital assets increase when you move away from the fundamentals and start evaluating contracts to determine if they involve derivatives or have embedded derivatives. In addition, recording mining revenue has many unique considerations, especially if you have questions about differences related to transaction fees and block rewards or if you or your client are mining independently or within a mining pool. Part three of a series (bold) This webcast is part three of a series that will bring to life the content incorporated in the AICPA practice aid Accounting for and Auditing of Digital Assets. This webcast will walk you through: A specific fact pattern when evaluating whether or not there is an embedded derivative within the contract The difference between recording revenue for transaction fees and block rewards A flow chart for determining how to recognize revenue when participating in a mining pool Add more value (bold) Whether you're a CPA working with clients or an industry accountant responsible for corporate accounting policy, this webcast will give you a clear path to help your clients or entity by applying the appropriate accounting standards to your digital asset derivative and mining activities. Detailed examples and use cases will demonstrate the real-world application of this guidance. Note: FASB issued ASU No. 2023-08, Intangibles-Goodwill and Other-Crypto Assets (Subtopic 350-60): Accounting for and Disclosure of Crypto Assets, which is effective for all entities for fiscal years beginning after December 15, 2024. This ASU is not yet reflected in this webcast.
Power BI - Create Excel Dashboards for Maximum Impact
-
Online
2.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this webcast, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals, in order to make your dashboards easily understood. This webcast focuses on using standard Excel features to create visuals. Although we will introduce new tools like Power BI Desktop, the focus of this webcast is not about using Power BI to create visuals. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Use Power Query to Transform Your Data Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com
Power BI - Use Power Query to Transform Your Data
-
Online
2.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. Data can be messy! In other words, it is not always clean and neat. Data comes from various sources like text files, Excel spreadsheets, databases, report files, etc. This is how most data analysis projects fail - the inability to get the correct data. This webcast focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while still allowing you a one-click refresh. We will review various data issues including appending files, combining multiple files from a folder, adding custom columns, unpivoting data, creating a lookup table, and much more. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com
Estate & Trust Primer - Tax Staff Essentials
-
Online
4.00 Credits
Protect your clients' assets and shield their estates from increased taxation brought about by the changing tax code. This CPE course will help you to understand the tax obligations of trusts and estates and how these obligations affect beneficiaries. The course provides exercises and examples that reflect the calculation and allocation of taxable income and its presentation on the appropriate forms. You will also learn how to prepare federal Form 1041 and the accompanying schedules.
Reviewing Individual Tax Returns: What Are You Missing?
-
Online
4.00 Credits
The sheer mass of Internal Revenue Code provisions affecting individual taxpayers presents a considerable challenge for CPAs and tax professionals. These provisions combined with the potential for input error when utilizing the array of income tax software available, create the potential for a multitude of errors that can occur when preparing your client's tax return. Join us as we discuss the common errors practitioners make on individual tax returns that are often missed by review staff. Sharpen your reviewing skills by examining case studies discussing issues for which additional information from the client may be warranted, and areas of tax law that require additional analysis and information.
Yellow Book: Application of GAGAS Principles
-
Online
5.50 Credits
Gain the essentials Engaging with chapters 1-5 of *Government Auditing Standards, 2018 Revision,* gain the essentials for performing engagements in accordance with generally accepted government auditing standards (GAGAS). Build an excellent foundation of the principles of GAGAS as it relates to understanding Yellow Book requirements and application guidance.
New Quality Management Standards: Bringing It All Together - Exploring All Components of a Quality Management System
-
Online
1.00 Credits
Pull together all components for an effective and tailored QM system (bold) For a quality management (QM) system to be successful, it needs achievable objectives and tailored processes in place to enable the performance of quality engagements. It also needs clearly articulated roles and responsibilities and the ability to identify, evaluate, and correct deficiencies. The revised QM standards are designed to emphasize firm leadership's responsibility for proactively managing quality, strengthening a firm's monitoring and remediation processes, and advancing the ability of the firm to tailor its system of quality management to the nature and circumstances of the firm. To succeed under these new standards, you'll need to know how to set up a functioning QM system that will help your firm identify and address risks for its audit and assurance practice. Fourth in a four-part webcast series (bold) This is the fourth webcast in a four-part series on the Auditing Standard Board's (ASB) new Quality Management Standards and looks at how to create an effective QM system. You'll take a deep dive into aspects of the ASB's Statement on Quality Management Standards (SQMS) No. 1, A Firm's System of Quality Management (ital). Attendance in each webcast in this four-part series will earn you one CPE credit. You can participate in one or all based on your interest in the topics. A rebroadcast of this webcast is scheduled for Dec.15, 2022, at 2:00pm ET.
Power BI - Go Beyond PivotTables with Power Pivot
-
Online
4.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. This webcast focuses on using the Power Pivot features to enhance data analysis. We will review the 4 features of Power Pivot (data model, calculations, hierarchies and KPI's) and you will learn how you can use each of these features. Although, the majority of the time will be spent on building the data model and using calculations. You will learn how to add data to your data model either directly into Power Pivot or from Power Query. We will discuss the benefits of the data model relationships versus using the VLOOKUP function to access data in different tables. One of the strengths of Power Pivot is the formula language called DAX (Data Analysis eXpressions). We will introduce DAX so that you can use basic DAX formulas to build various calculations in the data model. You will learn the difference between calculated columns and measures as we build these various calculations into our data model. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) *However, in order to follow along and apply concepts being taught during this session, you need to have the Power Pivot add-in installed. Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com
Power BI - Use Advanced Calculations with DAX Formulas
-
Online
4.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. This webcast focuses on using DAX (Data Analysis eXpressions) to create advanced calculations in Power Pivot data models. We will review what you learned in "Power BI - Go Beyond PivotTables with Power Pivot" and take your calculations to the next level using advanced DAX formulas. You will learn over 20 DAX functions that will allow you to perform calculations that were not possible with standard Excel. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data like: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. You will also learn the DAX calculation process in order to proof and validate your calculations. We will be using Power Pivot to create our DAX calculations, however, the process is very similar in Power BI Desktop and the functions and formulas are identical. If you are using Power BI Desktop, you should be able to follow along and learn how to create advanced calculations. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) *However, in order to follow along and apply concepts being taught during this session, you need to have the Power Pivot add-in installed. (bold) Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com
Impact of GASB Activities on State and Local Government
-
Online
3.00 Credits
Are you an accountant or finance professional working in the state and local government space? Are you an auditor with state and local government clients? If you answered "yes" to either of these questions, you're aware that to succeed at your job and to uphold the public trust, you need a solid understanding of governmental accounting and reporting. This course will walk you through GASB standards and look to the future by exploring current GASB projects.
Accounting for Digital Assets Under U.S. GAAP, Part IV
-
Online
1.00 Credits
Crypto lending and borrowing [bold] As you or your clients start to explore new ways to transact with crypto assets, one of the many possibilities is through involvement with crypto lending and borrowing. Gaining an understanding of the process of lending and borrowing crypto assets is the first step. This webcast provides the fundamentals related to these transactions and considerations for accounting from the perspectives of both lender and borrower. Part four of a series [bold] This webcast is part four of a series that will bring to life the content incorporated in the AICPA practice aid Accounting for and Auditing of Digital Assets. This webcast will walk you through: The process of borrowing and lending crypto assets Crypto lending accounting considerations including derecognition models Crypto borrowing accounting considerations including how to account for the obligation. Add more value [bold] Whether you're a CPA working with clients or an industry accountant responsible for corporate accounting policy, this webcast will give you a clear path to help your clients or entity by applying the appropriate accounting standards to your digital asset crypto lending and borrowing activities. Detailed examples and use cases will demonstrate the real-world application of this guidance. Learn valuable information to open your world of crypto assets even more. Note: FASB issued ASU No. 2023-08, Intangibles-Goodwill and Other-Crypto Assets (Subtopic 350-60): Accounting for and Disclosure of Crypto Assets, which is effective for all entities for fiscal years beginning after December 15, 2024. This ASU is not yet reflected in this webcast.
Power BI - Use PBI Desktop to Create Reports and Dashboards
-
Online
4.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. Power BI Desktop is a new stand-alone tool that adds visualization to your data. This webcast focus is on learning the Power BI Desktop interface, connecting to data sources and creating the visualizations. We will demonstrate the creation of each of the various visualizations and the various options related to each. We will also show how the visualization can be connected together to provide fully-interactive reports with drill-down capabilities. This webcast does not require any Excel knowledge but understanding Power Pivot and Power Query can reduce your learning curve. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) *However, in order to follow along and apply concepts being taught during this session, you need to have the Power Pivot add-in installed. Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Share Your Data Analysis using PowerBI.com
Reviewing Individual Tax Returns
-
Online
2.00 Credits
The sheer mass of Internal Revenue Code provisions affecting individual taxpayers presents a considerable challenge for CPAs and tax professionals. These provisions combined with the potential for input error when utilizing the array of income tax software available, create the potential for a multitude of errors that can occur when preparing your client's tax return. Join us as we discuss the common mistakes practitioners make when preparing individual tax returns that are often missed by review staff. Refresh and hone your skills with interactive case studies that examine individual tax returns. Learn about issues that may warrant additional client information and about areas of tax law that require deeper analysis. This course follows a highly illustrative case study format to increase participant comprehension and retention.
The Bottom Line on the New Lease Accounting Requirements
-
Online
4.00 Credits
FASB ASC 842, *Leases* explained Understanding lease fundamentals is essential to applying FASB lease requirements appropriately. As such, you'll delve into key concepts that define what a lease is, as well as basic lease accounting topics, such as: Contracts containing leases Lease classification Amortization of the right-of-use asset Impairment considerations Lease presentation and disclosure requirements Comprehensive examples and case studies will guide you through approaches to help you adopt accounting guidance for FASB ASU 2023-01. You'll also review the presentation and disclosure requirements, and other topics, including: Lease versus non-lease components Sales-type lease Direct financing lease Operating lease Lease terminations
Governmental and Not-for-Profit Annual Update
-
Online
8.00 Credits
Change is inevitable and at times overwhelming if you are unprepared. Ensure you are current in governmental and not-for-profit accounting and auditing. This update course is designed to prepare you for the latest accounting and auditing developments affecting governments and not-for-profits and give you the tools and knowledge to implement the new standards.