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, ...

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, ...

Many use Excel for basic tables, but you need to go beyond simple sums. If your formulas are getting clunky, conditional functions are the smarter, hidden-in-plain-sight option. They handle complex ...

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 ...