Build an Interactive Excel Dashboard From Scratch

Kenji Explains
Kenji Explains
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.
2 سال پیش در تاریخ 1401/02/11 منتشر شده است.
246,978 بـار بازدید شده
... بیشتر