COURSE SEARCH
 
   HOME > COURSES > LOTUS 1-2-3 MILLENNIUM EDITION ADVANCED MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Lotus 1-2-3 Millennium Edition Advanced




Course Aims
This training course builds on the Introductory level to give experienced Lotus 1-2-3 users knowledge of the more advanced features and facilities available within this product, and how to apply them.
Assumed Knowledge
A good understanding of PCs, Windows and a fundamental understanding of Lotus 1-2-3 gained from prior attendance on the "Lotus 1-2-3 Millennium Introduction" course.
Course Audience
Experienced users of Lotus 1-2-3 who want to gain a deeper understanding of the software in a short space of time.

This course can be found in the following categories:
Courses > Lotus > Lotus Smartsuite Millennium Edition
Courses > Lotus > Lotus 1-2-3

Table of Contents
3-Dimensional Features
  		• Multiple Page Worksheets
  		• Working with Multiple Worksheets
  		• Multiple Worksheet Navigation
  		• Sheet Names and Tab Colours
  		• Grouping Sheets
  		• 3-D Printing
  		• Printing
  		• Page Breaks
  		• Printing a 3-D Range
     
    Multiple Files
  		• Working with Multiple Files
  		• Recalculating Linked Files
     
    Functions
  		• Defining and Using Functions
  		• String Manipulation with Text Functions
  		• Concatenation
  		• Logical Functions & Operators
  		• Lookup & Calendar Functions
  		• Functions for Dates & Times
  		• Statistical Functions
  		• Information functions
  		• Cell Information
     
    Databases
  		• Database Terms
  		• Creating and Managing a Database
  		• Adding Records with Lotus Approach
  		• Deleting Database Records
  		• Query Tables
  		• Database Analysis
  		• Dynamic Crosstabs
  		• Reports
  		• Connecting to External Databases
  		• Database Statistical Functions
    What-if Tables Problem Solving
  		• Backsolver
  		• Regression
     
    Frequency Distribution Customizing Lotus 1-2-3
  		• Changing the 1-2-3 Set-up
  		• Setting Workbook Properties
  		• Custom Fills
  		• Custom SmartIcons
  		• Creating a New SmartIcon Bar
  		• Adding & Removing Icons on a SmartIcon Bar
     
    Version Manager
  		• Defining and Using the Version Manager
  		• Modifying a Version
  		• Displaying Version Properties
  		• Creating Version Groups
  		• Creating Reports
  		• Merging Versions and Groups
     
    SmartMasters
  		• Working with SmartMaster Files
  		• Creating a Customised SmartMaster
     
    Mapping
  		• Setting up a Range of Map Data
  		• Creating a Map
  		• Editing a Map
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Thursday 17th May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft