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