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. Enter formulas more efficiently, and fully control operators and dates Master the most widely-used functions in Excel Integrate external data from the web and other sources Easily transform complex datasets with Power Query Quickly summarise millions of records with Pivot Tables Perform ad hoc analyses with slicers and other filters Create advanced data mashups with Power Pivot Solve complex problems with What-If, Scenario Manager, Goal Seek, and Solver Automate repetitive tasks by editing recorded VBA code Demystify data with conditional formatting and other visualisation techniques Use the newest maps, charts, and data types in Excel Show geographical changes over time with animated 3D maps Use dynamic array functions: SORT, FILTER, UNIQUE, SORTBY and SEQUENCE Find insights using Excelâs new artificial intelligence Collaborate via Excel 2019âs breakthrough CoAuthoring tools Publish Power BI Desktop dashboards based on Excel data The full text downloaded to your computer With eBooks you can: search for key concepts, words and phrases make highlights and notes as you study share your notes with friends eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps. Upon purchase, you will receive via email the code and instructions on how to access this product. Time limit The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.
Price history
Oct 25, 2021
€38.44