OpenOffice.org 2 Calc - Advanced View a tutorial on this topic

Platform: PC

Description

OpenOffice.org™ 2 Calc is a modern, fully equipped spreadsheet application that runs on multiple platforms. It's simple enough for doing quick calculations and powerful enough to create elaborate documents, charts, and graphs. You'll enjoy learning about the more complex features of Calc with this advanced level tutorial series.
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.
Key # Length
1. preview Creating a database range 21316 1:23
2. preview Defining a database range 21317 1:45
3. locked Making changes to a database range 21318 2:32
4. locked Sorting a database range 21319 2:13
5. locked Validating data 21320 2:27
6. locked Adding validation help to cells 21321 1:08
7. locked Removing validation 21322 0:52
8. locked Creating subtotals for the database range 21323 1:51
9. locked Consolidating database ranges 21324 2:43
10. locked Using multiple operations with database ranges 21325 2:07
11. locked Selecting database ranges 21326 0:50
Key # Length
1. locked Making a criteria range 21327 0:58
2. locked Using a criteria range to search a database range 21328 1:18
3. locked Using comparison criteria to find information 21329 1:03
4. locked Using the AND condition to find information 21330 1:05
5. locked Using the OR condition to find information 21331 1:17
6. locked Copying filtered data to another area 21332 1:26
7. locked Using database functions to filter a database 21333 1:47
Key # Length
1. locked Preparing to use a VLOOKUP function 21334 0:55
2. locked Creating a VLOOKUP function 21335 2:05
3. locked Using a HLOOKUP function 21336 2:02
4. locked Rounding numbers using a function 21337 2:21
5. locked Using rounded numbers versus actual numbers in formulas 21338 2:00
6. locked Using labels in formulas 21339 1:45
Key # Length
1. locked Manually creating an outline group 21340 1:20
2. locked Opening and closing an outline group 21341 1:35
3. locked Removing outline groups 21342 0:58
4. locked Using AutoOutline 21343 1:07
Key # Length
1. locked Displaying formulas where the active cell is used (Trace Dependents) 21344 1:27
2. locked Displaying cells used in the selected formula (Trace Precedents) 21345 1:28
3. locked Tracing formula errors 21346 1:03
Key # Length
1. locked Pasting the value rather than the formula 21347 1:15
2. locked Copying formulas using paste special 21348 1:13
3. locked Using paste special for mathematical operations 21349 1:05
4. locked Transposing data from columns to rows 21350 1:11
Key # Length
1. locked Applying conditional formatting 21351 1:56
2. locked Changing and removing conditional formatting 21352 0:44
3. locked Adding records in conditional formatted cells 21353 0:31
Key # Length
1. locked Inserting a chart 21354 2:12
2. locked Adding and removing chart gridlines 21355 0:58
3. locked Formatting the chart axis 21356 2:15
4. locked Changing the scale of the axis 21357 1:58
5. locked Formatting the data series 21358 2:03
6. locked Using a secondary axis in a chart 21359 1:22
Key # Length
1. locked Creating a custom toolbar 21360 2:44
2. locked Adding a Custom button to a toolbar 21361 1:45
3. locked Deleting a custom toolbar 21362 0:51
4. locked Creating a custom menu 21363 1:54
Key # Length
1. locked Saving data as a text file 21364 2:19
2. locked Opening data from a text or CSV file 21365 1:41
3. locked Manually updating linked data 21366 1:15
4. locked Linking to external data in a sheet 21367 0:47
5. locked Deleting linked data 21368 1:08
Key # Length
1. locked Saving a Calc spreadsheet as a template 21369 1:49
2. locked Changing a saved template 21370 1:08
3. locked Managing your template 21371 2:05
4. locked Deleting a saved template 21372 0:54
Key # Length
1. locked Protecting a sheet 21373 1:32
2. locked Password protecting a spreadsheet on open 21374 1:58
3. locked Removing a spreadsheet's password 21375 1:15
Key # Length
1. locked Recording and running a macro 21376 2:19
2. locked Adding a Macro to a menu 21377 1:34
3. locked Deleting a Macro from a menu 21378 0:49
4. locked Writing a macro 21379 1:46
5. locked Adding a shortcut key to a macro 21380 1:28
Key # Length
1. locked Viewing data sources 21381 2:17
2. locked Editing data using the Data Source Explorer 21382 1:35
3. locked Copying data into Calc from the Data Source Explorer 21383 1:00
Tutorial series by Sarah DePriest
Sun and OpenOffice.org are trademarks or registered trademarks of Sun Microsystems, Inc., in the United States and other countries.