Microsoft Excel 2010 Inside Out

Mark Dodge has coauthored several popular books on Excel(R), including Microsoft(R) Office Excel(R) 2003 Inside Out. He is a former senior technical writer for the Microsoft(R) Office User Assistance group. Craig Stinson is a computer journalist and author. He has written or coauthored more than 20 books, including Microsoft(R) Windows(R) XP Inside Out, Deluxe Edition.

(Computer Bookshops Limited)

Acknowledgments; Questions and Support; Using the Companion Content; Support Information; We Want to Hear from You; Conventions and Features Used in This Book; Text Conventions; Design Conventions; Part 1: Examining the Excel Environment; Chapter 1: Whats New in Microsoft Excel 2010; 1.1 New and Improved for 2010; 1.2 If You Missed the Last Upgrade; 1.3 Retired in 2007; 1.4 If You Missed the Last Two Upgrades; 1.5 Onward; Chapter 2: Exploring Excel Fundamentals; 2.1 What Happens After You Install Excel?; 2.2 Examining the Excel 2010 Workspace; 2.3 Exploring File Management Fundamentals; 2.4 Importing and Exporting Files; 2.5 Using the Help System; 2.6 Recovering from Crashes; Chapter 3: Custom-Tailoring the Excel Workspace; 3.1 Customizing the Ribbon; 3.2 Customizing the Quick Access Toolbar; 3.3 Controlling Other Elements of the Excel 2010 Interface; 3.4 Enhancing Accessibility; Chapter 4: Security and Privacy; 4.1 The Trust Center; 4.2 File Security; 4.3 Other Security Features; Part 2: Building Worksheets; Chapter 5: Planning Your Worksheet Design; 5.1 Which Data Should Be in Rows, and Which in Columns?; 5.2 Will You Need to Print the Worksheet?; 5.3 Who Is the Audience?; 5.4 Would Your Worksheet Survive Without You?; 5.5 Does the Worksheet Rely on Imported Data?; 5.6 Do You Need More Than One Worksheet?; 5.7 Have You Allowed Room for New Data?; Chapter 6: How to Work a Worksheet; 6.1 Moving Around Regions; 6.2 Understanding Selection; 6.3 Techniques for Entering Data; 6.4 Managing Worksheets; 6.5 Viewing Worksheets; 6.6 Protecting Worksheets; Chapter 7: How to Work a Workbook; 7.1 Managing Multiple Workbooks; 7.2 Opening Multiple Windows for the Same Workbook; 7.3 Hiding and Protecting Workbooks; Part 3: Formatting and Editing Worksheets; Chapter 8: Worksheet Editing Techniques; 8.1 Copying, Cutting, and Pasting; 8.2 Inserting and Deleting; 8.3 Undoing Previous Actions; 8.4 Editing Cell Contents; 8.5 Finding and Replacing Stuff; 8.6 Getting the Words Right; 8.7 Editing Multiple Worksheets; 8.8 Auditing and Documenting Worksheets; 8.9 Outlining Worksheets; 8.10 Consolidating Worksheets; Chapter 9: Worksheet Formatting Techniques; 9.1 Formatting Fundamentals; 9.2 Using Themes and Cell Styles; 9.3 Formatting Conditionally; 9.4 Formatting in Depth; 9.5 Using Template Files to Store Formatting; Part 4: Adding Graphics and Printing; Chapter 10: Creating and Formatting Graphics; 10.1 Using the Shapes Tools; 10.2 Creating WordArt; 10.3 Creating SmartArt; 10.4 Inserting Other Graphics; 10.5 Formatting Graphics; 10.6 Working with Graphic Objects; 10.7 More Tricks with Graphic Objects; Chapter 11: Printing and Presenting; 11.1 Controlling the Appearance of Your Pages; 11.2 Controlling What and...

(Computer Bookshops Limited)