Excel Yourself

Get the most out of Excel with these how-to articles, videos and sample spreadsheets

Liam Bastick sees people wasting their lives manipulating data. If you go on a three-day course, at the end of two months you will have made up that time, and you will never look back.

Saving time with Excel Power Query

How to use Excel's message box feature

Opening the vault on Excel, part 3

Learn how to do conditional formatting in Excel

How to do conditional formatting in Excel

Opening the vault on Excel, part 2

How to forecast in Excel with the push of a button

How to use a PivotChart to create interactive Excel charts

Four excel questions have been reviewed and updated with newer easier solutions.

Opening the Excel Yourself vault

Excel reporting dashboards: how to make them work for you

How the Excel LEN function helps you allocate values month by month

Allocating amounts across months

Uncover buried treasure by using mapping tables in Excel

Improve your Excel moves by converting a budget into a forecast

Convert a budget into a forecast in Excel

'IF functions are one of the most common source of errors in Excel spreadsheets. Learn how to use them correctly.

How to use Excel's IF function

Excel Slideshare cover image

Power up your Excel skills

This step-by-step tutorial shows you how to use icons in Excel.

How to use icons in Excel

Hitting the slope charts in Excel

Excel's INDIRECT function is useful for carried forward balances

Understanding Excel's INDIRECT function

Who has spare time anymore! Do more with Excel with these handy Excel shortcuts.


The tornado chart approach is based on the 80/20 rule focusing on drivers that stand out beyond the rest.

Modelling with tornado charts in Excel