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:

About The Author

wsodownloadhub.com

See author's posts