Josh Aharonoff - CFO Excel Dashboard & Reporting
Josh Aharonoff - CFO Excel Dashboard & Reporting Josh Aharonoff - CFO Excel Dashboard & Reporting . File Size - 4.11 GB . 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 Power Query 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...