(962) 77 - 5939376

Excel Dashboard by Pivot Table

JAMA conducted a half day “Excel Dashboard by Pivot Table” workshop led by Mr. Yahya Hussein. The workshop targeted intermediate Excel level where it tackled

-Data Structure
-Dynamic Data for PivotTable
-Multi Report by on Click
-See Detail Behind One Number in a Pivot Table 
-Conditional Formatting in PivotTable 
-Percent of Parent, Rank, Running Total In and other Report Tricks
-Create a Year-over-Year Analysis  Grouping in
-PivotTable by data Type  Timeline in PivotTable
-Dashboard By PivotTable, Pivot Chart, slicer and time line