Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

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.

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.

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.