How do I quickly compile a single PowerPoint presentation from slides saved in multiple files?

As a reporting analyst, part of my responsibilities involved compiling the monthly review slide deck for senior management Whilst it was not a difficult task, it was a pretty boring and time consuming one. Every month, I had to to compile 10 decks, each consisting of 70 slides, which had to be updated to show … Continue reading How do I quickly compile a single PowerPoint presentation from slides saved in multiple files?

How do I re-filter only selected Pivot Tables in my workbook?

I had an interesting case a couple of years back, which resulted in quite a bit of head-scratching on my part. I was working as a reporting analyst and one of my key deliverables was to produce a monthly analysis of the hours that our consultants had logged on different projects. The analysis was to … Continue reading How do I re-filter only selected Pivot Tables in my workbook?