Beginning Microsoft Excel 2010

✍ Scribed by Abbott Katz

Publisher: Apress
Year: 2010
Tongue: English
Leaves: 395
Edition: 1
Category: Library

No coin nor oath required. For personal study only.

✦ Synopsis

Beginning Microsoft Excel 2010 is a practical, step-by-step guide to getting started with the world’s most widely used spreadsheet application. The book offers a hands-on approach to learning how to create and edit spreadsheets, use various calculation formulas, employ charts/graphs, and get work done efficiently.

Microsoft is rolling out several new features with Excel 2010—perhaps the most notable is the ability to use Excel 2010 online and this collaborate on a project in real time. Beginning Microsoft Office 2010 keeps you up-to-date with all of these new features and more.

What you’ll learn

What distinguishes 2010 from its immediate predecessor
What distinguishes 2010 from Excel 2003
Get started with data entry and formatting
How to get started with formula writing skills
Get started with database capabilities, including pivot tables
How to get started with charting

Who this book is for

This book is for those new to Excel and for those who have used Excel in the past but are new to Excel 2010.

Introduction to Excel
Getting Started and Getting Around the Worksheet
From Data Entry to Data Creation: Formula Basics and Beyond
Keeping Up Appearances—Formatting the Worksheet
The Stuff Of Legend—Charting in Excel
Setting the Table: Database Features of Excel 2010
Working With Multiple Sheets
PivotTables and Pivot Charts
Getting It On Paper—Printing in Excel 2010
Taking it to the Cloud: Sharing and Collaborating on the Internet

✦ Table of Contents

Prelim......Page 1
Team rebOOk
......Page 4
Contents......Page 5
About the Author......Page 11
About the Technical Reviewer......Page 12
Acknowledgments......Page 13
Introduction......Page 14
Unlocking Your Inner Worksheet......Page 15
The Pep Talk......Page 18
Interacting with the Interface......Page 19
Tab Talk......Page 21
Something New, Something Old......Page 23
Keeping Tabs…on a New One......Page 24
Cool QAT......Page 26
Understood in Context......Page 27
Alt-ered Consciousness......Page 28
More Addresses Than the Phone Book—Cells, and How to Get There......Page 30
Getting Around......Page 32
Key Points......Page 34
Ranges: A Select Tool......Page 37
Data Entry: Getting Started......Page 42
Entering Text: Trespassing Allowed......Page 43
Numbers are (a little) Different......Page 49
Relocating the Data: Copying and Moving......Page 50
Having Your Fill......Page 54
There’ll Be Some Changes Made—Editing Cells......Page 59
From Data Entry to Data Creation: Formula Basics and Beyond......Page 63
Cell references explained......Page 64
Ordering Up Your Results......Page 66
Not Just Your Average Function......Page 74
Making Range Values COUNT......Page 75
MAX and MIN—Recording Highs and Lows......Page 76
Absolute References: Absolutely Important......Page 84
More of the Same......Page 85
You Could Look It Up......Page 91
If: Worth Knowing—No Ifs, Ands, or Buts......Page 95
In Conclusion…......Page 97
You’ve Got Designs on Your Worksheet......Page 98
The Font Button Group: A Closer Look......Page 100
Borderline Command......Page 104
Getting Oriented......Page 115
Excel Has Got Your Number(s)......Page 129
Dates—The Long and the Short of It......Page 135
Time Is On Your Side—Yes It Is......Page 136
A New Kind of Copy—and Paste......Page 142
Style Setter......Page 148
Formatting—With Conditions......Page 150
Just a Bit More…......Page 163
IN CONCLUSION…......Page 165
Starting Charting......Page 166
Excluding Data......Page 169
Evaluating the Chart......Page 171
Resizing the Chart......Page 172
Flipping the Data Series......Page 174
The Column Chart......Page 175
The Line Chart......Page 177
The Pie Chart......Page 179
The Bar Chart......Page 181
The Scatter Chart......Page 182
Change Chart Type......Page 183
Save As Template......Page 184
Switch Row/Column......Page 185
Select Data......Page 186
Chart Layouts......Page 187
Chart Styles......Page 188
Changing the Chart Default—and the 2-Second Chart......Page 189
The Layout Tab......Page 190
Working with Chart Labels......Page 195
Axes to Grind......Page 198
The Format Tab—Getting Your Objects in Shape......Page 204
Sparklines: Mini-Charts with Big Impact......Page 205
You Win Some, You Lose Some......Page 209
In Conclusion…......Page 211
Setting the Table: Database Features of Excel 2010......Page 212
Sorting—Sort Of Easy......Page 213
Using Header Rows......Page 215
Sorting by More than One Field......Page 216
The AutoFilter: Picking and Choosing Your Data......Page 220
Playing—or Plying—the Numbers......Page 224
The Advanced Filter—Setting Your Data Aside......Page 226
Table Talk......Page 229
Creating a Table......Page 230
Using Table Styles......Page 231
Adding a Total Row......Page 232
Examining the other Table Style Options......Page 234
At the Risk of Repeating Yourself: The Remove Duplicates Option......Page 237
Using Data Validation......Page 239
Adding Data Entry Rules......Page 242
Using the Error Alert Option......Page 245
Adding a Validation Rule to Existing Data......Page 247
In Conclusion…......Page 248
Working With Multiple Sheets......Page 249
Inserting a Column......Page 250
Inserting and Deleting Cells......Page 251
Rows and Columns—and Getting them Back......Page 252
Multiple Worksheet Basics......Page 253
Inserting a New Worksheet......Page 254
Busting a (Sheet) Move......Page 255
Hiding Worksheets......Page 256
Far-Flung Formulas: Working with Multi-Sheet Cell References......Page 257
Doing a Multi-sheet Calculation......Page 258
Extending Your Reach: Referring to Cells in Different Workbooks......Page 260
The Watch Window—Spying On Your Own Data......Page 261
Protecting a Sheet......Page 263
Locking Cells......Page 264
Unlocking Cells......Page 266
Protecting a Whole Workbook......Page 268
Consolidating Your Data—Getting It All Together......Page 269
In Conclusion…......Page 274
Starting Out with PivotTables......Page 275
What’s in a Name?......Page 277
Constructing a PivotTable: Let’s Go......Page 278
Inserting the Table......Page 279
Setting Up the PivotTable......Page 281
Changing the Calculation......Page 284
Comparing the Data......Page 285
Moving and Removing Fields......Page 286
Adding Data Fields......Page 287
Changing Field Settings......Page 290
Counting Totals......Page 292
Using the Same Field Twice......Page 294
Filters Again-PivotTable Style......Page 295
Your Very Own Top 10 List......Page 298
The Report Filter—Getting on Top of the PivotTable......Page 299
The Slicer—Filter Deluxe......Page 303
Grouping the Data......Page 306
Formatting the Pivot Report—Values and All......Page 310
Pivot Charts......Page 312
In Conclusion…......Page 317
Hard Copy? Pretty Easy......Page 318
The Print Area Option......Page 320
Margin-al Utility......Page 323
Printing As You See Fit......Page 325
Headers and Footers—Getting to the Bottom (and the Top) of Your Printout......Page 327
Title Search......Page 332
There’s More Than One Way to View A Worksheet......Page 336
Gimme a (Page) Break—Another View......Page 339
Customize Your View, Too......Page 343
In Conclusion…......Page 345
Taking it to the Cloud: Sharing and Collaborating on the Internet......Page 346
Getting There......Page 347
Permission Granted: Sharing Your Workbooks......Page 354
Hey—You! Get Onto My Cloud!......Page 357
In Conclusion…......Page 358
What’s in a Name? Plenty, if it’s a Range......Page 359
Naming Many Ranges – at the Same Time......Page 365
The Name Manager – Tracking Your Ranges......Page 367
In Conclusion.........Page 368
Control Key Combinations......Page 369
Function keys......Page 371
Other shortcut keys......Page 373
Nobody’s Perfect......Page 376
¦ A......Page 382
¦ C......Page 383
¦ D......Page 385
¦ E......Page 386
¦ H......Page 388
¦ L......Page 389
¦ P......Page 390
¦......Page 391
¦ S......Page 392
¦ V......Page 394
¦ Z......Page 395

📜 SIMILAR VOLUMES