Mastering Excel: Pivot Tables - Softcover

Moore, Mark

Softcover

ISBN 10: 1628849991 ISBN 13: 9781628849998

Publisher: Speedy Publishing LLC, 2013

Synopsis

Pivot tables are THE indispensable skill you need to know to master Excel. They are the workhorses of Excel. You have 100,000 rows of data by invoice, product, salesperson and you are getting bombarded with questions. Who’s the highest earner? Which product sold the most in the last seven days. After this lesson, you’ll be able to answer those questions in seconds.This lesson is focused on this incredibly power tool.I walk you through all the steps to create a pivot table, how to work with pivot charts, using Excel tables effectively with Pivot Tables, how to create calculations in Pivot Tables, and much more.As always, I explain all the steps in plain English. The lessons are geared towards the average Excel user that just wants to improve their skill set without having to suffer through hours of technical, confusing instruction.Included in the book is a link to download a free workbook so readers can follow along with the exercises at their own pace.

Edition details

• Publisher: Speedy Publishing LLC
• Publication date: 2013
• Language: English
• ISBN 10: 1628849991
• ISBN 13: 9781628849998
• Binding: Paperback
• Edition number: 1
• Number of pages: 72