DEV4 Blog

Loading...

Driving schools are one of the businesses hit hard by the lockdown rules in 2020/21.   Understandably,  it is hard to keep social distancing in a driving lesson and the instructor can’t just sit in the backseat.

Driving schools will

Read more...
Published on 22 Apr 2021 by Gail Henderson

The EOMONTH function is a useful Excel function to know. The purpose of it is to easily identify the last date of a specified month.  The formula for this is EOMONTH(start date, how many months before/after). If the month you are looking for

Read more...
Published on 09 Apr 2021 by Joanna Hepburn

INDEX and MATCH are two functions on Excel which can be used together for a similar purpose as VLOOKUP, however they allow you to search anywhere in the data set. Together, these functions allow you to find the location of the cell you are looking

Read more...
Published on 08 Apr 2021 by Joanna Hepburn

PROPER is a handy function within Excel which allows you to neaten up data sets by capitalising the first letter of a word and converting the following letters to lowercase. The formula for this is =PROPER(cell to be neatened), e.g., in the exampl

Read more...
Published on 07 Apr 2021 by Joanna Hepburn

COUNTA and COUNTBLANK are functions on Excel which allow you to quickly identify how many cells contain data, and how many do not.

COUNTA allows you to count how many non-blank cells there are in a data range. This is done using the formula =COUNTA

Read more...
Published on 31 Mar 2021 by Joanna Hepburn

MAX, MIN, LARGE and SMALL are four functions of Excel which help with finding the range of data values in a dataset.

MAX allows you to find the highest value in a range of data using the formula =MAX(cell range to search). In the example below we u

Read more...
Published on 17 Mar 2021 by Joanna Hepburn

COUNTIF, AVERAGEIF and SUMIF are three Excel functions which help ease the process of analysing data.

COUNTIF counts how many of the data cells meet the conditions specified. In the example below we will use COUNTIF to count how many times the expe

Read more...
Published on 10 Mar 2021 by Joanna Hepburn

CONCATENATE is a neat function within Excel which allows you combine the data from multiple cells into a single cell. This can be used for many purposes, for example combining first and last names to show a full name, or, as shown below, combining

Read more...
Published on 03 Mar 2021 by Joanna Hepburn

PivotTables are a useful function on Excel which allow you to take a large dataset and transform it into an easy-to-read table. They can be used to separate data into timescales such as years or months, to compare data categories, and to produce char

Read more...
Published on 24 Feb 2021 by Joanna Hepburn

Carriage returns within text cells can often cause problems when you want to transfer data to another platform, such as a database.  An easy way to remove all carriage returns from a spreadsheet is to us the Excel Find and Replace function along

Read more...
Published on 28 Oct 2020 by Dev4