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.

Table names must start with a letter, underscore, or backslash, with the remaining characters being letters, numbers, periods, or underscores. They must also be unique, can't contain a space, and ...

Learn how to use Excel’s dynamic array formulas to automate data pairing, save time, and unlock new insights in your analysis ...

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.

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.

The pivot table in Excel. We’ll need a pivot table before we can start filtering, so to that end, we’ll build the pivot table shown in Figure A, based on the data shown in the same sheet.

Yes, you can create a list of your Excel workbook’s worksheet names as follows. From the Formulas tab, select Defined Names, Define Name to launch the New Name dialog box pictured below. Enter ...

In Microsoft Excel, you can create relationships between two tables based on the matching data within the table, even when the tables are from different sources.In older versions of Excel, people ...

Excel will auto-detect the perimeter of your table and populate the range. It will also auto-detect headings. If that option isn’t selected (which sometimes happens in the Mac version of Excel ...