Skip to content Skip to login

StarOffice Calc 7 - Advanced Training View a tutorial on this topic

Platform: PC

Description

StarOffice™ 7.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!
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview Creating a database range 14362 1:21
2. preview Defining a database range 14363 1:49
3. locked Making changes to a database range 14364 1:51
4. locked Sorting a database range 14365 2:07
5. locked Validating data 14366 2:30
6. locked Adding validation help to cells 14367 1:14
7. locked Removing validation 14368 0:55
8. locked Creating subtotals for the database range 14369 1:57
9. locked Consolidating database ranges 14370 2:51
10. locked Using multiple operations with database ranges 14371 2:45
11. locked Selecting database ranges 14372 0:55
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Making a criteria range 14347 1:19
2. locked Using a criteria range to search a database range 14348 1:21
3. locked Using comparison criteria to find information 14349 1:02
4. locked Using the AND condition to find information 14350 1:03
5. locked Using the OR condition to find information 14351 1:22
6. locked Copying filtered data to another area 14352 1:28
7. locked Using database functions 14353 1:35
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Preparing to use a VLOOKUP function 14354 1:17
2. locked Creating a VLOOKUP function 14355 1:57
3. locked Using a HLOOKUP function 14356 2:04
4. locked Rounding numbers using a function 14357 2:07
5. locked Using rounded numbers versus actual numbers 14358 1:18
6. locked Nesting functions 14359 2:48
7. locked Using an IF function with an AND condition 14360 2:34
8. locked Using the IF function with an OR condition 14361 1:48
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Inserting a chart 14373 2:15
2. locked Adding and removing chart gridlines 14374 1:13
3. locked Formatting the chart axis 14375 2:14
4. locked Changing the scale of the axis 14376 1:58
5. locked Formatting the data series 14377 1:53
6. locked Using a secondary axis in a chart 14378 1:24
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Applying conditional formatting 14379 1:51
2. locked Changing and removing conditional formatting 14380 0:45
3. locked Adding records in conditional formatted cells 14381 0:33
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a custom toolbar 14382 2:19
2. locked Adding a Custom button to a toolbar 14383 2:02
3. locked Deleting a custom toolbar 14384 0:35
4. locked Creating a custom menu 14385 2:21
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Saving data as a text file 14386 2:13
2. locked Opening data from a text or CSV file 14387 1:44
3. locked Inserting external data into a sheet 14388 1:50
4. locked Deleting linked data 14389 1:09
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Displaying formulas where active cell is used (Trace Dependents) 14390 1:26
2. locked Displaying cells used in formulas (Trace Precedents) 14391 1:27
3. locked Tracing formula errors 14392 1:00
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Using labels in formulas 14393 1:45
2. locked Manually creating an outline group 14394 1:41
3. locked Collapsing and expanding an outline group 14395 1:35
4. locked Removing outline groups 14396 0:58
5. locked Using AutoOutline 14397 1:14
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Recording and running a macro 14398 2:13
2. locked Adding a Macro to a menu 14399 1:15
3. locked Deleting a Macro from a menu 14400 0:39
4. locked Writing a macro 14401 1:42
5. locked Adding a shortcut key to a macro 14402 1:29
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Copying a value between sheets 14403 1:13
2. locked Copying formulas 14404 1:10
3. locked Using paste special for mathematical operations 14405 1:09
4. locked Converting column to row using transpose 14406 1:11
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Saving a Calc spreadsheet as a template 14407 1:18
2. locked Changing a saved template 14408 1:10
3. locked Managing your template 14409 2:12
4. locked Deleting a saved template 14410 0:59
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Protecting a sheet 14411 1:30
2. locked Password protect a spreadsheet on open 14412 1:58
3. locked Removing a spreadsheet's password 14413 1:17
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Touring the Data Source administration window 14414 2:06
2. locked Viewing data sources 14415 1:48
3. locked Creating a new data source based on a spreadsheet 14416 1:48
4. locked Creating a new data source based on a text file 14417 2:10
5. locked Creating a new data source based on an ODBC connection 14418 1:57
6. locked Creating a new data source based on an address book 14419 1:18
7. locked Creating a query using design view 14420 2:47
8. locked Creating a query using SQL 14421 2:24
9. locked Editing a query 14422 1:11
10. locked Renaming and deleting a query 14423 0:48
11. locked Linking a document to a data source 14424 1:18
12. locked Opening and editing documents using the link 14425 1:00
13. locked Editing and deleting a link 14426 1:19
14. locked Creating a new document and linking it to the data source 14427 1:16
15. locked Editing data using the data source viewer 14428 1:34
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Using an AutoPilot to create a data entry form 14429 2:06
2. locked Adding, deleting, and editing records in a form 14430 1:17
3. locked Finding a record using a data form 14431 1:12
4. locked Editing an existing form 14432 2:16
Tutorial series by Sarah DePriest
Sun and StarOffice are trademarks or registered trademarks of Sun Microsystems, Inc., in the United States and other countries.
©2012 Atomic Learning, Inc.   All rights reserved.