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 ...

Data cleaning is a crucial step in the data analysis process. Inaccurate, incomplete, or inconsistent data can lead to flawed insights and poor decision-making. Fortunately, Excel 365’s Power Query ...

Highlighting or even deleting duplicate records in Excel is simple but listing them isn’t as easy. Fortunately, you can use Power Query to easily display a list of duplicate values or records. Whether ...

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

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy. My TechRepublic article How to combine values from a column into a ...

For clients with monthly closing contracts, I send a "flash report" via email to the president or site manager as soon as the ...

Jeff's been involved in the IT industry since before the Internet and spent more than 20 years working in technical support, system administration, network administration, and consulting roles. He ...