OpenOffice.org Calc Introduction
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.
Pre-requisites: Participants should have a familiarity with Windows. This is not an Intro to Computers course.
The Spreadsheet Concept
Introduction to Calc
Calc Screen Layout
Showing, Docking and Hiding Windows
Help Agent, and Tips
Navigator
Moving the cursor with the Keyboard
Moving the Cursor with the Mouse
Selecting a Cell Range with the Keyboard
Selecting a Cell Range with the Mouse
Cell Area Name
Introduction
Constants
Cell References
Data Entry in an Area
Editing Data
Sum
Summary of File Shortcut Keys
Saving Documents
Closing Documents
Opening Documents
Places Bar
Starting a New Document
The Windows Clipboard
Filling
Moving
Deleting Ranges
AutoFill Feature
Inserting
Deleting
AutoFormat
Cell Formatting
Column Widths
Row Heights
Print Area
Page Preview
Page Breaks
Page Formats
Introduction
Inserting Charts
Introduction
Working with Sheets
The Navigator and Sheets
Select Multiple Sheets
Sorting Data
Data Filtering
Headers
Splitting Window Panes
Navigating in Spreadsheets
Function Keys Used in Spreadsheets
Formatting Cells Using Shortcut Keys