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.

***New Freebie – Fix the Excel Error for H Admin***

All the Spreadsheet tasks from the 2018 - 2023 Higher Admin & IT Assignments with errors that need to be fixed 😁
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. 
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.

BYS [INT1004] – N5 Integrated Tasks (Pack 1)

Plenty of practice with spreadsheets, databases, word and powerpoint, this pack is aimed at N5 Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 1 is based around a car wash and valeting business.

BYS [INT1005] – N5 Integrated Tasks (Pack 2)

Plenty of practice with spreadsheets, databases, word and powerpoint, this pack is aimed at N5 Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 2 is based around a football club.

BYS [INT1006] – N5 Integrated Tasks (Pack 3)

Plenty of practice with spreadsheets, databases, word and powerpoint, this pack is aimed at N5 Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 3 is based around an administrator working on a cruise ship.

BYS [INT1007] – N4 Integrated Pack 1

Plenty of practice with Spreadsheets, Databases, Word and PowerPoint, this pack is aimed at N4 Admin and IT and incorporates the skills as per the N4 Unit Specification for the IT Solutions For Administrators Unit.  Pack 1 is based around an ice-cream business.

BYS [INT1008] – N4 Integrated Pack 2

Plenty of practice with Spreadsheets, Databases, Word and PowerPoint, this pack is aimed at N4 Admin and IT and incorporates the skills as per the N4 Unit Specification for the IT Solutions For Administrators Unit.  Pack 2 is based It is based around a Scottish loch with camping, wildlife and water activities and a community trying to keep it clean and safe.

BYS [INT1009] – N4 Integrated Pack 3

Plenty of practice with Spreadsheets, Databases, Word and PowerPoint, this pack is aimed at N4 Admin and IT and incorporates the skills as per the N4 Unit Specification for the IT Solutions For Administrators Unit.  Pack 3 is based around and IT Training Business.

BYS [INT1010] – PDA IT in Business L7 (Excel)

The Professional Development Award (PDA) in Information Technology in Business at SCQF level 7 delivers the skills and knowledge needed for a range of administrative roles. It has particular emphasis on the use of IT within a business environment.  This pack focusses on the Excel element of the award and includes 5 design tasks.

BYS [INT1010] – PDA IT in Business L7 (Excel) – Summary Sheet

An overview of the new BYS [INT1010] - PDA IT in Business L7 (Excel) showing what is covered in each task.
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).

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.

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.
Example of an Excel Dashboard

Interactive Dashboard Excel File

An Excel worksheet to use with this YouTube Video on creating simple Interactive Dashboards. Also useful for practicing Pivot Tables, Pivot Slicers and Pivot Charts.

Upskilling Excel Files

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