Welcome to the Spreadsheets set of video tutorials
Here are some videos and other resources on spreadsheets, suitable for students in KS3 and KS4 (aged 11-15) starting to learn about this type of application. They can be used as classroom resources, homework, cover work or self study.
Developing spreadsheet skills
Using formulas
Min, Max and Count
The Average error
Conditional formatting
The if formula
Sorting data
Filtering data (searching)
Workbooks and worksheets
Replication and fill
Validation and verification
Showing formulas and printing
Data security
Countif introduction
Countif and Pie charts
Bar, line and scatter diagrams
Worksheet 1 Worksheet 2 Worksheet 3 Worksheet 4
Notes 1 Notes 2 Notes 3 Notes 4 Spreadsheet zip file