lavinch

On April 2, i attended an Excel workshop taught be Anthony in JC.
I always considered myself proficient in Excel, but at the conclusion of the workshop, i was surprised by how much i didn’t know about that program.
Some of the things that i have learned were:
* How to connect Excel to Access to get data for the dashboard
* How to create pivot tables from external data in MS Access
* How to make charts from data in pivot tables
* Putting the charts together in the dashboard (and adding form controls)
* Adding macros to control the dashboard (and refresh data, animate charts etc.)
* Final formatting touches to make it look better
Anthony seemed to be very knowledgeable and his commentary was always insightful and practical. In this training, he brings all his experience to teach us how to make better dashboards, charts, how to connect to external sources and how to manipulate pivot tables.