Our blog

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

Tatsuo Horiuchi is a 73 year old Japanese man who has discovered how to do something rather incredible. He was soon reaching the retirement age and was in search of a hobby. He had been interested in graphic design for some time but had never done anything about it. As he was looking for graphic […]

 Being able to check that the criteria of data entered in to a cell range is useful function in Excel, but now you are able to determine the criteria in a number of cell ranges. In earlier versions of Excel, you can use the COUNTIF function to check a cell range for a single criteria, […]

The formula you use to merge cells in excel is typing &” “& between each selected cells and then press Enter on the formula bar. e.g   =A1&” “&B1&” “&C1” By leaving a space between the &” “& you will have a space between the data, entering  &”, “&  will separate the data with a comma. […]