Advanced Spreadsheets
Working with range names.
Working with multiple worksheets.
Consolidating multiple worksheets.
Further use of Lotus 123 @ functions such as conditional @IF and lookups.
Design
Planning and building large spreadsheets.
Using spreadsheet templates.
Data imports.
Text functions.
Database
Creating a 123 database and accessing data from external sources.
Working with 123 Queries.
Graphing
Different graph styles.
Enhancing and advanced editing elements of a basic graph.
Macros
Recording commands in macros to simplify or automate routines. Editing macros and assigning macros to icons, buttons and hot-keys.
Customising
Changing 123 default settings.
Customising SmartIcons.
Security
Protecting areas of a worksheet to restrict user input.
Password protection.
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:
With basic skills and some experience of Lotus 123, the topics covered on this course will enable you to further enhance your spreadsheets and to use some more advanced features to streamline your work.
Course Duration:
1 Day
Course Pre-requisites:
It is assumed only that you have a skill level equivalent to that gained through attending 123 Introductory Training.At the end of this course
you will be able to:
- Apply design methods for spreadsheet applications.
- Utilise Lotus 123 database functions.
- Control and enhance Lotus 123 graphs.
- Create simple macros.
- Customise your Lotus 123 environment.
Price Band:
Specialised
