Excel 2010: The Missing Manual

Table of Contents

The Missing Credits; About the Author; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; What You Can Do with Excel; The Modern Face of Excel; Excel's New Features; About This Book; Part One: Worksheet Basics; Chapter 1: Creating Your First Spreadsheet; 1.1 Creating a Basic Worksheet; 1.2 Moving Around the Grid; 1.3 A Tour of the Excel Window; 1.4 Saving Files; 1.5 Opening Files; Chapter 2: Adding Information to Worksheets; 2.1 Adding Different Types of Data; 2.2 Handy Timesavers; 2.3 Dealing with Change: Undo, Redo, and AutoRecover; 2.4 Spell Check; 2.5 Adding Hyperlinks; Chapter 3: Moving Data; 3.1 Selecting Cells; 3.2 Making Continuous Range Selections; 3.3 Making Noncontiguous Selections; 3.4 Automatically Selecting Your Data; 3.5 Making Selections with the Keyboard; 3.6 Moving Cells Around; 3.7 A Simple Cut-and-Paste or Copy-and-Paste; 3.8 A Quicker Cut-and-Paste or Copy-and-Paste; 3.9 Fancy Pasting Tricks; 3.10 Paste Special; 3.11 Copying Multiple Items with the Clipboard; 3.12 Adding and Moving Columns or Rows; 3.13 Inserting Columns and Rows; 3.14 Inserting Rows; 3.15 Inserting Copied or Cut Cells; 3.16 Deleting Columns and Rows; Chapter 4: Managing Worksheets; 4.1 Worksheets and Workbooks; 4.2 Find and Replace; Chapter 5: Formatting Cells; 5.1 Formatting Cell Values; 5.2 Formatting Cell Appearance; Chapter 6: Smart Formatting Tricks; 6.1 The Format Painter; 6.2 Styles and Themes; 6.3 Conditional Formatting; Chapter 7: Viewing and Printing Worksheets; 7.1 Controlling Your View; 7.2 Printing; 7.3 Controlling Pagination; Part Two: Formulas and Functions; Chapter 8: Building Basic Formulas; 8.1 Creating a Basic Formula; 8.2 Functions; 8.3 Formula Errors; 8.4 Logical Operators; 8.5 Formula Shortcuts; 8.6 Copying Formulas; Chapter 9: Math and Statistical Functions; 9.1 Rounding Numbers; 9.2 Groups of Numbers; 9.3 General Math Functions; 9.4 Trigonometry and Advanced Math; 9.5 Advanced Statistics; Chapter 10: Financial Functions; 10.1 The World of Finance; 10.2 Financial Functions; 10.3 Depreciation; 10.4 Other Financial Functions; Chapter 11: Manipulating Dates, Times, and Text; 11.1 Manipulating Text; 11.2 Manipulating Dates and Times; 11.3 Math with Dates and Times; 11.4 Date and Time Functions; Chapter 12: Lookup, Reference, and Information Functions; 12.1 The Basic Lookup; 12.2 Advanced Lookups; 12.3 Information Functions; 12.4 Tutorial: Generating Invoices from a Product Catalog; Chapter 13: Advanced Formula Writing and Troubleshooting; 13.1 Conditions in Formulas; 13.2 Descriptive Names for Cell References; 13.3 Variable Data Tables; 13.4 Controlling Recalculation; 13.5 Solving Formula Errors; Part Three: Organizing Worksheets; Chapter 14: Tables: List Management Made Easy; 14.1 The Basics of Tables; 14.2 Sorting and Filtering a Table; 14.3 Dealing with Duplicate Rows; 14.4 Performing Table Calculations; Chapter 15: Grouping and Outlining Data; 15.1 Basic Data Grouping; 15.2 Grouping Timesavers; Chapter 16: Templates; 16.1 Understanding Templates; 16.2 Creating a New Workbook from a Template; 16.3 Creating Templates; Part Four: Charts and Graphics; Chapter 17: Creating Basic Charts; 17.1 Charting 101; 17.2 Basic Tasks with Charts; 17.3 Practical Charting; 17.4 Chart Types; Chapter 18: Formatting and Perfecting Charts; 18.1 Chart Styles and Layouts; 18.2 Adding Chart Elements; 18.3 Selecting Chart Elements; 18.4 Formatting Chart Elements; 18.5 Improving Your Charts; 18.6 Advanced Charting; Chapter 19: Inserting Graphics; 19.1 Adding Pictures to a Worksheet; 19.2 Excel's Clip Art Library; 19.3 Drawing Shapes; Part Five: Advanced Data Analysis; Chapter 20: Visualizing Your Data; 20.1 Data Bars; 20.2 Color Scales; 20.3 Icon Sets; 20.4 Sparklines; Chapter 21: Scenarios and Goal Seeking; 21.1 Using Scenarios; 21.2 Using Goal Seek; 21.3 Solver; Chapter 22: Pivot Tables; 22.1 Summary Tables Revisited; 22.2 Building Pivot Tables; 22.3 Multi-Layered Pivot Tables; 22.4 Fine-Tuning Pivot Table Calculations; 22.5 Filtering a Pivot Table; 22.6 Pivot Charts; Chapter 23: Analyzing Databases, XML, and Web Pages; 23.1 Excel and Databases; 23.2 Understanding XML; 23.3 Excel and XML; 23.4 Web Queries; Part Six: Sharing Data with the Rest of the World; Chapter 24: Protecting Your Workbooks; 24.1 Understanding Excel's Safeguards; 24.2 Data Validation; 24.3 Locked and Hidden Cells; Chapter 25: Worksheet Collaboration; 25.1 Your Excel Identity; 25.2 Preparing Your Workbook; 25.3 Distributing a Doooooocument; 25.4 Adding Comments; 25.5 Tracking Changes; 25.6 Sharing Your Workbook; Chapter 26: Using Excel on the Web; 26.1 Putting Your Files Online; 26.2 Using the Excel Web App; Chapter 27: Exchanging Data with Other Programs; 27.1 Sharing Information in Windows; 27.2 Embedding and Linking Objects; 27.3 Transferring Data; Part Seven: Programming Excel; Chapter 28: Automating Tasks with Macros; 28.1 Macros 101; 28.2 The Macro Recorder; 28.3 Macro Security; 28.4 Creating Practical Macros; Chapter 29: Programming Spreadsheets with VBA; 29.1 The Visual Basic Editor; 29.2 Understanding Macro Code; 29.3 Exploring the VBA Language; Part Eight: Appendix; Customizing the Ribbon; Adding Your Favorites to the QAT; Personalizing the Ribbon;

Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly). He has also written Excel 2007:The Missing Manual, Excel 2007 for Starters: The Missing Manual, Access 2007:The Missing Manual, and Access 2007 for Starters: The Missing Manual, all from O'Reilly. His web site is http://www.prosetech.com.