Lotus 1-2-3 Millennium Edition 9.8 Advanced Study Guide

0-619-28574-5 © 2006 Publish date: January 31, 2005 174 pages

Buy Now: $25.99

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

Learn the advanced techniques of spreadsheets by choosing the Lotus 1-2-3 Millennium Edition 9.8 Advanced study guide. This self-directed course is intended for those of you who have a basic understanding of Lotus 1-2-3 and want to take advantage of its more advanced features.

Use the Lotus 1-2-3 Millennium Edition 9.8 Advanced courseware to learn about using large spreadsheets, how to link multiple spreadsheets and workbooks, how to customize your workbook's properties, how to use the various toolbars, how to set user preferences, and how to use the more advanced functions, queries, and SmartMaster templates.

Our computer training books bring you high-quality instruction in a convenient book format that is easy to follow and easy to understand. You can complete each of the nine units in as little as one day or take as long as you need to fully master the advanced functions of Lotus 1-2-3. The study guide contains review sections you can use to refresh your mind along with hands-on activities to practice the steps for yourself.

The Lotus 1-2-3 Millennium Edition 9.8 Advanced courseware is an excellent choice to sharpen your spreadsheet skills and learn how to fully use 1-2-3 to create powerful spreadsheets.

Course Objectives

You will learn how to adjust the view magnification, use Print Preview, create an outline, and hide and unhide data. You will learn about linking sheets in the same workbook and between other workbooks. In addition you will learn how to set properties, modify the user setup, customize SmartIcons, perform advanced charting tasks, apply text and number formats, create named styles, use the @DATE and @NOW functions, use database and query tables, use @IF, @VLOOKUP, and @FV functions, how to analyze data with versions, backsolver, and the what-if table, how to add text blocks and cell comments, and how to lock your workbook.

Course Contents

Unit 1 introduces large sheets

• Viewing options
• Page setup
• Hiding and displaying data

Unit 2 covers linking sheets and workbooks

• Linking sheets within a workbook
• Linking and combining workbooks

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

• Adjusting workbook and sheet properties
• Customizing SmartIcons
• User setup

Unit 4 covers advanced charts

• Chart formatting options
• Creating mixed charts
• Working with graphic objects in charts

Unit 5 discusses advanced formatting

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

Unit 6 covers database tables and query tables

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

Unit 7 discusses advanced functions and analysis tools

• Advanced functions
• Analyzing data

Unit 8 covers documentation and protection

• Text blocks and cell comments
• Protecting your workbooks

Unit 9 talks about SmartMasters

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