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

How to handle formula errors in Excel using IFERROR

Use LET function to solve tricky Excel challenges

Creating hyperlinked index sheets in Excel

How to import Excel files using power query

Flexible conditional formats in Excel

How to improve your formatting in Excel

Creating a dependent drop-down list in Excel

Excel solutions for different versions explained

How to use Excel's LET function

How to use an IS function in Excel

How to use dynamic charts in Excel

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