Make a beautiful interactive Excel dashboard in just 20 minutes.
🔥Take our BI for Business Analytics Course: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/gratfde3bh
In this tutorial we'll make an awesome, interactive Excel dashboard completely from scratch on the richest people in the world, where we can filter by certain criteria, navigate across the different sections, and refresh our data, and much more. Doing this efficiently has taken me years to learn, so let me show the full workflow step by step. First, we'll analyze the dataset to identify the relevant areas with pivot tables. Second, we'll lay out the dashboard structure with shapes and textboxes. Third, we'll create the KPIs (Key Performance Indicators) and charts / visuals like a combo chart and a bar chart. Finally, we'll make the dashboard dynamic with pivot table slicers and a navigation bar using hyperlinks so we can navigate across the different worksheets.
LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Dashboard Workflow
0:40 - Data Analysis
5:10 - Dashboard Structure
9:40 - Charts & Visuals
16:17 - Making it Interactive