{"product_id":"excel-2013-pivot-tables-sharon-barak-9781511820875","title":"Excel 2013 Pivot Tables: Including the \"Data Model\" Smart Data Analysis","description":"Excel 2013 Pivot TablesIncluding 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 dataWhile reading the book and using the practice files, you will know to: \u003cb\u003eCreate a Pivot Table\u003c\/b\u003eoSelect data from the current fileoSelec data from another Excel fileoChange the data sourceoCreate a pivot table based on a dynamic data table\u003cb\u003ePerform Calculations: \u003c\/b\u003eoUse 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 item\u003cb\u003eChange The Report Structure\u003c\/b\u003eoSwitching columns and rowsoAdding columns or rowsoAdding a page break between items\u003cb\u003eFormat your Pivot Tables\u003c\/b\u003eoAdd totals and SubtotalsoSortoFilter\u003cb\u003eYou will also know to\u003c\/b\u003e-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\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Sharon Barak, Maayan Poleg\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 151182087X\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781511820875\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Createspace Independent Publishing Platform\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 04\/19\/2015\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 180\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.60lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.02h x 5.98w x 0.41d","brand":"Sharon Barak","offers":[{"title":"Paperback","offer_id":43939874767103,"sku":"9781511820875","price":17.95,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/products\/img_b3f5b7a6-d047-4fcf-bf71-a809c3426e12.jpg?v=1681443974","url":"https:\/\/www.whiterainbookhouse.com\/products\/excel-2013-pivot-tables-sharon-barak-9781511820875","provider":"WR Book House","version":"1.0","type":"link"}