Training Videos

Introduction to Logical Functions (FULL COURSE)

containing: How to construct a basic IF function, Understanding relational operators, Using SUMIF and COUNTIF functions, Boolean logic with AND and OR functions, Using IFERROR to eliminate #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!

Introduction to Formulae & Functions (FULL COURSE)

containing: How to construct a basic formula, Using Autofill, Understanding BODMAS, Absolute cell references, Creating a formula with a function, Mathematics with dates

Office 365 and Teams training through Digital Learning Solutions

NECS is pleased to provide you with free access to Digital Learning Solutions.

Using the IF function

IF functions allow you to make logical comparisons between a value and what you expect

Flash Fill in Excel 365

Flash Fill adds a level of intelligence in recognising a pattern and completing it based upon nearby data

Microsoft Excel Tables

A quick guide to using Format as Table in Microsoft Excel.