Filtering by date number and text

Filtering by Date , Number and Text This quick video explains how to Filter by Date, Number and Text in Excel. Filtering by Date Number and Text. Once a filter is applied to a list – we can filter based on the values in each of the rows. Here we look at applying...

COUNTIF

The COUNTIF Function This quick video explains how you use The COUNTIF Function in Excel. Learn how to use the COUNTIF function to count entries in a range of cells that meet certain criteria (e.g. values over a certain amount). Useful function to use when trying to...

Sorting and Filtering by Format

Sorting and Filtering by Format This quick video explains Sorting and Filtering by Format in Excel. Sorting and Filtering by Format Excel provides a powerful new Filtering option – that allows us to Filter based on the format that the cell has been formatted in. This...

How to use the SUMIF Function in Excel

How to use the SUMIF Function in Excel This quick video explains how to work with the SUMIF formula in Excel. Learn how to work with the SUMIF formula to add up values in a range of cells only if a matching cell meets a certain criteria (particular sales person,...

Data Validation

Data Validation This quick video explains using Data Validation in Excel. We can use Excel’s powerful Data Validation rules to ensure that data entered into a cell is of the correct type and range for the table it is being inserted into – we can restrict the values...

IF Statement

IF Statement This quick video explains The IF Statement in Excel. Learn to use the IF statement – widely used in Excel when testing for a particular condition (is commission payable? Is it a Monday?) Learn when to use this function and understand when it is used....