Lotus 123 v97 Introduction (1 Day)
Brief Outline:
This course concentrates on the basics of using a spreadsheet application. You will see what a ‘spreadsheet’, is and will learn how to create one.
You will learn how to add text and numbers, and use simple formulas in the hands-on exercises. Learn how easy it is to edit and format data and manipulate information on your spreadsheet. Create charts that will display your data and information.
Throughout the course you will practise keyboard and mouse shortcuts that will save you time and money.
Detailed Outcomes:
By the end of your learning, you will be able to:
- Describe the Lotus 123 screen.
- Use the Online Help features.
- Enter basic spreadsheet formulas.
- Set up the page, page size, margins.
- Create a full spreadsheet.
- Navigate with mouse and keys.
- Zoom in/out and arrange windows.
- Cut, paste and copy formulas.
- Edit text, data and formulas.
- Format a spreadsheet.
- Create a chart.
Recommended Prior Experience (Prerequisites):
No experience in using Lotus 123 is required nor assumed. Participants are expected to have a sound knowledge of and experience with a Windows PC.
Dates & Bookings ► | Manuals for Sale ► | Intermediate ►
Lotus 123 v97 Intermediate (1 Day)
Brief Outline:
This course will take you to the next level of using Lotus 123. This course will concentrate on the more advanced aspects of charting, such as creating a chart with two scales, creating combination charts, and what to do when your chart gives you problems.
This course will place emphasis on the automatic analysis and summary features of Lotus 123. You will be shown examples of creating and using formulas so that it seems simple, you'll also learn how to create more advanced formulas.
With the trainer you will go through several hands-on exercises to apply all the skills learnt.
Detailed Outcomes:
By the end of your learning, you will be able to:
- Revise important shortcuts.
- Apply advanced charting features.
- Draw and import graphics.
- Name cell ranges to use formulas easily.
- Use absolute references in formulas.
- Group and Outline data to summarise Information.
- Create 3-dimensional spreadsheets and copy sheets.
- Create SubTotals from Raw Data.
- Create and Use Pivot Tables.
- Create ‘What If’ formulas (Goal Seek).
Recommended Prior Experience (Prerequisites):
CLASS Training Introductory Course or proven experience with Lotus 123.
Dates & Bookings ► | Manuals for Sale ►