Excel Yourself

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

Dynamic arrays: Sorting lists in Excel


New functions: dynamic arrays in Excel


Opening the vault on Excel, Part 10


Dealing with dynamic arrays in Excel


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