|
Provided by: NobleProg - IT training courses OpenOffice CalcOpen Office |
 |
|
|
||||||||||||||||||||
Calc Overview
Similarities and differences between OpenOffice Calc and Microsoft Excel
Calc navigation and useful shortcuts
Working with workbooks
Freezing and splitting panes
Working with Worksheets
Inserting and removing data from a cell
Comments
Copying Data, Formats and Formulas
Paste special
Keyboard shortcuts
AutoFill
Filling cells with data series
Creating sort list (e.g. Jan,Feb,March, etc.)
Formulas, Address and Names
Formuals
Basic logic expressions
Lookup functions
Absolute and relative addresses
Cross-workbook and cross-worksheet references
Naming cells and ranges
Formatting
Formatting worksheets
Using Styles
Formatting Cells
Format Paintbrush
Functions
Basic functions (sum, average, round, count, etc.)
Date and time functions
Conditional functions
Function Wizard
Charts
Chart types
Embedding charts
Chart elements
Multi-series charts
Formatting legend, axis and other charts elements
Document Protection
Workbook protection
Worksheet protection
Hiding cells
Protecting cells
