Lesson 1: Advanced formula construction
- Range names
- The @ROUND function
- The @IF function
- The @VLOOKUP function
Lesson 2: Advanced worksheet management
- Viewing options
- Hiding columns of a worksheet
- Protecting worksheet data
Lesson 3: Using 3-D workbooks and linking
multiple files
- Using 3-D workbooks
- Working with multiple files
- Comparing multiple worksheet files and
linked files
Lesson 4: Analyzing information
- The @ISERR function
- Using the Backsolver feature
- Outlining
Lesson 5: Using versions and version groups
- Creating versions
- Creating version groups and version
reports
Lesson 6: Introduction to macros and
LotusScript
- Introduction to macros
- Introduction to LotusScript
Lesson 7: Enhancing and printing worksheets
- Filling and transposing ranges
- Enhancing worksheet appearance
- Advanced printing techniques
Lesson 8: Customizing the SmartIcon bar;
using Internet tools
- Working with sets of SmartIcons
- Customizing a SmartIcon set
- Internet tools
You will need 8 megabytes (MB) of Random Access
Memory (RAM) if you are using 1-2-3 Millennium Edition. See your
reference manual for hardware considerations that apply to your
specific hardware setup.
In addition, you will need printers if you want
to print the worksheets >created in the course.
