Excel 2007 Pocket Guide: A Quick Reference to Common Tasks

Description

Contents......Page 7 What’s New in Excel 2007......Page 9 The Excel 2007 Interface......Page 10 The Ribbon......Page 11 Contextual Tabs......Page 12 Dialog Expanders......Page 13 The Office Button......Page 14 The Excel Program Window......Page 15 New Excel 2007 File Format......Page 18 Workbook, Template, and Workspace Files......Page 19 Tips on Using Templates......Page 21 The Anatomy of an Excel File......Page 22 A Workbook......Page 23 Sheet Tabs......Page 24 Worksheets......Page 25 Columns and Rows......Page 28 Cells......Page 29 Styles......Page 31 Shortcut Menus and the Mini Toolbar......Page 33 AutoCorrect......Page 36 Smart Tags......Page 37 Excel Tasks......Page 39 Working with Files......Page 40 Printing......Page 43 Moving Around in a Workbook or Worksheet......Page 48 Manipulating Workbooks and Worksheets......Page 51 Manipulating Rows, Columns, and Cells......Page 53 Entering Data Efficiently......Page 56 Creating, Managing, and Formatting Excel Tables......Page 60 Entering Data with a Data Entry Form......Page 62 Using AutoCorrect and AutoComplete......Page 64 Inserting Text and Other Elements......Page 66 Cutting, Copying, and Pasting Data......Page 67 Formatting Cell Contents......Page 69 Formatting Numbers and Dates......Page 72 Formatting Cell Borders and Areas......Page 76 Working with Hyperlinks......Page 78 Working with Headers and Footers......Page 80 Getting a Running Total......Page 83 Adding Formulas to Cells......Page 84 Auditing Formulas......Page 86 Using Named Ranges......Page 87 Defining Alternative Data Sets......Page 88 Sorting Worksheet Data......Page 90 Filtering Worksheet Data......Page 92 Using Subtotals to Summarize Data......Page 94 Protecting All or Part of a Workbook......Page 95 Spelling and Other Tools......Page 96 Setting General Customization Options......Page 99 Customizing the Quick Access Toolbar......Page 101 Comments......Page 102 Tracking Changes......Page 103 Sharing Workbooks......Page 105 Working with the Web......Page 106 Summarizing Data with Charts......Page 107 Analyzing Data with PivotTables and PivotCharts......Page 109 New Formulas in Excel 2007......Page 113 Math Formulas......Page 114 Date and Time Formulas......Page 122 Financial Formulas......Page 124 Lookup and Reference Formulas......Page 129 Logical Formulas......Page 133 Text Formulas......Page 134 Statistical Formulas......Page 136 Excel Reference......Page 146 Command Reference......Page 147 Native Formats......Page 148 Startup Switches......Page 149 Wildcards in Filters and Searches......Page 150 Keyboard Shortcuts......Page 151 Internet Sites......Page 160 Books......Page 161 Excel Utilities......Page 162 Index......Page 165