CPE Catalog & Events

This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. 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 to utilize ChatGPT for advanced financial analysis in accounting. The session reveals how to combine sophisticated evaluation and interpretation of financial data with the cutting-edge AI capabilities of ChatGPT. Aimed at enhancing the understanding of an entity's performance, predicting future financial health, and aiding in informed business decision-making, this course goes beyond basic financial statement analysis to include a wide array of techniques and tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session provides insights for enhancing the preparation and utilization of budgets. Seasoned accountants will benefit from a refreshed awareness of popular techniques. Budding financial professionals will obtain novel insight regarding fundamental budgeting concepts. All participants will develop an appreciation for the holistic nature of budgeting as an integral tool for planning and control. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA standards issued over the past few years, including the 16 SASs effective since 2021 and beyond. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. On the financial front, the course covers the 9 ASUs issued in 2023, including ASUs covering crypto assets and leases for common control entities. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.

This course will review the Accounting Standard Updates issued by the FASB that impact nonprofit entities. We will also look at the work of the Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

One of the most cost effective methods for storing your files safely and economically in the cloud is with Microsoft 365 OneDrive and SharePoint apps. If you use either or both of these cloud storage apps, this course is a "must take." There are often times when you want or need cloud based files to be stored on your local laptop or desktop PC. With the OneDrive Sync app, you can have the best of both worlds. You can have copies of a file stored locally and in the cloud simultaneously. The Synch app will update both copies of the file in real time for any changes that are made in the local or cloud copy of the file. A classic example is if you have a QuickBooks Desktop data file that you need to store locally to work with the files in QuickBooks. However, you also want the file stored in the cloud for anytime, anywhere access and enhanced security. The Sync app facilitates this scenario effortlessly. Nationally recognized accounting technology advisor and thought leader, John Higgins, will take you through the step-by-step process of setting up and using the Sync app. 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 accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This Masterclass is a one-hour training to show accountants how they can grow their practice this year through CFO and business advisory services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Join us for an enlightening presentation where we delve into the pivotal technology trends reshaping the accounting profession. This course covers an array of topics including cloud computing, big data, data analytics, Robotic Process Automation (RPA), Machine Learning (ML), Artificial Intelligence (AI), cryptocurrency, blockchain technology, and the metaverse. We will also cover provide an update on the current market for cloud based accounting / ERP and personal productivity software. Designed for forward-thinking professionals, this session offers insights into how these technologies impact your business, your firm, your clients and most importantly, your career. Stay ahead in your field by understanding these emerging technologies and their practical applications in business. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Take an in-depth look at Form 990. Dive into the 12-parts of Form 990 and its 16 schedules with a line-by-line analysis that offers explanations and tips for accurate completion. Updated for changes in 1099-MISC and 1099-NEC reporting, the webcast shows participants the ins and outs of reporting on Form 990.

This course covers basic legal principles that every accountant should be familiar with to avoid common legal disputes and costly litigation. By analyzing business law issues from the standpoint and background of accountants and auditors, this course will help you develop an approach to client and practice issues with a sensitivity and appreciation for potential legal ramifications.

This is indeed another year of significant change in the world of government and nonprofit accounting and auditing. Time is valuable, and it's hard to stay current in today's rapidly changing environment. Let us save you time and effort with this informative update course. The course materials utilize a highly illustrative and innovative format. Over 30 focused exercises are included to provide an enhanced working knowledge of the latest developments in government and nonprofit accounting and auditing.

This course will enable practitioners to understand and apply the AICPA "clarification" auditing standards to audits of Small- and Medium-Sized Entities (SMEs). Further, this course will provide guidance on how to perform an effective, efficient and profitable audit engagement. The course is loaded with practical practice aids to help enable participants to comply with the standards. Troublesome areas as identified in peer reviews and litigation will be covered. Participants who take this course will enjoy smooth sailing in their peer reviews, guaranteed! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Providing a practical overview of the IRS Power of Attorney, Form 2848, and IRS Tax Information Authorization, Form 8821. Participants will explore the differences between these forms, understand when each is required, and how to comply with IRS requirements for representing clients and accessing their tax information. The course will cover practical issues, ethical considerations, and best practices for managing client authorizations through the IRS Centralized Authorization File (CAF) system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The IRS believes, perhaps with some justification, that many workers classified as independent contractors are actually employees and should be treated as such for tax purposes. The result is that worker classification audits are frequent and often costly for business clients, both in terms of time as well as money expended. This program prepares tax practitioners to assist their clients with worker classification audits, and to avoid them if possible, by discussing and explaining the circumstances under which workers will most likely be characterized as employees or as independent contractors. The program also deals with the first line of defense against the IRS in worker classification audits - Section 530, as well as the common law factors distinguishing an employee from an independent contractor. This program also explores the IRS Voluntary Classification Settlement Program and discusses whether a practitioner should advise a client to request admission into this program.

Understanding unconscious bias is key to creating an inclusive workplace and to making the best business decisions. This course explores the concept of unconscious bias, the science behind it, and how it can affect the way employers hire, evaluate, and treat employees. We will also discuss strategies employers can use to reduce unconscious bias and create a more inclusive workplace.

This program addresses the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. Practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers will be explored, with particular emphasis on internal controls of small-to-medium clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available for your questions during the event.