Microsoft Excel 2019 Inside Out (PDF)

Conquer Microsoft Excel 2019-from the inside out!

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