Josh Aharonoff – CFO Excel Dashboard & Reporting
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
Sale Page
Course Price : 499$
Our Price : 30$
INSTANT Delivery Course
WHAT YOU GET?
Intro & Getting Started
Course Intro Your Tech StackOrganizing Your Data
Overview Creating Tables + Adding additional context – 1st video Creating Tables + Adding additional context – 2nd video Using PowerQuery to transform your dataCreating Summarized Financials Report
Setting Dates Profit & Loss Balance Sheet Cash Flows Custom periods & sections Measuring Period over Period ChangesCreating 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 RemarksSale Page
Code:
https://www.yourcfoguy.com/courses/cfo-dashboardsCourse Price : 499$
Our Price : 30$
INSTANT Delivery Course