OpenOffice.org: Calc 1.1

OpenOffice.org: Calc is a spreadsheet software that is a free alternative to Microsoft Excel. It allows you to store, organize, and analyze numerical information. This topic covers version 1.1.

Lessons

Learn at Your Own Pace

Acquiring the skills you need can be done in no time with this free, self-paced tutorial.

Select a lesson to begin:

Unit 1: OpenOffice.org Calc (Spreadsheet) Basics

1: Install and Launch OpenOffice.org

2: Identify Basic Parts of the OpenOffice.org Calc Window

3: Create, Open and Save Workbooks

4: Enter, Edit and Delete Data

5: Moving, Copying and Deleting Cell Contents

6: Creating Simple Formulas

7: Creating Complex Formulas

Unit 2: Worksheet Layout and Management

8: Using Functions

9: Working with Multiple Worksheets

10: Inserting and Deleting Rows and Columns

11: Changing Column Width and Row Height

12: Inserting and Deleting Cells

13: Text and Cell Alignments

14: Formatting Numbers

15: Applying Font Color and Borders to Cells

Unit 3: Charting, Printing, File Formats, and Document Sharing

16: Creating a Chart

17: Moving, Resizing, and Deleting Charts

18: Editing Charts

19: Formatting a Chart

20: Defining Page Setup Options

21: Print Management

22: File Formats and Sharing Documents

Add new unit

View all lesson pages

1: Unit 1: OpenOffice.org Calc (Spreadsheet) Basics

Add New Lesson

1: Install and Launch OpenOffice.org edit

2: Identify Basic Parts of the OpenOffice.org Calc Window edit

3: Create, Open and Save Workbooks edit

4: Enter, Edit and Delete Data edit

5: Moving, Copying and Deleting Cell Contents edit

6: Creating Simple Formulas edit

7: Creating Complex Formulas edit

2: Unit 2: Worksheet Layout and Management

Add New Lesson

8: Using Functions edit

9: Working with Multiple Worksheets edit

10: Inserting and Deleting Rows and Columns edit

11: Changing Column Width and Row Height edit

12: Inserting and Deleting Cells edit

13: Text and Cell Alignments edit

14: Formatting Numbers edit

15: Applying Font Color and Borders to Cells edit

3: Unit 3: Charting, Printing, File Formats, and Document Sharing

Add New Lesson

16: Creating a Chart edit

17: Moving, Resizing, and Deleting Charts edit

18: Editing Charts edit

19: Formatting a Chart edit

20: Defining Page Setup Options edit

21: Print Management edit

22: File Formats and Sharing Documents edit

Explore Our Online Classes

We do not offer an online class for .

View our complete list of classes to explore other topics with the help of an online instructor.

Articles

Want to learn more? Read these recommended articles:

Recording a Macro in OpenOffice.org Calc Using the Stylist in OpenOffice.org Calc Doing More with OpenOffice.org's Calc What is OpenOffice.org Calc?

Extras

Test your knowledge now!

Thank you so much for the opportunity to participate in this course. I appreciate that I was able to do the work when I had time between the other millions of things I have to do. I am looking forward to adding the certificate to my resume.

-Online Learner Maple Ridge, Canada

OpenOffice.org: Calc 1.1

Lessons

Videos

Learn at Your Own Pace

Explore Our Online Classes

Articles

Extras

Sign in or create an account to access this content.

Sign In

Create an Account

OpenOffice.org: Calc 1.1

Lessons

Videos

Learn at Your Own Pace

Explore Our Online Classes

Articles

Extras

Sign in or create an account to access this content.

Sign In

Create an Account

Sign in or create an account.

Sign In

Create an Account