CFO Dashboards
Data Organization & Visualization:
Creating Engaging & Effective Financial Dashboards
This allows them to act fast in making vital decisions
Learning how to provide this data in a visually compelling way has been one of the biggest game-changers in my career.
Presenting the data is not enough - without proper design, important data points can get overlooked and messages can get confused or lost entirely.
By creating engaging and effective financial dashboards, you'll add tremendous value to CEOs, the executive team, board of directors, and other key stakeholders.
Enhanced visualization
Real-time monitoring
Efficient financial analysis
Budget-to-actuals comparison
Key Performance Indicator (KPI) tracking
Customizable reports
Course Intro
FREE PREVIEWHow to use this course
Using design principles to captivate your audience
Your Tech Stack
Overview
Creating Tables + Adding additional context - Part I
Creating Tables + Adding additional context - Part II
Using PowerQuery to transform your data
Setting Dates
Creating a Summarized Profit & loss
Creating a Summarized Balance Sheet
Creating a Summarized Cash Flows
Creating Custom Periods & Sections
Measuring Period over Period Changes
Getting Data Ready for Dashboards
Creating Date Selectors
Creating our first KPI
Finishing the KPI dashboard
Creating a KPI Dashboard with a graph
Mid-Course Feedback
Creating a KPI Dashboard with a dynamic spill array
Budget vs Actuals - Part I - Designing our tables
Budget vs Actuals - Part II - Creating our gauge charts
Budget vs Actuals - Part III - Finalizing our design
Management Report
Cash Out Dashboard
Creating a Cover Page in Excel
Creating dashboards using PivotTables
Creating Dashboards using PivotTables: PivotTable Profit & Loss
Creating Dashboards using Pivot Tables: Using Pivot Charts
Break Even Dashboard
Spotlight Dashboard - Pulling in the data
Spotlight Dashboard - Designing the dashboard
Final Thoughts
Supercharge Your Data Analysis with Bonus Templates!
This course is for Finance & Accounting professionals looking to take their financial reporting & excel skillset to the next level
We will start off covering how to structure our data so that it is easily refreshable and scalable to use in our dashboards & reports. We will then create various reports & dashboards in a dynamic & visually appealing manner.
You can purchase just the templates, or the full course with the templates, handouts, and videos showing you how to create each dashboard & report. We also offer an option where you can send us your data, and we will send you back a file with these dashboards connected to your dataset.
The only tool you will need is Microsoft Excel, however, it is also encouraged to have a license for Microsoft PowerPoint and a 3 Statement Model that we will use to create our dashboards & reports. If you do not have a 3 Statement Model, you can utilize the templates included with the course.
PowerBI and other data visualization tools are great and can add tremendous value to your dashboards. This course focuses on maximizing what you can do with Microsoft Excel, given how widely used & easy to manage it is.
You will get lifetime access to this course.
The course is entirely on demand, so you are welcome to start and pause at any point.
Your CFO Guy is committed to helping you understand the basics of 3 Statement Model. As such, we offer a 30-day money-back guarantee. If you are not satisfied with the course, you can request a full refund within 30 days of your purchase.
To be eligible for a refund, you must have completed the course within 30 days of purchase and must provide proof of course completion. If you have any questions or would like to request a refund, please contact us at [email protected] within 30 days of purchase.
We are dedicated to helping you succeed, and we are confident that the Intro to 3 Statement Model course will help you do just that.