CPE Catalog & Events

In the dynamic landscape of modern workplaces, the ability to retain top talent and foster employee engagement is a key determinant of organizational success. "The Education Advantage" is a one-hour program designed to help HR professionals, employers and employees understand: Turnover Costs Cost of Disengaged Employees Professional Development as a Strategic Imperative Employer Hesitations How to Embrace Professional Development Initiatives Types of Educational Opportunities This one-hour session is ideal for HR professionals, managers, and organizational leaders seeking tangible solutions to elevate employee engagement and retention through strategic professional development. Elevate your workforce and organizational success with "The Education Advantage."

Today's senior executives use LinkedIn to impress hiring managers, find talent, develop opportunities, and build relationships. This interactive session is for the financial executive who wants to position themselves internally and externally for career success by leveraging the #1 professional digital platform. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Managing a strong network is one of the most important things you can do to grow professionally. Yet despite its importance, maintaining an effective network is often not taught in undergraduate and graduate schools. The good news is that managing and growing a network is easier than it sounds. In fact, most professionals have some level of basic networking skills simply from helping someone find a job, attending an industry conference, or seeking professional connections through social media. Effective networking involves more than simply collecting contacts. Strong networks should be relevant to your career and consist of people you trust. Personal networks are just as important as professional networks and the two often overlap. In this course, we explore ways to strengthen and grow networks by examining proven strategies that have helped individuals meet their personal and professional goals.

Discover the real-world power of Artificial Intelligence (AI) and equip yourself with the skills to conquer modern challenges in accounting and finance. In this engaging course, we demystify AI and unveil its practical applications, transforming it from theory into a hands-on tool. Learn the essential AI fundamentals and unlock its remarkable potential to boost your productivity and effectiveness alongside your team. Explore the specific problem-solving capabilities of AI, tailored to address the unique challenges faced by accounting and financial professionals. Gain expertise in leveraging AI features integrated into everyday applications, including the ubiquitous Excel. Uncover how these features enable you to effortlessly detect fraud, identify potential transaction errors, and elevate your financial operations to new heights. Witness firsthand how AI is reshaping the present and future of your profession, positioning you at the forefront of this revolutionary wave.

To make more money in less time, all accountants need to learn to market themselves effectively to their clients or their firm. For better or worse, promotions and more money go to those who are the best marketers, rather than the most competent accountants.  In this fascinating and fun workshop, participants will learn seven key ways to get more clients and/or promotions through the art of marketing.

Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.

One of the most significant challenges facing auditors is the prevalence of fraud that exists in today's business environment. All auditors should have a working knowledge of the requirements in professional literature regarding fraud. We will cover the issues that all auditors need to know about fraud and the people who commit fraud. This course will provide horror stories about frauds that have occurred and how they were detected. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This webinar will show you how to use Excel's charting and formatting features to present financial data to a non-financial audience. As the saying goes, "A picture is worth a thousand words." People tend to better understand your point when visuals are used. We will explore the many capabilities of presenting your data without showing rows and rows or columns and columns of data. Help your audience visualize the meaning of the data, whether it is a trend, an exception, a distribution or a good vs. bad relationship. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of 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 session describes a state agency's quality review of a not-for-profit organization's A-133 Single Audit.  The case study describes the organization audited, its federally- and state-funded programs, and the CPA firm retained to do the audit.  Various anomalies in the financial statements alerted state officials to potential problems, and a detailed quality review followed.  Find out how the entity turned hundreds of thousands of dollars in bank overdrafts into hundreds of thousands of dollars of cash on its balance sheet.  Explore other “creative” ways to deal with fixed assets, accounts receivable, and related-party transactions.  Were the auditors just sloppy, ignorant, negligent?  Or were they active participants in producing fraudulent financial statements?  You be the judge.

Technology continues to evolve at an ever-increasing pace-disrupting and transforming virtually all aspects of our personal and professional lives. New technology is impacting and revolutionizing almost any product and service available, from AI, 5G and blockchain to IoT, robotics and EVs. Join Inspector Gadget as he explores the latest technology trends, vendor solutions, and cutting-edge gear and gadgets. Technology has never been more critical and impactful than it is today. Ensure you have the essential details to navigate your next steps.

Tax practitioners are responsible for presenting partner capital accounts on the tax basis. But what does this mean and how have rules changed in recent years regarding partner capital accounts? This webinar covers exactly that. For tax practitioners preparing partnership 1065 forms, this course explains these complex rules in practical and understandable terms.

This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Department of Justice updated guidance regarding their evaluations of Corporate Compliance Programs in March 2023: “Prosecutors should assess whether the company’s complaint-handling process includes proactive measures to create a workplace atmosphere without fear of retaliation, appropriate processes for the submission of complaints, and processes to protect whistleblowers.” This course offers recommendations for employers to consider when developing or augmenting an internal complaint handling process. Organizations benefit when whistleblowers trust the process and choose to promptly report their concerns internally. The measures offered promote a strong speak up culture and align with the Department of Justice's guidance. 

Everyone knows that Excel is the most widely used spreadsheet application in the world today. However, because it is ever-changing, many users are unable to keep up with the latest features and capabilities of this ubiquitous application. In this session, we look at some of the most helpful new features and tools that have been added to both the Desktop version of Excel and the Web version. Content like this is valuable to anyone that regularly works with Excel - We hope you will attend! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.

In this session, participants will delve into the differences and similarities that coexist between the Baby Boomers, Gen X, Millennials, and Gen Z in the workplace. Guided by generational whisperer, Summer Jelinek, this immersive session will equip HR professionals with actionable strategies to foster understanding, drive productivity, and promote a harmonious working environment, irrespective of generational backgrounds.

Unlike a traditional financial audit objective (Are the financial statements materially misstated), performance auditing can address a wide variety of objectives.  Is this program working? Can it be improved? Where can we save money? How can we operate more efficiently and effectively? Are management’s assertions supported? And so forth.  This session will explain what a performance audit is, describe the applicable standards, and provide examples that indicate the value of a performance audit.  Performance audits can add value to any entity and practitioners can profit from adding these assurance services to their practices.

According to the FBI, “white-collar crime is … synonymous with the full range of frauds committed by business and government professionals … characterized by deceit, concealment, or violation of trust …. The motivation behind these crimes is financial—to obtain or avoid losing money, property, or services or to secure a personal or business advantage.”  CPAs can and should play a crucial role in preventing and detecting white-collar crime, as well as in prosecuting the perpetrators.  This session will explore whether we are up to this challenge, heighten awareness regarding the CPA’s role as a front-line defender of the public interest, and assess whether we are deserving of the public trust we enjoy.

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.