Excel Yourself

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

New function: XLOOKUP replaces VLOOKUP in Excel


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