In this post I’ll be introducing three Excel tools I use for data cleansing that take only a few clicks.
Here are six more useful functions to use in Excel. This time, logical functions that return a result based on the conditions.
VLOOKUP lets Excel do the hard work of matching up a value from one spreadsheet to another. It saves time and is an essential Excel tool.
If you’re new to Google Sheets there are some great addons you can use to add functionality and make it feel more like Excel
There are some simple things you can do to make the message clearer and quicker for the user to understand.
Here is the second part of my Excel series showing the tools I use for ad hoc analysis and data cleansing.
Microsoft Excel should be part of your analysis toolkit for ad hoc analysis and data cleansing.