CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel for Accounting Professionals Session 6: List Comparisons and Indenting
-
Online
2.00 Credits
This session opens with how to use Excel's lookup functions to perform list comparisons. Also, this webcast covers how to perform multicolumn list comparisons without first combining several columns into a single lookup column. We discuss how a minor detail like how we indent can produce major efficiency gains. We end the webcast by comparing traditional lookup functions to Excel;'s multiple condition summing function. 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 webcast, 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.
Applying the Uniform Guidance in Your Single Audits
-
Online
8.00 Credits
Designed to provide you with the knowledge to be more efficient and effective at planning and performing audits in accordance with the requirements of the Uniform Guidance and the Single Audit Act, this course examines how the Single Audit Act relates to OMB Uniform Guidance, as well as the different types of guidance and requirements found in the Uniform Guidance. The course also covers responsibilities and requirements of the auditor and the auditee, how to identify federal assistance and how to determine a nonfederal entity's major programs. Make sure your skills are up to date with the latest information in this challenging audit area.
Excel for Accounting Professionals Session 7: Date Driven Workbooks and Concatenation
-
Online
2.00 Credits
When we try to improve efficiency, we seek to delegate manual tasks to Excel. This implies that we seek to convert manual input cells into formula cells. When we realize that Excel can operate on and return date and text values, the opportunity for efficiency greatly expands. This webcast covers key date and text functions. It also demonstrates how to greatly improve the utility of the conditional summing function by using comparison operators. 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 webcast, 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.
Current Audit Environment and ASB Activity
-
Online
2.00 Credits
Explore the current audit environment, and recognize audit challenges triggered by the current environment. Provide a comprehensive review of recent audit pronouncement and exposure drafts. Understand topics critical to success in today's rapidly changing regulatory environment. This course provides 4 hours of CPE credit in the Auditing field of study.
Auditing Financial Statements of ERISA Plans
-
Online
4.00 Credits
Conduct a compliant audit Identify proper audit procedures to test the line items of the statement of net assets available for benefits, including investments. Identify proper audit procedures to test the activity in the statement of changes in net assets available for benefits, including participant testing. Plan investments Differentiate plan investment procedures based upon the type of audit and risk assessment. Identify types and classifications of common plan investments. Identify audit procedures required for investment activity, contributions and benefit payment or withdrawals at the participant level. GAAP presentation and disclosure Understand GAAP requirements for presentation and disclosure for employee benefit plan financial statements. Other audit considerations Recognize procedures needed to determine the plan's tax status Learn how to identify related parties, parties in interest, and prohibited transactions. Recognize additional audit procedures needed for Form 11-K filers.
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.
Streamlined Excel Reporting Series Session 1: PivotTable Fundamentals
-
Online
2.00 Credits
This is part 1 of a 4 part series. The first session of the series introduces the PivotTable feature and covers the basics. We start here to ensure that all participants, regardless of previous PivotTable experience, have the skills needed for the remaining sessions. We discuss the four report layout areas, rows, columns, values, and filters. We then discuss how to update PivotTable reports and ensure that any new transactions appended to the data source are included in the report. We explore how to create monthly columns and how to properly format the values in a PivotTable.
Streamlined Excel Reporting Series Session 2: Working with PivotTables
-
Online
2.00 Credits
This is part 2 of a 4 part series. This session begins by comparing the formula-based reports we built at the end of the Excel for Accounting Professionals series to PivotTables. We'll dig into the details between these two report types so that you are comfortable applying them to specific workbooks. In this webcast, we create two versions of many reports, one version with formulas and the other with PivotTables. With this interactive practice, you will be comfortable replacing formula-based reports with PivotTables when appropriate.
Multi-State Taxation - Tax Staff Essentials
-
Online
8.00 Credits
Multistate taxation has never been a more relevant topic. This course helps professionals skillfully navigate the maze of multistate corporate tax codes.. Be the one to guide your client skillfully through the maze of multistate corporate tax codes. Rapidly develop a working knowledge of both multistate tax compliance and related planning opportunities.
Streamlined Excel Reporting Series Session 3: PivotTable Wrap-Up and Web Data
-
Online
2.00 Credits
This is part 3 of a 4 part series. In this session, we finish our PivotTable discussion by examining various ways to present report values, discussing the subtly of properly sorting a recurring-use PivotTable, and covering numerous filtering options, including slicers. Next, we explore the lookup function, which is designed specifically to retrieve values from PivotTables. The webcast concludes by transitioning to data acquisition techniques, and we'll retrieve data, including stock quotes from perhaps the largest external data source of all, the World Wide Web.
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Online
2.00 Credits
This is part 4 of a 4 part series. This session continues the discussion about external data and digs into the details for retrieving data from other sources. We'll pull data from an Access data base using Microsoft Query. You'll learn how to retrieve data from simple text files as well, and how to prepare data for use with Excel. This webcast concludes by examining several data visualization tools in Excel, including PivotCharts.
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.