Qualification

Broadly comparable to SCQF Level 5

Interests

  • Computing

Why take this course?

This course helps employees to use Microsoft Excel more effectively, enabling them to ‘work smarter’ with greater productivity and accuracy.

It is ideal for those with a basic knowledge of Excel who want to build confidence and strengthen their practical skills in key areas. Through hands-on, workplace-focused activities, learners will develop techniques that can be applied immediately to everyday tasks and reporting.

What you will experience

This one-day course can be delivered face-to-face at a NESCol campus, online using Microsoft Teams or at a local business premises for up to twelve attendees.

You will learn how to:

  • Use shortcuts of navigation, selection and commands
  • Apply formulas such as: if statements; nested if statements; SUMIF and COUNTIF
  • Protect your worksheets and workbooks
  • Apply data validation techniques, allowing you to automate functions off entered text
  • Manipulate text data through formula
  • Work efficiently with relative and absolute referencing
  • Link cells, worksheets and workbooks to create dynamic automatic reports
  • Use templates within Excel.