Excel Yourself

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

Using Excel's flexible ranges in conditional calculation functions


Opening the vault on Excel, Part 9


Use Power Query to solve common Excel budget issues


Opening the vault on Excel, part 8


 Imitating a sparkline chart in Excel

Imitating a sparkline chart in Excel


Power up your Excel skills in 2020


Opening the vault on Excel, Part 7


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


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