![]() |
![]() |
|
| Suitable for delegates with little or no knowledge of spreadsheet packages, this two day course provides the skills necessary to create fairly comprehensive worksheets using 1-2-3 analysis tools. A user knowledge of Windows 95/98/2000 or NT is assumed. | ||
| Getting Started | The Screen, Navigation, Entering & Editing Data, Inserting Rows & Columns | |
| Basic Skills | Formulae, @Functions, Absolute & Relative, Formatting, Named Ranges, Navigator | |
| Enhancements | Screen Colours, Font & Cell Attributes, Formats & Borders, Previewing Sheets | |
| Printing | Page Setup, Headers & Footers, Printing Worksheets | |
| Multiple Worksheets | 3D Navigation, 3D Ranges, Worksheet Consolidation, 3D Print Ranges | |
| Fills & Maps | The Fill Handle, Simple & Complex Fills, Custom Fill Lists, The Lotus Map Facility | |
| Graphics | Graph Types, Create a Graph, Add a Graph to a Worksheet | |
| Database | Create a Database, Add Records, Sort & Search Records | |
| Macro Overview | What is a macro?, Create a simple macro, Script Assignment Methods | |