I have used a pivot table a lot in my previous role. It was mostly used to just create a table and a line graph where it would show the number of department problems that would arise every month and how many were solved in a particular month and if there's any backlogs or if there was any cases where it was escalated. So it would keep a track of all that and it would be automatically updated. And then the other thing that I would use a lot is macros. It usually helps shorten my work and makes it a really quick work.
