Lotus 123 Millennium
Edition-Part 1
Lotus 123 Millennium
Edition-Part 2
Lotus 123 Millennium
Edition-Part 1
Lotus 123 Millennium
Edition-Part 2
Lotus 1-2-3 Millennium
Edition – Part 1
6
Hours / $225
Lesson 1: 1-2-3 Basics
A) The paper spreadsheet
B) Starting 1-2-3
C) The 1-2-3 window
Lesson 2: Entering Data and Navigating in a Worksheet
A) Entering and correcting data
B) Using formulas
C) Opening a second file
D) Navigation and movement techniques
Lesson 3: Modifying a Worksheet
A) Working with ranges
B) Using @functions
C) Editing cell contents
D) Using 1-2-3 on-line help
Lesson 4: Inserting Rows and Moving Data
A) Inserting rows and ranges
B) Moving data
Lesson 5: Copying Data
A) Copying data
B) Absolute references
C) Using fill by example
Lesson 6: Formatting Techniques
A) Formatting cell contents by using the status bar
B) Formatting text by using the InfoBox
C) Formatting numbers by using the InfoBox
D) Copying styles
Lesson 7: Printing a Worksheet
A) Checking spelling
B) Using print preview
C) Page setup and print options
Lesson 8: Additional Features
A) Introduction to a three-dimensional workbook
B) Creating a basic chart
C) Using SmartMasters
Lotus 1-2-3 Millennium Edition
– Part 2
6 Hours / $255
Lesson 1: Advanced Formula Construction
A) Range names
B) The @ROUND function
C) The @IF function
D) The @VLOOKUP function
Lesson 2: Advanced Worksheet Management
A) Viewing options
B) Hiding columns of a worksheet
C) Protecting worksheet data
Lesson 3: Using 3-D Workbooks and Linking Multiple Files
A) Using 3-D workbooks
B) Working with multiple files
C) Comparing multiple worksheet files and linked files
Lesson 4: Analyzing Information
A) The @ISERR function
B) Using the BackSolver feature
C) Outlining
Lesson 5: Using Versions and Version Groups
A) Creating versions
B) Creating version groups and version reports
Lesson 6: Introduction to Macros and LotusScript
A) Introduction to macros
B) Introduction to LotusScript
Lesson 7: Enhancing and Printing Worksheets
A) Filling and transposing ranges
B) Enhancing worksheet appearance
C) Advanced printing techniques
Lesson 8: Customizing the SmartIcon Bar; Using Internet Tools
A) Working with sets of SmartIcons
B) Customizing a SmartIcon set
C) Internet tools