Microsoft Excel is incredibly versatile, but there are a lot of functions you might not even know about. These are some of the best ones.

Hit Ctrl+F3 to open Name Manager, click New and paste in your LAMBDA string into the Refers To field. Give your new function ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.