Excel Yourself

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

How to capture small data sets in Excel

Make your own: User defined functions in Excel

How to use text boxes in Excel

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