Book Image

101 Excel 2013 Tips, Tricks and Timesavers

By : John Walkenbach
Book Image

101 Excel 2013 Tips, Tricks and Timesavers

By: John Walkenbach

Overview of this book

Excel is a popular program. Millions of people throughout the world use it on a regular basis. But it’s a safe bet that the vast majority of users have yet to discover some of the amazing things this product can do. 101 Excel 2013 Tips, Tricks, & Timesavers?is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more,?101 Excel 2013 Tips, Tricks, & Timesavers?will save you time and help you avoid common spreadsheet stumbling blocks.
Table of Contents (10 chapters)
Free Chapter
1
Cover
2
Table of Contents
3
Title Page
4
Introduction

Tip 77: Identifying Data Appropriate for a Pivot Table

A pivot table requires that your data is in the form of a rectangular database table. You can store the database in either a worksheet range (which can be a table or just a normal range) or an external database file. And although Excel can generate a pivot table from any database, not all databases benefit.

Figure 77-1 shows part of a simple database table that has five columns and 3,144 rows (one row for each county). This data is appropriate for a pivot table. For example, a pivot table can instantly calculate the total population by state or by region and display the values in a nicely formatted table.

9781118642184-fg07701.tif

Figure 77-1: This data is appropriate for a pivot table.

Generally speaking, fields in a database table consist of two types of information:

Data: Contains a value or data to be summarized. For this example, the 1990 Population and the 2000 Population fields are data fields.

Category...