CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel - Building Powerful Lookup & Reference Formulas
-
Online
2.00 Credits
Improve efficiency with these powerful functions (bold) Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. In this webcast, we will focus on the Logical, Information and Lookup and Reference functions. -In the Logical function section, you will learn to perform logical tests using the IF function along with AND, OR and NOT. -In the Information function section, you will learn various ERROR checking functions that can be combined with the Logical functions. -In the Lookup and Reference section, you will learn to use the various LOOKUP functions and the INDIRECT function. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute. Regardless of the version you are using, ALL concepts covered in this webcast apply to ALL versions of Excel.
Excel - Advanced Financial and Statistical Calculations
-
Online
2.00 Credits
Improve efficiency with these powerful functions (bold) Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. In this webcast, we will focus on Financial, Statistical and Math functions. -In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. -In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel.
Pass-Through and Corporate Annual Tax Update
-
Online
5.00 Credits
Corporations and pass-through entities are subject to new regulations and IRS pronouncements every year. This course provides an in-depth analysis of all the most salient pass-through and C corporation matters that have come up in the past year. A perfect primer for the tax season, this course is designed to help tax professionals effectively communicate tax changes and planning opportunities with clients.
Tax Fundamentals of LLCs and Partnerships - Tax Staff Essentials
-
Online
8.00 Credits
Most U.S. businesses are formed as a pass-through entity, which includes partnerships. If you are new to the subject, or if you have worked in this area for years but need a quick review, this course will provide a firm grasp of the fundamental concepts, help you to build a strong foundation of knowledge, and freshen up your analytical skills. Talking about tax can sometimes sound like you're speaking a foreign language in front of your clients. You can leverage the tone of the course materials to explain complex issues with accuracy and confidence.
Excel - Advanced Spreadsheet Troubleshooting Techniques
-
Online
2.00 Credits
Fix those formulas! (bold) In this webcast, we will focus on debugging and troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn methods to resolve issues when you receive errors. During this session, we will also discuss Excel's nine built-in error-checking options and demonstrate different approaches to error resolution. Finally, will review techniques to resolve rounding errors. Regardless of the version you are using, ALL concepts covered in this webcast apply to ALL versions of Excel.
Excel - Functions and Formula Shootout
-
Online
2.00 Credits
Function refresh (bold) Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions perk your interest in becoming an Excel function expert, this webcast is right up your alley! This past-paced webcast digs into some of the most powerful functions in Excel. Although, we cannot cover all 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Functions like: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide examples files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This webcast is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast apply to all versions of Excel.
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.
Documenting Your EBP Audit: What You Need to Know
-
Online
8.00 Credits
What you document matters Understand different parts of the employee benefit plan (EBP) audit process, and learn to think holistically about your level of audit documentation. Understand the appropriate level of documentation in the performance of audit procedures of employee benefit plans, which will involve testing items that are not typically tested in audits of other types of entities. Real-life examples Learn from real-life examples and solutions, guided by a former employee benefit plan expert panel member and someone who performs peer reviews. Work in templates to truly understand documentation in an EBP audit, and learn best practices for documentation to incorporate into your audits.
Advanced Tax Planning S Corporations - Tax Staff Essentials
-
Online
8.00 Credits
Understand the intricacies of the ever-popular S corporation form of doing business and consider the tax effect that various types of S corporation distributions will have on the corporation's shareholders. Updated for the latest guidance on recently enacted tax legislation, this course examines planning and reporting successful complex S corporation transactions. The uses of Qualified Subchapter S Subsidiaries are also explored to help you minimize your client's tax bill with winning strategies related to this type of entity.
Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups
-
Online
2.00 Credits
As popular as the VLOOKUP function is, it has limitations. This session walks through the limitations and suggests how to improve the VLOOKUP function. We then discuss how to move beyond VLOOKUP altogether. We spend some time trapping errors with the IFERROR function, which was first rolled out with Excel 2007. 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.
Reviewing Partnership Tax Returns: What Are You Missing?
-
Online
4.00 Credits
The partnership section of the Internal Revenue Code is arguably one of the most complicated. That complexity, and the reliability of tax software to properly handle it, can create many issues for you and your staff when processing your client's LLC and partnership tax returns. Join us as we discuss the common errors practitioners make on partnership tax returns that are often missed by review staff. The intent is to sharpen skills for reviewers by examining case studies and discussing issues where additional information from the client may be warranted and areas of tax law where proper treatment requires additional analysis and information. Multiple issues will be discussed, including income, deductions, K-1 reporting, and K-2 and K-3 reporting. This course follows a highly illustrative case study format to increase participant comprehension and retention.
Reviewing S Corporation Tax Returns: What Are You Missing?
-
Online
4.00 Credits
The complexity of S corporation tax law creates a formidable challenge to the tax practitioner for accurate compliance and reporting of their client's S corporation activities. Join us as we discuss the common errors practitioners make on S corporation tax returns that are often missed by review staff. The intent is to sharpen skills for reviewers by examining case studies and discussing issues where additional information from the client may be warranted and areas of tax law where proper treatment requires additional analysis and information. Multiple issues will be discussed including income, deductions, K-1 reporting, and K-2 and K-3 reporting. This course follows a highly illustrative case study format to increase participant comprehension and retention.
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.
New Quality Management Standards: Resources - Expectations for Firms and Engagement Partners
-
Online
1.00 Credits
Leverage resources for optimal QM performance (bold) Managing a firm's resources to achieve the objectives of a quality management (QM) system involves planning, maintaining, scheduling, and allocating resources in ways that are best for each firm - but the system needs to use and leverage resources effectively. In this webcast, you'll gain a better understanding of how firms can design and operate their QM systems to appropriately manage resources - human, technological, intellectual, and financial. Managing resources is not only about the quantity available but also having the correct proportion of each resource to perform quality engagements. These revised standards strengthen an engagement partner's responsibilities for quality management at the engagement level and may positively change aspects of corporate culture. Second in a four-part webcast series (bold) This is the second webcast in a four-part series on the Auditing Standard Board's (ASB) new quality management standards. You'll take a deep dive into the resource component of the ASB's Statement on Quality Management Standards (SQMS) No. 1, A Firm's System of Quality Management (ital), and the engagement partner's responsibility for resources under Statement on Auditing Standards (SAS) No. 146, Quality Management for Engagements Conducted in Accordance with Generally Accepted Auditing Standards (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. 8, 2022, at 2pm ET.
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.
Intermediate Individual Taxation - Tax Staff Essentials
-
Online
8.00 Credits
Frequent changes in legislation make it difficult to keep track of the opportunities for individuals to save on their taxes. Materials provide explanations of the latest in tax law changes and the individual and business planning opportunities they provide. Explore, in-depth, the effects of the latest tax legislation, including the SECURE Act, the SECURE 2.0 Act, the Inflation Reduction Act, tax court decisions, and IRS guidance on the hottest tax topics affecting individual taxpayers, including those with small businesses. This course provides a wealth of tax-planning tips and strategies and addresses key tax return issues to arm you with the latest guidance to better serve your new and existing clients.
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
Power BI - Introduction to MS Power BI Tools
-
Online
2.00 Credits
This is the first webcast in the 2020 Power BI Series. Please see below for the suggested viewing order. Excel is a popular data analysis tool, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. Those that learned to analyze data using PivotTables, soon learned there were many weaknesses in PivotTables that resulted in elaborate calculations in order to perform simple tasks. In 2010, after much development and little hype, Microsoft released Power Pivot, a new data analytic tool that removed the weaknesses of PivotTables. This single product took Excel from a low-end data analytic tool to one of the most sophisticated and comprehensive tools. Since 2010, Microsoft has continued their development of end-user data analytic tools. This entire suite of products is called Power BI. During this webcast... We will provide an overview of the various Power BI tools and discuss Microsoft's Power BI Strategy. We will begin by explaining the challenges faced by many accountants when it comes to analyzing data in Excel. You will learn how each Power BI tool reduces the challenges and improves your data analytic skills. You will also gain a complete understanding of when to use which tool. This is an overview of the various Microsoft Power BI tools and should be your first step in learning the complete set of Power BI tools. As an overview, we will not be teaching the details of each tool but you will receive a thorough understanding of what each tool can accomplish. 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 Microsoft Power BI Series: 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 - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com
Accounting for Digital Assets under US GAAP, Part II
-
Online
1.50 Credits
Guidance on how to account for digital assets (bold): Accounting for stablecoins may not be stable: Though the use of digital assets is rapidly expanding, accounting guidance has not kept pace. As a result, accounting for digital assets can feel shaky. The AICPA can help: The AICPA practice aid on accounting and auditing for digital assets and this webcast can help you answer the question of what to do when you or your client accounts for stablecoins. You'll be helped to understand how to account for other transactions and investments involving crypto and digital assets under U.S. GAAP. You'll also learn more about what the AICPA is doing to lend clarity and guidance to this murky but increasingly important field. Learn how you can add more value: Whether you're a CPA with attest clients or an industry accountant responsible for corporate accounting policy, this guidance will give you a clear path to help your clients or firm by applying the most up-to-date accounting policy. Detailed examples and use cases will demonstrate 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.
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.