{"product_id":"excel-2013-pivot-tables-sharon-barak-9781511954877","title":"Excel 2013 Pivot Tables: Including the \"Data Model\" (full color): 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 1511954876\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781511954877\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\/29\/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.75lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.00h x 6.00w x 0.47d","brand":"Sharon Barak","offers":[{"title":"Paperback","offer_id":47200772980991,"sku":"9781511954877","price":34.71,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_cac9fb36-3c43-49a8-b919-8507aaf4719d.jpg?v=1756787815","url":"https:\/\/www.whiterainbookhouse.com\/products\/excel-2013-pivot-tables-sharon-barak-9781511954877","provider":"WR Book House","version":"1.0","type":"link"}