Publisher: Open

Version: 3.1
Length: 1 day
Course-ID: 084295

Course Description

You will use the features and tools present in OpenOffice.org 3.1 Calc to manage data. You will also apply advanced analysis techniques to more complex data sets. In addition, you will apply visual elements and advanced formulas to a spreadsheet.

Who should attend

This course is designed for general office workers as well as data analysts.

What will I learn

How to create a spreadsheet, perform calculations. Modify and format a spreadsheet. Audit and analyze data in a spreadsheet. Present data using charts. Finalize a spreadsheet.


Exploring the OpenOffice Calc Interface
  • Explore the Interface
  • Customize the Interface
  • Obtain Help
Creating a Spreadsheet
  • Enter Data in a Spreadsheet
  • Save a Spreadsheet
Performing Calculations
  • Calculate Using Basic Formulas and Functions
  • Calculate Using Advanced Functions
Modifying a Spreadsheet
  • Manipulate Data
  • Sort and Filter Data
  • Search for Data in a Spreadsheet
  • Spell Check a Spreadsheet
Formatting a Spreadsheet
  • Format Cells
  • Apply Conditional Formatting
Auditing Data in a Spreadsheet
  • Trace Cells
  • Troubleshoot Errors in Formulas
  • Add Data Validation Criteria
Analyzing Data
  • Create Scenarios
  • Analyze Data Using Goal Seek
  • Analyze Data Using Solver
  • Analyze Data Using DataPilot
Presenting Data Using Charts
  • Create a Chart
  • Modify a Chart
Finalizing a Spreadsheet
  • Prepare a Spreadsheet for Distribution
  • Export a Spreadsheet