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