CPE Catalog & Events

This course extends the Power BI series of courses that explore using OLAP (Online Analytical Processing ) formulas and advanced time intelligent functions. OLAP formulas can create a calculation in a cell that is based upon the measure in the data model. This powerful tool allows making calculations in an Excel worksheet without using a PivotTable to perform the analysis. Gone are the days of creating a PivotTable, then using those values in the PivotTable for additional calculations. When using Power BI to build a data model that connects to data files, you may want to know the date of these files. This class teaches you how to create a measure based on the refresh date of your data. In the class "Power BI—Use Advanced Calculations with DAX Formulas," you learned the basics of time intelligent functions, and the ability to calculate measures based upon dates. In THIS course, we will take it to the next step and teach you how to perform many more date-based calculations. This session is presented using Excel 2019/Office 365. Regardless of the version, you are using, most concepts covered in this course apply to all versions of Excel.

This course focuses on using DAX (Data Analysis eXpressions) to create advanced Power Pivot data model calculations. We will review what you learned in "Power BI - Go Beyond PivotTables with Power Pivot" and take your calculations to the next level using advanced DAX formulas. You will learn over 20 DAX functions that allow you to perform calculations that were not possible with standard Excel. We will also review the use of a date or calendar table that will enable us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data like month-to-date, quarter-to-date, year-to-date, last year, same period, last year-to-date, etc. You will also learn the DAX calculation process to proof and validate your calculations. We will be using Power Pivot to create our DAX calculations. However, the process is very similar in Power BI Desktop and the functions and formulas are identical. If you are using Power BI Desktop, you should be able to follow along and learn how to create advanced calculations. This session is presented using Excel 2019/Office 365. Regardless of the version, you are using, most concepts covered in this course apply to all versions of Excel.

Power BI Desktop is a new stand-alone tool that adds visualization to your data. This course focus on learning the Power BI Desktop interface, connecting to data sources, and creating the visualizations. We will demonstrate the creation of each of the various visualizations and the various options related to each. We will also show how the visualization can be connected to provide fully interactive reports with drill-down capabilities. This class does not require any Excel knowledge, but understanding Power Pivot and Power Query can reduce your learning curve. This session is presented using Excel 2019/Office 365. Regardless of the version, you are using, most concepts covered in this course apply to all versions of Excel.

Data can be messy! Data can come from text files, Excel spreadsheets, databases, report files, etc., which means it's not always clean and neat. Most data analysis projects fail due to the inability to get the correct data. This class focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while allowing you a one-click refresh. We will review various data issues, including appending files, combining multiple files from a folder, adding custom columns, unpivoting data, creating a lookup table, and much more. We use Excel 2019 during the presentation, but most concepts covered in this course apply to all versions of Excel.

This course covers many useful financial negotiation tips, illustrated by real-life examples that will get you thinking. Participants will wo rk through mini-cases, to apply principles and increase their financial and business creativity, and help their organization to be financially successful in negotiations.  This is different from and complements tactical/strategic negotiation seminars, by being more financial-oriented, with lots of specific examples. It is partly about how to persuade, but also about creating different financial options that would be attractive to other party.  The tips provided are also useful for internal negotiations and for non-accountants.

This downloadable PDF course offers more than 100 practical, insightful, and sometimes unconventional tips for accountants in financial leadership roles. Designed for controllers and CFOs, the content goes beyond technical rules and dives into the real-world challenges professionals face every day — from boardroom dynamics and ethical gray areas to team leadership and reporting strategy. Whether you're navigating organizational politics, benchmarking your finance team, defending a close process, or preparing for a career transition, this course offers both wisdom and practicality. You'll also find opportunities to benchmark your own practices against industry norms and peer organizations, helping you lead with greater confidence and clarity.

This on-demand self-study course addresses practical tips to help you, your clients and your organization to get through and manage a cash crisis. It is based upon the popular live webcast "Practical Tips to Get Through a Cash Crisis," originally broadcast in May 2020. During the course, you will receive practical advice and ideas to help manage issues brought on by the pandemic.

You can learn to deliver high-quality PC&R engagements consistently and accurately and explore the latest regulatory developments through this comprehensive online learning program.

Participants will go over the changes on preparation, compilation and review engagements using SSARS rules, followed by a general overview of how to perform these services. Participants will explore how to effectively perform these services through comprehensive lectures. Designed for practitioners in small and medium-sized CPA firms, the course includes detailed explanations and practical examples, with opportunities to deepen understanding through real-world case studies. This on-demand format allows you to retain a focus on practical application to enhance your skills and knowledge.

Your client just informed you of their terminal illness. What do you do from a tax, financial, insurance, investment, retirement, and estate planning point of view? Decisions you make before death lay the groundwork for planning choices after death. Randy Gardner discusses the strategies that will prepare you for the best post-mortem outcomes and help you put your client's mind at ease.

This course is designed to help any professional to learn how to deliver presentations that have an impact. Learn how to create useful slides, prepare your presentation, manage your nerves, set up the room and handle questions and answers. This webcast was originally broadcast on August 3, 2015. Note: There is a minimum passing rate of 70% for this course.

Simplifying financial reporting without compromising quality is the mission of the Private Company Council (PCC). By advocating for the needs of private companies, the PCC reduces unnecessary complexity, making financial reporting more efficient and accessible for stakeholders like lenders, creditors, and owners. In this must-watch segment, we're joined by two industry leaders, Jere Shawver — Chair of the PCC and CEO at Baker Tilly, LLP, and Phil Marciano — Partner at Citrin Cooperman. Jere and Phil offer valuable insights into how the PCC is reshaping financial standards and streamlining processes to benefit businesses and financial users alike.

The growing interest in private equity in accounting reflects a shift towards new growth opportunities, strategic investments, and competitive positioning within the industry. Allan Kotlin, CEO of Kotlin Consulting Group, addresses the growing role of private equity in the accounting industry and explores challenges in mergers and acquisitions, including the importance of cultural fit and leadership decisions. This includes discussion of how private equity affects profitability as well as strategies for staying competitive, such as mergers, private equity rollups, and partnering with big firms. He also covers how generational conflicts and changes in compensation impact younger partners.

Learn how to navigate tax regulations and reporting requirements for private foundations. Gain knowledge about excise taxes, income distribution calculations, and how to complete Form 990-PF. Identify transactions subject to excise tax, distinguish between grantmaking and operating foundations, and calculate the average fair market value of assets. Discover reporting requirements for both foreign and domestic grants, and explore topics like excess business holdings, self-dealing, and program-related investments. Understand the basics of Unrelated Business Income Tax (UBIT) and recent regulatory changes affecting net operating losses and alternative investments. Equip yourself with the knowledge to effectively manage private foundation tax compliance.

You'll learn to identify basic issues related to tax compliance for private foundations.

Workflow automation enhances efficiency by streamlining tasks and improving decision-making. Optimize collaboration, reporting, and AI-driven analytics in finance.

Learn how new productivity enablement and workflow solutions can help leadership teams work smarter, not harder - and increase their resource capacity to focus on strategies that prepare them for the future and deliver higher business performance.

You'll learn key information for delivering valuable and compliant forensic services, such as definitions, restrictions, and stipulations to consider when executing forensic engagements.

Prioritize your organization's response to growing distrust in business and consider the implications of your strategy.

Calculating economic damages can be complex. You'll examine the core concepts and methods related to business, individual, and intellectual property damages to better assist clients with these engagements.