Our blog

There are a number of steps you can take to help ensure accuracy and help prevent errors in a spreadsheet: Design the spreadsheet to allow for growth and with a clear view of the purpose. Always protect cells where possible Turn off auto complete or the automatic conversion of data if relevant. Use drop downs […]

Slicers act as visual filters, allowing you to filter and visualise your data as either in a table or as a chart. You can easily create Slicers in Excel. First enter your data into Excel and put it into a table with headers. 2. Highlight your data in the table, click the design tab and then […]

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 […]