home

Year 10 Spreadsheets- Look down the list to find you name and the video that you need to produce

Set up your spreadsheet first then use www.screencast-matic.com or www.screenr.comor look at the list of screencast software at Shambles Screencating Software Make sure that your name appears somewhere in the video screencast.

When you have completed your video go to Edit wiki and add the link to your screencast video. Go to link above then choose external linke to add your link

Here is one I made earlier:- How to use Format Painter @http://screenr.com/i5b

How to use a simple if function- Tach

How to use Sumif - Aki []

How to use conditional formatting- Bryan - []

How to use lookups - Ham-[]

Show how copying a formulae with an absolute cell reference is difference from copying with a relative reference - Ajay-[]

Show how you can get a spreadsheet to show formulae clearly all on the same page- Mos []

Show how to hide columns in a spreadsheet and set column widths to an exact size - Gor

Show how to a data filter can be used to show only some of the data in a table - Nam

Show how you can use named cells in a formula - Chin Woo-[]

Show how to add a header and a footer to a large spreadsheet and to get it to all print on one page.- Alex

Show how to format part of a spreadsheet to show dates and another part to show currency in $- Gor

Show how to change the date settings on a computer from US to UK eg 1/14/2011 (USA) vs 14/1/2011 (UK) - Akmal

Show how to create a simple pie chart showing the percentages and a title- Tuch

Show how to use an AND formula- Vago- http://screenr.com/3M6

Show how to use an OR formula - Jeffrey

Show how to get add up a set of number on one sheet of a spreadsheet so that the total always shows on another sheet.- Mike

Show how to sort a table of data using more than one level sort - Ja