Contact me now for
Excel Specialist Advice >>
The Aggregate function (Excel 2010 and later) is like the excellent SUBTOTAL function, but even more powerful.
People sometime ask: why use Excel when you can have the online convenience of Google spreadsheets? And the answer depends on what you want. Being …
There are two main types of table in Excel: the formal and the informal. Formal tables are part of the Excel “toolkit”. To add one, …
Ranges, which can be single cells or multiple cells can be named. They can make the logic of the spreadsheet easier to understand. This is …
A group of six children do a test. How many achieve higher than the threshold (in the example, 15)? [wpvideo ztRyOfft] This is a simple example …
[wpvideo hjzV1pjv]There are several hundred functions on Excel, which can mostly be combined to produce thousands more, but sometimes even they cannot cope with requirements. Excel’s …
Excel is a powerful tool for analysing data, and as part of that has a wide range of statistical functions. However these must be used …
Excel is a very powerful product, but particularly when using statistical functions, you need to take care. One example is standard deviation, which gives information …
Spreadsheets mean that things can be tried out very quickly; and changes and improvements made (almost) immediately. However, in a ‘mature’ spreadsheet, the only changes …
The other day I saw an article on the web by a writer who seemed to think that VLOOKUP was new to Excel 2013. Strange, …