Microsoft Office Excel 2007 for dummies

Table of Contents......Page 7
About This Book......Page 15
What You Can Safely Ignore......Page 16
Part I: Getting In on the Ground Floor......Page 17
Part V: Life Beyond the Spreadsheet......Page 18
Keyboard and mouse......Page 19
Special icons......Page 21
Where to Go from Here......Page 22
Part I: Getting In on the Ground Floor......Page 23
The Excel 2007 User Experience......Page 25
Manipulating the Office Button......Page 26
Bragging about the Ribbon......Page 28
Keeping tabs on the Excel Ribbon......Page 29
Selecting commands from the Ribbon......Page 31
Adding command buttons on the Customize Quick Access Toolbar’s drop-down menu......Page 32
Adding command buttons on the Ribbon......Page 33
Adding non-Ribbon commands to the Quick Access toolbar......Page 34
Having fun with the Formula bar......Page 35
Moving around the worksheet......Page 36
Surfing the sheets in a workbook......Page 40
Showing off the Status bar......Page 41
Starting Excel from the Windows XP Start menu......Page 43
Creating an Excel desktop shortcut for Windows Vista......Page 44
Creating an Excel desktop shortcut for Windows XP......Page 45
Exiting Excel......Page 46
Help Is on the Way......Page 47
Migrating to Excel 2007 from Earlier Versions......Page 48
Cutting the Ribbon down to size......Page 49
Finding the Standard Toolbar buttons equivalents......Page 55
Finding the Formatting Toolbar buttons equivalents......Page 57
Putting the Quick Access toolbar to excellent use......Page 59
Dealing with the new Excel file formats......Page 63
Using your macros......Page 64
Creating a Spreadsheet from Scratch......Page 65
The ins and outs of data entry......Page 66
Doing the Data-Entry Thing......Page 67
The telltale signs of text......Page 70
Making sure that Excel’s got your number......Page 72
How to fix your decimal places (when you don’t even know they’re broken)......Page 73
Tapping on the old ten-key......Page 75
Entering dates with no debate......Page 76
Make it a date in the 21st Century......Page 77
Fabricating those fabulous formulas!......Page 78
Altering the natural order of operations......Page 81
Formula flub-ups......Page 82
You really AutoCorrect that for me......Page 84
Cell editing etiquette......Page 85
I’m just not complete without you......Page 87
Fill ‘er up with AutoFill......Page 89
Working with a spaced series......Page 91
Copying with AutoFill......Page 92
Creating custom lists for AutoFill......Page 93
Inserting special symbols......Page 94
Entries all around the block......Page 95
Data entry express......Page 96
How to Make Your Formulas Function Even Better......Page 97
Inserting a function into a formula with the Function Wizard button......Page 98
I’d be totally lost without AutoSum......Page 101
Making Sure That the Data Is Safe and Sound......Page 104
The Save As dialog box in Windows Vista......Page 105
The Save As dialog box in Windows XP......Page 106
Changing the default file location......Page 107
The difference between the XLSX and XLS file format......Page 108
Saving the Workbook as a PDF File......Page 109
Document Recovery to the Rescue......Page 110
Part II: Editing Without Tears......Page 111
Making It All Look Pretty......Page 113
Point-and-click cell selections......Page 114
Nonadjacent cell selections......Page 115
Selecting the cells in a table of data, courtesy of AutoSelect......Page 116
Keyboard cell selections......Page 118
AutoSelect keyboard style......Page 119
Cell selections à la Go To......Page 120
Having Fun with the Format as Table Gallery......Page 121
Cell Formatting from the Home Tab......Page 123
Getting comfortable with the number formats......Page 128
Accenting your cells with the Accounting Number format......Page 130
Currying your cells with the Comma Style......Page 131
Playing around with the Percent Style......Page 132
The values behind the formatting......Page 133
Make it a date!......Page 135
Ogling some of the other number formats......Page 136
Calibrating Columns......Page 137
Rambling rows......Page 138
Hiding worksheet columns......Page 139
Futzing with the Fonts......Page 140
Altering the Alignment......Page 142
From top to bottom......Page 144
Tampering with how the text wraps......Page 145
Reorienting cell entries......Page 147
Shrink to fit......Page 148
Bring on the borders!......Page 149
Applying fill colors, patterns, and gradient effects to cells......Page 150
Copying custom styles from one workbook into another......Page 152
Fooling Around with the Format Painter......Page 153
Going through Changes......Page 155
The Open dialog box in Excel 2007 running on Windows Vista......Page 156
The Open dialog box in Excel 2007 running on Windows XP......Page 158
Opening recently edited workbooks......Page 160
Searching for workbooks when running Excel on Windows Vista......Page 161
Searching for workbooks when running Excel on Windows XP......Page 162
Opening files with a twist......Page 163
Undo is Redo the second time around......Page 164
Doing the Old Drag-and-Drop Thing......Page 165
Copies, drag-and-drop style......Page 167
Insertions courtesy of drag and drop......Page 168
Formulas on AutoFill......Page 169
Relatively speaking......Page 170
Some things are absolutes!......Page 171
Cut and paste, digital style......Page 173
Keeping pace with the Paste Options......Page 174
Paste it from the Clipboard task pane......Page 175
So what’s so special about Paste Special?......Page 176
Sounding the all clear!......Page 178
Get these cells outta here!......Page 179
Staying in Step with Insert......Page 180
Stamping Out Your Spelling Errors......Page 181
Stamping Out Errors with Text to Speech......Page 183
Printing the Masterpiece......Page 187
Taking a Gander at the Pages in Page Layout View......Page 188
Checking the Printout with Print Preview......Page 189
Printing the Worksheet......Page 191
Printing the Worksheet from the Print Dialog Box......Page 192
Printing particular parts of the workbook......Page 193
My Page Was Set Up!......Page 195
Massaging the margins......Page 196
Getting the lay of the landscape......Page 198
Putting out the print titles......Page 199
Using the Print buttons in the Sheet Options group......Page 202
From Header to Footer......Page 203
Adding an Auto Header or Auto Footer......Page 204
Creating a custom header or footer......Page 206
Creating different even and odd page headers and footers......Page 209
Solving Page Break Problems......Page 210
Letting Your Formulas All Hang Out......Page 212
Part III: Getting Organized and Staying That Way......Page 215
Maintaining the Worksheet......Page 217
Zeroing In with Zoom......Page 218
Splitting the Difference......Page 220
Fixed Headings Courtesy of Freeze Panes......Page 223
Adding a comment to a cell......Page 226
Comments in review......Page 228
Editing the comments in a worksheet......Page 229
If I only had a name . . .......Page 230
Name that formula!......Page 231
Naming constants......Page 232
Seek and Ye Shall Find . . .......Page 234
You Can Be Replaced!......Page 237
Do Your Research......Page 238
You Can Be So Calculating......Page 240
Maintaining Multiple Worksheets......Page 245
Sliding between the sheets......Page 246
Editing en masse......Page 249
Don’t Short-Sheet Me!......Page 250
A worksheet by any other name . . .......Page 251
A sheet tab by any other color . . .......Page 252
Getting your sheets in order......Page 253
Opening Windows on Your Worksheets......Page 254
Comparing Two Worksheets Side by Side......Page 259
Moving and Copying Sheets to Other Workbooks......Page 260
To Sum Up . . .......Page 263
Part IV: Digging Data Analysis......Page 267
Doing What-If Analysis......Page 269
Creating a one-variable data table......Page 270
Creating a two-variable data table......Page 273
Playing What-If with Goal Seeking......Page 275
Setting up the various scenarios......Page 278
Producing a summary report......Page 280
Pivot Tables: The Ultimate Data Summary......Page 283
Producing a Pivot Table......Page 284
Formatting a Pivot Table......Page 287
Refining the Pivot Table style......Page 288
Sorting and Filtering the Pivot Table Data......Page 289
Filtering individual Column and Row fields......Page 290
Modifying the pivot table fields......Page 292
Pivoting the table’s fields......Page 293
Modifying the table’s summary function......Page 294
Get Smart with a Pivot Chart......Page 295
Moving a pivot chart to its own sheet......Page 296
Formatting a pivot chart......Page 297
Part V: Life Beyond the Spreadsheet......Page 299
Making Professional-Looking Charts......Page 301
Creating a new chart......Page 302
Moving an embedded chart onto its own chart sheet......Page 304
Customizing the chart type and style from the Design tab......Page 305
Customizing chart elements from the Layout tab......Page 306
Adding data labels to the series in a chart......Page 307
Adding a data table to a chart......Page 308
Editing the titles in a chart......Page 309
Formatting chart elements from the Format tab......Page 310
Formatting the chart titles......Page 311
Formatting the Category x-axis and Value y-axis......Page 312
Adding Great Looking Graphics......Page 313
Adding and formatting a text box......Page 314
Adding an arrow to a text box......Page 315
The wonderful world of Clip Art......Page 316
Formatting Clip Art and imported pictures......Page 319
Adding preset graphic shapes......Page 321
Working with WordArt......Page 322
Make mine SmartArt......Page 324
Filling in the text for a new SmartArt graphic......Page 325
Formatting a SmartArt graphic......Page 326
Theme for a day......Page 327
Reordering the layering of graphic objects......Page 328
Hiding graphic objects......Page 329
Creating a Data List......Page 333
Adding the Form button to the Quick Access toolbar......Page 335
Adding records to a data list using the data form......Page 336
Editing records with the data form......Page 338
Moving through the records in the data form......Page 339
Finding records with the data form......Page 340
Sorting records on a single field......Page 344
Sorting records on multiple fields......Page 345
Filtering the Records in a Data List......Page 347
Using readymade number filters......Page 348
Using readymade date filters......Page 349
Getting creative with custom filtering......Page 350
Querying an Access database table......Page 353
Performing a New Web query......Page 355
Using Add-Ins in Excel 2007......Page 357
Adding Hyperlinks to a Worksheet......Page 359
Recording new macros......Page 362
Running macros......Page 366
Assigning macros to the Quick Access toolbar......Page 367
Part VI: The Part of Tens......Page 369
Top Ten New Features in Excel 2007......Page 371
Top Ten Beginner Basics......Page 375
The Ten Commandments of Excel 2007......Page 377
Index......Page 379