Suitable spreadsheet techniques and build for the WJEC AS course, but could equally be used by anyone wanting to learn how to create a spreadsheet with a few macros,Multiple IF, VLOOKUP, 3D referencing and much more. Suitable for KS4 and KS5 and quite useful to compare to a relational database once built.

	vid 1 - stock and order
	vid 2 - stock macro
	vid 3 - spinners and date macro
	vid 4 - the vlookup function
	vid 5 - archiving an order
	vid 6 - updating stock levels
	vid 7 - navigation system
	vid 8 - finishing up