{"product_id":"microsoft-excel-2019-inside-out","title":"Microsoft Excel 2019 Inside Out","description":"Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organised reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analysing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customisations to advanced analysis, visualisations, and dashboards. Discover how experts tackle today’s key tasks–and challenge yourself to new levels of mastery. \u003cul\u003e  \u003cli\u003eEnter formulas more efficiently, and fully control operators and dates \u003c\/li\u003e  \u003cli\u003eMaster the most widely-used functions in Excel \u003c\/li\u003e  \u003cli\u003eIntegrate external data from the web and other sources \u003c\/li\u003e  \u003cli\u003eEasily transform complex datasets with Power Query \u003c\/li\u003e  \u003cli\u003eQuickly summarise millions of records with Pivot Tables \u003c\/li\u003e  \u003cli\u003ePerform ad hoc analyses with slicers and other filters \u003c\/li\u003e  \u003cli\u003eCreate advanced data mashups with Power Pivot \u003c\/li\u003e  \u003cli\u003eSolve complex problems with What-If, Scenario Manager, Goal Seek, and Solver \u003c\/li\u003e  \u003cli\u003eAutomate repetitive tasks by editing recorded VBA code \u003c\/li\u003e  \u003cli\u003eDemystify data with conditional formatting and other visualisation techniques \u003c\/li\u003e  \u003cli\u003eUse the newest maps, charts, and data types in Excel \u003c\/li\u003e  \u003cli\u003eShow geographical changes over time with animated 3D maps \u003c\/li\u003e  \u003cli\u003eUse dynamic array functions: SORT, FILTER, UNIQUE, SORTBY and SEQUENCE \u003c\/li\u003e  \u003cli\u003eFind insights using Excel’s new artificial intelligence \u003c\/li\u003e  \u003cli\u003eCollaborate via Excel 2019’s breakthrough CoAuthoring tools \u003c\/li\u003e  \u003cli\u003ePublish Power BI Desktop dashboards based on Excel data \u003c\/li\u003e \u003c\/ul\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":45998719402222,"sku":"9781509307692","price":67.18,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0630\/9612\/7726\/files\/1509307699.jpg?v=1733539923","url":"https:\/\/bookland.com.au\/products\/microsoft-excel-2019-inside-out","provider":"Book Land AU","version":"1.0","type":"link"}