If you work in industry and get reports on a regular basis then Excel data connectors can save you lots of time and automate a lot of the work you have to do.
What is a Data connector? - It allows you to connect a source file or data source into a table in your excel file and just by hitting refresh you can pull the latest data into the table. The imported columns can be used as the source for additional calculated columns to fix the most common issues with imported data.
Like what? - Additional spaces can be removed with a Trim Column - incorrectly formatted dates can be fixed with a substitute column..
More to follow...
I'm busy working on my blog posts. Watch this space!