This tutorial will guide you through the creation of an interactive Excel workbook. The tutorial introduces most of the basic features used in the classroom ready resources on this Website.
The workbook produced looks at unit conversions including currency. It is flexible in it's use and after creating the workbook you should be able to adapt it easily. Using the skills learned, you should be able to start creating your own interactive workbooks in the Flexcel style!
Follow the 8 stages below to create the Conversions workbook.
Format and name the main worksheet ready to create the values and formulae.
Create the reference table in the settings worksheet. This is the worksheet that drives the main worksheet, but that the students do not see.
Create reference values and formulae to display the values that will form the basis of the workbook.
Make the main worksheet look nice! Add a splash of colour and organise the page.
Add functionality by using a spinner and scroll bar to control values.
Add show/hide buttons and macros
Enable values to be hidden at the click of a button by adding the Show/hide macro. Also add a button and macro to open the MS Calculator.
Record and add rounding macros
Record your own macros and attach them to buttons to show the values to different degrees of accuracy.