CPE Catalog & Events

How you communicate with your internal and external customer can make or break your career! We all know how to talk, but how do we make sure we are really connecting with others? This course will discuss different personality styles and demonstrate the different ways to communicate information to them. See how recognizing their personality style(s) can turn communication breakdowns into breakthroughs.

More Dates

Crypto lending and borrowing As you or your clients begin exploring new ways to transact with crypto assets, one of the many possibilities is through involvement with crypto lending and borrowing. Understanding the process of lending and borrowing crypto assets is the first step. You'll learn the fundamentals related to these transactions and accounting considerations from the perspectives of both lenders and borrowers. Note: This webcast has been updated to cover 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. Part four of a series 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 Whether you're a CPA working with clients or an industry accountant responsible for corporate accounting policy, you'll gain a clear path to help your clients or entity by applying the appropriate accounting standards to digital asset crypto lending and borrowing activities. Detailed examples and use cases will demonstrate the real-world application of this guidance. You'll learn valuable information to open your world of crypto assets even more.

Unlock the full potential of your data with PivotTables PivotTables are a versatile and transformative tool for organizing and analyzing data. Whether you're a beginner or an experienced user, this course will provide you with the knowledge and skills to make the most of PivotTables so that you can: Customize PivotTable options Execute advanced calculations Create insightful reports Moving beyond formula-based reports By delving into more advanced techniques for using PivotTables, you'll learn how to replace formula-based reports by: Incorporating multiple fields into the Values area Performing custom calculations using calculated fields and items Setting up PivotTable options to create sophisticated reports *Session 2 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 3: PivotTable Displays and Alternatives](Need new URL due to Title change) to tackle real-world issues and create powerful workbooks.*

Tools for Risk Management A key to an effective risk management process is to move from the historic silo-based approach to an enterprise-wide approach. During this webcast, you will learn: Increased risks for organizations, including technology and cyber risks The use of a risk readiness assessment to identify management's current state regarding risk management The importance of retaining talent and updating your business model Findings from executive surveys that identify potential risks

More Dates

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

More Dates

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.comSpeaker - Bryan Smith

More Dates

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.

The AICPA Tax Advocacy Team in Washington, D.C., tackles the challenge of staying current with evolving tax laws. The team advocates for sound tax policy and effective tax administration. The Washington Tax Brief webcast series keeps members informed about: Key tax advocacy initiatives Proposed changes to tax law Fundamental tax reform, including recent updates to IRS regulations

The AICPA Tax Advocacy Team in Washington, D.C., tackles the challenge of staying current with evolving tax laws. The team advocates for sound tax policy and effective tax administration. The Washington Tax Brief webcast series keeps members informed about: Key tax advocacy initiatives Proposed changes to tax law Fundamental tax reform, including recent updates to IRS regulations

Essential techniques for displaying data in alternative ways You'll work alongside an expert instructor as you practice using PivotTables and exploring creative alternatives for insightful data presentation. You'll learn techniques for effective data presentation, including: Filtering and sorting data Cleaning and organizing data through text manipulation Using dynamic features to summarize and analyze large datasets Using slicers and filters for visual filtering Highlighting key Excel features through guided practice You'll walk through realistic scenarios that show alternative functions for greater data management, such as: GROUPBY PIVOTB PERCENTOF In addition, various text functions such as TEXTJOIN and TEXTSPLIT will be explained, highlighting how to concatenate and split text strings efficiently. *Session 3 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 4: External Data and PivotCharts](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series-session-4-external-data-and-pivotcharts) to tackle real-world issues and create powerful workbooks.*

Excel has long been included in the accountant's toolbox. Even though Microsoft Power BI and other big data tools such as Qlik and Tableau are becoming more important, Excel is still a "must have" tool. We cover what the accountants of today should know about Excel to improve their efficiency, access data, and gain insights into the company, industry, and economy.

More Dates

Auditing entities that hold or transact digital assets (bold) Would you like to better understand the environment of digital asset transactions? Have you ever wondered if you should accept or continue a client engagement? This webcast will help you identify challenges, risks and factors to consider when deciding to accept or continue with a client who holds or transacts with digital assets. During the webcast and discussion, you will learn: The Digital Assets Working Group's mission and the process through which nonauthoritative guidance is developed What private keys are and ways to safeguard them and the digital assets to which they enable access About the rapidly evolving nature of the digital asset ecosystem that may lead to challenges when performing required procedures surrounding laws and regulations You will gain: Insight into the unique aspects of the risk assessment process when involved in the digital assets space Awareness of the pseudo-anonymous nature of digital asset transactions that may lead to challenges in performing required procedures surrounding related-party relationships and transactions with related parties You will also gain access to valuable resources: Accounting for and Auditing of Digital Assets Practice Aid Blockchain Universal Glossary Webcast: Accounting for Digital Assets under U.S. GAAP Digital Asset Resources

Mastering finance with strategic insights Management accountants drive strategic directions and enhance operational efficiency. You'll learn how to integrate nonfinancial data into reporting and use scenario planning to evaluate business outcomes. Blending financial smarts with nonfinancial data Effective communication is crucial for conveying messages and handling crises. You'll explore various ways to enhance your understanding of effective communication, including: Transforming routine reports into comprehensive scenario analyses to highlight alternative business futures, influencing decision-making processes Improving effective communication skills to convey insights and analyses clearly Why sustainability matters in financial planning Integrating sustainability into financial planning is critical and beneficial for the business. Driven by evolving regulations, discussions focusing on transparency, consistency and trust in sustainability reporting are crucial in the modern business environment. You'll learn more about the sustainability considerations relevant to your business.

Comply With All Standards As You Prepare, Compile and Review Engagements This webcast is a go-to reference for staying in compliance with all professional standards surrounding engagements performed in accordance with Statements on Standards for Accounting and Review Services (SSARSs).

More Dates

The positive power of stress How we think about stress determines its effect on us. This webcast presents scientific studies and personal stories to help you rethink stress and make it work for you, not against you. Stress can increase our intellect, physical and emotional strength, and our empathy toward others, leading to greater success.

More Dates

The construction industry stands out in its need to adhere to a diverse range of accounting standards. This course explores the essential knowledge required for success in construction accounting, as well as the key issues influencing this field. Discover the implications of recent developments for yourself, your business, or your clients. In addition, we will examine the relationship between contractors and sureties. Given the construction industry's significant and ever-expanding share of the economy, staying up to date with the latest accounting updates in this sector is critical. Note: This course does not address FASB ASC 606, Revenue from Contracts with Customers, or FASB ASC 842, Leases. The AICPA offers a companion course which focuses on revenue and lease accounting for construction contractors. See Contract Accounting and Lease Accounting and Their Impact on Construction Contractors (CCREVL).

We're human. We bring our feelings to work. (bold) In this webcast, you'll learn: What emotional intelligence means How to increase your self-awareness How to better manage your professional relationships

Keeping up with FASB changesYou'll explore changes in accounting, including: Relevant pronouncements Exposure drafts Projects Additionally, you'll be able to identify recently issued FASB standards and guidance that cover broad and narrow issues, as well as understanding how to apply them. You'll also learn about upcoming standards that will be effective in the near future.

More Dates

In this course, Tom Hood shares why collaboration matters now, what collaboration really is, how to facilitate collaboration, collaboration techniques, and examples of how collaboration can be effectively used. Aspiring leaders and leaders of teams and organizations will learn why collaboration is important and how to make it work.

Practical hands-on Excel learning exercises taught by a highly engaging expert in the field You'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives. You'll walk through the VLOOKUP and IFERROR functions, and explore the following topics: Improving the use of VLOOKUP with VALUE/TEXT Improving the use of VLOOKUP with MATCH. Moving beyond VLOOKUP with INDEX Trapping errors with IFERROR Moving beyond basic Excel functions Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel. You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing: Combining functions to enhance flexibility Utilizing functions for atypical data categories Perfecting sophisticated lookup functions *Session 5 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*