Katz Beginning Microsoft Excel 2010

1. ed
ISBN: 978-1-4302-2956-8
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 396 Seiten

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 rolled out several new features with Excel 2010-perhaps the most notable was the ability to use Excel 2010 online and collaborate on a project in real time. Beginning Microsoft Office 2010 keeps you up-to-date with all of these features and more.

Abbott Katz, author of Beginning Microsoft Excel 2010, brings extensive Microsoft Office instructional experience to the task, having trained users of the suite s components in varied academic and corporate settings. He has a doctorate in sociology and wide-ranging writing experience as well. Abbott has composed, and continue to compose, numerous complex spreadsheets, twinning technical fluency with the imagination to realize Excel s potential in a diverse array of settings.

Autoren/Hrsg.

Katz, Abbott

Inhaltsverzeichnis

1;Title Page;2
2;Copyright Page;3
3;Contents at a Glance;4
4;Table of Contents;5
5;About the Author;11
6;About the Technical Reviewer;12
7;Acknowledgments;13
8;Introduction;14
9;CHAPTER 1 Introduction to Excel;15
9.1;Making the Acquaintance;15
9.2;Unlocking Your Inner Worksheet;15
9.3;The Pep Talk;18
9.4;Interacting with the Interface;19
9.5;Tab Talk;21
9.6;Something New, Something Old;23
9.7;Keeping Tabs…on a New One;24
9.8;Cool QAT;26
9.9;Understood in Context;27
9.10;Alt-ered Consciousness;28
10;CHAPTER 2 Getting Started and Getting Around the Worksheet;30
10.1;More Addresses Than the Phone Book—Cells, and How to Get There;30
10.2;Getting Around;32
10.3;Key Points;34
10.4;Ranges: A Select Tool;37
10.5;Data Entry: Getting Started;42
10.5.1;Entering Text: Trespassing Allowed;43
10.6;Numbers are (a little) Different;49
10.7;Relocating the Data: Copying and Moving;50
10.8;Having Your Fill;54
10.9;There’ll Be Some Changes Made—Editing Cells;59
11;CHAPTER 3 From Data Entry to Data Creation: Formula Basics and Beyond;63
11.1;Cell references explained;64
11.2;Ordering Up Your Results;66
11.2.1;Not Just Your Average Function;74
11.2.2;Making Range Values COUNT;75
11.2.3;MAX and MIN—Recording Highs and Lows;76
11.2.4;Absolute References: Absolutely Important;84
11.3;More of the Same;85
11.3.1;You Could Look It Up;91
11.3.2;If: Worth Knowing—No Ifs, Ands, or Buts;95
11.3.3;In Conclusion…;97
12;CHAPTER 4 Keeping Up Appearances—Formatting the Worksheet;98
12.1;The Font Button Group: A Closer Look;100
12.2;Borderline Command;104
12.3;Getting Oriented;115
12.4;Excel Has Got Your Number(s);129
12.5;Dates—The Long and the Short of It;135
12.6;Time Is On Your Side—Yes It Is;136
12.7;A New Kind of Copy—and Paste;142
12.8;Style Setter;148
12.9;Formatting—With Conditions;150
12.10;Just a Bit More…;163
12.11;P. S.;165
12.12;IN CONCLUSION…;165
13;CHAPTER 5 The Stuff Of Legend—Charting in Excel;166
13.1;Starting Charting;166
13.1.1;Making a Chart of Our Own;169
13.1.1.1;Excluding Data;169
13.1.1.2;Evaluating the Chart;171
13.1.1.3;Resizing the Chart;172
13.1.1.4;Flipping the Data Series;174
13.1.2;Changing The Chart—It’s Your Call;175
13.1.2.1;The Column Chart;175
13.1.2.2;The Line Chart;177
13.1.2.3;The Pie Chart;179
13.1.2.4;The Bar Chart;181
13.1.2.5;The Area Chart;182
13.1.2.6;The Scatter Chart;182
13.2;The Design Tab—A Closer Look;183
13.2.1;Change Chart Type;183
13.2.2;Save As Template;184
13.2.3;Switch Row/Column;185
13.2.4;Select Data;186
13.2.5;Chart Layouts;187
13.2.6;Chart Styles;188
13.2.7;Move Chart;189
13.3;Changing the Chart Default—and the 2-Second Chart;189
13.4;The Layout Tab;190
13.5;Working with Chart Labels;195
13.6;Axes to Grind;198
13.7;The Format Tab—Getting Your Objects in Shape;204
13.8;Sparklines: Mini-Charts with Big Impact;205
13.9;You Win Some, You Lose Some;209
13.10;In Conclusion…;211
14;CHAPTER 6 Setting the Table: Database Features of Excel 2010;212
14.1;Sorting—Sort Of Easy;213
14.1.1;Using Header Rows;215
14.1.2;Sorting by More than One Field;216
14.2;The AutoFilter: Picking and Choosing Your Data;220
14.3;Playing—or Plying—the Numbers;224
14.4;The Advanced Filter—Setting Your Data Aside;226
14.5;Table Talk;229
14.5.1;Creating a Table;230
14.5.2;Using Table Styles;231
14.5.3;Adding a Total Row;232
14.5.4;Examining the other Table Style Options;234
14.6;At the Risk of Repeating Yourself: The Remove Duplicates Option;237
14.7;Data Validation: Improving Your Entrée to Data Entry;239
14.7.1;Using Data Validation;239
14.7.2;Adding Data Entry Rules;242
14.7.3;Adding an Input Message;245
14.7.4;Using the Error Alert Option;245
14.7.5;Adding a Validation Rule to Existing Data;247
14.8;In Conclusion…;248
15;CHAPTER 7 Working With Multiple Sheets;249
15.1;Adding To Sheets—Inserting Rows, Columns and Cells;250
15.1.1;Inserting a Column;250
15.1.2;Inserting a Row;251
15.1.3;Deleting Rows and Columns;251
15.1.4;Inserting and Deleting Cells;251
15.1.5;Hiding Rows and Columns—and Getting them Back;252
15.2;Multiple Worksheet Basics;253
15.2.1;Inserting a New Worksheet;254
15.2.2;Busting a (Sheet) Move;255
15.2.3;Hiding Worksheets;256
15.2.4;Grouping Worksheets;257
15.3;Far-Flung Formulas: Working with Multi-Sheet Cell References;257
15.3.1;Doing a Multi-sheet Calculation;258
15.3.2;Extending Your Reach: Referring to Cells in Different Workbooks;260
15.4;The Watch Window—Spying On Your Own Data;261
15.5;Protect Your Cells From Unwanted Intruders—Even Yourself;263
15.5.1;Protecting a Sheet;263
15.5.1.1;Locking Cells;264
15.5.1.2;Unlocking Cells;266
15.5.2;Protecting a Whole Workbook;268
15.6;Consolidating Your Data—Getting It All Together;269
15.7;In Conclusion…;274
16;CHAPTER 8 PivotTables and Pivot Charts;275
16.1;Starting Out with PivotTables;275
16.2;What’s in a Name?;277
16.3;Constructing a PivotTable: Let’s Go;278
16.3.1;Inserting the Table;279
16.3.2;Setting Up the PivotTable;281
16.3.3;Updating the Pivot Report;284
16.3.3.1;Changing the Calculation;284
16.3.3.2;Comparing the Data;285
16.3.3.3;Moving and Removing Fields;286
16.3.3.4;Adding Data Fields;287
16.3.3.5;Changing Field Settings;290
16.3.3.6;Pivoting the Table;292
16.3.3.7;Counting Totals;292
16.3.3.8;Using the Same Field Twice;294
16.4;Filters Again-PivotTable Style;295
16.5;Your Very Own Top 10 List;298
16.6;The Report Filter—Getting on Top of the PivotTable;299
16.7;The Slicer—Filter Deluxe;303
16.8;Grouping the Data;306
16.9;Formatting the Pivot Report—Values and All;310
16.10;Pivot Charts;312
16.11;In Conclusion…;317
17;CHAPTER 9 Getting It On Paper—Printing in Excel 2010;318
17.1;Hard Copy? Pretty Easy;318
17.2;The Print Area Option;320
17.3;Margin-al Utility;323
17.4;Printing As You See Fit;325
17.5;Headers and Footers—Getting to the Bottom (and the Top) of Your Printout;327
17.6;Title Search;332
17.7;There’s More Than One Way to View A Worksheet;336
17.7.1;Gimme a (Page) Break—Another View;339
17.8;Customize Your View, Too;343
17.9;In Conclusion…;345
18;CHAPTER 10 Taking it to the Cloud: Sharing and Collaborating on the Internet;346
18.1;Getting There;347
18.2;Permission Granted: Sharing Your Workbooks;354
18.3;Hey—You! Get Onto My Cloud!;357
18.4;In Conclusion…;358
19;APPENDIX A Working With Range Names;359
19.1;What’s in a Name? Plenty, if it’s a Range;359
19.2;Naming Many Ranges – at the Same Time;365
19.3;The Name Manager – Tracking Your Ranges;367
19.4;In Conclusion...;368
20;APPENDIX B Keyboard Shortcuts;369
20.1;Control Key Combinations;369
20.2;Function keys;371
20.3;Other shortcut keys;373
21;APPENDIX C Error Messages;377
21.1;Nobody’s Perfect;377
22;Index;383