Introducing 123
An overview of the benefits of spreadsheets, the basic spreadsheet structure and a tour of the Lotus 123 screen.


Documents Basic
Data entry and editing using some quick techniques.
Using simple calculations.
Checking your spelling and correcting mistakes.
Getting some HELP!


Saving & Retrieving
Securing your work, saving and retrieving files.
Automatically saving spreadsheets.
Organising work directories.
Removing unwanted files.


Formatting
Working with ranges.
Changing font style and size, aligning, bordering, shading, setting row and column heights.


Rearranging
Moving, copying and deleting sections of your spreadsheet.


Printing
Previewing work.
Changing the page layout, using automatic, headings and page numbers.
Printing all or part of your work.


Formulae & Functions
Basic 123 @ functions including sums and averages.
Looking up other functions to assist with more complex calculations.


Charts & Graphs
Using the step-by-step Chart Assistant.
Creating and editing bar, pie charts and line graphs.
Using drawn objects to enhance spreadsheets and graphs.


Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.

Course Overview:

As a new user, with little or no experience of 123, the topics covered on this course will empower you with the skills required to design and produce simple spreadsheets.

Course Duration:

Course Pre-requisites:

• Use Lotus 123 to structure and analyse your data.
• Perform automatic calculations.
• Enhance the appearance of your work.
• Produce graphs.
• Save your work and retrieve it for future reference or changes.
• Print your work.

Price Band:

 Specialised