Create an Excel table in two seconds In addition, notice that the filter feature is automatically applied, so sorting by a specific field is accomplished by a few clicks of the mouse.

In older versions of Excel, people have used functions such as VLOOKUP, INDEX, and MATCH to create relationships between tables, but in newer versions of Excel, there is a Relationship command ...

What is a pivot table, and why should you create one? Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and ...

With a pivot table, you can create one pool of information and then easily change your focus from one thing to another — an analysis that would be tedious to perform manually.

If you wish to create a a Pivot Table and Pivot Chart in Excel, then this detailed article will guide you through the entire process.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

To learn more about Excel Table objects, read 10 reasons to use Excel’s table object. Send me your question about Office I answer readers’ questions when I can, but there’s no guarantee.