How to monitor productivity within departments using Microsoft Exc
 

I'm gathering production numbers for all 7 internal departments within our
work unit, I would like to know if this can be done in Excel? The info that I
would like to share will be daily with monthly tabs allowing all supervisors
access to this document, but, each dept., will have various columns and rows
of information provided. (Is there a way to simply this task in Excel?)