Ability Software Consultants +44 (0)1531 828366
info@officecourseware.com
Instructor with Microsoft Office, OpenOffice and StarOffice training coursewareOfficecourseware.com

Home Titles Costs Contact Us Links

Table of contents from instructor-led courseware notes. Page numbers are for guidance only and may vary. Courseware notes are formatted for double-sided printing.

OpenOffice.org 1.1 Calc Advanced

Linking

 1
Introduction 1
Document Links 1
Creating Document Links 1
Updating Links 2
Linking Calc to Writer 3

Functions

 5
Functions 5
AutoPilot: Functions 5
Function List 8
String Manipulation with Text Functions 8
Date and Time Functions 9
Lookup and Reference Functions 10
Mathematical Functions 11
Array Formulae 12

Formatting

 13
Styles 13
Number Formats 15
Conditional Formatting 16

Templates

 19
Introduction 19
Document Templates 19

Scenarios

 21
Creating a Scenario 21
The Navigator and Scenarios 22

Spreadsheet Detective

 23
Precedents and Dependants 23
Tracers 23
Notes 24

Lists

 25
Grouping and Outlining 25
Subtotals 26

Consolidation

 29

DataPilot Tables

 31
Introduction 31
Creating a DataPilot Table 31
Managing DataPilot Tables 32

Data Sources

 33
Creating a New Data Source 33
Opening a Data Source 34

Goal Seek

 35

Data Validity & Protection

 37
Data Validity 37
Protection 37

An Introduction to Macros

 39
What is a Macro? 39
Recording a Macro 39
Running a Macro 39
  Writer 1.1 Intro
Writer 1.1 Adv
Calc 1.1 Intro
Calc 1.1 Adv
Impress 1.1		  


All trademarks and product names used on this web page are for identification purposes only and are acknowledged as the registered trademarks of their respective owners. Officecourseware.com and Ability Software Consultants do not claim the endorsement of, or to represent, any of the companies whose names or products are presented on this page.