Master Excel Dashboard KPIs: Essential Tips & Tricks 📊

Learn how to create a dashboard fort KPI in Excel. Add Background 1) Insert ~ Shapes ~ Rectangle 2) Insert a rectangle 3) Shape Format ~ Shape Fill set to white 4) No outline 5) Add shadow (Outer Bottom Right) 6) Resize and reposition text box Title 1) Insert ~ Textbox 2) Enter title 3) Font size 24 Bold font 4) No fill and no border 5) Resize and reposition text box Total Sales 1) Copy and past title 2) =$C$19 3) Font type to Impact Font size 20 4) Fill = light green 5) Add shadow (Outer Bottom Right) 6) Resize and reposition total sales text box to make it look like a wrap around ribbon Add Sparkline Bar Chart 1) Select D21 2) Insert ~ Sparklines ~ Column 3) Select Sales column for 2024 4) Enter 5) Sparkline ~ High Point 6) Ctrl + C 7) Right-click ~ Paste Special... 8) Linked Picture 9) Resize and reposition Linked Picture . #tips #excel #microsoft #howto #tricks