Build an Interactive Excel Dashboard From Scratch
246.9 هزار بار بازدید -
2 سال پیش
-
How to build a dynamic
How to build a dynamic and interactive Excel dashboard from scratch.
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/626c3e...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
In this video you will learn create an interactive excel dashboard step-by-step. We'll start with a large dataset on beverage giant coca-cola. Once we convert this dataset into a table, we'll start our dashboard analysis. First, we'll create summary of the key financial figures using sums and averages on pivot tables.
Then, we'll create a monthly breakdown for the products using a pivot chart and a timeline so you can update the length according to your needs.
Thirdly, we'll create a breakdown by region using pivot tables and a map chart of the US.
Lastly, we'll make the dashboard dynamic / interactive using pivot table slicers and making sure to filter the connections so everything updates automatically.
LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS
📝 Investment Banking Recruiting Course: https://learn.careerprinciples.com/co...
SOCIALS:
📸 Instagram - Instagram: kenji_explains
🤳 TikTok - https://www.tiktok.com/@kenjiexplains...
GEAR:
📹 My Favorite Books & Gear: https://kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Summary of Key Financials
2:50 - Area Chart
4:58 - Monthly Sales Chart
5:04 - PivotChart Timeline
7:33 - Map Chart
10:18 - Making Everything Dynamic With Slicers
12:28 - Customizing the Dashboard Layout
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/626c3e...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
In this video you will learn create an interactive excel dashboard step-by-step. We'll start with a large dataset on beverage giant coca-cola. Once we convert this dataset into a table, we'll start our dashboard analysis. First, we'll create summary of the key financial figures using sums and averages on pivot tables.
Then, we'll create a monthly breakdown for the products using a pivot chart and a timeline so you can update the length according to your needs.
Thirdly, we'll create a breakdown by region using pivot tables and a map chart of the US.
Lastly, we'll make the dashboard dynamic / interactive using pivot table slicers and making sure to filter the connections so everything updates automatically.
LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS
📝 Investment Banking Recruiting Course: https://learn.careerprinciples.com/co...
SOCIALS:
📸 Instagram - Instagram: kenji_explains
🤳 TikTok - https://www.tiktok.com/@kenjiexplains...
GEAR:
📹 My Favorite Books & Gear: https://kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Summary of Key Financials
2:50 - Area Chart
4:58 - Monthly Sales Chart
5:04 - PivotChart Timeline
7:33 - Map Chart
10:18 - Making Everything Dynamic With Slicers
12:28 - Customizing the Dashboard Layout
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
2 سال پیش
در تاریخ 1401/02/11 منتشر شده
است.
246,978
بـار بازدید شده