Students taking the Sun OpenOffice.org Calc Specialist classroom course will gain the basic skills to enter data, create formulas and calculations, and insert chart objects to create and print spreadsheets. Using a variety of interactive demos and practice activities, the student learns how to group and filter data, and use ranges, headers and footers, and other moderately advanced topics. The course addresses the OpenOffice.org Specialist skill set. The OpenOffice.org Specialist course is for individuals who use the OpenOffice.org productivity software. Certification candidates must pass one of the Sun OpenOffice.org Certification exams in order to earn their Specialist Certification.
Who Can Benefit
OpenOffice Calc New Users
Prerequisites
This course is intended for students new to Calc with the following prerequisite skill:
Skills Gained
By the end of this course, you will be able to:
- Explain the benefits of OpenOffice.org
- Use OpenOffice.org Help
- Use the Calc Menus and Toolbars
- Create, Open and Save Spreadsheets
- Open and Save Spreadsheets with Different Formats
- Enter, Format, and Edit Numbers in Cells
- Enter and Edit Basic Formulas and Functions into Calc
- Leverage the Automatic Features of Calc
- Create Charts in Calc
- Modify Chart Formats and Styles
- Manage Worksheets
- Leverage Best Practices for Creating and Editing Spreadsheets
- Modify the Layout of a Page
Related Courses
Before:
After:
Course Content
Module 1 - Introduction to OpenOffice.org
- What is OpenOffice.org
- Starting OpenOffice.org
- What is Calc
- Spreadsheets and Cells
- Parts of the Main Window
- Defining General Settings for OpenOffice.org
Module 2 - Creating, Opening, Saving, and Viewing Spreadsheets
- What are Templates
- Starting a New Spreadsheet
- Opening an Existing Spreadsheet
- Closing a Spreadsheet
- Saving Spreadsheet
- Exporting to PDF
- Quick exporting to PDF
- Controlling PDF content and quality
- Export to XHTML
- Password Protection
- Saving a Document Automatically
- Saving a Spreadsheet as Another Type
- Saving as Web pages (HTML)
- Closing OpenOffice.org
Module 3 - Navigating within Spreadsheets
- Going to a Particular Cell
- Using the Navigator
- Moving form Cell to Cell
- Moving from sheet to sheet
- Selection Mode
- Customizing the effect of the Enter key
Module 4 - Selecting Cells, Columns, Rows, and Sheets
- Selecting Cells
- Selecting columns and rows
- Selecting
Module 5 - Working with Columns, Rows, and Sheets
- Inserting Columns and Rows
- Modifying Column Width and Row Height
- Deleting columns and rows
- Inserting new sheets
- Deleting sheets
- Renaming sheets
- Moving and Copying sheets
Module 6 - Entering and Editing Data
- Spreadsheet Best Practices
- Entering Data
- Undoing and redoing changes
- Using Spellchecker
- AutoCorrect
- Speeding Up Data Entry
- Editing Data
- Find & Replace
- Cutting, copying and pasting
Module 7 - Formatting Data
- What is Formatting
- Using the Formatting Toolbar
- Formatting the Font
- Bold, Italic and Underline
- Formatting numbers
- Formatting the cell borders
- Formatting the cell background
- Font Color
- Formatting Paintbrush
- AutoFormatting cells and sheets
- Defining a new AutoFormat
- Formatting spreadsheets using themes
- Using Conditional Formatting
Module 8 - Using Functions and Creating Formulas
- Understanding Functions
- Understanding the structure of functions
- Advanced Structure
- Creating Formulas
- Operators in formulas
- Operator types
- Order of calculation
- Basic Arithmetic and Statistical Functions
- Calculations Linking Sheets
- Strategies for Creating Formulas
- Absolute and Relative References
- Finding and Fixing Errors
Module 9 – Charts
- Creating a Chart
- Editing Charts
- Changing the chart type
- Chart Types
- Chart title
- Data Labels
- Trend Lines
- Mean value lines
- Y error bars
- Formatting Charts
- Using the Chart Object Properties
- Resizing and Moving Charts
Module 10 - Viewing and Printing
- Using zoom
- Freezing, Unfreeze columns and rows
- Splitting the screen
- Creating a Clone of a Document
- Switching Between Documents
- Page Breaks
- Page Options
- Headers and Footers
- Selecting the page order, details and scale
- Using Print Ranges
- Previewing pages before printing
|
