Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

To do that, select the Data tab, highlight the table, and click From Table/Range in the Get & Transform Data command group of ...

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

Microsoft Excel lets you create simple forms that your users can enter data. To save them time and make sure you get the information you need, you can create a drop-down box that limits the users to ...

Q. I know that Excel has many great features, but I struggle with being able to find all of them, or even knowing if a feature exists to perform certain operations. Do you have any suggestions? A. It ...