Make Interactive Excel Dashboard in Just 12 Minutes

📂 Get the dataset here: https://payhip.com/b/2b7DW

✨ Want the finished dashboard? Get the complete, fully editable file here: https://payhip.com/b/JUZSl

✨ Ready-to-Use dashboards & templates:

https://payhip.com/MarizDigital

Build an Interactive Excel Dashboard in just 12 minutes. In this video, we will build an automated excel dashboard from scratch using the sample data provided below. First, we prepare the base of our dashboard by removing the gridlines and adding color on the entire sheet. Then we will outline the overall structure of the dashboard using shapes. Next, we will connect our metrics using text box, the formula bar, and the metric value on our pivot tables. After that, we will create charts as our visualizations – stacked column chart for Sales vs Target per month, smooth line chart for total customers per month, and bar chart for profit per region. Since our charts is based on Pivot Tables, by default, messy Field Buttons appear on our charts. We will also show how to remove these buttons. Then we will customize our dashboard and finally add slicers. The slicers make our dashboard automated by providing buttons that we can click to filter data at once.

📺FREE COURSES:

EXCEL: https://youtube.com/playlist?list=PLjHKwibbH7DxtALrABq6tZXcVHU6Y5bw8&si=HiUD_id77DsWQETO

TABLEAU: https://youtube.com/playlist?list=PLjHKwibbH7DwPtqRqeHREA6pHWpV7_SLe&si=-kCz2dLcv9JSmGnC

POWERPOINT: https://youtube.com/playlist?list=PLjHKwibbH7Dz8_KzBKaCTgBSjUwfESm4g&si=NuHeQ5xyT-MnOEZh

STAY CONNECTED:

🔗: https://linktr.ee/marizcaranguian

BUSINESS/PARTNERSHIP INQUIRIES:

💌: itsmariz.business@gmail.com