Get Started. It's Free

## 1. Formulae

### 1.2. Absolute vs Relative references

1.2.1. lesson ideas

1.2.1.1. undertenminutes

### 1.3. Lesson ideas

1.3.1. @simonhaughton

1.3.2. @chrisleach78

1.3.2.1. 12 Days of Christmaths

## 2. Terminology

### 2.9. Lesson ideas

2.9.1. NGfL

2.9.1.1. Intro to terminology

## 3. Functions

### 3.7. Data Validation

3.7.1. Lesson ideas

3.7.1.1. NGfL

3.7.1.1.1. Creating drop down lists

### 3.16. Lesson ideas

3.16.1. NGfL

3.16.1.1. Understanding Functions

## 5. Predicting outcomes

### 5.5. Comparable data

5.5.1. Additional external sources of data

### 5.6. Test prediction

5.6.1. Change rules

5.6.2. Change variables

5.6.3. Complex questions (lines of enquiry)

## 6. Analysing results

### 6.2. Reasons for bias

6.3.1. Efficient?

6.3.2. Ease of use?

6.3.3. Appropriate?

### 6.6. Pivot tables

6.6.1. lesson ideas

6.6.1.1. undertenminutes

6.6.1.1.1. Using for data analysis

## 8. Formatting

### 8.1. Sorting

8.1.1. Multiple columns

8.1.2. Single column

8.1.3. Ascending

8.1.4. Descending

8.1.5. Filters

8.1.5.1. Excel 2007

### 8.2. Conditional Formatting

8.2.1. Based on numbers

8.2.2. Based on text

8.2.3. Lesson ideas

8.2.3.1. @simonhaughton

### 8.7. Cells

8.7.1. Borders

8.7.2. Fill

8.7.3. Text

8.7.3.1. Font

8.7.3.2. Alignment

8.7.3.3. Text wrap

8.7.4. Numbers

8.7.4.1. Currency

8.7.4.2. Decimal places

8.7.4.3. Date

8.7.4.4. etc

8.7.5. Merge cells

### 8.10. Articles

8.10.1. Designshack

## 10. Publishing tools

### 10.4. Macros

10.4.1. Assigning, editing buttons

### 10.6. Printing

10.6.1. Pages

10.6.2. Gridlines

10.6.3. Orientation

10.6.4. Set print area

### 10.9. Audiences

10.9.1. Graphs vs Tables

## 11. Links to other software

### 11.1. Web Queries

11.1.1. Auto refresh

11.1.2. Real world examples

### 11.4. Datalogging

11.4.1. Analogue vs digital sensors

11.4.2. Data from sensors

11.4.2.1. Reliability of data?

### 11.5. Web query vs datalogging

11.5.1. Reliability of data?

11.5.2. What data to select?

## 12. Creating graphs

12.1.1. Line

12.1.2. Bar

12.1.3. Pie

### 12.3. Formatting

12.3.1. Titles

12.3.2. Axis

12.3.3. Scale

12.3.4. Series

12.3.5. Legend

12.3.6. Text alignment

12.5.1. Chartle

### 12.6. 2graph

12.6.1. Lesson ideas

12.6.1.1. @simonhaughton

12.6.1.1.1. Graph / analyse TV ratings

### 12.7. Lesson ideas

12.7.1. NGfL Cymru

12.7.1.1. Interactive finding answers from graphs

## 14. Lesson ideas

### 14.1. @simonhaughton

14.1.2. Theme Park Project

### 14.2. @chrisleach78

14.2.2. Wizard's Apprentice

14.2.3. 6 Nations Dream Team

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)