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