Novell OpenOffice Calc training
Intoweb Training has created a web-based, Intranet driven virtual helpdesk that allows organizations to do Openoffice Calc training with their employees without having to attend a training seminar or even leave their designated workstations.
These systems are more than just training systems. Due to easy accessibility via the Intranet, employees will use them as a help facility as well, giving them OpenOffice Calc training on the fly. Allowing you to empower your business to leverage Linux and open source with confidence.
For more information please feel free to contact us at
The following lists the items that are covered in Calc:
- Opening Calc
- The Workbook environment
- Modifying the Toolbar settings
- Calc Help
- Opening a new spreadsheet
- Understanding the "Open" dialog box
- Workbook Properties
- Setting up your pages
- Working with multiple worksheets
- Renaming worksheets
- Insert and delete worksheets
- Moving and copying worksheets
- Adjusting column width and row height
- Hiding and unhiding rows and columns
- Inserting columns and rows
- Deleting columns and rows
- Merging cells
- Entering and correcting data
- Changing the font and size of text
- Changing the color of text
- Bold, underline and italicize text
- Other underlining options
- Aligning text
- Inserting special characters
- Undo and Redo
- Cut, copy and paste
- Using the Paste Special function
- The Autofill feature
- Inserting a note
- The AutoFormat feature
- The AutoCorrect feature
- Spell checking your worksheet
- Using the Thesaurus
- Find and Replace text
- Hyperlinks
- Hyperlinks within a workbook
- Entering Numbers
- Formatting number styles
- Dates and Times
- Labels and Values
- Adding borders to cells
- Applying a color background
- Page Break Preview
- Saving your Workbook for the first time
- Opening a new workbook
- Opening an existing workbook
- Sorting Data
- Multi-level sorting
- Filtering Data
- Recording Macros
- Drawing functions
- Moving and sizing objects
- Grouping Objects
- Adding text to graphics
- Insert graphics from a file
- Adjusting Graphics
- Using the Gallery
- Using textboxes to enter text
- FontWork
- Insert text animation
- 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
- Creating a chart
- Formatting your chart area
- Modifying chart data
- Protecting your worksheet
- Freeze Panes
- Creating a Template
- E-mail you workbook
- Exit Calc
|