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.
**Upskilling in Advanced Excel** UPDATED
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.
**Upskilling in Excel** UPDATED
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
*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 😁
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.
BYS [BGE 1001] – Working with Business Applications 1
This pack is based around the SQA Technologies – Broad General Education mapping to National 3 and National 4 Administration and IT document and linking to TCH 3-08a. It focusses on Spreadsheets, Databases, Word and PowerPoint.
There is plenty of practice on each with progression from basic to more challenging tasks.
There is a video that outlines everything in this resource pack.(Please note there are now also tasks on databases, not shown in my video). https://www.facebook.com/BuildYourSkillScotland/videos/1163283751530227
BYS [BGE 1002] – Working with Business Applications 2
This pack is based around the SQA Technologies – broad general education mapping to National 3 and National 4 Administration and IT document and linking to TCH 3-08a. It focusses on Spreadsheets, Databases, Word and PowerPoint.
This is a progression from Working with Business Applications (1) and is set up as 8 mini projects.
There is a video that outlines everything in this resource pack. https://www.facebook.com/BuildYourSkillScotland/videos/1163283751530227
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.
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.
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.
BYS [SSV1001] – Basic Formulae & Formatting
Lots of practice with the basics. See below for a full product description.
BYS [SSV1004] – Absolute Cell References & Named Cells
Using ($) absolute cell references and naming cells to complete worksheets. See below for a full product description.
BYS [SSV1006] – Working with Percentages
Lots and lots of practice using percentages (%). See below for a full product description.
BYS [SSV1007] – IF Statements (Level 1)
Basic IF statement practice with straightforward formatting and sorting data. See below for a full product description.
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.
BYS [SSV1009] – IF Statements (Level 3 – Nested)
Plenty of practice using nested IF Statements or the IFS function with increasing complexity. See below for a full product description.
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.
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.
BYS [SSV1014] – SumIF & CountIF Function
Plenty of practice using SumIF and CountIF with increasing complexity . See below for a full product description.
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.
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.