{"product_id":"9780137521838","title":"Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)","description":"\u003cp\u003eUse Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts 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 all their flexibility and analytical power-- including important recent improvements in Microsoft 365 Excel. 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 \u003cbr\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\u003eTransform huge datasets into clear summary reports\u003c\/li\u003e \u003cli\u003eInstantly highlight your most profitable customers, products, or regions\u003c\/li\u003e \u003cli\u003eUse the data model and Power Query to quickly analyze disparate data sources\u003c\/li\u003e \u003cli\u003eCreate powerful crosstab reports with new dynamic arrays and Power Query\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\u003c\/li\u003e \u003cli\u003eSave time and avoid formatting problems by adapting reports with GetPivotData\u003c\/li\u003e \u003cli\u003eUnpivot source data so it's easier to work with\u003c\/li\u003e \u003cli\u003eUse new Analyze Data artificial intelligence to create pivot tables\u003c\/li\u003e \u003c\/ul\u003e","brand":"Addison Wesley","offers":[{"title":"Default Title","offer_id":48133085692144,"sku":"9780137521838","price":49.5,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780137521838_p0.jpg?v=1763641913","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780137521838","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}