Introduction

Spreadsheets are an incredibly powerful and useful tool. They are full of many features which you can utilise to help you automate tasks, visualise data more effectively and in general just make your life better. Below you will find a selection or articles outlining a few of them.

Articles

• Lookups - in this article I discuss how you can use Lookup, VLookup, HLookup and Index Match to easily filter specific information out of a table of data.
• Conditional formatting a whole row - in this article I discuss how you can use conditional formatting to highlight a whole row of data in a table according to certain criteria.

These will be added to over time as I think of other things worth talking about.