Full Courses:
Excel for Finance Professionals – Learn forecasting, automation, and analysis
Power Query Masterclass: Advanced Data Cleaning & Automation
Demand Planning, Forecasting and Supply Chain Analytics with Excel and Power BI
In this video we will set up an amazing dashboard in microsoft excel from scratch. We will learn lots of concepts in this video. Some key concepts we will learn are:
- Pivot tables / slicers
- Data Analysis
- Custom formatting
- Working with shapes.
- Design and colors.
Timestamps:
00:00 - Intro
02:00 - Wireframing the dashboard
04:15 - Determine data points required
06:17 - Setting up workings and pivottables
22:00 - Building up the dashboard
31:30 - Final touches and formatting
#exceltipsandtricks #exceldashboard #pivottables #excelcharts #excelmacros