
1. Shortcuts
1.1. Fill Handle
1.2. AutoSum
1.3. Autofill, fill series
1.4. GoTo
2. Predicting outcomes
2.1. Goal seek
2.2. WhatIf
2.3. Examples in real world
2.4. Reliability
2.5. Comparable data
2.5.1. Additional external sources of data
2.6. Test prediction
2.6.1. Change rules
2.6.2. Change variables
2.6.3. Complex questions (lines of enquiry)
2.7. Calculate revenue, cost, VAT, profit, markup
3. Analysing results
3.1. Identifying a bias
3.2. Reasons for bias
3.3. Evaluating a spreadsheet
3.3.1. Efficient?
3.3.2. Ease of use?
3.3.3. Appropriate?
3.4. unreliable input = unreliable output
3.5. Using filters, autofilters
3.6. Pivot tables
3.6.1. lesson ideas
3.6.1.1. undertenminutes
3.6.1.1.1. Using for data analysis
3.7. Split Screen
3.8. Annotating using text boxes
4. Introduction
4.1. What is a spreadsheet?
4.2. Examples of how they are used in the 'real world'
4.3. What is a spreadsheet model?
4.4. What is a spreadsheet simulation?
4.5. What are the advantages of using spreadsheets?
4.6. What are the disadvantages of using spreadsheets?
5. Formatting
5.1. Sorting
5.1.1. Multiple columns
5.1.2. Single column
5.1.3. Ascending
5.1.4. Descending
5.1.5. Filters
5.1.5.1. Excel 2007
5.2. Conditional Formatting
5.2.1. Based on numbers
5.2.2. Based on text
5.2.3. Lesson ideas
5.2.3.1. @simonhaughton
5.2.3.1.1. Spreadsheet Quiz
5.3. Adding comments
5.4. Transposing columns to rows
5.5. hide, show columns, rows
5.6. Adjust height, width of rows, columns
5.7. Cells
5.7.1. Borders
5.7.2. Fill
5.7.3. Text
5.7.3.1. Font
5.7.3.2. Alignment
5.7.3.3. Text wrap
5.7.4. Numbers
5.7.4.1. Currency
5.7.4.2. Decimal places
5.7.4.3. Date
5.7.4.4. etc
5.7.5. Merge cells
5.8. Layout for questionairre
5.9. Layout for Gantt Chart
5.10. Articles
5.10.1. Designshack
5.10.1.1. How to make your spreadsheet less lame
6. Links to other software
6.1. Web Queries
6.1.1. Auto refresh
6.1.2. Real world examples
6.2. Mail merge
6.3. CSV vs xslx
6.4. Datalogging
6.4.1. Analogue vs digital sensors
6.4.2. Data from sensors
6.4.2.1. Reliability of data?
6.5. Web query vs datalogging
6.5.1. Reliability of data?
6.5.2. What data to select?
6.6. Embedding spreadsheet / graph into ppt, doc
7. Alternatives to Excel
7.1. Open Office
7.2. Adobe Acrobat Suite
7.3. Google Docs
7.3.1. Google Forms
7.4. Pictograms
8. Formulae
8.1. +, -, /, *
8.2. Absolute vs Relative references
8.2.1. lesson ideas
8.2.1.1. undertenminutes
8.3. Lesson ideas
8.3.1. @simonhaughton
8.3.1.1. spreadsheet quiz
8.3.2. @chrisleach78
8.3.2.1. 12 Days of Christmaths
9. Terminology
9.1. Rule, variable, label
9.2. Formula, function
9.3. Column, row
9.4. Cell, reference, range
9.5. Worksheet, spreadsheet
9.6. Absolute cell reference
9.7. Relative cell reference
9.8. Input, process, output
9.9. Lesson ideas
9.9.1. NGfL
9.9.1.1. Intro to terminology
10. Functions
10.1. Sum, Average
10.2. Min, Max, Mode, Median
10.3. Count, CountIF, Countblank, CountA
10.4. Goalseek
10.5. IF, nested IF, Sumif,
10.6. Absolute vs Relative references
10.7. Data Validation
10.7.1. Lesson ideas
10.7.1.1. NGfL
10.7.1.1.1. Creating drop down lists
10.8. Dependant data validation
10.9. Naming ranges
10.10. Calculations on dates, NOW
10.11. Randbetween
10.12. Vlookup
10.13. Concatonate
10.14. IF AND, IF OR
10.15. Relational operators =,<, >, <>, <=, >=
10.16. Lesson ideas
10.16.1. NGfL
10.16.1.1. Understanding Functions
11. Editing
11.1. Cut, copy
11.2. Paste, paste special
11.3. Find and replace
11.4. Insert, delete, columns, rows
11.5. Adding, deleting worksheets
11.6. Renaming worksheets
12. Publishing tools
12.1. Protecting cells
12.2. Freeze panes
12.3. Headers, footers
12.4. Macros
12.4.1. Assigning, editing buttons
12.5. Linking data between spreadsheets, worksheets
12.6. Printing
12.6.1. Pages
12.6.2. Gridlines
12.6.3. Orientation
12.6.4. Set print area
12.6.5. Adjust margins
12.6.6. Page break view, adjust
12.6.7. Repeat headings
12.7. Add hyperlinks
12.8. Form Controls
12.9. Audiences
12.9.1. Graphs vs Tables
13. Creating graphs
13.1. Types of graphs
13.1.1. Line
13.1.2. Bar
13.1.3. Pie
13.2. Selecting data
13.2.1. Adjacent cells
13.2.2. Non-adjacent cells
13.3. Formatting
13.3.1. Titles
13.3.2. Axis
13.3.3. Scale
13.3.4. Series
13.3.5. Legend
13.3.6. Text alignment
13.4. Analysing real world examples
13.5. Create charts online
13.5.1. Chartle
13.6. 2graph
13.6.1. Lesson ideas
13.6.1.1. @simonhaughton
13.6.1.1.1. Graph / analyse TV ratings
13.7. Lesson ideas
13.7.1. NGfL Cymru
13.7.1.1. Interactive finding answers from graphs
14. Lesson ideas
14.1. @simonhaughton
14.1.1. Intro to Spreadsheets
14.1.2. Theme Park Project
14.2. @chrisleach78
14.2.1. Toyshop spreadsheet
14.2.2. Wizard's Apprentice
14.2.3. 6 Nations Dream Team
14.3. data resources
14.3.1. calories
14.4. ictstarters.wikispaces.com
14.4.1. Who wants to be a millionaire?
14.5. @MrAColley
14.5.1. Spreadsheet Quiz Scheme (7 Lessons)