# Formula and Functions

## How to remove the first word / Name Salutation from a string in Excel

This guide will show you some quick and easy steps to removing the first word from a string in Excel. This is perfect for that situation where you have name salutations to remove from a data field, for example where…

## How to find the Last Value in a row Excel formula

Finding the last value in a row of data is a great technique to learn in Excel and this post will show you how. The method is very useful when creating Excel dashboards and automating any kind of regular Excel…

## How to convert a date into a month name in Excel 2010

A useful trick to learn in Excel is how to convert a date such as 01/01/2014 into a month name, such as January or ‘Jan’.  Read on to find out how to convert a date to a month name in…

## How to show the current date or time using Excel 2010

There are two easy-to-remember functions in Excel 2010 that should be in all Excel analysts repertoire.  With a wide array of uses in reporting and Excel dashboard creation let me introduce you to them…      The Today() function If…

## How to lookup a value in Excel based off the row and column

There are times as an Excel analyst where you will need to lookup a value in a table based off the row and column, or based off two values.  This can seem tricky at first if you do not know…

## How to add leading zeros to a cell value in Excel

If you need to add leading zeros to a value in Excel there are two methods that you can use, depending on whether the result you want is a numeric or text value.  To find out how to add leading…

## How to link to cells on different worksheets in Excel

With Excel used to create large reports you will often find a need to link a cell value on one worksheet to a different worksheet in the same file.  This is simple when you know how so read on to…

## How to use a VLOOKUP in Excel

The VLOOKUP function is a powerful way of looking up data from one table and pulling it into another, this is useful for all sorts of tasks in where combining various data tables into one is required.  If you are…

## Removing blank characters, AKA Non-breaking spaces, from Excel text strings

If you have an issue where Excel’s TRIM function does not appear to be removing the blank spaces in your text string, or you are trying to remove blank characters/non-breaking spaces from a text string then read on to learn…

## How to Round numbers up or down in Excel

This quick and easy guide will explain how to use the ROUND formula in Excel in order to round your numbers up or down by a chosen amount of decimal places… The Round Formula in Excel Apart from certain occasions…