Intoweb Training Virtual Expert

Novell OpenOffice Calc training

Back to Virtual Expert Demos

Have a look at the comprehensive e-learning offered below:

Opening Calc
Exploring the Calc Environment
Modifying the toolbar settings
Page Setup
Workbook Properties
Understanding the Open dialog box
Basic application options
Creating a new Workbook
Working with multiple worksheets
Renaming worksheets
Insert and delete worksheets
Moving and copying sheets
Hide and Show worksheets
Inserting Text
Changing the fonts and sizes of data
Changing the data color
Bold, underline and italicize data
Other underlining options
Superscript, Subscript and Strikethrough
Other formatting options
Text Alignment
Changing text case
Spell checking your workbook
Inserting special characters
Inserting Headers
Inserting Footers
Undo and Redo
Cut, Copy and paste
Paste Special
Hyphenation and Automatic Line Break
Thesaurus
Methods of Selection
Deleting and modifying existing data
Zooming Tool
AutoFormat
AutoCorrect options and settings
Inserting notes
Inserting Hyperlinks
Entering Numbers
Formatting number styles
Dates and Times
Labels and Values
Using formulas to calculate values
Error messages in a spreadsheet
The Error###
The Error: Err:503
The #NAME? Error
Calc Error Codes
Using the Subtotal function
The Outline Function
Outline Symbols
Absolute cell referencing
The IF Function
The PMT function
The RATE function
Using the detective function
The VLOOKUP function
The HLOOKUP function
Saving your Workbook for the first time
Versions
Closing your Workbook
Opening a saved Workbook
Opening and Working with multiple Workbooks
Modify and save with different name
Compare Workbooks
Save your Workbook as a template
Create a new file using a template
Using the Autopilot
Inserting rows and columns
Changing the row height and column width
Hide and Show Rows and Columns
Deleting Rows and Columns
Inserting a manual break
Remove a manual break
Insert cells
Modifying cell borders
Changing the backgrounds of cells
Merging cells
Deleting cells
Modifying page borders
Create a color background
Use a graphic as a background
Change sheet options
Viewing Options
Freeze panes
Split Window
Define Names
Creating names
Drawing graphics
Move and size graphics
Add text to graphics
Modifying line options
Fill a graphic with a color
Using a gradient fill
Create a hatching fill
Fill a graphic using a bitmap
Add a shadow to the graphic
Set transparency options
Add 3D graphics
Inserting rulers
Insert a picture from a file
Grouping graphics
Arrange graphics
Naming an object
Using textboxes to insert text
Fontwork
Insert a text animation
Inserting a chart
Changing the graph type
Modify Chart Elements
Resize and move the chart
Recording a macro
Running a macro
Tracking changes in a workbook
Protecting Data
Sorting Data
Multi-level sorting
Filtering Data
Start the Datapilot
Using the DataPilot
Refresh and Delete the DataPilot table
Consolidating data
Validity Options
Goal Seek
Printing your Workbook
Export as PDF
Sending your workbook via E-mail
Using the Help Feature
Exit OpenOffice Calc

Back to Virtual Expert Demos

© 2006 Intoweb Training

Intoweb Training Home | Contact Us | About us | Jobs | Site Map | Affiliates | Microsoft Training | Groupwise Training | Custom Made Solutions | Open Source Training | Virtual Expert | Business Training Solutions | Training Articles | Business Assessment Tools | Online Shop