| Topic |
Content |
| Worksheet Layout |
Toolbars, Formula Bar, Column Tabs, Row Tabs and Cells. |
| Pointer Shapes |
Select cut/copy/paste, fill/copy, and best fit. |
| Navigate the Worksheet |
Keyboard shortcuts to get around a large worksheet. Use preview to check print outs and correct errors. |
| Format Features |
Merge & Centre Button, Borders & Shading, Currency, Insert & Delete Rows & Columns. |
| Autosum |
Create a small expense sheet using the autosum function to add totals and autofill to copy the formula. |
| Manual Formula |
Write a formula to calculate savings over a three month period. |
| Writing Formula |
Use a small table of figures to calculate, using the sum function, divide function and multiply function, and learn the use of brackets. |
| Locate & Display Formula |
Use the goto feature to locate formula in a sheet, colour them to remind you not to touch. Use the Display Formula shortcut on the keyboard to show how complex or simple the formulae are. |
| Absolute |
Learn the use of Absolute v Relative references. |
| Formula Bar |
Edit a formula using the formula bar. |
| Insert Function |
Use the Insert function button to locate formulae. Identify category lists and learn how to search for formula. Introduce Average, Minimum & Maximum functions. |
| Charting |
Four steps to create a chart, using the Chart Wizard. |
| Chart Types |
Column, Line, Bar & Pie Charts. |
| Format Charts |
Background colour, bar colours, fill effects. Chart area, plot area and legend. |
| DataBase |
Create a small database with a Header Row. Input data using the Data Form. Filter the Data using autofilter, and sort the data in ascending and descending order. |
| Print Options |
Use the Setup option to layout the worksheet on the page, before printing. |
