Excel 2010 For Dummies Quick Reference

✍ Scribed by Colin Banfield, John Walkenbach

• Publisher: Wiley Pub
• Year: 2010
• Tongue: English
• Leaves: 243
• Series: For Dummies Computer/Tech
• Edition: Spi
• Category: Library

✦ Synopsis

Find the answers to your most important Excel questions with this reference

John Walkenbach’s name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach—along with Excel expert Colin Banfield—answers your most common and important Excel questions in this easy-to-understand reference.

You'll learn how to open, save, protect, and recover workbook files; add, copy, and delete worksheets; enter and edit data and text; create formulas and functions; audit, format, and print; and more. Highly organized and free of unnecessary jargon, this essential reference allows you to find the answers you’re looking for quickly and easily.

• Excel gurus Walkenbach and Banfield offer quick and easy answers to common Excel questions
• Offers information in a highly organized, easy-to-understand format so you can find exactly what you need
• Includes information on opening, saving, protecting and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing; formatting; printing; and more
• Covers navigating the user interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more

Excel 2010 For Dummies Quick Reference enables you to spend more time working on your projects rather than trying to figure how to make Excel work for you!

✦ Table of Contents

Excel® 2010 For Dummies® Quick Reference......Page 1
Author’s Acknowledgments......Page 5
Table of Contents......Page 7
Part 1: Getting to Know Excel 2010......Page 15
Excel 2010 Basics......Page 16
Familiarizing Yourself with the Excel 2010 Window......Page 17
Navigating with the Mouse and Keyboard......Page 19
Introducing the Ribbon......Page 22
Introducing the Quick Access Toolbar (QAT)......Page 27
Going Backstage......Page 28
Previewing Your Formatting Live......Page 29
Formatting with Themes......Page 30
Soliciting Help......Page 31
Part 2: Managing Workbooks......Page 35
Changing the Default File Location......Page 36
Comparing Two Workbooks Side by Side......Page 37
Creating Multiple Windows (Views) for a Workbook......Page 38
Opening Non-native Files......Page 39
Opening a Workbook......Page 40
Protecting and Unprotecting a Workbook......Page 43
Recovering an Unsaved File......Page 45
Saving Workbooks......Page 46
Switching among Open Workbooks......Page 49
Working with Workbook Templates......Page 50
Part 3: Working with Worksheets......Page 53
Changing a Worksheet’s Name......Page 54
Copying or Moving a Worksheet......Page 55
Deleting a Worksheet......Page 56
Freezing Row or Column Titles......Page 57
Grouping and Ungrouping Worksheets......Page 58
Protecting a Worksheet......Page 59
Splitting Panes......Page 60
Turning Off Gridlines......Page 61
Zooming a Worksheet......Page 62
Part 4: Entering and Editing Worksheet Data......Page 63
Copying Cells and Ranges......Page 64
Editing the Contents of a Cell......Page 69
Entering Data into a Range......Page 71
Entering Dates and Times......Page 72
Entering Formulas......Page 73
Entering Text......Page 76
Entering Values......Page 78
Filling a Series......Page 79
Inserting or Deleting Entire Rows and Columns......Page 81
Moving Cells and Ranges......Page 82
Searching for Data to Replace......Page 84
Selecting Cells and Ranges......Page 86
Transposing a Range......Page 88
Undoing Changes and Mistakes......Page 89
Validating Data Entry......Page 90
Part 5: Using Formulas and Functions......Page 93
Basic Formula Essentials......Page 94
Changing When Formulas Are Calculated......Page 95
Editing Functions in Formulas......Page 96
Entering Functions in Formulas......Page 97
Modifying a Range Reference Used in a Function......Page 100
Referencing Cells or Ranges in Other Workbooks......Page 101
Referencing Cells or Ranges in Other Worksheets......Page 104
Part 6: Creating and Using Names......Page 105
Applying Names to Existing Cell References......Page 106
Creating Names......Page 107
Deleting Names......Page 111
Managing Names......Page 112
Pasting Names into a Formula......Page 114
Part 7: Auditing Your Work......Page 115
Checking for Specific Worksheet Errors......Page 116
Creating a Table of Names......Page 118
Evaluating Parts of a Formula......Page 119
Finding Specific Data......Page 120
Handling Circular References......Page 122
Locating Errors by Selecting Special Cells......Page 124
Tracing Cell Relationships......Page 125
Understanding Formula Error Values......Page 126
Using Cell Comments......Page 127
Using the Watch Window......Page 129
Part 8: Formatting Your Data......Page 131
Aligning Cell Contents......Page 132
Changing the Appearance of Cell Contents......Page 134
Formatting Based on the Contents of a Cell or Range......Page 135
Formatting a Number......Page 141
Formatting a Range Using Comparative Visualizations......Page 143
Hiding Cell Contents......Page 146
Hiding and Unhiding Columns and Rows......Page 147
Modifying Cell Size......Page 148
Using Cell Styles......Page 150
Part 9: Previewing and Printing Your Work......Page 153
Adjusting Page and Printer Settings......Page 154
Changing the Worksheet Display Mode......Page 156
Handling Page Breaks......Page 157
Inserting a Header or Footer......Page 160
Specifying Sheet Printing Options......Page 164
Part 10: Charting Your Data......Page 167
Anatomy of a Chart......Page 168
Activating a Chart......Page 169
Adding Context to Numbers with Sparklines......Page 170
Adding a New Data Series to a Chart......Page 174
Adding a Title to a Chart......Page 175
Creating a Chart......Page 176
Creating and Using a Chart Template......Page 178
Displaying Data Labels in a Chart......Page 179
Formatting a Chart Element......Page 180
Inserting and Modifying Chart Legends......Page 181
Modifying a Chart Axis......Page 182
Resizing, Moving, Copying, and Deleting an Embedded Chart......Page 183
Resizing, Moving, and Deleting a Chart Element......Page 184
Updating the Source Data Range for a Chart or a Data Series......Page 185
Part 11: Working with Tables......Page 187
Anatomy of a Table......Page 188
Creating a Table......Page 189
Formatting a Table......Page 190
Inserting and Deleting Table Rows and Columns......Page 191
Referencing Table Data in a Formula......Page 192
Removing Duplicate Values from a Table......Page 195
Selecting Table Areas......Page 196
Part 12: Analyzing Data with PivotTables......Page 197
Anatomy of a PivotTable......Page 198
Adding a Slicer Report Filter......Page 199
Changing the Summarization of PivotTable Data......Page 203
Creating and Using a PivotChart......Page 204
Creating a PivotTable Report......Page 206
Formatting a PivotTable Report......Page 207
Grouping PivotTable Items......Page 210
Modifying a PivotTable Report......Page 212
Using Custom Calculations......Page 215
Part 13: Sorting and Filtering Your Data......Page 217
Creating a Custom Sort List......Page 218
Filtering a PivotTable Report......Page 219
Filtering Data in a Table......Page 221
Sorting Data in a PivotTable......Page 226
Sorting Data in a Table......Page 228
Index......Page 233

✦ Subjects

Библиотека;Компьютерная литература;Microsoft Office;Microsoft Excel;