authorizations

  • Oracle
  • ForgeRock
  • symantec
  • gurulabs
Newsletter

Would you like to receive newsletters? Send us your email.


Sun OpenOffice.org Calc Specialist (OPO-1210)

Course ID : OPO-1210  

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 New Calc Users

Prerequisites

This course is intended for students new to Calc with the following prerequisite skill:
  • Basic computer literacy

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

Course Content

Module 1 - Introduction to OpenOffice.org Module 2 - Creating, Opening, Saving, and Viewing Spreadsheets Module 3 - Navigating within Spreadsheets Module 4 - Selecting Cells, Columns, Rows, and Sheets Module 5 - Working with Columns, Rows, and Sheets Module 6 - Entering and Editing Data Module 7 - Formatting Data Module 8 - Using Functions and Creating Formulas Module 9 - Creating Charts Module 10 - Viewing and Printing