Microsoft Excel 2019 Inside Out

Huge savings for students

Each student receives a 50% discount off of most books in the HSG Book Store. During class, please ask the instructor about purchase details.
List Price: $49.99
Price: $25.00
You Save: $25.00
2Conquer 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

Microsoft Press