CPE + Events Catalog

This course presents five use cases for specific data issues a user may encounter in Power Query (Excel version). Through hands-on examples, users are guided through the process of overcoming each of these issues. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the tenth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.

This course covers a number of useful transformations using Power Query (Excel version) to clean, enrich, and shape data. Coverage includes pivoting and unpivoting, filtering and grouping, fuzzy matching, and more, with hands-on exercises for users to practice these skills. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the ninth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.

In order to prepare accurate and effective not-for-profit financial statements, professionals must have a strong working knowledge of the reporting requirements. Now is the time to obtain that knowledge! This course explains the requirements, illustrates how the requirements manifest in the financial statements, and clarifies options available to not-for-profits in applying the requirements. The course covers key accounting areas that affect not-for-profits, including net assets, contributions, and functional expense reporting. The course materials utilize a highly illustrative and innovative format, including 30 focused exercises to provide an enhanced working knowledge of not-for-profit accounting and reporting.

In order to prepare accurate and effective not-for-profit financial statements, professionals must have a strong working knowledge of the reporting requirements. Now is the time to obtain that knowledge! This course explains the requirements, illustrates how the requirements manifest in the financial statements, and clarifies options available to not-for-profits in applying the requirements. The course covers key accounting areas that affect not-for-profits, including revenue recognition, contributions, and leases. The course materials utilize a highly illustrative and innovative format, including over 30 focused exercises to provide an enhanced working knowledge of not-for-profit accounting and reporting.

Spear phishing. Ransomware. Malware. Like the threats your business faces, the cybersecurity lexicon is constantly evolving. This comprehensive presentation imparts practical privacy and data security know-how and creates fluency with the latest terminology. Learn best practices for cybersecurity safety, as well as tailored training for those in positions responsible for implementing security policies. It is just as important to be diligent, safe, and well-versed in the attacks that we face in our personal lives.

Written business communication provides a structured, documented, and efficient way to convey information, make decisions and collaborate across various business functions. It ensures clarity, consistency, and professionalism in all interactions. Well-crafted e-mails reflect positively on your executive presence. Mastery can enhance your reputation and credibility as well as lead to opportunities for career advancement. In this course, you will learn how to incorporate strategies to articulate your ideas, instructions, and messages with precision. This reduces the likelihood of misunderstandings, errors, and confusion and provides a framework for your business success.

Employee discipline is always challenging. Training on proper progressive discipline is critical to avoiding potential lawsuits while also trying to bring out the best possible employee performance. This webinar is designed to assist human resources professionals and managers in understanding the best ways to use progressive discipline as both a management and risk reduction tool. The webinar also will address best practices with regard to the employee termination process.

The past few years have shown us the need for numerous projects and the need to manage those projects in a unique way. Project management is an important part of every organization; however, often companies do not differentiate between project management and operations management. Sometimes the finance professional is called upon to serve on a project team, or in other cases is in a position to manage a project within the finance or accounting department. In either case, he or she should be well versed in both the theory and practice of project management. While project management has probably been around since the time of building the pyramids, the modern discipline started to take hold in large organizations in the late '50s and early '60s. From there it spread to smaller organizations to the point where almost any-sized organization can benefit from its ideas. This course is designed for the finance professional of the small and medium-sized organization. It is not meant for the experienced project manager of a large organization or the person wanting training for project management certification. In an effort to avoid talking theory without concrete examples, we will often use examples born from projects needed as a result of recent changes in both economics and politics.

Recent economic, societal, and political changes have shown us the need for numerous projects and the need to manage those projects in a unique way. Project management is a way of thinking highly recognized and practiced by large organizations, but often neglected by the smallest companies and entrepreneurs. This course quickly discusses the basics of project management thought and practice and then spends the majority of the time exploring some of the greatest mistakes that can be made, the ways to avoid them, and some of the tricks that have been introduced into the discipline. In the program we will explore some of the specific types of project management as well as some of the available software programs to make the task of project management easier.

Recent economic, societal, and political changes have shown us the need for numerous projects and the need to manage those projects in a unique way. Project management is a way of thinking highly recognized and practiced by large organizations, but often neglected by the smallest companies and entrepreneurs. This course quickly discusses the basics of project management thought and practice and then spends the majority of the time exploring some of the greatest mistakes that can be made, the ways to avoid them, and some of the tricks that have been introduced into the discipline. In the program we will explore some of the specific types of project management as well as some of the available software programs to make the task of project management easier.

Gerald Ford once said that "[n]othing in life is more important that the ability to communicate effectively." Public speaking remains a centuries-old skill that allows individuals to effectively communicate both at a personal and professional level. The benefits of good public speaking run long, whether it be the ability to persuade others, lead a team, or encourage critical thinking. This course is designed to refresh and refine speaking skills for professionals. Through this webinar, participants will gain a better understanding of the core skills of how to communicate effectively in groups - big or small. The webinar is intended to help those who already speak in public better improve their skills, while at the same time teaching more novice speakers how to approach a task that so many professionals dread - speaking in front of others.

This course focuses on the main elements of financial education and will help accounting and finance professionals guide their clients, and their clients' children, through a personalized teaching roadmap. Clients with wealth face questions about how to teach their children about money to raise financially capable children. Often, clients' first contact is with their accounting and financial professionals, so it is important to be able to provide a framework to help teach clients how to prepare their children for life with privilege. This course is designed for all practitioners who want to help their clients navigate the process of teaching the next generation about personal finances. Because every family and child are different, it is critical to develop a specific plan for each client, and likely each child and grandchild. By working with their clients' descendants, accounting and finance professionals not only build rapport and trust but also get to know the children and grandchildren, building firm value and long-term connection. With new and updated information and tactics, professionals can learn best practices to engage clients and their children.

This program covers three topics: the Department of Labor's changes in overtime rules, the Federal Trade Commission's ban on most non-compete agreements, and the Department of Labor's new rules relating to differentiating between employees and independent contractors under the Fair Labor Standards Act (FLSA). Understanding these new changes will allow accounting and finance professionals to discuss these important business law changes with their clients.

When it comes to attracting the best talent, it is imperative to know your audience. It is critical for employers and managers to understand Next Gen employees (those born in 1980 or later), as this group is expected to comprise 62% of the workforce by 2025. To be successful, accounting and related professionals should understand how to create strong relationships with Next Gen talent, some of the most talented, energetic components of the workforce. Using sound research as a guide, this webinar addresses guidelines and procedures that have proven successful in attracting and retaining Next Gen employees so that companies can continue to grow.

The accounting industry has embraced the hybrid and, in some cases, fully remote work model for the profession. As technology has evolved to support this strategy, the need to project professionalism and leadership through a virtual platform has become a significant skill for all current and future leaders. This seminar provides practical tools to establish an impactful virtual executive presence and communicate with confidence and authority.

In many smaller organizations the job of risk manager is housed with the CEO, and many of the staff who better understand the details of the various risks are not included in risk-management discussions. This program will take a hard look at risk management and show how to develop a program that is specifically designed to work well in a small business. Based on proven management techniques, the risk-management system will better focus on good risk management and especially strong mitigation.

This course gives CPAs the knowledge to help their clients plan for retirement by evaluating how much retirement income will be required and strategizing about how to reach retirement goals.

This course gives CPAs the knowledge to help their clients plan for retirement by evaluating how much retirement income will be required and strategizing about how to reach retirement goals.

This course gives CPAs the knowledge to help their clients plan for retirement by evaluating how much retirement income will be required and strategizing about how to reach retirement goals.

Single auditing can seem complex. With thousands of pages of potential AICPA, GAO, and OMB literature coming together for the audit of one client, auditors can easily lose focus and confidence in what they are supposed to do; however, it does not have to be that way. This course is designed to sharpen your skills and knowledge in performing single audits and eliminate wasted efforts.