At the end of every month, about 30 CSV files, one for each branch, pile up in a folder. I open the files, select all, copy, and paste them into a summary workbook. Doing this 30 times takes about 40 ...

Did you know that data analysts spend up to 80% of their time cleaning and preparing data? If you’re nodding in agreement, you’re not alone. The good news is that tools like Power Query in Excel and ...

If you are working with Excel spreadsheets or workbooks, juggling multiple tables of data, at some time you might need to combine them into one. Rather than spending hours manually copying and pasting ...

Are you opening Excel files for the same purpose that arrive monthly from various branches one by one and pasting them to the ...

Upgrade your Pivot Tables in Excel with Power Pivot! This video covers how to use Power Pivot to analyze multiple Excel ...

There are some nice improvements to Power Query integration in the latest version of Power BI Report Builder that, while they are documented, didn’t get an official blog post but which I think deserve ...