In this post we explain how to add leading zeros to zero pad Excel values. We provide several example of how this can be accomplished. How To Add Leading Zeros to Zero Pad Excel Values Let’s consider that we have … Continue reading
Here we explain how to use double quotes in an Excel formula. We provide two examples on how to achieve this by escaping the quote character and by using the CHAR function. How To Use Double Quotes in an Excel … Continue reading
Sometimes when I’m analysing data, we need to use PowerShell to import data from Microsoft Excel. We generally have two quick options to do this. Let’s take this sample data: Save As a Comma Delimited CSV We can save our … Continue reading
I have a background in SQL, and sometimes in Microsoft Excel i need to perform a simple inner join on two datasets. In this blog I explain how we can perform inner joins with Microsoft Excel relatively quickly. Set up … Continue reading
There are multiple ways of using Excel to check if a value exists in another column such as manually using the ribbon, using a MATCH formula or using a VLOOKUP formula. Additionally there are clever things we can do to … Continue reading
Removing duplicate rows in Excel is something that we use regularly to verify the data in our business intelligence-led migration projects. Luckily for us it can be done in a few trivial steps. Removing Duplicate Rows in Excel First we … Continue reading
Using Excel to find duplicates in a column is a simple task that can often add huge value to the accuracy of our data. We typically use Microsoft Power BI to spin data and drive our migration projects. But in … Continue reading