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 Introduction

Introduction

 1
The Spreadsheet Concept 1
Introduction to Calc 1
Calc Screen Layout 2
Showing, Docking and Hiding Windows 4
Help Agent, and Tips 4
Navigator 5

Cell Ranges 7
Moving the cursor with the Keyboard 7
Moving the Cursor with the Mouse 7
Selecting a Cell Range with the Keyboard 7
Selecting a Cell Range with the Mouse 8
Cell Area Name 8

Entering Data

 11
Introduction 11
Constants 11

Formulae

 13
Cell References 14
Data Entry in an Area 15
Editing Data 16
Sum 17

File Operations

 19
Summary of File Shortcut Keys 19
Saving Documents 19
Closing Documents 21
Opening Documents 21
Places Bar 21
Starting a New Document 21

Editing

 23
The Windows Clipboard 23
Filling 24
Moving 24
Deleting Ranges 25
AutoFill Feature 26

Inserting and Deleting

 27
Inserting 27
Deleting 27

Formatting

 29
AutoFormat 29
Cell Formatting 30
Column Widths 33
Row Heights 33

Printing

 35
Print Area 35
Page Preview 36
Page Breaks 36
Page Formats 37

Charts

 41
Introduction 41
Inserting Charts 41

Sheets

 43
Introduction 43
Working with Sheets 43
The Navigator and Sheets 45
Select Multiple Sheets 46

Spreadsheet Lists

 49
Sorting Data 49
Data Filtering 50

Windows

 53
Headers 53
Splitting Window Panes 53

Appendix

 55
Navigating in Spreadsheets 55
Function Keys Used in Spreadsheets 56
Formatting Cells Using Shortcut Keys 57
  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.