Training Videos

How to Cleanse Raw Data (FULL COURSE)

containing: Data cleansing functions, Text substitution functions, Using Flash Fill, Extracting the correct text, De-duplication techniques, Using Text to Columns to clean data, Working with American formatted dates, Reformatting offset headings

Introduction to XLOOKUP (FULL COURSE)

containing: Using XLOOKUP instead of VLOOKUP or HLOOKUP, Using a nested XLOOKUP, Limitations of VLOOKUP and HLOOKUP, Using XLOOKUP instead of INDEX and MATCH, Finding nearest match

Conditional Formatting (FULL COURSE)

containing: What is Conditional Formatting?, Demonstrating preset highlighting rules, Creating a Conditional Formatting rule using a formula, Clearing existing rules, Highlighting an entire record

Introduction to Creating Charts (FULL COURSE)

containing: Using a recommended chart, Modifying your chart design, Formatting chart elements, Selecting a specific chart type, Using keyboard shortcuts to create a quick chart, Awareness of pitfalls, Selecting the appropriate data, Working with pie charts

Introduction to Data Validation techniques (FULL COURSE)

containing: Demonstrating Data Validation controls, Understanding the Data Validation dialog box, Modifying existing Data Validation controls, Creating Data Validation from scratch, Working with lists

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.