Book Image

Excel 2013 Dashboard Design [Video]

By : Anthony M Kau
5 (1)
Book Image

Excel 2013 Dashboard Design [Video]

5 (1)
By: Anthony M Kau

Overview of this book

Discover the art of creating dynamic Excel dashboards in our comprehensive course. From planning strategically to empowering users and connecting to data sources, each step is meticulously detailed. Learn the vital concepts of Excel Dashboard Design and why they're crucial for modern data-driven decision-making. Follow a structured journey from conceptualization to distribution, empowering you to create impactful dashboards efficiently.
Table of Contents (8 chapters)
Chapter 6
Adding Interactivity
Content Locked
Section 2
Customizing Slicers
Normal 0 false false false EN-IN X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-fareast-language:EN-US;} If the default slicer settings and color scheme is not acceptable for the dashboard, we can customize them. - Setup any column and row headers in your dashboard - Use a formula that can handle blank cells to reference the cells in your PivotTable; for example, =if(D4=0,"",D4) - Select every other row and change the fill color to simulate banded rows; you can alternatively format the cells as a table