Spreadsheets (Using Microsoft Excel)
-
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Community Learning Homepage
EXCEL WINDOW
1
- How to Start Microsoft Excel
DATA
2
- Entering Data
3
- Column Width
4
- Alignment
5
- Making Changes to Data
6
- Highlighting Cells
7
- Inserting / Deleting a Column
8
- Inserting / Deleting a Row
9
- Decimals
SAVING AND PRINTING
10
- Giving Your Spreadsheet A Name
11
- Saving Changes To Your Spreadsheet
12
- Printing your Spreadsheet
13
- Header & Footers
FORMULAS
14
- Adding 2 cells together ( + )
15
- Adding a range of cells (SUM)
16
- Subtracting one cell from another ( - )
17
- Multiplying cells together ( * )
18
- Dividing one cell from another ( / )
19
- Percentages ( / * + - )
20
- Auto Fill
21
- Printing Formulas
EXERCISES
1
- Budget & Expenditure forecast
2
- Sales
3
- Invoice
4
- Wages