Excel 2007

The Missing Credits; About the Author; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; What You Can Do with Excel; Excel's New Face; Excel's New Features; About This Book; Part I: Worksheet Basics; Chapter 1: Creating and Navigating Worksheets; 1.1 Creating a Basic Worksheet; 1.2 Editing Data; 1.3 Navigating in Excel; 1.4 Saving Files; 1.5 Opening Files; Chapter 2: Adding Information to Worksheets; 2.1 Adding Different Types of Data; 2.2 Quick Ways to Add Data; Chapter 3: Moving Data Around a Worksheet; 3.1 Selecting Cells; 3.2 Moving Cells Around; 3.3 Adding and Moving Columns or Rows; Chapter 4: Managing Worksheets and Workbooks; 4.1 Worksheets and Workbooks; 4.2 Find and Replace; 4.3 Spell Check; 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 II: Formulas and Functions; Chapter 8: Building Basic Formulas; 8.1 Creating a Basic Formula; 8.2 Formula Shortcuts; 8.3 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: Quickly 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 III: 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 IV: 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 V: Advanced Data Analysis; Chapter 20: Scenarios and Goal Seeking; 20.1 Using Scenarios; 20.2 Using Goal Seek; 20.3 Solver; Chapter 21: Pivot Tables; 21.1 Summary Tables Revisited; 21.2 Building Pivot Tables; 21.3 Multi-Layered Pivot Tables; 21.4 Fine-Tuning Pivot Table Calculations; 21.5 Filtering a Pivot Table; 21.6 Pivot Charts; Part VI: Sharing Data with the Rest of the World; Chapter 22: Protecting Your Workbooks; 22.1 Understanding Excel's Safeguards; 22.2 Data Validation; 22.3 Locked and Hidden Cells; Chapter 23: Worksheet Collaboration; 23.1 Preparing Your Workbook; 23.2 Adding Comments; 23.3 Tracking Changes; 23.4 Sharing Your Workbook; Chapter 24: Querying Databases and XML Files; 24.1 Excel and Databases; 24.2 Understanding XML; 24.3 Excel and XML; Chapter 25: Exchanging Data with Other Programs; 25.1 Sharing Information in Windows; 25.2 Embedding and Linking Objects; 25.3 Transferring Data; Chapter 26: Connecting Worksheets to the Web; 26.1 Putting Worksheets on the Web; 26.2 Performing Web Queries; 26.3 Using Hyperlinks; Part VII: Programming Excel; Chapter 27: Automating Tasks with Macros; 27.1 Macros 101; 27.2 The Macro Recorder; 27.3 Macro Security; 27.4 Creating Practical Macros; Chapter 28: Programming Spreadsheets with VBA; 28.1 The Visual Basic Editor; 28.2 Understanding Macro Code; 28.3 Exploring the VBA Language; Part VIII: Appendix; Appendix A: Customizing the Quick Access Toolbar; A.1 The Quick Access Toolbar; Colophon;