Lotus 123 - Introduction
   

Duration:

 One Day
   

Aim:

 To introduce the capabilities of Lotus 123 for Windows to a new user. To ensure that users create spreadsheets efficiently and professionally.
   

Who Should Attend:

 Users who have to keep track of money e.g. create budgets, cashflow, profit and loss, accounts, petty cash etc…..
   

Objectives:
  1. To gain hands-on all the basic functions of Lotus 123
  2. Setting up formulas and developing professional worksheets using formatting and print options.
   

Course Topics
  • What is a Spreadsheet?
  • An Introduction to Lotus 123
    • The Screen Layout
    • The Toolbars
    • The Help System
    • Navigating a Spreadsheet
    • Understanding Workbooks and sheets
  • Creating, Saving and Opening Workbooks
  • Entering and Editing Data
    • Entering Text, Numbers, Formulas
    • Editing
    • Deleting, Undoing, Clearing
    • Selecting ranges
  • Formulas
    • Entering basic formulas
    • Using the AutoSum Function
    • Using built-in Functions
    • Entering Formulas for specific ranges
    • Editing Formulas
    • AutoCalculate
  • Copying and Moving Data
    • Copying using the AutoFill Tool
    • Useful features of AutoFill
    • Shortcuts of copying and moving
  • Formatting
    • Character Formatting
    • Numeric Formatting
    • Improving the Layout of the worksheet
    • Inserting / Deleting Rows & Columns
    • Hiding and Showing Data
  • Page Setup
    • Margins & Scaling
    • Page Layout and Orientation
    • Headers and Footers
  • Print and Print Preview
    • Print Options
Related courses -
Tircoed Foelgastell Cross Hands Carmarthenshire SA14 7EL
Tel: 01269 832399 Mobile: 07909 785900 Email: info@ace-training.co.uk www.ace-training.co.uk