If you are unable to view the movies,
please download Adobe Flash Player
These movies can be downloaded to your desktop for future, easy access.
QuickTime Player is required to
play
the downloadable movies.
How to use the features of Open Office
Using Calc (.ods)
Getting started
Basic spreadsheets, Entering and formatting data, creating formulas, copying formulas, simple graphs, conditional formulas, concatenation of text.
More advanced Spreadsheets
Builds on earlier tutorial, adding: Multiple sheets, moving data between sheets, combining formulas,
using conditional formulas to suppress unhelpful output. New functions are VLOOKUP and COUNTIF.
Spreadsheet Smorgasbord
Builds on earlier tutorials, adding Quartiles (& Median), Percentile Rank, Conditional Formatting (format depends on cell value), VLOOKUP to apply descriptors from a list. New functions are: QUARTILE, PERCENTRANK.
Last updated on Thursday, 02 September 2010 03:12PM
Questions?
If you have a question that is not answered
here, you can e-mail Webmaster
