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.

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.  There are another 3 additional resources available 1.Sorting and Outlining [SSV1011] 2.Forms and Reports (Level 2) [DBV1007] 3.Forms and Reports (Level 3) [DBV1008]
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.

Product Price List August 2018

A list of all our resources and prices as at August 2018