open office calc tutorial 3 - Inbuilt functions within Calc
This tutorial illustrates a couple of the inbuilt functions within Calc and how to configure them. It looks at Vlookup and Countif Check out the full collection at http://opensourcesource.wikispaces.com
open office calc - Explanation of the interface
An introduction to Open Office Calc. This video tutorial explains the interface and demonstrates how to input data, format cells, use the autofill function and finally how to create formulae.
http://opensourcesource.wikispaces.com/
Excel lesson 5 - How to create macros
How to create macros to do repeatable tasks in Excel. Also cover the 'if' and 'countif' functions to create self marking tests.