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.
www.Openoffice.org is the leading open-source office software suite. It works on all common PCs, it stores all data in an international open standard format and can also read and write files from other common office software packages. It can be downloaded and used free of charge for any purpose.
Target Student:
This course is designed for general office workers as well as data analysts.
Delivery Method:
Instructor-led Training
Course Content
Lesson 1: Exploring the OpenOffice Calc Interface
- Topic 1A: Explore the Interface
- Topic 1B: Customize the Interface
- Topic 1C: Obtain Help
Lesson 2: Creating a Spreadsheet
- Topic 2A: Enter Data in a Spreadsheet
- Topic 2B: Save a Spreadsheet
Lesson 3: Performing Calculations
- Topic 3A: Calculate Using Basic Formulas and Functions
- Topic 3B: Calculate Using Advanced Functions
Lesson 4: Modifying a Spreadsheet
- Topic 4A: Manipulate Data
- Topic 4B: Sort and Filter Data
- Topic 4C: Search for Data in a Spreadsheet
- Topic 4D: Spell Check a Spreadsheet
Lesson 5: Formatting a Spreadsheet
- Topic 5A: Format Cells
- Topic 5B: Apply Conditional Formatting
Lesson 6: Auditing Data in a Spreadsheet
- Topic 6A: Trace Cells
- Topic 6B: Troubleshoot Errors in Formulas
- Topic 6C: Add Data Validation Criteria
Lesson 7: Analyzing Data
- Topic 7A: Create Scenarios
- Topic 7B: Analyze Data Using Goal Seek
- Topic 7C: Analyze Data Using Solver
- Topic 7D: Analyze Data Using DataPilot
Lesson 8: Presenting Data Using Charts
- Topic 8A: Create a Chart
- Topic 8B: Modify a Chart
Lesson 9: Finalizing a Spreadsheet
- Topic 9A: Prepare a Spreadsheet for Distribution
- Topic 9B: Export a Spreadsheet
