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.

超好用的Excel快捷键,你知道吗?


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