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 81: Grouping Items by Date in a Pivot Table

One of the more useful features of a pivot table is the ability to combine items into groups. Grouping items is simple: Select them and choose PivotTable Tools⇒Options⇒Group⇒Group Selection.

You can go a step further, though. When a field contains dates, Excel can create groups automatically. Many users overlook this helpful feature. Figure 81-1 shows a portion of a table that has two columns of data: Date and Sales. This table has 731 rows and covers dates between January 1, 2012, and December 31, 2013. The goal is to summarize the sales information by month.

9781118642184-fg08101.tif

Figure 81-1: You can use the PivotTable feature to summarize the sales data by month.

Figure 81-2 shows part of a pivot table (in columns D:E) created from the data. Not surprisingly, it looks exactly like the input data because the dates haven’t been grouped.

To group the items by month, right-click any cell in the Date column of...