Data-Pivot

  
    Data-Pivot

Pivot Table to Explore Data Fields

Excel 
 > Click on Data Table 
   > Ctrl + Home                 = Go to Cell A1
     Ctrl + Shift + Down + Right = Select the whole Table
     Insert > Pivot Table > New Worksheet
     > New Worksheet > Rename to "pivot" (or your choice)
       > Drag a 1st field into the Rows section
       > Drag a 2nd field into the Rows section
       > Rearrange fields to your preferred sequence
       > Convert from Stagged Style to Tabular
         > Click into Pivot Table > Design
           > Subtotals     > Do Not Show Subtotals
           > Grand Totals  > Off for Rows and Columns
           > Report Layout > Show in Tabular Form
           > Report Layout > Repeat All Item Labels
 > Copy Paste Entire Pivot Table
   > Amend the copy to a explore new fields
   > Repeat as needed
  

Data-Pivot

  
    Data-Pivot

Pivot Table, Pivot Chart

Excel > Insert > PivotChart > PivotTable & PivotChart
> Select a table or range = <Worksheet Name>
  > x        = Axis (Categories) 
    y        = Values            > Value Field Settings = {Sum, Count, Average, ...}
    split by = Legend
    filters  = _
> Pivot Chart
  > Top-Right > "+" Sign 
    > Axes
      Axis Titles
      Chart Title
      Data Labels
      Data Table
      Error Bars
      Gridlines
      Legend
      Trendline >  

  

  
    -----------------------------------------------------------------------
Dashboard
> Copy worksheet with Pivot Chart
  > In the new copy
    Insert > Slicer
-----------------------------------------------------------------------

  

Contact