|
Autor: Dodge, Mark (4) / Stinson, Craig (6) |
|||||||||||||||||||
|
Microsoft Excel 2010 Inside OutThe ultimate, in-depth reference for conquering Excel 2010Includes your book and sample spreadsheets online.
|
||||||||||||||||||
|
|
|||||||||||||||||||
|
|
|||||||||||||||||||
Microsoft Excel 2010 Inside Out
The ultimate, in-depth reference for conquering Excel 2010
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.
- Fully searchable online edition of the book - with unlimited access on the Web.
The Contents at a Glance
- Examining the Excel Environment
- Building Worksheets
- Formatting and Editing Worksheets
- Adding Graphics and Printing
- Creating Formulas and Performing Data Analysis
- Managing Databases and Tables
- Collaborating
- Automating Excel
- Integrating Excel with Other App ication
- Appendixes
About the Authors Mark Dodge and Craig Stinson:
Mark Dodge started using computers in 1982, began using spreadsheet and database programs in a corporate accounting office in 1985, started working in computer publishing in 1988, and has since written or edited more than two dozen books for Microsoft Press and others. Mark, a former professional musician and current award-winning art photographer, lives with his wife on a beautiful island in Puget Sound in Washington. |
Craig Stinson, an industry journalist since 1981, was editor of Softalk for the IBM Personal Computer, one of the earliest machine-specific computer magazines. He is the author of more than 20 Microsoft Press books about Windows and Excel. Craig lives with his wife and two children in Bloomington, Indiana. |
Mark Dodge started using computers in 1982, began using spreadsheet and database programs in a corporate accounting office in 1985, started working in computer publishing in 1988, and has since written or edited more than two dozen books for Microsoft Press and others. Mark, a former professional musician and current award-winning art photographer, lives with his wife on a beautiful island in Puget Sound in Washington.
Craig Stinson, an industry journalist since 1981, was editor of Softalk for the IBM Personal Computer, one of the earliest machine-specific computer magazines. He is the author of more than 20 Microsoft Press books about Windows and Excel. Craig lives with his wife and two children in Bloomington, Indiana.