CPE Catalog & Events

This webcast will walk you through a SOC 2 report, giving you enhanced knowledge of essential information for preparing or reviewing SOC 2 reports. Get comfortable with SOC 2 reports. Avoid potential pitfalls. For service auditors and user entities new to SOC 2 reporting, not understanding the report contents can result in reporting deficiencies or inappropriate identification of key information. How will this course benefit you? This webcast presents the contents of each section of a SOC 2 report, highlighting key items of interest. As a user or user auditor, you will be better able to identify pertinent information that affects your organization or audit work. And as a service provider or service auditor, you will be better able to recognize what users are looking for and meet the requirements of SSAE No. 18. Why take this course? Take this course as an introduction to SOC 2 reporting, to strengthen your foundational knowledge as you perform SOC 2 examinations as a service auditor or as you review SOC 2 reports as a user entity or user auditor.Speaker - Jeffrey Cook

This course provides a concise overview of Google Sheets, a cloud-based spreadsheet application by Google. Similar to Excel, the tool allows users to enter numbers, apply formulas, prepare graphs, create charts, use pivot tables and more. While Excel is the default tool and industry standard for most accountants, Sheets has many underrated capabilities which are clearly superior to Excel. These include online collaboration, team communications, mobility, version control, revision history, cloud storage, translation, Google integration, and scores of third-party add-ons. You'll walk away knowing how to use a whole new array of spreadsheet features not found in Excel that can boost your analytical powers and accelerate your financial workflow. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Garrett Wasny, MA, CMC, CITP/FIBP

A discussion of the latest 2021/222 tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Steven C. Dilley, CPA, JD, PhD

Imagine being able to see into the future with confidence.  The ability to be a great forecaster is not innate but learned.  By examining great forecasters, we can learn to improve our ability to predict the future.  We will examine best practices and current research to improve our ability to predict events that will affect our business.   Speaker - John Levy

More Dates

With the roll out of a new Form W-4 in late 2019, the IRS made significant changes to employers' withholding and payroll reporting requirements. In addition to the myriad of changes brought about by COVID-19 legislation, carried out through the payroll function, the IRS fundamentally revamped Form W-4 for employee reporting, doing away with the concept of allowances and requiring changes to payroll administration and employee communications. Now more than ever, employers need to know that the W-4 they are working with is working to withhold income taxes correctly for their employees. In addition, it is the employer's responsibility to ensure Form W-4 is filled out correctly and accurately. Employers need to understand the nuances and requirements that come with this obligation. This course will review the Form W-4 in all its glory, including all the changes that were made to the format and substance of the form, understanding what an employer can and cannot do, and how to actually fill out the Form W-4. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Elizabeth Bystrom, CPA

This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Allison M. Henry, CPA, CGMA

Auditing PP&E, Including Leases under Topic 842 - Digesting the Risks of Improper Treatment of Tangible Long-Lived Assets will address tips and techniques for auditing tangible long-lived assets for various assessed risk levels, with a special emphasis on lease accounting under Topic 842. Property, plant and equipment can range from a low-risk to a high-risk audit area, depending on the nature of transaction and events engaged in by the reporting entity. Construction, capitalized interest and complex leasing arrangements tend to result in higher risk of material misstatement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer F. Louis, CPA

Accounting standards affecting not-for-profit (NPF) organizations have become increasingly complex, and, as a result, a great deal of confusing exists as to how to properly account for certain transactions unique to these organizations. This course will clarify proper accounting and reporting for these troubling areas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Daniel W. Bradley, CPA

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

The process of closing out the books every month can make year-end accounting a breeze! But isn't this time consuming? Not when you know the steps to take on a monthly basis. We'll show you what to do in QuickBooks Online as well as what you can do monthly to ensure a tax return that will stand up again an IRS audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Dawn W. Brolin, CPA, CFE

Looking for an idea that will help recruit and retain employees, engage customers, and invite investors? Sustainability is the solution! Sustainability is no longer just a "nice thing to do," it is both a business and moral imperative. Incorporating sustainable strategies into your day-to-day operations creates a competitive advantage, enhances your brand, and benefits the bottom line. On the business side, according to Harvard University, companies with strong sustainability initiatives have 4 times the sales growth, 8 times the employee engagement, and a 47% greater increase in stock value than their non-sustainable competitors. On the moral side, your customers and employees will no longer support an organization that does not address environmental and social issues. This session will explain the 6 benefits of sustainability and 6 steps to building a sustainable business. Learn how to make sustainability a competitive advantage to attract and retain loyal customers and high-performing employees. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer Elder, CSP, CPA, CMA, CIA, CFF, CGMA, MS

Innovation is key to finding success in the face of change - but how do you actually achieve it? In this course, you'll learn why innovation matters, what you need to build an innovation strategy, and how to get your team's buy-in along the way. Leaders of teams and organizations of any size will gain practical takeaways to start developing an innovation system.Speaker - Jennifer H Elder,Tom Hood

We all make predictions in our personal and professional lives.  We base our decisions to marry, buy a house, launch a new product or hire staff on expectations about the future.  In the past few years, research into improving predictions has advanced. We will look at this research and current best practices in forecasting to help us prepare better budgets and projections.  Speaker - John Levy

More Dates

Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly consider attending this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Karl Egnatoff, CPA.CITP

What can we learn from one of the largest municipal frauds in U.S. history? Rita Crundwell stole nearly $54 million from the citizens of Dixon, Illinois over the course of two decades. This course examines circumstances that allowed this landmark fraud to occur. We will explore internal control deficiencies and other circumstances that hindered prevention or timely detection of Rita's scheme. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Chris Harper, CPA

Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA

This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Chris Harper, CPA

This course provides a complete framework for transforming the culture in your organization. Key topics covered include: - What is organizational culture - A self assessment - Why culture matters - How to change your culture This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jim Bitterle

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

Join us for an insightful presentation featuring John Higgins, a renowned technology advisor to the CPA profession, who has assisted many firms with Microsoft 365 (M365) deployment. Discover how to leverage the M365 suite of apps to unlock new efficiencies and opportunities within your firm. Don't miss this chance to supercharge your practice with cutting-edge tools! Whether you are a solo practitioner or larger firm, this "bootcamp" will provide you with an ROI many times greater than your investment to attend. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - John Higgins, CPA.CITP