Microsoft Excel Resources

Our resources for Microsoft Excel cover the many features, functions and formulae attributed to this software and gives plenty of practice with for beginners right through to students working at an advanced level.

All our Microsoft Excel resources and paperless with instructions online by way of comment boxes.  They have been designed in such a way that there are lots of hints and tips for the first 4 – 5 tasks and thereafter they get progressively more complex with less help in order to get students thinking for themselves as they continue to build their skill.

N6 Administration and IT Pack

***BYS [INT1001] – N6 Integrated Tasks (Pack 1)***

Lots of practice with spreadsheets and databases. This pack is aimed at Higher Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 1 is based around Open Water Swimming Events.
N6 Administration and IT Pack

***BYS [INT1002] – N6 Integrated Tasks (Pack 2)***

Lots of practice with spreadsheets and databases. This pack is aimed at Higher Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 2 is based around a Business Support and Training Organisation.
N6 Administration and IT Pack

***BYS [INT1003] – N6 Integrated Tasks (Pack 3)***

Lots of practice with spreadsheets and databases. This pack is aimed at Higher Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 3 is based around Summer Activity Camps and Holiday Accommodation.

***New Freebie – Basic Excel Formulas Summary***

A summary sheet for basic Excel functions; (sum / average / count / max / min / countA / CountBlank) and arithmetical formulas (add / subtract / multiply / divide) with a (short) practice file.

***New Freebie – Upskilling Advanced Excel***

This FREE pack will help you if you want to improve on your existing Excel skills. It will also help students studying Higher Admin & IT. There are 8 videos - one for each section that you will find on our YouTube Channel.

*New Freebie – Upskilling Excel*

This FREE pack will help you if you want to improve your Excel skills. It will also help you if you are studying N4/N5 Administration and IT, or if you are doing the "crash" Higher. There are also 9 videos - 1 for each section that you will find on our YouTube Channel
Microsoft Excel 2016 on-screen, paperless resources to help understand how to use percentages (%) in an Excel spreadsheet.

Build Your Skill – Summary of Resources

These PDF files gives an idea of what the Build Your Skill Resources look like by using a series of screenshots to give examples and an overview of tasks. 
Basic Formulas, Basic Functions, N4 Admin & I.T, Excel Spreadsheets

BYS [SSV1001] – Basic Formulae & Formatting

Lots of practice with the basics. See below for a full product description.
Excel Charts, Graphs, Spreadsheets, N4 Admin & I.T, N5 Admin & I.T

BYS [SSV1003] – Graphs (Level 1)

The basics of graphs. See below for a full unit description.
Absolute Cell References $, Named Cells, Spreadsheet, Excel, N5 Admin & I.T, Higher Admin & I.T

BYS [SSV1004] – Absolute Cell References & Named Cells

Using ($) absolute cell references and naming cells to complete worksheets. See below for a full product description.
%'s in Excel, Percentages in Excel, Working with %'s, N5 Admin & I.T, Higher Admin & I.T, Excel

BYS [SSV1006] – Working with Percentages

Lots and lots of practice using percentages (%). See below for a full product description.
IF Statements Level 1, N5 Administration & I.T, Excel Spreadsheets.

BYS [SSV1007] – IF Statements (Level 1)

Basic IF statement practice with straightforward formatting and sorting data. See below for a full product description.
IF Statements, Higher Admin & I.T, Excel Spreadsheets

BYS [SSV1008] – IF Statements (Level 2)

Intermediate IF Statement practice that includes absolute cell references and additional formulae. See below for a full product description.
Nested IF Statements, Excel Spreadsheets, H Administration and I.T

BYS [SSV1009] – IF Statements (Level 3 – Nested)

Plenty of practice using nested IF Statements with increasing complexity. See below for a full product description.
Conditional Formatting, Excel Spreadsheets, N5 Admin & I.T, H Admin & I.T

BYS [SSV1010] – Conditional Formatting (Level 1)

Practice using pre-set conditional formatting such as "Highlight Cell Rules", "Top Bottom Rules", "Data bars" and "Colour Scales". See below for a full product description.
Grouping, Sorting and Outlining, Sub Totals, N5 Admin & I.T, Higher Admin & I.T, Excel, Spreadsheets

BYS [SSV1011] – Sorting & Outlining

Plenty of practice sorting data on 2 and 3 fields then using the Outlining function to sub-total data.  See below for a full product description.

BYS [SSV1013] – V & H Look-Up Function

Plenty of practice using V and H Look ups with increasing complexity . See below for a full product description.
SumIF function, CountIF function, Excel Spreadsheets, Higher Admin & IT

BYS [SSV1014] – SumIF & CountIF Function

Plenty of practice using SumIF and CountIF with increasing complexity . See below for a full product description.
Pivot Tables, Excel Spreadsheets, Higher Admin & I.T

BYS [SSV1015] – Pivot Tables

Plenty of practice using Pivot Tables. See below for a full product description.

BYS [SSV1016] – Working with Excel (1)

Lots of practice with Excel editing, formulas and functions.  See below for a full product description.

BYS [SSV1016] – Working with Excel (1) – Task Details

A summary sheet showing exactly what Excel function or formula is required to complete the tasks in pack SSV1016 – Working with Excel (1).

BYS [SSV1017] – Working with Excel (2)

Lots of practice with Excel editing, formulas, complex formulas and functions.  See below for a full product description.

BYS[SSV1017] – Working with Excel (2) – Task Details

A summary sheet showing exactly what Excel function or formula is required to complete the tasks in pack SSV1017 – Working with Excel (2).

Product Price List January 2021

Our current prices and products.