Generate Direct Linking HTML

Select the tutorials you would like to include in the Direct Linking HTML, then click the "Preview" button.

OpenOffice.org 3.1 Calc - Intro
- A. Basics
- - Introducing Calc
  - Using the menus and toolbars
  - Docking and floating the toolbars
  - Customizing the toolbars pt. 1
  - Customizing the toolbars pt. 2
  - Using the help agent, tips, and extended tips
  - Using help
  - Understanding a spreadsheet and entering information into a cell
  - Using Save and Save As
  - Moving with the keyboard pt. 1
  - Moving with the keyboard pt. 2
  - Understanding compatibility with other spreadsheet applications
- B. Working with Cells
- - Using AutoComplete
  - Editing a cell
  - Using spell check
  - Selecting cell ranges pt. 1
  - Selecting cell ranges pt. 2
  - Using Selection mode
  - Entering values in a cell range
  - Using AutoFill
  - Using Cut, Copy and Paste
  - Using Paste Special
  - Using drag and drop editing
  - Using Undo and Redo
  - Using Delete and the Delete Contents command
- C. Formulas and Functions
- - Using the status bar to calculate cell ranges
  - Using the Sum command
  - Creating formulas
  - Using functions in formulas
  - Using the Function wizard pt. 1
  - Using the Function wizard pt. 2
  - Using the Function List
  - Editing formulas
  - Using relative cell referencing
  - Understanding absolute cell references
  - Creating an absolute cell reference
- D. Formatting Cells
- - Formatting numbers using the Formatting toolbar
  - Formatting text using the Formatting toolbar
  - Using the Alignment and Indentation commands
  - Rotating information in a cell
  - Wrapping text in a cell
  - Using the Merge Cells command
  - Using the Borders command
  - Formatting cells using the Format Cells dialog box
  - Using the Format Paintbrush command
  - Applying AutoFormat
- E. Working with Columns and Rows
- - Selecting columns and rows
  - Changing column width
  - Changing row height
  - Hiding and showing columns and rows
  - Inserting columns
  - Inserting rows
  - Deleting columns and rows
  - Inserting and deleting cells
- F. Page Setup and Printing
- - Using zoom
  - Using Page Break Preview
  - Changing the page setup
  - Setting manual page breaks
  - Setting rows to repeat
  - Editing headers and footers pt. 1
  - Editing headers and footers pt. 2
  - Using Page Preview
  - Printing
  - Defining, adding to, and removing print ranges
  - Saving as a PDF

OpenOffice.org 3.1 Calc - Intro

Platform: PC

OpenOffice.org^™ 3.1 is a free open-source office software suite for word processing, spreadsheets, presentations, and more. This tutorial series focuses on the spreadsheet application of the suite, Calc.

Click here to learn about subscribing to this collection!

Click any of the highlighted titles to view free sample tutorial movies. Atomic Training subscribers to this collection have access to all of the following movies, plus thousands of tutorials on other applications.

Expand all / Collapse all

A. Basics

		Key #	Length
1.	Introducing Calc	77892	1:03
2.	Using the menus and toolbars	77828	1:53
3.	Docking and floating the toolbars	77829	1:47
4.	Customizing the toolbars pt. 1	77830	1:24
5.	Customizing the toolbars pt. 2	77879	2:04
6.	Using the help agent, tips, and extended tips	77831	3:08
7.	Using help	77832	3:11
8.	Understanding a spreadsheet and entering information into a cell	77882	2:23
9.	Using Save and Save As	77833	3:21
10.	Moving with the keyboard pt. 1	77834	1:57
11.	Moving with the keyboard pt. 2	77883	2:10
12.	Understanding compatibility with other spreadsheet applications	77835	2:10

B. Working with Cells

		Key #	Length
1.	Using AutoComplete	77836	1:38
2.	Editing a cell	77837	1:43
3.	Using spell check	77838	2:51
4.	Selecting cell ranges pt. 1	77839	2:43
5.	Selecting cell ranges pt. 2	77840	1:44
6.	Using Selection mode	77884	1:04
7.	Entering values in a cell range	77841	0:57
8.	Using AutoFill	77842	2:27
9.	Using Cut, Copy and Paste	77852	2:08
10.	Using Paste Special	77853	1:30
11.	Using drag and drop editing	77854	1:31
12.	Using Undo and Redo	77855	1:57
13.	Using Delete and the Delete Contents command	77856	1:20

C. Formulas and Functions

		Key #	Length
1.	Using the status bar to calculate cell ranges	77843	1:19
2.	Using the Sum command	77844	1:39
3.	Creating formulas	77845	2:53
4.	Using functions in formulas	77846	2:21
5.	Using the Function wizard pt. 1	77847	1:41
6.	Using the Function wizard pt. 2	77885	1:59
7.	Using the Function List	77886	2:33
8.	Editing formulas	77848	3:06
9.	Using relative cell referencing	77849	2:34
10.	Understanding absolute cell references	77850	3:06
11.	Creating an absolute cell reference	77851	1:35

D. Formatting Cells

		Key #	Length
1.	Formatting numbers using the Formatting toolbar	77880	1:24
2.	Formatting text using the Formatting toolbar	77881	1:31
3.	Using the Alignment and Indentation commands	77857	1:04
4.	Rotating information in a cell	77858	2:51
5.	Wrapping text in a cell	77859	1:24
6.	Using the Merge Cells command	77860	1:20
7.	Using the Borders command	77861	1:03
8.	Formatting cells using the Format Cells dialog box	77862	2:22
9.	Using the Format Paintbrush command	77863	1:40
10.	Applying AutoFormat	77887	1:39

E. Working with Columns and Rows

		Key #	Length
1.	Selecting columns and rows	77864	2:15
2.	Changing column width	77865	2:41
3.	Changing row height	77866	2:52
4.	Hiding and showing columns and rows	77867	2:49
5.	Inserting columns	77868	1:47
6.	Inserting rows	77869	1:39
7.	Deleting columns and rows	77870	2:22
8.	Inserting and deleting cells	77871	2:26

F. Page Setup and Printing

		Key #	Length
1.	Using zoom	77888	1:19
2.	Using Page Break Preview	77872	2:48
3.	Changing the page setup	77873	1:42
4.	Setting manual page breaks	77874	1:39
5.	Setting rows to repeat	77875	2:02
6.	Editing headers and footers pt. 1	77876	1:47
7.	Editing headers and footers pt. 2	77890	2:23
8.	Using Page Preview	77889	1:09
9.	Printing	77877	1:27
10.	Defining, adding to, and removing print ranges	77878	2:17
11.	Saving as a PDF	77891	1:52