Excel Yourself

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

How to use slicers on formatted tables in Excel

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