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 3
Working with PivotTables
Content Locked
Section 2
Constructing PivotTables (part 2)
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;} You are importing your PowerPivot data into PivotTables, but you need to use an advanced chart type to display your data. We'll create an intermediary table that will give us a higher level of control of the chart. - Insert a new PivotTable into your Excel workbook - Below the PivotTable, create an intermediary table using VLOOKUP - Fill your intermediary table with this dynamic formula to reference your PivotTable data in the precise format that you need