Find the data you need in an Excel sheet more easily with these functions.

This tutorial shows you how to fix and remove #DIV/0! error in Microsoft Excel by using the IFERROR or ISERROR function.

The Draw tab is not on Excel's ribbon by default. Learn how to enable, add and use the Draw tab and the various drawing tools in Excel.

The makedirs, and its counterpart removal function, the removedirs function, create folders recursively so as to create nested subfolders automatically.

Excel and Google Sheets have three functions to calculate the internal rate of return: IRR, XIRR, and MIRR. Learn how these functions can calculate investment returns.

Learn how to calculate all the particulars of a loan using Excel and how to set up a schedule of repayment for a mortgage or any other loan.

In 2019, Microsoft introduced the Xlookup function as a major upgrade to the Vlookup function that most Excel power users are familiar with (it also essentially replaces the Index Match function).