Lotus 1-2-3 Millennium Edition 9.0: Advanced
Price: $ 59.00 (USD)
Add to Cart
Have a question about this course? Contact a representative.
Course Description
Lotus 1-2-3 Millennium Edition 9.0: Advanced
Course Type: Self-paced Courses
Estimated Time of Completion: 3 hour(s) 29 minutes
CEU Credits:
Language: English
Description: In this course, you'll explore the basics of creating charts from worksheet data and enhancing those charts. You will also be introduced to database concepts and examine how to work with a range of worksheet data as a database. Finally, you'll explore how to display worksheet data by creating charts, and you'll also manipulate worksheet ranges by using database operations.
Objectives:
Advanced Formula Construction
Naming Ranges
The @ROUND, @IF, and @VLOOKUP functions
Advanced Worksheet Management
Viewing Options
Hiding Data
Protecting Worksheet Data
Using 3-D Workbooks and Linking Multiple Files
Using 3-D Workbooks
Working with Multiple Files
Using Versions and Version Groups
Creating Versions
Creating Version Groups and Version Reports
Introduction to Macros and LotusScript
Introduction to Macros
Introduction to LotusScript
Back to Top
Course Type: Self-paced Courses
Estimated Time of Completion: 3 hour(s) 29 minutes
CEU Credits:
Language: English
Description: In this course, you'll explore the basics of creating charts from worksheet data and enhancing those charts. You will also be introduced to database concepts and examine how to work with a range of worksheet data as a database. Finally, you'll explore how to display worksheet data by creating charts, and you'll also manipulate worksheet ranges by using database operations.
Objectives:
· After completing this course, you'll be able to create charts from worksheet data and enhance those charts. You will also be able to display worksheet data by creating charts, and you'll manipulate worksheet ranges by using database operations.
· Browser Netscape Communicator 4.0
· Browser Other: AOL 4.0
· Operating System MacOS 8.5
· Browser Microsoft Internet Explorer 4.0
· Operating System MS-Windows 95
Advanced Formula Construction
Naming Ranges
The @ROUND, @IF, and @VLOOKUP functions
Advanced Worksheet Management
Viewing Options
Hiding Data
Protecting Worksheet Data
Using 3-D Workbooks and Linking Multiple Files
Using 3-D Workbooks
Working with Multiple Files
Using Versions and Version Groups
Creating Versions
Creating Version Groups and Version Reports
Introduction to Macros and LotusScript
Introduction to Macros
Introduction to LotusScript
More Information
| Language | English |
| Course Length | 3.00 hours |
| Duration of Access | 12 weeks |
| Instructor | Self Study |
| Vendor | Element K |
Price: $ 59.00 (USD)
Add to Cart