Our blog

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

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