DEV4 Blog

Loading...

Using different systems for managing contacts and messages can be quite time consuming so it is good news that there is a way to extract LinkedIn contacts and messages into a useable .csv format.

If you want a quick view in list format of all the mess

Read more...
Published on 27 Jun 2021 by Gail Henderson

EDATE is a useful function on Excel which allows you to find the same date as the data in which you entered, but for a specified month in the past or future. For example, if you give the formula cell B1 which contains the date 20/01/2020 and ask f

Read more...
Published on 13 May 2021 by Joanne Hepburn

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