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.

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