Microsoft Excel 2019 Inside Out
Book Description
Dive into Microsoft Excel 2019 - and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to make the most of Excel's most powerful tools for analyzing 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 customizations to advanced analysis, visualizations, 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 summarize 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 visualization 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.
Book Details | |
| Publisher: | Microsoft Press |
| By: | Bill Jelen |
| ISBN-13: | 9781509307692 |
| ISBN-10: | 1509307699 |
| Year: | 2018 |
| Pages: | 864 |
| Language: | English |
Book Preview | |
| Online | Microsoft Excel 2019 Inside Out |
Free Download | |
| Source Code | Microsoft Excel 2019 Inside Out |
Paper Book | |
| Buy: | Microsoft Excel 2019 Inside Out |
Share Microsoft Excel 2019 Inside Out
