Mastering Excel: Pivot Tables - Couverture souple

Livre 15 sur 30: Mastering Excel

Moore, Mark

 
9781628849998: Mastering Excel: Pivot Tables

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.

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

Présentation de l'éditeur

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.

Présentation de l'éditeur

In this lesson we cover one of the most requested topics in Excel. Pivot Tables. What are Pivot Tables? How do they work? We 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 more. As always, we work through all the steps in plain English. Our 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.

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.