Are you looking for a very quick and very easy way to show data visualisations in Excel? Then take a look at Data Bars from the Home ribbon. Data Bars…
Posts published in “Data Analysis”
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 is conditional formatting? It’s when…
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 want to share my preferred…
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 wish this had existed 20…
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 read on and I will…
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 the data below we want…
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 data practitioners. Users provide the…