Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.

You might think that your work is done, but actually, Excel is sitting and waiting for you to do more with those tables, ...

In this tutorial, I’ll show you how to export an Excel table to a SharePoint list. I’ll also share a lot of basic information about SharePoint lists along the way.

First, add the short list (Figure A) to B3:B6 and format it as an Excel Table object. Simply click any cell in the list and press Ctrl + T. In the resulting dialog, make sure the My Table Has ...

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.

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

Excel tables provide superior tools for working with data in list form. If you want to sum columns of data automatically so that the totals show only the sum of visible cells (for example), Excel ...

How to Create a Table That Makes Choices in Excel 2007. Excel enables you to include data validation for a cell, limiting the type and content of any inputted data.

You can edit a drop-down list in Excel using a few different methods. It's easy to edit a drop-down list if it's based on an Excel table, as the table should update automatically with your edits.

Apart from the primary usage, this handy feature can also help in printing labels from an Excel list. ... As our mailing list only contains a single table, click on OK to move to the next step.