Browse all IT training courses

Lotus 1-2-3 Advanced

Click here for a PDF version

Introduction

Lotus 1-2-3 is one of the world's best selling software packages, comprising spreadsheet, graphics and database functions. This latest release takes full advantage of the Windows environment. 

Objectives

To greatly extend existing Lotus 1-2-3 awareness. The knowledge gained will enable students to further develop specific models and applications. 

Designed for

Existing users of Lotus 1-2-3 for Windows. Participants should have either attended our "Lotus 1-2-3 for Windows Intermediate" course or attained a similar level of proficiency. 

Duration

One day 

Topics

  • Review of fundamental Lotus 1-2-3 concepts
  • File Linking
  • Referencing different sheets in the same spreadsheet file
  • Referencing external spreadsheet files
  • @ Functions
  • Text handling
  • Logical handling
  • Date/time handling
  • Database @ functions
  • Statistical @ functions
  • Lookup @ functions
  • Modelling techniques
  • Data tables and use of ranges
  • Range names and Range Navigator
  • Solver and Backsolver
  • Version Manager
  • Worksheet Security
  • Protection of cells and worksheets
  • Hiding cells and worksheets

Follow-up

Lotus 1-2-3 for Windows Macros - 1 day 

Get in Touch

Pricing Guide:

  • 1

    £495 per head

  • 4

    £130 per head

  • 8

    £70 per head

Ask us about training for roll-outs and bespoke systems.

…and every course includes

  • Custom-building the course for you
  • Free post-course support helpline
  • All course materials
  • Trainer expenses