|
Chapter 1: OpenOffice.org 3.1
- Lesson 1.1 : What is OpenOffice.org 3.1?
- Lesson 1.2 : Why use OpenOffice.org?
- Lesson 1.3 : Getting Started with Openoffice.org 3.1 Calc
- Lesson 1.4 : Benefits of Calc
Chapter 2: Creating and Navigating a Spreadsheet
- Lesson 2.1 : Interface Ride
- Lesson 2.2 : Creating a new Workbook
- Lesson 2.3 : Saving a Workbook
- Lesson 2.4 : Closing a Saved Workbook
- Lesson 2.5 : Opening the Existing Workbook
- Lesson 2.6 : Sending the Workbook as an Email
- Lesson 2.7 : Exporting the Workbook
Chapter 3: Working with Cells
- Lesson 3.1 : Inserting your Data into Cells
- Lesson 3.2 : Moving and Grooving Cells
- Lesson 3.3 : Selecting Cells
- Lesson 3.4 : Cut, Copy and Paste
- Lesson 3.5 : Undo, Redo and Repeat
- Lesson 3.6 : Finding and Replacing Cell Contents
Chapter 4: Filling
- Lesson 4.1 : Auto Fill
- Lesson 4.2 : Custom Fill – Using Series
Chapter 5: Making Calculations in Calc
- Lesson 5.1 : Defining Formulas – I
- Lesson 5.2 : Defining Formulas – II
- Lesson 5.3 : Cell References
- Lesson 5.4 : Working with Functions – I
- Lesson 5.5 : Working with Functions – II
- Lesson 5.6 : Working with Functions – III
Chapter 6: Viewing a Spreadsheet
- Lesson 6.1 : Page Views
- Lesson 6.2 : Displaying Toolbars, Rulers and Status Bar
- Lesson 6.3 : Highlighting Numerical Values
Chapter 7: Handling Cells, Columns and Rows
- Lesson 7.1 : Inserting a Cell, Row or Column
- Lesson 7.2 : Deleting a Cell, Row or Column
- Lesson 7.3 : Merging & Splitting Cells
- Lesson 7.4 : Changing Width and Height
- Lesson 7.5 : Hiding and Restoring Columns and Rows
Chapter 8: Formatting Cells
- Lesson 8.1 : Formatting Numbers
- Lesson 8.2 : Fonts and Font Effects
- Lesson 8.3 : Text Alignments
- Lesson 8.4 : Auto Format
- Lesson 8.5 : Applying Styles
- Lesson 8.6 : Using Conditional Format
Chapter 9: Inserting Graphics
- Lesson 9.1 : Inserting Images
- Lesson 9.2 : Working with Graphics
- Lesson 9.3 : Insert images from Gallery
- Lesson 9.4 : Drawing on your Own
- Lesson 9.5 : Inserting OLE Object
Chapter 10: Other Insert Features
- Lesson 10.1 : Chart Using Chart Wizard
- Lesson 10.2 : Editing the Chart
- Lesson 10.3 : Keeping Links with Hyperlinks
- Lesson 10.4 : Inserting Notes
Chapter 11: Managing Worksheets
- Lesson : 11.1 : Adding and Deleting Sheets
- Lesson : 11.2 : Selecting and Renaming Sheets
- Lesson : 11.3 : Copying and Moving Sheets
- Lesson : 11.4 : Hiding and Restoring Sheets
Chapter 12: Printing your Work
- Lesson : 12.1 : Previewing the Printout
- Lesson : 12.2 : Formatting Page Printout
- Lesson : 12.3 : Dealing with Page Breaks
- Lesson : 12.4 : Printing a Calc Spreadsheet
Chapter 13: Sharing
- Lesson13.1 : Protecting the Workbook
- Lesson13.2 : Protecting Worksheet
- Lesson13.3 : Protecting Cells
- Lesson13.4 : Tracking the Changes in a Document
- Lesson13.5 : Comparing and Merging Workbook
Chapter 14: Report Creation
- Lesson14.1 : Sorting the Records
- Lesson14.2 : Filtering the Records
- Lesson14.3 : Groups and Outline
- Lesson14.4 : Sub Total List
- Lesson14.5 : Data Pilot
Chapter 15: Handling Data
- Lesson15.1 : Trace Dependence and Precedence
- Lesson15.2 : Goal Seek
- Lesson15.3 : Solver
- Lesson15.4 : Validity Checking
|