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.

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

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.

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

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 Pivot Table Field List Menu Restoring the drag-and-drop menu in your Excel Pivot Table is typically a quick fix. By using either right-click options or ribbon commands, you can easily access ...

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