Corporate HomeCorporate ProfileWorldwide OfficesSolutions At WorkEmployment  
LRS Education Services
LEARN  >  Find a Class  >  Class Summary

APLOT92 - Lotus 123 Release 9.5 Advanced

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com
Students learn how to create decision-making formulas, macros, versions, and custom SmartIcon sets.
Click here for a printer-friendly version of this page
 
Contact us for class availability


Prerequisites

Course APLOT91: Lotus 123 Release 9.5 Worksheets or equivalent knowledge
 
Detailed Class Syllabus


Lesson 1: Advanced formula construction
  • Range names

  • The @ROUND function

  • The @IF function

  • The @VLOOKUP function


    • Lesson 2: Advanced worksheet management
  • Viewing options

  • Protecting a worksheet


    • Lesson 3: Multiple file linking
  • Creating linked formulas

  • Redirecting file links

  • Multiple-sheet files vs. linked files


    • Lesson 4: Analyzing information
  • The @ISERR function

  • Auditing the worksheet

  • Using the Backsolver feature


    • Lesson 5: Using the Version Manager feature
  • Creating versions

  • Creating scenarios


    • Lesson 6: Introduction to macros
  • Macro preview

  • Creating a macro


    • Lesson 7: Exploring and organizing macros
  • Exploring macro keywords

  • Documenting macros

  • Using a macro library


    • Lesson 8: Using SmartIcons
  • Working with sets of SmartIcons

  • Customizing a SmartIcon set


    • Lesson 9: Enhancing and printing a worksheet
  • Filling and transposing ranges

  • Enhancing a worksheet’s appearance

  • Advanced printing techniques
    •  
    Microsoft Partner Gold LearningPrometricEC-Council
    Microsoft Certified ProgramsAdditional Certification Courses