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.

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.

Here, I have a list of exam grades and the scores required for each grade (let's call this table 1). I also have a table containing students' scores (table 2 from this point).

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

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

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.

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

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.

A frequency table tabulates the number of times values from a data set appear within a configured range. As an example, you might have a list of employee scores and want to display the frequency ...

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