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
- ISBN10 1509307699
- ISBN13 9781509307692
- Publish Date 16 January 2019 (first published 11 October 2018)
- Publish Status Active
- Publish Country US
- Imprint Microsoft Press
- Format Paperback
- Pages 864
- Language English