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