On April 15, 2017
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
-PivotTable
-PivotChart
-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
Number of Attendees 16