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
Sales Page
Download Link for VIP Membership Users:
Download link is available for Lifetime VIP Membership members only. |
|---|
Already a member? Log in here
About The Author
