Excel Yourself

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

Opening the vault on Excel, Part 6


Understanding Excel's Power Query date tables


Opening the Vault on Excel, part 5


Understanding Excel's SUMIFS function


Opening the vault on Excel, part 4


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