Call: 0118 3243000
Systematix Training Ltd

OpenOffice Calc 2.3

Course Description

Worksheets are an integral part of financial analysis and audit. Experts pore over pages of mundane data to make interpretations and permutations. During such operations, they have to be meticulous as overlooking even a minor detail would prove disastrous and require starting the calculation afresh. The ability to manipulate data and perform calculations automatically using a software application certainly has more advantages over the printed format. In this course, you will use the features and tools present in OpenOffice Calc 2.3 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

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.

We offer a range of OpenOffice training courses

Exploring the OpenOffice Calc Interface
  • Explore the Interface
  • Obtain Help
  • Customize the Interface
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 DataPilot
Presenting Data Using Charts
  • Create a Chart
  • Modify a Chart
Finalizing a Spreadsheet
  • Prepare a Spreadsheet for Distribution
 
Publisher: Open
Version: 2.3
Length: 1 day
Course-ID: 084294

Printer Friendly Version
Download Outline As PDF
Request A Quote Ask Us A Question

One of the best external courses I have ever attended

- Bayer

Microsoft Registered Partner
BSI ISO 9000