Data Analyst and Technical Consultant

Tag: excel

VLOOKUP and IFERROR

VLOOKUP and IFERROR

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.

Logical Excel Functions

Logical Excel Functions

Here are five more useful functions to use in Excel.  This time, logical functions that return a result based on the conditions

Remove duplicates from an Excel list

Remove duplicates from an Excel list

Here’s how to remove duplicates from an Excel column in a few clicks.

Splitting a cell – Text to columns

Splitting a cell – Text to columns

Here’s how to split a cell into two, or more, in a few easy steps using the Text to Columns wizard.

Five Excel String Functions

Five Excel String Functions

Here are five more useful functions to make life easier in Excel.  This time we’ll look at string functions for dealing with text and start to explore date functions.

Five Excel Text Functions

Five Excel Text Functions

Excel functions make your life easier to calculate, analyse and clean up data. These five functions convert text so it’s consistent.