Excel

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