Josh Aharonoff – CFO Excel Dashboard & Reporting
Really great, well-structured and very helpful course.It includes lots of practical tips and knowledge. I would recommend to anyone in the field of Finance and Accounting.
View Files (PROOF): Link
Sales Page: Link
Archive: Link
DOWNLOAD
You have to be logged in and our VIP Members to see the Download Links
WHAT YOU GET?
Intro & Getting Started
Course Intro
Your Tech Stack
Organizing Your Data
Overview
Creating Tables + Adding additional context – 1st video
Creating Tables + Adding additional context – 2nd video
Using PowerQuery to transform your data
Creating Summarized Financials Report
Setting Dates
Profit & Loss
Balance Sheet
Cash Flows
Custom periods & sections
Measuring Period over Period Changes
Creating Dashboards
Getting Data Ready for Dashboards
Creating Date Selectors
Creating our first KPI
Finishing the KPI dashboard
Creating a KPI Dashboard with a graph
Creating a KPI Dashboard with a dynamic spill array linked to a chart
Budget vs Actuals pt I – designing our tables
Budget vs Actuals pt II – creating our Gauge charts
Budget vs Actuals pt 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 Pt I – pulling in the data
Spotlight Dashboard Pt II – Designing the Dashboard
Closing Remarks
DOWNLOAD
You have to be logged in and our VIP Members to see the Download Links
Discover more from 9WSODL
Subscribe to get the latest posts sent to your email.