Lotus 1-2-3 Millennium Edition Advanced Study Guide

0-619-01409-1 © 2001 Publish date: July 14, 2000 146 pages

Buy Now: $25.99

Course ID: lotus-123-me-adv-sg

CBT Planet stocks a wide variety of computer training books to bring you self-directed study in a portable and convenient format. Our books range from entry-level to advanced. The Lotus 1-2-3 Millennium Edition Advanced study guide will give you the know-how for working with the advanced features of 1-2-3. Because of the convenience of this format, you can learn these techniques on your own without going to a boring class or seminar.

The Lotus 1-2-3 Millennium Edition Advanced courseware contains eight units covering topics such as working with large worksheets, linking sheets and workbooks, customizing 1-2-3, advanced charting features, advanced formatting topics, using database tables and query tables, documenting and protection, and using SmartMasters.

This study guide is perfect for learning advanced database techniques without taking a traditional class. You'll begin to work more productively once you know how to use the powerful features included in Lotus 1-2-3. You are in full control of how long it takes to master the software by choosing your own timeframe. The Lotus 1-2-3 Millennium Edition Advanced courseware can realistically be completed in as little as one day of dedicated study or you can spread out your learning to a pace that works best for you.

Course Contents

Unit 1 introduces large sheets

• Viewing options
• Page setup and print preview
• Hiding and displaying data

Unit 2 covers linking sheets and workbooks

• Linking sheets in the same workbook
• Linking and combining outside workbooks

Unit 3 goes over how to customize Lotus 1-2-3

• Setting a workbook's properties and setting a sheet's properties
• Customizing SmartIcons
• User setup

Unit 4 covers advanced charting topics

• Chart formatting options
• How to create mixed charts
• Implementing graphic objects in charts

Unit 5 discusses advanced formatting

• Number formatting options
• Date and time formats and their functions
• Named styles and the Style Gallery

Unit 6 covers database tables and query tables

• Database tables
• Query table basics
• How to find records in query tables

Unit 7 discusses documentation and protection

• Using text blocks and entering cell comments
• How to protect your workbooks

Unit 8 covers using SmartMasters

• Working with built-in SmartMasters
• How to create and modify SmartMasters