# 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.

### ***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]

### BYS [SSV1001] – Basic Formulae & Formatting

Lots of practice with the basics. See below for a full product description.

### BYS [SSV1003] – Graphs (Level 1)

The basics of graphs. See below for a full unit 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 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.

### Product Price List August 2018

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