How to insert & use Functions in Excel Functions help you perform a variety of mathematical operations, lookup values, calculate date and time, and a lot more.

Learn how to use MINVERSE and MMULT functions in Excel. MINIVERSE returns the matrix inverse of an array,. MMULT function returns matrix product of two arrays.

Microsoft Excel's dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP().

You can use keyboard shortcuts to format the Excel document to your specific requirements, making data entry much quicker. In this article we'll provide shortcuts to insert names, functions or data.