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