Create interactive excel dashboard in 5 simple steps #exceldashboard #exceltutorial #pivottable

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: https://www.instagram.com/skillnator0/
Full youtube excel playlist: https://www.youtube.com/playlist?list=PLzLUxjmulsaVNouPDa1aYJG1I-Doi_qS_

Link to the file: https://drive.google.com/drive/folders/1ZsA2-2knQSnrteNWJ13UL67xTS4zHBFX?usp=share_link

#exceltipsandtricks #exceldashboard #pivottables #excelcharts #excelmacros

Видео Create interactive excel dashboard in 5 simple steps #exceldashboard #exceltutorial #pivottable канала Skillnator