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
Instagram: / skillnator0
Full youtube excel playlist: • Microsoft Excel
Link to the file: drive.google.com/drive/folder...
#exceltipsandtricks #exceldashboard #pivottables #excelcharts #excelmacros
Негізгі бет Create interactive excel dashboard in 5 simple steps
Пікірлер: 248