Course Search:
Request more details:


Print Page

OpenOffice.org Calc Advanced

Description:
This course introduces participants to all the key aspects of OpenOffice Calc and enables them to use the software efficiently.
  • Cost: Price on application
  • Duration: 1 day
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Pre-requisites: Participants should know the Introductory features of Cal.
Linking:
Introduction
Document Links
Creating Document Links
Updating Link
Linking Calc to Writer
Functions:
Functions 5
AutoPilot: Functions
Function List
String Manipulation with Text Functions
Date and Time Functions
Lookup and Reference Functions
Mathematical Functions
Array Formulae
Formatting:
Styles
Number Formats
Conditional Formatting
Templates:
Introduction
Document Templates
Scenarios:
Creating a Scenario
The Navigator and Scenarios
Spreadsheet Detective:
Precedents and Dependants
Tracers
Notes
Lists:
Grouping and Outlining
Subtotals
Consolidation:
DataPilot Tables:
Introduction
Creating a DataPilot Table
Managing DataPilot Tables
Data Sources:
Creating a New Data Source
Opening a Data Source
Goal Seek:
Data Validity & Protection:
Data Validity
Protection
An Introduction to Macros:
What is a Macro?
Recording a Macro
Running a Macro


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.