Ready to chat data? That's what we're here for
Read time: 2 minutes
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 […]
Read time: 1 minute
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 […]
Read time: 1 minute
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, […]
Read time: 2 minutes
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. […]
Read time: 1 minute
To calculate the Standard Deviation in Excel, you start by clicking on the formula tab on the ribbon and then click on the More Functions button. From the drop down list choose Statistics and then click on Std Dev button. When the Function Arguments dialogue box opens up, enter the cell range of the list […]
Read time: 2 minutes
A Gantt chart template for Excel will allow the user to schedule tasks in a specific project that will chart it from the start date to the completion of each task. A Gantt chart will make it easier to visualise a project from start date to completion, with each task of the project will have […]
"*" indicates required fields