{"product_id":"excel-2013-pivot-tables-including-the-data-model-smart-data-analysis-paperback","title":"Excel 2013 Pivot Tables: Including the \"Data Model\" Smart Data Analysis - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eSharon Barak\u003c\/b\u003e (Author), \u003cb\u003eMaayan Poleg\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003eExcel 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\u003c\/p\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003eMaayan 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\u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 180\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.41 x 9.02 x 5.98 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e April 19, 2015\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":47212630835449,"sku":"9781511820875","price":24.23,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/QmVrR3l6dy9Mei9ocXA1OTVDUENJUT09.webp?v=1768094777","url":"https:\/\/bookscloud.io\/products\/excel-2013-pivot-tables-including-the-data-model-smart-data-analysis-paperback","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}