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:
Full youtube excel playlist:
Link to the file:
#exceltipsandtricks #exceldashboard #pivottables #excelcharts #excelmacros
Create Interactive Excel Dashboard In 5 Simple Steps #exceldashboard #exceltutorial #pivottable For Country: United States. City: Abilene, Billings, Des Moines, Palmdale, Sacramento
Tag: #Anchor, #pop over to this web-site, #source for this article, #visit this page, #try this
