{"product_id":"microsoft-excel-pivot-table-data-bill-jelen-9780135408797","title":"Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot","description":"\u003cp\u003eLearn to use pivot tables and pivot charts in Microsoft Excel to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you've never created a pivot table before, this book will help you leverage their flexibility and analytical power--and includes exploration of new array functions and Copilot capabilities in analysis creation. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen (\"MrExcel\") shares practical \"recipes\" for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you'll find nowhere else.\u003c\/p\u003e \u003cp\u003eBy reading this book, you will: \u003c\/p\u003e \u003cul\u003e \u003cli\u003eMaster easy, powerful ways to create, customize, change, and control pivot tables\u003c\/li\u003e \u003cli\u003eUse Copilot and Analyze Data features to create pivot tables\u003c\/li\u003e \u003cli\u003eTransform huge datasets into clear summary reports\u003c\/li\u003e \u003cli\u003eInstantly highlight your most profitable customers, products, or regions\u003c\/li\u003e \u003cli\u003ePivot data with powerful dynamic arrays and Power Query\u003c\/li\u003e \u003cli\u003eUse PIVOTBY and GROUPBY functions to create reports without needing to refresh\u003c\/li\u003e \u003cli\u003eBuild geographical pivot tables with 3D Maps\u003c\/li\u003e \u003cli\u003eConstruct and share state-of-the-art dynamic dashboards\u003c\/li\u003e \u003cli\u003eRevamp analyses on the fly by dragging and dropping fi elds\u003c\/li\u003e \u003cli\u003eBuild dynamic self-service reporting systems\u003c\/li\u003e \u003cli\u003eShare your pivot tables with colleagues\u003c\/li\u003e \u003cli\u003eCreate data mashups using the full Power Pivot capabilities in modern Excel versions\u003c\/li\u003e \u003cli\u003eGenerate pivot tables using either VBA on the Desktop or Typescript in Excel Online or on the Desktop\u003c\/li\u003e \u003cli\u003eEmbrace GetPivotData for better looking reports and learn how to prevent it for quick reporting\u003c\/li\u003e \u003cli\u003eUnpivot source data so it's easier to use\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eAbout This Book\u003c\/p\u003e \u003cul\u003e \u003cli\u003eFor everyone who wants to get more done with Microsoft Excel in less time\u003c\/li\u003e \u003cli\u003eFor business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data\u003c\/li\u003e \u003c\/ul\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Bill Jelen\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 0135408792\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9780135408797\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Microsoft Press\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 12\/15\/2024\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 608\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 2.20lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.11h x 7.41w x 1.25d","brand":"Bill Jelen","offers":[{"title":"Paperback","offer_id":46431688163583,"sku":"9780135408797","price":54.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_73e8245e-da33-4405-bd34-71bf09508a72.jpg?v=1735142091","url":"https:\/\/www.whiterainbookhouse.com\/products\/microsoft-excel-pivot-table-data-bill-jelen-9780135408797","provider":"WR Book House","version":"1.0","type":"link"}