Our blog

Round a Number in Excel In the example below there are 7 employees A to G and their monthly sales total. This is how you would round these numbers up to the nearest £1. Using the formula =ROUND(C3/1,0)*1 you can easily round the monthly sales total to the nearest £1. In excel you can use […]

Creating a chart in Excel allows you to visualise your data and make more sense of it. Here’s how to create a chart. Highlight the required data Select ‘Insert’ to choose either a chosen chart, or a chart type recommended by Excel Insert the chart Add titles, axis labels and colours for professionalism Excel offers […]

The IF function in Excel can be very helpful for data analysis and conditional formatting. Below is an example of a way that the IF function can be used. The general formula for an IF function is: =IF(cell value, “value if true”, “value if false”) . For a value “greater than” you use > For […]

Working with Excel inevitably means handling data, but sometimes this data comes from a source other than Excel. This can be from a text file, word document, webpage or any other source. Usually copying and pasting data doesn’t format correctly, leading to errors and poor data security. In the example below we are trying to […]

If you have a large amount of data that you need to find the sum of, rather than doing =SUM(C3+C4+C5) etc. there is a much quicker way to manage your data. By using the formula =SUM(C3:C21) you are automatically including every cell between and including C3 to C21. Then press enter and your sum will […]

Conditional formatting in Excel allows you to format a single cell or group of cells according to the data within them. In Excel you can chose to format a cell with highlights, data bars, colour scales or icons due to the rules that you can set; ultimately opening up endless data visualisation possibilities. If you […]