© Guy Hart-Davis 2016

Guy Hart-Davis, Learn Office 2016 for Mac, 10.1007/978-1-4842-2002-3_17

17. Manipulating Data with PivotTables

Guy Hart-Davis

(1)Barnard Castle, Durham, UK

In this chapter, you’ll look at how you can manipulate the data in your worksheets to draw conclusions from it by creating PivotTables. PivotTables are great for asking questions of your data and looking at the data in different ways without having to enter it multiple times in separate worksheets.

You’ll start by going over what PivotTables are and what you can do with them. After that, I’ll show you how to create a PivotTable either by using Excel’s automated tool , which can give you a jump-start by creating a recommended PivotTable that you can adjust as needed, or by ...

Get Learn Office 2016 for Mac, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.