Full Course: 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
Categories: Other, Product For Sale
Tags: Josh Aharonoff – CFO Excel Dashboard & Reporting
Size: 4.12 GB
Delivery: MEGA, GOOGLE DRIVE, FAST CLOUD, TORRENT, BOX
View Files (PROOF): Link
Sales Page: Link
Archive: Link
Reviews
There are no reviews yet.