Overview
This well-organized reference packs hundreds of timesaving solutions, tips, and workarounds–all students 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.
You’re beyond the basics—so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Learn how the experts tackle Excel—and challenge yourself to new levels of mastery. Includes companion eBook and sample files.
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
- | Author: Bill Jelen
- | Publisher: Microsoft Press,U.S.
- | Publication Date: Jan 16, 2019
- | Number of Pages:
- | Language:
- | Binding: Paperback / softback
- | ISBN-13: 9781509307692
- | ISBN-10: 1509307699
