Professional Development and Event Catalog

Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

This comprehensive session is a must-attend event for accountants who prepare financial statements and want to explore best practices for discerning the stories told by financial statements. We discuss salient requirements for presenting financial information while considering the critical role of disclosure for lending relevance to financial statements. We also explore techniques that will allow participants to perform meaningful financial statement analysis and effectively communicate conclusions to decision-makers and other stakeholders. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.

More Dates

This comprehensive program equips CPAs with the knowledge and practical tools to handle clients who have failed to file tax returns for multiple years. The course covers every stage of the process-from client onboarding and transcript analysis to risk assessment, ethical considerations, and resolution strategies. Participants will learn how to manage cases involving individuals, married couples, businesses, payroll taxes, and S corporations, including situations with missing records and potential criminal exposure. Real-world examples, IRS references, and best practices are integrated throughout to ensure confidence and compliance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

The course provides general information on proceedings that led to a grand jury indictment of television reality stars, Todd and Julie Chrisley. Participants learn how business decisions can lead to federal charges for conspiracy, bank fraud, wire fraud, and tax evasion. The grand jury also indicted the Chrisley's accountant, Peter Tarantino, on tax-related offenses. Participants learn how to develop resources and tools for effective detection and deterrence of federal crimes, and the learn the consequences that follow white-collar crime, including how responses can influence lengthy prison terms. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

This course provides a concise overview of how artificial intelligence (AI) is reshaping financial oversight in the global manufacturing sector. With factories evolving into digital ecosystems powered by intelligent automation, predictive analytics, and edge computing, the role of accounting and finance professionals is rapidly transforming. Participants will explore how AI technologies intersect with core financial functions-cost accounting, audit, tax compliance, and financial planning-while enabling real-time reporting, fraud detection, and predictive decision-making. Drawing on current global trends and real-world case studies, the course offers actionable insights into integrating AI into financial operations, elevating the strategic role of accounting in manufacturing enterprises. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many clients end up selling one or more residences during their lifetimes. Accounting and finance professionals must be aware of the tax rules that relate to such sales in order to assist their clients regarding these sales. This program provides accounting and finance professionals with the tax rules they need to know to help their clients when they sell a personal residence. This program is a comprehensive survey of the various tax issues associated with the sale of a residence.

More Dates

CPAs today face greater challenges than ever to maintain the high ethical standards of their profession. It is vitally important that all CPAs understand their professional responsibilities related to all aspects of their job. This course, which focuses on key components of the AICPA Code of Professional Conduct, reviews a history of the CPA profession and focuses on ethical requirements that CPAs must adhere to in their everyday practice, including practical examples of potential ethical dilemmas that practitioners may encounter, particularly those related to objectivity and independence. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED. This course does not qualify for IRS credit.

More Dates

This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving theft of public money and circumstances that allowed the fraud to occur. Case studies we examine include the 2012 $54 million embezzlement from the City of Dixon by Rita Crundwell. The events that impacted the small Illinois town of 16,000 residents was the largest governmental fraud case to date, and spanned an astonishing 20 years. This remarkable story inspired an award-winning documentary, "All the Queen's Horses." We will also examine factors that led to scandals involving the Baptist Foundation of Arizona, World Com, Collin Street Bakery and the Ohio American Cancer Society, among others. This course is ideal for CPAs, government finance personnel, all Internal Auditors, lawyers, governance professionals, accountants and human resource personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

This course provides tools and insights into financial statement analysis - both quantitative and qualitative. We'll look not only at the three main financial statements but also dive into the MD&A and footnotes. We'll also discuss the affect of industry nuances on comparability of different analysis tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

This course provides tax and accounting professionals with a comprehensive overview of overtime requirements under the Fair Labor Standards Act (FLSA). Participants will explore the statutory definition of overtime, exemptions, and the calculation of the "regular rate of pay." Through practical examples and compliance-focused scenarios learners will gain the skills to identify risks, properly compute overtime pay, and advise clients or employers on best practices. The course emphasizes regulatory compliance, accurate application of rules, and strategies to avoid common pitfalls in wage and hour audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Whether your employees report in every day to the floor or from an off-site network, the success of your organization depends a great deal on the motivation they bring to the job. This program helps identify specific methods you can use to improve employee motivation. You'll learn how to use observation tools to find out what motivates your employees and you'll study classic motivational theories. The results will help you influence the behaviors of others and tweak your own behavior to improve your bottom line.

More Dates

Fraud continues to make headlines, underscoring the importance of understanding how fraud occurs, how it can be prevented, and how auditors are expected to respond. This course begins with an overview of common fraud schemes identified in the 2026 Report to the Nations issued by the Association of Certified Fraud Examiners, along with key characteristics commonly observed among fraud perpetrators. The course then explores practical approaches organizations use to prevent and deter fraud, highlighting controls, policies, and cultural factors that can reduce fraud risk. Participants will also review recent fraud cases reported in the news to reinforce how these schemes manifest in real-world settings. The course concludes with a discussion of the auditor's responsibilities related to fraud under AU-C 240, including an overview of proposed changes to the fraud standards and what they may mean for future audit engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

This course provides a comprehensive overview of the ethical standards and principles governing tax practice, as outlined in IRS Circular 230. Participants will explore the importance of ethics in the tax preparation industry, review IRS rules, and examine common ethical violations and their associated penalties. The course emphasizes procedures that promote compliance with ethical guidelines, equipping tax practitioners to navigate complex ethical dilemmas confidently. Real-world scenarios will be used to demonstrate the application of ethical principles in tax preparation and representation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Since 2017, employees have not been eligible to take an itemized deduction for a home office. The Tax Cuts and Jobs Act suspended all miscellaneous itemized deductions for tax years 2018 through 2025. That deduction is scheduled to go into effect in 2026. Self-employed individuals can deduct office expenses on Schedule C, Form 1040. The home office deduction includes typical office-connected expenditures such as supplies, postage, computers, printers, and all the other ordinary and necessary expenses a person would have in connection with running a home office. The home office tax deduction for the self-employed would cover expenses for the business use of a home, which includes mortgage interest, rent, insurance, utilities, repairs, and depreciation. This program discusses many of the most important issues relating to the deductibility of home office-related expenses.

More Dates