Our blog

Using the IF function in Excel can be very useful in a spreadsheet. The IF function will allow you to check if a condition you have set is true or false. You can use the IF function in a formula to give a result, depending on whether the data expressed in a cell meets the […]

Making a graph in a Excel spreadsheet is fairly simple and can be used to show data in a more visual format. There are different types of graphs available including, column, bar, line and pie charts. The type of graph that you use in a spreadsheet depends on the type of data results you need […]

Sometimes when you are using Excel spreadsheets, you may find that you need to check cells for duplicate values,  for example if you have merged data from two worksheets into one and you have to check if data has been duplicated. There are various ways of  finding the duplicate values in content, but the simplest […]

One advantage of saving an Excel spreadsheet as a PDF file is that it allows someone to view the spreadsheet without owning the Microsoft Excel program. All they would need to view the PDF file is a PDF reader, such as Adobe Acrobat which is available for free download. Please note, you will only be […]

 If you find that you have a lot of data to enter on your spreadsheet, it may be a good idea to create a drop down list to allow your users to enter data more easily. Having a drop down list will allow you choose from a set number of entries, so saving time. The […]

If you are working in an excel spreadsheet there may be times when you are looking at a large area of data and you may need to keep areas of the worksheet visible when you are scrolling to make managing your data easier through simplistic visualisation. You can do this by using the Freeze Frame […]