Tips

If you use Excel for more than just simple P&L spreadsheets, you've probably done some experimenting with its built-in functionality. But what if Excel doesn't do everything you need? Rick Cook discusses the pluses and minuses of using third-party resources to power up your spreadsheets.

Making sense of information sometimes requires that you analyze frequency distributions. Excel has a function that makes it a snap! This is the latest installment in a series of articles by Peter Aitken that take a detailed look at some of Excel's advanced functions.

Want to predict the future? Excel is no crystal ball, but some of its functions can help. In this latest installment in his series of articles that take a detailed look at some of Excel's advanced functions, Peter Aitken discusses a couple of them that can help you accomplish what you predict.

When a numerical value has more decimal places than you need or want, Excel offers a selection of functions to help you deal with it. The latest installment in Peter Aitken's series of articles takes a detailed look at some of Excel's advanced rounding capabilities.

Are you intimidated by the very mention of statistics? There's no need to be. In this sixth in a series of articles that take a detailed look at some of Excel's advanced functions, Peter Aitken tells you why statistics are nothing to fear when you use the TTEST() function in your own work.

This article describes how John Chamberlain of St Dominics Sixth Form College used Excel spreadsheets to model all six different examples relating to equilibria in A level Chemistry.

This Excel spreadsheet has been built as an example of how random numbers can be generated using Macros. The spreadsheet also enables the users to explore how the spreadsheet has been written.

Debi Hand from Peter Symonds College focuses on the use of Excel worksheets to aid the learning process in AS Decision and Discrete Mathematics. In some cases this means a simple use of a sheet to highlight characteristics of sorting algorithms; in other cases this would be to use a spreadsheet to help speed up the process of learning - in particular in the case of simulations.

When generating random numbers in Excel, the values are changed every time return is pressed. This article explains how to use Macros in Excel to produce the random numbers and then use them, without them continually changing.

This interactive resource has been created in Excel as a simulation tool to assist students answering sample exam questions in Decision and Discrete Mathematics.