CPE + Events Catalog

Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course provides a concise overview of how artificial intelligence (AI) is transforming financial strategies, tax compliance, and audit practices in the global retail industry. As retailers deploy AI to personalize customer experiences, automate inventory, and optimize pricing, accounting professionals must adapt to new challenges in data integrity, regulatory compliance, and financial reporting. Drawing on real-world case studies from retail giants and small businesses alike, this course explores how AI technologies intersect with accounting workflows and outlines strategies to maintain accuracy, trust, and control in an AI-driven marketplace. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Accounting and finance professionals routinely encounter a broad range of legal issues while advising clients or performing routine job functions. Contract law tops the list as the most frequent issue that intersects with the accounting and finance professions. As trusted advisors, it is wise to understand the fundamentals of contract law for both personal and professional benefit. This course provides a broad overview of contract law basics geared specifically toward the accounting and finance professions. From contract formation to enforceability, this course offers an interesting look at how contract law intersects with accounting and finance. Participants should walk away with a better understanding of common issues that arise when reviewing contracts.

PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.

This course is designed to provide accountants with a comprehensive understanding of the subscription pricing model. As the business world increasingly shifts toward subscription-based models, it's crucial for accountants to understand the financial implications and strategies associated with this pricing approach. This course will cover the basics of subscription pricing, how to set prices, and how to analyze the financial impacts of these decisions, as well as the specific impacts to your business. By the end of this course, participants will be equipped with the knowledge and skills to effectively manage the implementation of subscription pricing to their practice.

The GASB has been working on some big projects lately. This course starts with a look at the GASB standards effective this year, including GASB 94, Public Private Partnerships and GASB 96, Subscription Based IT Arrangements. We will include practical applications in the form of case studies to apply the topics. We will then switch gears to the GASB standards coming down the pike, including the major projects of the GASB.

More Dates

Microsoft Teams is one of the most popular tools for communication, collaboration, and knowledge sharing. If you use Microsoft Teams in your practice or business, this is a "must attend" course. You will learn everything you need to know to optimize the features of Teams and maximize your productivity. We will cover everything from how to effectively design your teams and channels configuration. How to utilize all the Teams features for posting conversations and working with your Office documents, PDF files and more. You will leave this course with the skills to master all the features of Teams! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

More Dates

Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Discover how artificial intelligence is transforming the accounting, tax and finance landscape. This course offers CPAs a comprehensive overview of AI technologies, with a special emphasis on generative AI tools such as ChatGPT and Google Gemini. Learn how these advancements are reshaping business operations and what they mean for your professional role. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Given the opioid epidemic and the legalization of medical and recreational marijuana in a growing number of states, many employers are concerned about the impact drugs and alcohol may be having on the safety and security of their workplaces. Reasonable suspicion testing is among the best ways for employers to identify whether an employee is under the influence of drugs or alcohol while working. This webinar explores what managers and supervisors need to know to implement a Reasonable Suspicion Testing Policy.

Not-for-profit organizations encounter distinct accounting complexities. This course provides an introduction to the financial statements and specialized accounting principles relevant to nonprofits. Attendees will explore key topics such as net assets, agency transactions, contributions, and endowments, focusing on the unique transactions and account balances that define not-for-profit accounting.

Unlock the secrets to understanding a company's financial health and management performance through comprehensive financial analysis. This seminar will guide you through essential tools such as vertical analysis, horizontal analysis, and ratio analysis to gain deep insights into business performance. - Vertical Analysis: Learn how to express each line item of financial statements as a percentage, making it easier to compare companies of different sizes and identify key trends. - Horizontal Analysis: Discover how to compare financial information over multiple periods to spot significant changes and trends, providing a clearer picture of a company's growth and performance. - Ratio Analysis: Dive into calculating and interpreting financial ratios to assess profitability, liquidity, and solvency. Understand how these ratios reveal the effectiveness of management and the potential of the business. This seminar goes beyond just teaching terms and formulas. We will apply these analytical tools to real-world financial data, demonstrating how to derive meaningful insights and make informed decisions. Join us to enhance your financial analysis skills and gain a competitive edge in evaluating business performance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Creating Culture Benefits Your Organization It's important to dedicate time and resources in: Evaluating the company's current culture Communicating the company's values Creating processes and risk avoidance activities for a healthy corporate culture Prioritizing and monitoring risks This course will help you evaluate your organization's current culture, and teach you strategies for building a thriving corporate culture.

It's not about top-down management anymore - things have changed. For organizations to be successful today, everyone needs to contribute. Our success depends not just on how you manage those who report to you but also on those to whom you report. The world is too complex now for any one person to have all the answers. Sometimes those in charge need and want your support. Learn how to manage the managers in "Managing Up the Ladder." It takes a special finesse and approach. You'll learn strategies for acquiring buy-in from those above you in the organization and tools for more effective communications and building respect.

This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Single Audits are a critical area of focus under the AICPA's Enhancing Audit Quality Initiative, requiring a thorough understanding of the Uniform Guidance's unique audit requirements for federal funds. This course examines the distinctive performance and reporting standards in Single Audits, equipping participants with foundational knowledge to navigate these complex audits effectively. Key topics include an overview of internal controls over compliance, understanding compliance requirements, using the Compliance Supplement, and identifying the elements of a finding in a Single Audit. This course is ideal for professionals seeking a clear and practical introduction to the essentials of Single Audits.  

Getting rich requires many things.  First, you need to know how to overcome previous limitations you may have had about making a lot of money.  Second, you need to know and use the best financial strategies for becoming wealthy--including the latest investment and marketing strategies.   And third, you need to be able to enjoy your lifestyle, and look at what obstacles get in the way of you being rich and fully contented.  By exploring the latest methods for achieving financial and personal success, you'll be able to make a lot more money and have a great time doing it.

More Dates

Performing engagements in accordance with Generally Accepted Government Auditing Standards (GAGAS), commonly referred to as the "Yellow Book," involves additional reporting, ethics, and performance requirements that go beyond those outlined in AICPA Generally Accepted Auditing Standards (GAAS). This course provides an overview of the guidance found in the Yellow Book and explores its relationship with the AICPA Code of Professional Conduct. Participants will gain an understanding of the unique CPE requirements for GAGAS engagements and review the Yellow Book standards for financial statement audits, with a focus on ethical principles and independence. This course is designed to equip professionals with the foundational knowledge needed to navigate the complexities of Yellow Book engagements effectively.