CPE Catalog & Events

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.

Tax planning for 2025 is largely based upon legislation contained within the Inflation Reduction Act and the SECURE Act 2.0, that offer new planning options and challenges for businesses in 2025. There are, however, other business tax changes in 2025 that result from different pieces of tax legislation, IRS pronouncements, and court cases that need to be taken into account from a planning perspective. This program analyzes the new opportunities and challenges that these tax changes offer to businesses and their owners that impact 2025 and sometimes later years.

In an era defined by rapid change and uncertainty, effective leadership requires more than just managing teams; it demands the courage to disrupt and innovate. This course is your blueprint for transforming potential chaos into a strategic advantage and is designed for leaders at all levels-whether you're a seasoned CEO, an ambitious small business owner, or an individual contributor aspiring to influence greater change. You'll gain the insights and tools needed to not only adapt to change but to lead it effectively and confidently. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The budget and the forecast are two common tools used by controllers and CFOs across almost every industry. However, are we really getting the most out of these tools? Or are we merely replicating whatever was done last year? In this course, we will use examples and illustrations to demonstrate various budgeting and forecasting techniques. We will discuss traditional approaches, as well as newer approaches such as flexible budgeting, in an effort to show how companies can gain more value. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Sustainability Accounting is now a recognized professional skill of increasing importance in larger organizations. It is the process of finding, measuring and managing the material metrics for sustainable performance and risk management. The goal is to bring these metrics into regular financial statements so leaders can act on them.  This course teaches Sustainability Accounting basics with example from the restaurant industry.   It is suitable for any professional or student who wants to learn fast about sustainability issues in specific industry sectors and how to integrate sustainability metrics into financial accounting and reporting.

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session will cover: Avoiding Budget People Issues:  Managing Budgeting’s Soft Side •    Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create to a better plan.  

Many organizations struggle to keep budgets current in an ever-changing business climate.  Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past.  Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process.  This session will show you powerful techniques to drive your organization’s performance.

Identify and eliminate risk Understand how risk affects all areas of business-from hiring and onboarding to customer fulfillment and customer support, and everything in between. Gain the knowledge to make informed decisions about risk assessment. Understand the importance of fully integrating risk assessment techniques into other elements of enterprise risk management. Tools and techniques With the assistance of 17 tools and techniques, learn how to assess and manage risks in your organization. Compare SWOT analysis and PESTLE analysis in analyzing risks. Understand how enterprise risk management (ERM) can help protect and enhance stakeholder value. Learn how ERM can be used by businesses of all sizes.

This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identifying internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. 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 allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-basis financial statements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Recognize the impact of emerging issues, including the increasing divergence of private company accounting standards, the pace and complexity of new standards being issued, and the usefulness of non-GAAP reporting. We'll discuss current issues, including accounting for crypto assets, the controversy over ESG reporting, going concern disclosures and impairment testing, and accounting for internally developed intangibles, including research and development. The course also includes an update on the FASB and PCC agendas.

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This series will offer solutions to the budgeting woes from both the big picture and in the details.    Understanding and Preventing Budget Calamities 2 Hours - Accounting •    Most of us lead or participate in the budget process at least annually.  Inherent flaws exist in the standard budget building process that you can solved by recognizing them and committing to solutions.   Building Flexible Budgeting Models: Walking Through and Crunching The Numbers 2 Hours - Accounting •    We can all learn from others and improve our budgeting process by listening to our colleagues’ wisdom and experience.  This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial planning.  Avoiding Budget People Issues:  Managing Budgeting’s Soft Side 2 Hours - Accounting •    Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create to a better plan.   Budgeting:  Presenting and Communicating your Numbers 2 Hours - Accounting •    Now that the budget is complete, how we communicate our plan is critical.  this session reveals some key guidelines in budget presentation and will identify key problems in how people often communicate financial plans.   

This Masterclass is a one-hour training to show accountants how they can grow their practice this year through CFO and business advisory services. 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 provides HR Professionals with scripts for and tactics for coaching leaders in handling an array of employee relations situations with sensitivity, good judgment, and high confidence.  Topics include employee complaints, personality & attitude problems,  performance counseling, personal hygiene problems, disability-related performance issues, misconduct due to mental conditions. You will learn how to use a unique process, “Reset the Clock,” that prevents attorneys from taking something leaders did wrong or did not do in the past and using it to support legal challenges in the future.  Liability is replaced with credibility. Lawsuits are then avoided rather than won.  Financial assets are protected, morale stays high, and bad publicity is averted. HR Professionals avoid hearing from senior leaders:  “You should have anticipated this” after an avoidable legal claim.

Our session will include a discussion regarding indirect rate strategies for cost recovery.  We will cover negotiating indirect rates with pass-through entities and alternative indirect cost recovery methods. A look at applying the PPP Loan Forgiveness credit.  Understanding the definition of sub-awards and the MTDC allocation base, and where best  to allocate bonus expense.  Included in this session will be a selected review of the Uniform Guidance FAQs regarding indirect rates for States and Municipalities, as well as recently issued FAQs that impact indirect rates and cost recovery.  

The annual budgeting process is often criticized as an accounting exercise that is obsolete soon after it is published, prone to gamesmanship, cumbersome, not volume sensitive, and disconnected from the organization's strategy and risk management processes. You can resolve these deficiencies using capacity-sensitive driver-based projections. Driver-based budgeting allows for quick scenario planning and far easier analysis of a growing organization whose future may look nothing like today. The driver-based budgets can be periodically refreshed to create rolling financial forecasts extending well beyond the fiscal year end. Learn how managerial accounting can become managerial economics.

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session will cover: Budgeting:  Presenting and Communicating your Numbers •    Now that the budget is complete, how we communicate our plan is critical.  this session reveals some key guidelines in budget presentation and will identify key problems in how people often communicate financial plans. 

Two seemingly similar products can have very different costs, yet many companies are completely oblivious to these differences causing them to lose money or competitive bids.  When companies compete, those with good information win the “gravy” contracts and those with bad information lose money on “dog” jobs.  Attend this session to gain insights on how to win bids for the best opportunities and give the money-losers to your competitors.  Achieve your target profitability in the process.  

In today's fast-paced world, maintaining a healthy work-life balance is essential for mental wellness. This course is designed to provide practical tools and strategies to help you create a balanced, fulfilling life. You'll learn actionable techniques for improving sleep hygiene, incorporating proper nutrition, fostering open communication, and managing stress. Whether you're struggling with burnout, seeking better work-life harmony, or simply looking to improve your overall well-being, this course offers valuable insights and tools to help you thrive. Designed to fit into your busy schedule, it delivers the guidance you need to make practical, sustainable changes in your life, starting today. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.