Excel 2007 Pocket Guide: A Quick Reference to Common Tasks

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