Microsoft Excel is a very versatile tool and can be used for many different purposes. The example we have here is a volume calculator for some simple geometric shapes. The user can enter values for the parameters (such as side length, or radius), and the corresponding volume is updated automatically.

Click to enlarge

However, rather than just display the parameters and calculated volume, it is often more user friendly to format the spreadsheet area with diagrams, and the odd splash of colour here and there!

Also, this example does not make use of any macros, but could be easily extended to do so. The volume equation for each shape is entered directly into worksheet cells but could be stored in macro code instead in the form of a custom worksheet function. This function could then be called as necessary, just like a standard worksheet function.