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
![](https://2.bp.blogspot.com/-K0FGjsUwT0g/WTLJEbsL3PI/AAAAAAAAM2Y/qSSeZou600cGrLMZGf1ue3c-1eNT1E4-ACLcB/s320/JAMA%2B%25281%2529.jpg)
![](https://3.bp.blogspot.com/-OjnUxTSMn9U/WTLJQpBZX4I/AAAAAAAAM2o/PMJvdLysjzAu2mitU6ooBhOXgQCLIdT2gCLcB/s320/JAMA%2B%25282%2529.jpg)
![](https://3.bp.blogspot.com/-V92Z8uPbdUQ/WTLJel1hPsI/AAAAAAAAM20/OcovwnzDIJkD79ziboDMgMr_XxLV55r7ACLcB/s320/JAMA%2B%25283%2529.jpg)
![](https://1.bp.blogspot.com/-lUDNy9e-cDM/WTLJlk09-QI/AAAAAAAAM24/U9S1eGx722sAHPlPKXUqKKptYo7SKGz4ACLcB/s320/JAMA%2B%25284%2529.jpg)
![](https://2.bp.blogspot.com/-l0Wo0FGbiWY/WTLJnAn8anI/AAAAAAAAM28/eWhlRikfn3I6cgd0X05YwF7qt-2nIhbjQCLcB/s320/JAMA%2B%25285%2529.jpg)
![](https://1.bp.blogspot.com/-Gq62uZnoNYc/WTLJqwSAGgI/AAAAAAAAM3A/B44KYL1edSkzZ-krNr8k0N_CAgDpdbphwCLcB/s320/JAMA%2B%25286%2529.jpg)
![](https://1.bp.blogspot.com/-i99zSmTJJK0/WTLJs068VzI/AAAAAAAAM3E/O9DsXsfiXe8-Ymo7haxyv-1e5dCyuLx7wCLcB/s320/JAMA%2B%25287%2529.jpg)
![](https://1.bp.blogspot.com/-wR6ZDWwNElg/WTLI_Ii7eiI/AAAAAAAAM2Q/Z26qU-jbgbwKKeZPDuIJKZ73YaidrulwgCLcB/s320/JAMA%2B%252811%2529.jpg)
![](https://2.bp.blogspot.com/-5BOpGqNQV-w/WTLI_V6tp3I/AAAAAAAAM2U/U0KB62MiA64-H2AlawovGgKWScTaqe5ngCLcB/s320/JAMA%2B%252812%2529.jpg)
![](https://3.bp.blogspot.com/-_9FriDJq0zw/WTLJGpSVbTI/AAAAAAAAM2c/2mXqqnbuZl09z_JbkMczc2IbNjngGhsBgCLcB/s320/JAMA%2B%252816%2529.jpg)
![](https://3.bp.blogspot.com/-E43G99rYUqE/WTLJHf1yxkI/AAAAAAAAM2g/sLIVWt5uPGAo3crfoyiswAqB-PsjIQ2CgCLcB/s320/JAMA%2B%252819%2529.jpg)
![](https://4.bp.blogspot.com/-ALyKbRIGUxU/WTLJQOW1IsI/AAAAAAAAM2k/4tMvPkmSYLsV9Wx8ok8JfHc6-3hHYis8QCLcB/s320/JAMA%2B%252820%2529.jpg)
![](https://4.bp.blogspot.com/-4564_8V8e70/WTLJREvk2pI/AAAAAAAAM2s/VmKLSFCWTPoZiw3jRJ2A9nLtJVl6ZisUgCLcB/s320/JAMA%2B%252821%2529.jpg)
![](https://2.bp.blogspot.com/-ynSHf7aDNEc/WTLJTpRDRFI/AAAAAAAAM2w/SOq23iFxMpIEdrQZDH7TMfzfAkQMVbOlwCLcB/s320/JAMA%2B%252823%2529.jpg)