3 Review(s)

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 About the Author Mark Dodge has cowritten several popular books on Excel, including Microsoft Office Excel 2007 Inside Out. He is a former senior technical writer for the Microsoft Office User Assistance group. Craig Stinson is a computer journalist and author who has written or coauthored more than 20 books, including Microsoft Office Excel 2007 Inside Out and Windows 7 Inside Out. Table of Contents Part 1: Examining the Excel Environment Chapter 1 What's New in Microsoft Excel 2010 Chapter 2 Exploring Excel Fundamentals Chapter 3 Custom-Tailoring the Excel Workspace Chapter 4 Security and Privacy Part 2: Building Worksheets Chapter 5 Planning Your Worksheet Design Chapter 6 How to Work a Worksheet Chapter 7 How to Work a Workbook Part 3: Formatting and Editing Worksheets Chapter 8 Worksheet Editing Techniques Chapter 9 Worksheet Formatting Techniques Part 4: Adding Graphics and Printing Chapter 10 Creating and Formatting Graphics Chapter 11 Printing and Presenting Part 5: Creating Formulas and Performing Data Analysis Chapter 12 Building Formulas Chapter 13 Using Functions Chapter 14 Everyday Functions Chapter 15 Formatting and Calculating Date and Time Chapter 16 Functions for Financial Analysis Chapter 17 Functions for Analyzing Statistics Chapter 18 Performing What-If Analysis Part 6: Creating Charts Chapter 19 Basic Charting Techniques Chapter 20 Using Sparklines Chapter 21 Advanced Charting Techniques Part 7: Managing Databases and Tables Chapter 22 Managing Information in Tables Chapter 23 Analyzing Data with PivotTable Reports Chapter 24 Working with External Data Part 8: Collaborating Chapter 25 Collaborating on a Network or by E-Mail Chapter 26 Collaborating Using the Internet Part 9: Automating Excel Chapter 27 Recording Macros Chapter 28 Creating Custom Functions Chapter 29 Debugging Macros and Custom Functions Part 10: Integrating Excel with Other Applications Chapter 30 Using Hyperlinks Chapter 31 Linking and Embedding Chapter 32 Using Excel Data in Word Documents Appendixes Appendix A Menu to Ribbon Command Reference Appendix B Keyboard Shortcuts Appendix C Function Reference