Excel Spreadsheet Blog

Functions

Aggregate function

The Aggregate function (Excel 2010 and later) is like the excellent SUBTOTAL function, but even more powerful.
Read More →

Google spreadsheet vs Excel

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 ...
Read More →
Tables

Tables in Excel – introduction

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, ...
Read More →

Good design – Naming

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 ...
Read More →

Array Functions – Introduction

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 ...
Read More →
Macros

Macros: Making Excel even more capable

[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 ...
Read More →

Care when using Statistical Functions in Excel (Part 1)

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 ...
Read More →

STDEV.S vs STDEV.P observation

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 ...
Read More →

Good design – introduction

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 ...
Read More →

There's history and history!

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, ...
Read More →