Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...

Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...

You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up. Not anymore: Excel 2013’s table tools include features that make it easy to link ...

Step 1: Prepare your data. Perhaps the most important step in using Excel pivot tables is to carefully organize your data. The easiest way to do this is to use Excel tables, which let you add rows ...

You can import an Excel data table into Word to customize your template with names and addresses. Mail merge helps you quickly create auto-personalized letters, envelopes, labels, and more.