Best Blackhat Forum

WHAT YOU GET?
 
Intro and 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 and Loss
 Balance Sheet
 Cash Flows
 Custom periods and 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 and 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