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