Excel 2013 Pivot Tables: Including the "Data Model": Smart Data Analysis: Volume 2 (In Everyday Language) This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. .

Seller Inventory # 7719-9781511820875

Contact seller

Report this item

Bibliographic Details

Title: Excel 2013 Pivot Tables: Including the "Data Model": Smart Data Analysis: Volume 2 (In Everyday Language)
Publisher: CreateSpace Independent Publishing Platform
Publication Date: 2015
Language: English
ISBN 10: 151182087X
ISBN 13: 9781511820875
Binding: paperback
Condition: Very Good

About this title

Synopsis

Excel 2013 Pivot Tables

Including the "Data Model"

A pivot table is a simple, yet powerful technique, that enables Excel's users to transform data overload into meaningful and organized knowledge.

With pivot tables you can:

* See the data in dozens of different ways with a simple mouse drag* Perform fast calculations with no need for formulas* Focus on another part of the data each time and get a clear picture* Show more trends and patterns* Create dozens of reports and charts to analyze your data

While reading the book and using the practice files, you will know to:

Create a Pivot TableoSelect data from the current fileoSelec data from another Excel fileoChange the data sourceoCreate a pivot table based on a dynamic data tablePerform Calculations:oUse sum, average, minimum, maximum and countoShow Percentage of a column total, row total and Grand totaloDisplay the running totaloGroup numeric and date dataoUse calculated field and calculated itemChange The Report StructureoSwitching columns and rowsoAdding columns or rowsoAdding a page break between itemsFormat your Pivot TablesoAdd totals and SubtotalsoSortoFilterYou will also know to•Add slicers and to manipulate then•Add a timelines and to manipulate it•Add charts to your pivot tables•Use the new and innovative feature: "The Data Model"And, of course, You will learn some cool tips and tricks!

About the Author

Maayan Poleg holds an MA in Education Administration. She instructs and develops Excel's applications since 1996. Maayan has an extensive knowledge and experience in the field of VBA training You can contact Maayan at: Maayan@excel-vba.guru

"About this title" may belong to another edition of this title.

Store Description

Started in an unfortunate mother's basement in 2004 with books that a student layabout no longer needed, AwesomeBooks now stocks over 2 million titles which are ready to be sent to your door within 24hours of ordering. Our heritage is in supplying great quality used books. We have over 1.8 million books in our distribution centre ready to be shipped to you at any time. We also sell new books and are increasing our range of titles every day.

Visit Seller's Storefront

Seller's business information

WRAP Ltd
Unit 4,, 119 Loverock Road, Reading, RG30 1DZ, United Kingdom

Sale & Shipping Terms

Terms of Sale

All our books are used in either Good or Very Good condition. Should there be any problems after purchase email us and we will sort it out to your satisfaction.

Shipping Terms

We try to keep our shipping terms as simple as possible :)

Shipping cost for orders to other destinations vary, so please check your destination country for more details.

Shipping rates from United Kingdom to U.S.A.

Shipping rates from United Kingdom to U.S.A.
Order quantity	4 to 15 business days	4 to 15 business days
First item	US$ 5.54	US$ 5.54

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.