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, …
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.