Excel Magic (Part 8): Transforming a Pro-forma into a Dashboard (Video) (Course Id 2222)

• Who is this course for?
  This course is intended for CPAs, accountants, and other professionals who require Continuing Professional Education (CPE) and have basic Excel skills, including experience with Pivot Tables and Power Query.

• What is this course about or what problem does this course solve?
  This course addresses the limitations of traditional pro-forma reports and provides practical solutions for transforming them into interactive, self-service dashboards using Excel.

• How can the knowledge from this course be used?
  Learners can use the knowledge to create more dynamic and functional Excel dashboards that track vessel hire data, calculate net revenues, and present budgets versus actuals effectively.

• Why is this course important to a CPA, Accountant, or IRS Enrolled Agent?
  It equips financial professionals with advanced Excel techniques that enhance reporting capabilities, making financial data more accessible, insightful, and useful for decision-making.

• When is this course relevant or timely?
  The course is particularly timely for professionals working with financial models or operational data who need to modernize their reporting methods; it was updated as recently as February 2024.

• How is a course like this consumed or used?
  The course is delivered as a self-study video format under NASBA QAS standards, with interactive review questions and a final exam, and can be completed entirely online.

The Pro-Forma course is presented in three parts.

First, the course reveals the 3 shortcomings of presenting a pro-forma report. They are:

• Hard to slice and dice
• Hard to build a collapsible table on timeline
• Not for self-service

Next, the course presents 3 challenges in building a Pro-Forma financial statements report and provides solutions for the challenges. They include:

• How to Track On-hire Days for Each Vessel?
• How to Track Daily Hire Rates for Each Vessel?
• How to Calculate Net Hire Revenues?

Last, the Pro-Forma course presents another 3 challenges in building a Dashboard report and provides solutions for the challenges. They include:

• How to convert Pro-forma report to a Dashboard report?
• How to build the Slice-and-dice function of a dashboard?
• How to display budgets, actuals, and off-hires all in one chart?

Video - NASBA QAS - NASBA Registry - 2222

Course Learning Objectives

• Understand when and how to build a pro-forma report or a dashboard report
• Master the “golden” formulas to track days based on start/end dates and this/next periods
• Discover the way to model “staggered” daily rates and summarize into one table
• Recognize how to convert a cross-table to a flat-table
• Understand how to build a self-service dashboard that enables slice-and-dice

Chapter 1 - Excel Magic (Part 8): Transforming a Pro-forma into a Dashboard

Chapter 1 Review Questions

Glossary/Index