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