| About The BookConquer Microsoft Excel 2010—from the inside out! |
You’re beyond the basics—so dive in and really put your spreadsheets and data-analysis 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. Discover how the experts tackle Excel 2010—and challenge yourself to new levels of mastery!
Apply best practices for designing and managing spreadsheets
Use built-in functions for complex calculations, or develop your own
Master data visualization tools—charts, Sparklines, SmartArt
Retrieve external data from databases, servers, and the Web
Perform advanced financial, statistical, and “what-if” analysis
Create dynamic PivotTable and PivotChart views
Customize the Ribbon and create your own templates
Control data access and integrity as you collaborate on spreadsheets online
Write and debug macros with Visual Basic for Applications
Your book + sample files—online!
Sample spreadsheets—ready to download and put to work. See the “About the Companion Content” section.
Fully searchable online edition of the book—with unlimited access on the Web. See inside back; free online account required.