| |
You`re beyond the basics—so dive in and really put your spreadsheets and data-analysis skills to work! This supremely organised 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 and Visual Basic® for Applications
isbn-9788120342040
|
| |
|