EXCEL

EXCEL TIPS

http://www.scribd.com/doc/21129191/Excel-2003-for-IGCSE-ICT

Creating a database and INTERROGATING (making a query) it. Also, you can always put your cursor in the top left corner of your data where the fileld headings are and select DATA from the top headings and then FILTER to obtain the drop down boxes.

media type="youtube" key="wpR-YQnRnq0" height="390" width="480"

Good site with worked examples especially SUMIF
 * @http://www.homeandlearn.co.uk/me/MicrosoftExcel.html ||

=vlookup video - this turns up in all exams! media type="youtube" key="CtHJrjW31cA?fs=1" height="385" width="480"

VLOOKUP across two worksheets
media type="youtube" key="vgb_rdI67Zs" height="390" width="480"

=sum =count =sum =sumif =countif functions - they turn up in all exams!

media type="youtube" key="H01XEyPlIvM?fs=1" height="385" width="480"



Nested IF statement

media type="youtube" key="zxYc_Jki7eI" height="390" width="480"