Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

English | 2022 | ISBN: 978-0137559534 | 848 Pages | EPUB | 83 MB

Conquer Microsoft Excel – from the inside out!

Dive into Microsoft Excel — 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 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. Topics include:

  • Customizing the Excel workspace
  • Best practices for designing and managing worksheets
  • Creating formulas and functions
  • Performing statistical, what-if, and other data analysis
  • Core to advanced charting techniques
  • Using graphics and sparklines
  • Managing databases and tables
  • Automating Excel with macros and custom functions
  • Collaborating in Excel online, in the cloud, and more
  • Extending Excel