The subject of this tutorial is pivot tables and pivot charts. A pivot table represents a very special kind of data table that summarizes different types of data (such as the records of an Excel data list) and enables you to dynamically analyze the relati Read more...
The subject of this tutorial is turning your worksheets into Web pages that you can publish to your Web site, either publicly on the World Wide Web or on your company's more private intranet. Read more...
The Excel list, a new element in version 2003, is one of the most fun features you're likely to encounter in this latest go-round of the program. Read more...
This technique covers the different ways you can share a workbook so that different people can edit its contents at the same time. Read more...
This tutorial looks at all the little things you can do to ensure that your printed reports not only contain all the necessary information but also present it in the clearest possible manner. Read more...
This technique introduces you to the process of sorting worksheet data. It begins by covering the basic sorting of the records in a data list using one, two, or even three fields in the list. Read more...
Excel makes it easy to send out spreadsheets for review by clients, coworkers, and managers who need to give you their input or approval after reviewing their contents. Read more...
This technique covers how to use AutoFilter to do basic and custom filtering of the data list. Read more...
This tutorial covers ways you can use worksheet windows to compare data, copy and move it between different regions of the same (or different) worksheets, and even move it from one workbook file to another. Read more...
Excel's Consolidation feature makes short work of combining numerical data in tables stored on several different worksheets or even different workbook files. Read more...