Our blog

There are many basic features of Excel spreadsheets that staff can learn from checking out instructional videos online. However, there are limits to time available for your teams to search online finding how to work smarter and enhance efficiency. No two companies are the same and generic ‘how to’ guides only go so far when […]

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