Excel Spreadsheet Blog

Aggregate function

30/07/2021

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

Google spreadsheet vs Excel

13/02/2018

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 ...

Tables

Tables in Excel – introduction

09/10/2017 Tables

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, ...

Good design – Naming

02/10/2017

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 ...

Array Functions – Introduction

22/06/2016

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 ...

Macros

Macros: Making Excel even more capable

02/11/2015 Macros

[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 ...

Care when using Statistical Functions in Excel (Part 1)

03/10/2015

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 ...

STDEV.S vs STDEV.P observation

26/09/2015

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 ...

Good design – introduction

19/11/2013

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 ...

There's history and history!

22/10/2013

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, ...