📈 Excel for Business & Finance - Build an Interactive Excel Dashboard From Scratch

How to build a dynamic and interactive Excel dashboard from scratch. 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/626c3ec146c9ddac82189452 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 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/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🏦 The Investment Banking Program: https://www.careerprinciples.com/career-track/the-investment-banking-program 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 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.