Professional Development and Event Catalog

Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through importing data, setting up calculated fields and columns, and creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood. 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 explores managerial accounting techniques with an emphasis on internal decision-making tools. You will appreciate a reminder regarding concepts you may not have considered since your college days. We will revisit managerial accounting concepts by illustrating practical examples that you can immediately bring back to the office!

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.  

Critics have claimed that traditional managerial accounting is at best useless and at worst dysfunctional and misleading. Most line managers do not trust their management accounting data. 21st Century management accounting develops cost/unit metrics that are useful for budgeting, cost analysis and control. Activity-based costing (ABC) brings truly accurate fact-based costing visibility. ABC does not broadly allocate overhead, but traces costs by identifying cause-and-effect relationships. Such information can provide the ability to reveal true profit margins for products, service-lines, specific sales channels and customers. The same information also helps reduce costs and improve productivity by reporting unit costs that you can use to monitor cost trends and benchmark against your competition. Removing the barriers caused by your current management accounting techniques can provide huge rewards.

Volatility and complexity are the new normal. Most organizations are drowning in data, but starving for information. The finance and accounting function has the opportunity to leverage Big Data and the continuum of analytics – descriptive, diagnostic, predictive, and prescriptive. All are useful for better decision making. Collecting, validating, and reporting data is not the same thing as analyzing information where we can glean valuable, actionable insights. In some ways the finance function is many years behind other disciplines such as marketing, sales, and supply chain managers, in applying analytics. How can the CFO’s function catch up?

Substantive Analytic Procedures - Strengthening Evidence to Satisfy Audit Objectives will provide the tips and best practice techniques for strengthening substantive analytic procedures in order to reduce over-reliance on tests of details. One of the ways to perform a more effective and efficient audit is to maximize the use of substantive analytic procedures in the detailed audit plan. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for analytical procedures. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In a competitive market, every company is looking for anyway to differentiate themselves from their competition. While we often look to new markets and data for a competitive advantage, ethics can be the factor that makes the biggest difference to customers, employees, and the public at large. Using surveys, research, case studies, and examples, this course will explore why the CPA credential and the AICPA Code of Professional Conduct is so different. We will discuss why CPA's are in a unique position of trust and how this can put their companies ahead. 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 provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Individuals may cite retaliatory concerns when weighing their decision to report an issue; during an investigation; or, after an investigation’s conclusion. No matter the timing, when an individual raises a retaliation concern, their claims should be taken seriously and fully reviewed. Does your organization analyze retaliation allegations and investigate outcomes as part of their cultural assessment?   Most organizations track retaliation matters at a general, non-specific level. The type of retaliation and the perceived cause of the retaliatory act are not delineated. When a retaliation matter requires investigation, an organization should gather key data points for trending purposes and to fine tune future training and policy initiatives. This course offers recommendations for (1) framing responses to retaliation allegations (2) capturing key data points (3) developing specific metrics for retaliation matters

In this course, we will share tips and tricks for working remotely.  You will learn what to do/what not to do in a virtual working environment, strategies for leading teams remotely, employee engagement ideas, and techniques and tools for teleworking.

The ACFE/COSO Fraud Risk Management Guide (FRMG) was published in 2016 (and updated in 2023).  It has quickly gained acceptance as the set of best practices for preventing, detecting, and thus deterring fraud. The fraud landscape is constantly changing and evolving. The FRMG sets out a rigorous set of principles and leading practices for managing fraud risk for forward-thinking organizations to follow.  It covers: How to establish fraud risk management governance. How to conduct rigorous fraud risk assessments. How to design and implement fraud control activities. How to establish reporting mechanisms and investigative procedures. How to monitor the overall fraud risk management program. Fraud risk can be managed.  All anti-fraud and accountability professionals will benefit from this session's focus on effective fraud risk management.

With the rapid pace of change, change now happens daily in business and our personal lives. It can be difficult to navigate change when right and wrong get a bit fuzzy. New processes, new technology, new circumstances and new impacts to people must be measured and decisions made as the change evolves. Change always becomes something different than what was originally planned or imagined. In this session, learn how to measure your ethics through change. You will learn how to filter everything you do during change through a simple litmus test. Through the power of story, you will learn from the lessons of other organizations and their ethical mistakes. Lastly, you will take away what is required to manage yourself so that when ethical decisions arise, you have the mental capacity to manage through it well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the many complex financial and tax accounting issues that are common in S corporation transactions, with discussion of common pitfalls and the new AICPA "small" GAAP accounting standards.

Financial accounting for trusts and estates is one of the least understood branches of accounting. It is not particularly concerned with recording income and expenses but is obsessed with determining whether receipts and expenditures are assigned to income or principal/corpus. This course will dive into this tricky area and provide a reporting guide for fiduciary accounting.

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.   

Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. Most 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 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 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. 

The COVID-19 pandemic has altered corporate and public accounting in ways we could never have imagined. This broad-based course will discuss accounting and auditing implications that have arisen as a result of the pandemic.