Excel Formulas and Functions

This course is for individuals who want to summarise, consolidate, compare, analyse and match data using a range of useful functions. You will be able to make logical comparisons, match data, summarise information & trouble-shoot errors on your spreadsheet.

Key features of the course

  • IF Formulas
  • Nesting IF functions with other functions
  • SUM, MAX, MIN, MODE, COUNT, COUNTA AVERAGEIF, SUMIF, SUMIFS, COUNTIF, COUNTIFS VLOOKUPS, XLOOKUPS, IFERROR
  • Troubleshooting error message
  • Protecting cells and worksheets from edits

Course Summary

Start date

28th January 2022

How long it takes

Full day

Location

Digital Jersey Hub

Cost

Fully funded by Government's Fiscal Stimulus Programme

Apply Now

Entry Requirements

There are no formal entry requirements for this course

Meet the lecturer - Debbie Davies

Debbie trains on Microsoft Office products and also specialises in delivering bespoke courses. She designs packages around clients' particular needs and systems, often delivering the training from within their office premises. As a TAP-qualified trainer, Debbie aims to make her courses easy to understand and as hands-on as possible. Her sessions are an open forum for questions and discussions on the materials covered. Her delegates feel welcome from the moment they enter the training room. Debbie's TAP Diploma in Learning Facilitation includes know-how in training delivery, facilitation skills and online learning, learner engagement and the use of blended approaches.

Meet the lecturer - Alex Morel

Alex has been a Learning & Development professional since 1999 and has worked around the world advising and training over 350 organisations from a wide range of public, private and not-for-profit organisations. Over the years, Alex has been involved in countless migrations, system updates and implementation of new processes and ways of working, all of which have required unique approaches to engaging with end-users to help to change behaviours. Her background and experience in Adult Learning combined with her passion for technology means she is the ideal consultant to help you develop a digitally fluent workforce.

2020 Digital Leadership Programme
All rights reserved