Create a table or open an existing table. In this tutorial, we have a table of plants; we want to find which value is at number three. In the cell where you want to place the result, enter: =CHOOSE(3, ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

To analyze your company's payroll expenditures, you might create an Excel spreadsheet and use some of the functions in the Financial or Math & Trigonometry categories. To create a pricing spreadsheet, ...

Simpler and faster is always better in Excel. We start with some of my favorite shortcuts, then move on to using Excel for everyday situations such as finding random numbers for passwords, or random ...