Functional Skills

This page has been prepared to help with the basics of working in the digital industry as well as support you with your functional skills. The term functional skills refers to skills that any organisation would reasonably expect a professional person to do, regardless of the industry they work in; such as:

  • Reading
  • Writing
  • Speaking and Listening
  • Simple maths
  • The use of basic IT systems, such as email, internet and office tools.

All of these lessons have been made to embed functional skills and to help you to prepare for your functional skills exams.

Financial Decisions

Let’s compare some bad decisions with money, to good financial advice. In this lesson we will be exploring some different aspects of finances that affect young people.


Spreadsheet Basics

These exercises have been developed to give you a basic introduction to spreadsheets and to remind you of a few of the most basic principles used in spreadsheets, such as importing data, making charts or graphs and basic formula. Basic Data Handing and Formula; Clothing Store Open a new spreadsheet. Enter your name using text… Read More »


Logical (IF) Formula

Logical formula are basically tests; and the results of that test will determine what will happen next. This lesson has been put together to help you better understand logical formula and practice their usage in a range of different ways. The slideshow below gives four different examples of logical formula, though the first two examples… Read More »


Sorting and Filtering

Sorting and filtering are two ways or organisation data on a spreadsheet or database in order to make it easier to analyse and use. Sorting is the process of putting all the data in a particular order, whereas filtering allows you to turn your headings into drop down menus to display only the information you… Read More »


Conditional Formatting

Conditional formatting is the process of changing the formatting of the contents in a cell depending on the values of the cell, for example, if a cell shows a positive number like £548.37 it will appear black, however if it was a negative number like £397.15 it would appear red automatically. Conditional Formatting Exercise: Open… Read More »