Our blog

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

There are over 200 Excel keyboard shortcuts, so we’ve compiled a list of 15 of the most useful ones.   Next worksheet / Previous worksheet Sometimes you need to switch between different worksheets in the same workbook. You can do this by using: Control + Page Down (Windows) Or Fn + Control + Down arrow […]

When there is a large set of data and duplicates need to be removed, this would be nearly impossible to do manually. However, Excel has a very simple function that makes removing duplicates from data very easy. Highlight the data that you want to remove duplicates from. Click on the data tab and click Remove […]

Most non-Excel users believe that spreadsheets are only useful for financial professionals and accountants. However this is not true as Excel is available on all computers and is brilliant for data analysis, graphs, calculations, statistics and much more. Here are some of its less known but impressive features. Conditional Formatting This analysis tool highlights data […]