CPE Catalog & Events

This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Thsi course provides a comprehensive overview of Written Information Security Plans (WISP), focusing on their purpose, requirements, and implentation. All PTIN holders must certify they have a WISP prior to renewal, along with certifying the training of employees, staff and contractors as necessary. Participants will explore the history and legal foundation of WISP under the Gramm-Leach-Bliley Act, and how compliances is enforsed through IRS Circular 230, AICPA Statments of Standards, The American Bar Associations and the Federal Trade Commission (FTC). 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 explores the complex rules of installment sales, with a focus on their tax treatment and strategies to maximize the benefits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Penalty abatement is a technique that tax practitioners can utilize to help their clients reduce penalties and interest they owe to the IRS if the taxpayer can prove "reasonable cause". This informative and insightful webinar will provide you with some insider tips, practical steps and effective strategies to help your client manage IRS tax penalties and interest. Learn about various types of penalties that you may face, and the various forms and procedures used for requesting penalty and interest abatement, including First Time and Reasonable Cause abatement. Plus, learn about the procedure to follow when requesting refund of paid penalties. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Stay informed and prepared with this comprehensive annual update on the latest developments in accounting and auditing. We'll begin with a deep dive into the Accounting Standards Updates (ASUs) effective in 2025, followed by insights from the FAF's 2024 PCC Review and an overview of FASB's Invitation to Comment - Agenda Consultation, which will shape the future of accounting standards. On the auditing side, we'll tackle the essential changes in quality management standards that firms must implement by the end of 2025. The session will also highlight common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB). Join us to gain practical insights and actionable takeaways to navigate these updates with confidence. Finally, we will close the course by exploring the audit technology adoption process to help transform resistance into resilience as the industry embraces new technologies. We will learn how to overcome common barriers to deliver a successful implementation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Successful organizations understand the importance of effective internal controls and develop a system to stay on the intended course. Those who design policies and procedures benefit by knowing why control measures are necessary. First, we'll examine critical concepts and the importance of strong internal control policies. Then, we'll look at why standards are needed and control creation methods. Finally, discuss strategies to implement policies and procedures.

Tax professionals can enhance their practice by studying tax-saving strategies for individual clients.

The most difficult concepts to master when dealing with flow-through business entities are the basis and distribution concepts. Major error and malpractice issues occur if the CPA does not fully understand the impact of these rules. This course is designed to focus on the practical applications of these rules.

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.

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability, and growth. It also provides hands-on training for implementing these techniques in real-world scenarios. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

When auditors detect findings in Yellow Book and single audits, they do not just communicate them in some shabby little letter to management; they get reported! In this course, we will examine what types of findings get reported, how they get reported, and where they get reported! This course will take you from just checking a box and fulfilling a requirement to developing and delivering findings that make a meaningful difference to your clients.

The Inflation Reduction Act (IRA) and SECURE Act 2.0 both contained tax law changes that impact many individuals in 2025 and in later years. This program covers many of these changes as well as other tax topics that continue to impact individual income taxpayers.

Whether you are an experienced veteran or new to the industry, one of the toughest parts of being a tax practitioner is keeping up with all of the changes in tax legislation. This course takes a look at recent changes to tax law from a practitioner perspective. In this session, we will explore the nuances of virtual currency and the new Form 8300 reporting requirements.

Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. 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 current economic environment has changed how organizations view their accounting operations. Your business faces challenges that could lead to valuable opportunities for streamlining through automation, outsourcing and technology. In this webcast, accounting professionals will share insights from their experiences, including 10 key tips to keep financial reporting and accounting running smoothly during times of change and turnover. This webcast is a rebroadcast from the 2024 AICPA & CIMA Not-For-Profit Industry Conference.

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.