Skip to content Skip to navigation Skip to login

StarOffice Calc 6 Training

Platform: PC

Description

StarOffice™ 6.0 Calc - a Sun™ Open Net Environment (Sun ONE) software offering - is a powerful spreadsheet tool. It is part of an affordable alternative in office productivity suites that runs on multiple operating systems.

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

Click here to learn about subscribing to this collection!

Expand all / Collapse all

A. Getting Started:

Tutorial Number	Tutorial Title	Key #	Length
1.	Creating a new spreadsheet	4067	1:26
2.	Get familiar with the Calc window	4068	1:48
3.	Adding, reordering, renaming, and deleting sheets	4070	2:05
4.	Using the Navigator	4071	1:23

B. Entering Data:

Tutorial Number	Tutorial Title	Key #	Length
1.	Entering and deleting data and moving around a spreadsheet	4076	2:12
2.	Filling the same data down a column or across a row	4077	1:26
3.	Filling incremental data down a column or across a row	4078	1:28
4.	Entering percentages in Calc	4079	1:19
5.	Using the AutoCorrect features	4080	1:35
6.	AutoInputting Text	4081	1:01
7.	Using a selection list for quick data entry	4082	0:44

C. Calculations:

Tutorial Number	Tutorial Title	Key #	Length
1.	Sum a row or column	4090	0:56
2.	Inserting subtotals	4100	1:39
3.	Using the logical IF function	4101	1:58
4.	Getting an average using the Function AutoPilot	4113	2:02

D. Formatting:

Tutorial Number	Tutorial Title	Key #	Length
1.	Find and Replace in Calc	4072	1:35
2.	Preventing Calc from automatically formatting your text	4073	1:00
3.	Find and Replace in Calc: Similarity and Wildcard searches	4074	2:37
4.	Making text fit in cells (wrapping text)	4075	1:15
5.	Creating and using a sort list	4083	2:16
6.	Selecting entire rows, columns, non-adjacent cells and spreadsheets	4084	1:15
7.	Resizing rows and columns	4085	0:59
8.	Hiding and showing rows and columns	4086	1:30
9.	Inserting and deleting rows and columns	4087	1:14
10.	AutoFormatting cells and creating your own autoformats	4088	1:26
11.	Quick cell formatting using the Object Bar	4089	2:55
12.	Cell formatting using color themes	4099	1:40
13.	Combining 2 cells into 1(merging cells)	4112	1:34
14.	Setting up headers and footers	4091	2:14
15.	Adding and deleting a manual page break	4093	1:27
16.	Preventing scrolling in a region of a spreadsheet	4094	1:54
17.	Splitting a spreadsheet	4095	1:19
18.	Sorting your data	4096	2:07
19.	Adding a note to a cell	4097	1:35
20.	Naming a region for quick reference	4098	1:58
21.	Previewing your spreadsheet before printing	4092	1:11
22.	Controlling how your spreadsheet prints out (page setup)	4102	1:59
23.	Emailing an open spreadsheet	4069	0:35

E. Additional Formatting:

Tutorial Number	Tutorial Title	Key #	Length
1.	Cell formatting using the Stylist	4103	1:36
2.	Creating your own cell style	4104	1:53
3.	Displaying data using AutoFilter	4105	1:32
4.	Displaying data using the Standard Filter	4106	1:35
5.	Using relative cell references	4109	1:14
6.	Using absolute cell references	4110	2:03
7.	Rotating text using the cell attributes window	4111	2:15