-
Conditional Formatting
One of the simplest and most effective functions of Excel is Conditional Formatting. Data can become much more easily understood in a few clicks. What…
-
SEARCH or FIND in Excel?
The =SEARCH and =FIND functionality in Excel may sound very similar, and they are. I use =SEARCH when I’m trying to find text regardless of…
-
How to calculate Age from D.O.B in Excel
There are a number of ways to use formulae to calculate a person’s Age from their Date of Birth (D.O.B.) in Excel but I just…
-
How to use Stock Data Types
If you are looking to analyse stocks and shares in Excel then take a look at the Stock Data Type available in Excel 365. I…
-
How To Use Data Validation and Criteria in Excel
Do you want to know how to create dropdowns in Excel cells for users to select their input? Or forgotten how to do it? Then…
-
Text To Columns
The Text To Columns functionality in Excel is useful if you want to split a cell by a character within a cell. For example, in…
-
Install the Analysis ToolPak
The Analysis ToolPak is an Excel add-in that provides that provides data analysis tools to make developing complex models easier. The functionality is aimed at financial, statistical and engineering…