Home » Our Blog » Excel Data Cleaning and Reporting » Functions

# Excel – Using VLOOKUP to compare two lists

If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two lists or columns of data.

Years ago the Training and Development manager of a large organisation invited me to spend some time in their Accounts department in order to observe how the Accounts team dealt with their day-to-day tasks. My job was to report on any process that could be improved using Microsoft® Excel. Read more

# Excel – How can I do a VLOOKUP based on more than one value?

There are times when you want to return a match for a VLOOKUP based on more than one value.  For example, we may have customers who have multiple branches.  Each branch is recorded under the same customer number.  So how do we look up info for a specific branch if all of the branches are using the same customer number?

# Excel – change text to uppercase, lowercase or first capital

PROBLEM: having to retype text when your data is in UPPERCASE, lowercase or a Mix oF bOTH.

SOLUTION: quickly change the text back to the proper case without having to retype it. Read more

# Excel – remove unwanted spaces from a cell

PROBLEM: needing to remove unwanted spaces in Excel data. Doing it manually will suck up most of your day!

SOLUTION: get to know the Trim function and save yourself time (and headaches). Read more

# Excel – How do I move the negative sign in front of the number?

Anyone that regularly imports data into Excel will be familiar with the process of “data cleaning”. This is where you need to remove spaces and irrelevant data in order to get the data fit for use in Excel.

I recently had an excellent question regarding working with data imported into Excel where negative numbers are imported with the negative sign to the right of the number, e.g. 500-. These numbers are commonly referred to as “mirrored negatives”. Read more