Before you convert your Excel data into a table, make sure you have column headers along the top row. This will make dealing with and using the data much more straightforward down the line.

A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.

To create a search field in a spreadsheet, you must first activate the Developer tools menu. To do this, go to Options > ...

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

How to add a filter to the interface in Excel The dropdown and search filters are good for you, but they’re not great for others who might be viewing the information in your pivot table.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

Use Excel to combine multiple data sources in XML documents by creating a map in a spreadsheet that contains the predefined table information. Once the map is in place, the data can be imported ...

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

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it. $3,500 iPhone possible?

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.