Hart-Davis Beginning Microsoft Office 2010

1. ed
ISBN: 978-1-4302-2950-6
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 741 Seiten

This book is a practical, step-by-step guide to getting started with Microsoft Office 2010. You'll learn how to create and edit essential office files-documents, spreadsheets, presentations, and more-quickly and efficiently. You'll also learn about all of the new updates included with Office 2010. Collaborate on projects in the cloud and access your files from virtually anywhere-with Beginning Microsoft Office 2010, you'll take a hands-on approach to learning everything, new and old, that the world's most popular productivity software suite has to offer. Get started with Office 2010 Basics. Create, store, and share office documents. Use shared Office tools both online and offline. How to keep e-mail, contacts, appointments, notes, and tasks organized.

Guy Hart-Davis is the author of more than 50 computer books, including How to Do Everything with Microsoft Excel 2007 and How to Do Everything with Microsoft Word 2007.

Autoren/Hrsg.

Hart-Davis, Guy

Inhaltsverzeichnis

1;Title Page;2
2;Copyright Page;3
3;Contents at a Glance;5
4;Table of Contents;7
5;About the Author;26
6;About the Technical Reviewers;27
7;Acknowledgments;28
8;Introduction;29
8.1;Who Is This Book For?;29
8.2;What Does This Book Cover?;29
8.3;Conventions Used in This Book;32
8.4;Visit the Beginning Microsoft Office 2010 Wiki!;33
9;CHAPTER 1 Getting Started with Office 2010;34
9.1;Meeting the Office Programs and Learning What You Can Do With Them;34
9.1.1;Microsoft Word;34
9.1.2;Microsoft Excel;35
9.1.3;Microsoft PowerPoint;36
9.1.4;Microsoft Outlook;37
9.1.5;Microsoft OneNote;38
9.2;Understanding the Common Features of the Programs;39
9.2.1;The Title Bar and Minimize, Maximize, and Close Buttons;40
9.2.2;The Control Menu and the Quick Access Toolbar;41
9.2.3;The Ribbon;42
9.2.4;Backstage;42
9.2.5;The Status Bar;43
9.3;Opening Programs;44
9.3.1;Opening a Program the Standard Way;44
9.3.2;Making a Program Easy to Run;45
9.3.3;Making a Program Launch Automatically;45
9.4;Creating a Document;46
9.5;Saving a Document;48
9.6;Closing a Document;50
9.7;Opening a Document;51
9.8;Closing a Program;54
9.9;Summary;54
10;CHAPTER 2 Head in the Cloud: Experiencing Software as a Service;55
10.1;Coming to Grips with Software as a Service;55
10.1.1;Understanding What Software as a Service Is;55
10.1.2;Understanding the Office Web Apps, Windows Live, and SkyDrive;55
10.1.3;Deciding Whether Software as a Service Meets Your Needs;57
10.2;Getting Started with the Office Web Apps;57
10.2.1;Signing Up for the Office Web Apps;57
10.2.2;Opening an Office Web App;58
10.2.2.1;Creating a New Document on SkyDrive;58
10.2.2.2;Opening an Existing Document on SkyDrive;59
10.2.3;Saving Changes to a Document in the Office Web Apps;60
10.3;Transferring Documents Between SkyDrive and Your PC;61
10.3.1;Saving Documents to SkyDrive from the Desktop Office Programs;61
10.3.2;Copying Documents from Your PC to SkyDrive;62
10.3.3;Downloading Documents from SkyDrive to Your PC;64
10.4;Summary;64
11;CHAPTER 3 Learning Common Tools Across the Office Suite;65
11.1;Using the Ribbon;65
11.1.1;Giving Commands from the Ribbon;67
11.1.2;Minimizing the Ribbon;67
11.1.3;Controlling the Ribbon with the Keyboard;68
11.2;Using Backstage;69
11.3;Sharing a Document with Other People;71
11.3.1;Sending a Document via E-mail;71
11.3.2;Saving a Document to SkyDrive;73
11.3.3;Saving a Document to a SharePoint Server;74
11.4;Saving Time and Effort with AutoCorrect;75
11.4.1;Choosing Options on the AutoCorrect Tab of the AutoCorrect Dialog Box;77
11.4.2;Choosing AutoFormat As You Type Options;77
11.4.3;Choosing Math AutoCorrect Options;80
11.4.4;Creating AutoCorrect Entries;81
11.4.5;Creating AutoCorrect Exceptions;82
11.4.6;Working with Actions;83
11.5;Checking Spelling and Grammar;85
11.5.1;Checking Spelling;86
11.5.1.1;Checking Spelling as You Type;86
11.5.1.2;Checking Spelling in the Whole Document;87
11.5.2;Checking Grammar in Word and Outlook;89
11.5.2.1;Controlling How the Spelling Checker Works;91
11.5.2.2;Choosing Grammar and Style Options for Word and Outlook;94
11.5.3;Taking Control over Spelling Checks with Custom Dictionaries;96
11.5.3.1;Understanding How Custom Dictionaries Work;96
11.5.3.2;Coming to Grips with Your Custom Dictionaries;96
11.5.3.3;Creating a Custom Dictionary;97
11.5.3.4;Adding Words to or Removing Words from a Custom Dictionary;98
11.5.3.5;Turning Off, Removing, or Deleting a Custom Dictionary;99
11.6;Printing Documents;99
11.7;Summary;101
12;CHAPTER 4 Working with Text and Graphics;103
12.1;Entering Text in Your Documents;103
12.1.1;Entering Text in Documents Using Copy and Paste;103
12.1.2;Entering Text by Scanning a Document and Using Optical Character Recognition;103
12.1.3;Entering Text by Using Speech Recognition;104
12.1.4;Inserting Symbols in a Document;104
12.2;Navigating with the Keyboard and Selecting Objects;107
12.3;Applying Direct Formatting to Text and Objects;108
12.4;Using Cut, Copy, and Paste;111
12.4.1;Using Standard Cut, Copy, and Paste in the Office Programs;111
12.4.2;Using the Office Programs’ Clipboard;111
12.4.3;Using Paste Options;113
12.4.4;Setting Paste Options in Word;115
12.5;Using Find and Replace;116
12.5.1;Locating Text with Find;116
12.5.2;Replacing Text with Replace;118
12.6;Creating Tables;120
12.6.1;Inserting a Table;120
12.6.2;Drawing a Table;121
12.6.3;Merging and Splitting Cells in a Table;122
12.6.4;Adding Content to a Table;122
12.6.5;Formatting a Table;123
12.7;Using Pictures and Shapes in Your Documents;124
12.7.1;Understanding How You Position Graphical Objects;124
12.7.2;Choosing Where to Insert a Graphical Object;124
12.7.3;Inserting Clip Art;125
12.7.4;Inserting Pictures in Your Documents;129
12.7.5;Adding and Formatting a Shape;130
12.7.5.1;Applying a Style to a Shape;132
12.7.6;Rotating a Graphical Object;134
12.7.7;Positioning a Graphical Object;135
12.7.8;Choosing Text Wrapping in Word and Outlook;136
12.7.9;Making a Picture Look the Way You Want It;138
12.7.9.1;Adjusting a Picture’s Sharpness, Brightness, Contrast, and Colors;138
12.7.9.2;Applying a Picture Style;140
12.7.9.3;Cropping a Picture;140
12.7.10;Inserting SmartArt;142
12.7.11;Arranging Graphical Objects to Control Which Is Visible;144
12.8;Creating Hyperlinks;145
12.9;Summary;148
13;CHAPTER 5 Customizing Office to Suit You;149
13.1;Customizing the Quick Access Toolbar, Ribbon, and Status Bar;149
13.1.1;Customizing the Quick Access Toolbar;149
13.1.1.1;Adding Buttons for Frequently Used Commands to the Quick Access Toolbar;150
13.1.1.2;Adding a Ribbon Command to the Quick Access Toolbar;151
13.1.1.3;Adding Buttons for Other Commands to the Quick Access Toolbar;151
13.1.1.4;Resetting the Quick Access Toolbar to Its Default Buttons;153
13.1.1.5;Moving the Quick Access Toolbar to Below the Ribbon;154
13.1.2;Customizing the Ribbon;154
13.1.2.1;Resetting the Ribbon to Its Default Settings;157
13.1.3;Sharing Customizations with Other PCs;157
13.1.4;Customizing the Status Bar;158
13.2;Choosing Essential Options;160
13.2.1;Choosing General Options;160
13.2.2;Choosing Save Options in Word, Excel, and PowerPoint;162
13.2.2.1;Choosing the Default Format for Saving Documents;163
13.2.2.2;Choosing AutoRecover Settings;164
13.2.2.3;Choosing the Default File Location;165
13.3;Summary;165
14;CHAPTER 6 Entering Text and Using Views;167
14.1;Entering Text in Your Word Documents;167
14.1.1;Inserting the Text from a File in a Document;167
14.1.2;Inserting Prebuilt Blocks of Text with AutoText;168
14.2;Selecting Text in Word-Specific Ways;170
14.2.1;Selecting Text with the Mouse;170
14.2.2;Selecting Text with the Extend Selection Feature;171
14.2.3;Selecting Multiple Items at Once;172
14.3;Moving with Keyboard Shortcuts and the Browse Object;172
14.4;Telling Word Where to Find Your Templates;175
14.5;Customizing Keyboard Shortcuts in Word;177
14.6;Creating Backup Documents and Recovering from Disaster;179
14.7;Using Views and Windows to See What You Need;181
14.7.1;Picking the Right View for What You’re Doing;181
14.7.1.1;Using Print Layout View to See How a Document Will Look When Printed;181
14.7.1.2;Using Full Screen Reading View to See More of a Document;182
14.7.1.3;Using Web Layout View to Get a Preview of Web Pages;184
14.7.1.4;Developing a Document in Outline View;185
14.7.1.5;Using Draft View;186
14.7.2;Opening Extra Windows;187
14.7.3;Splitting the Document Window into Two Panes;188
14.8;Summary;190
15;CHAPTER 7 Adding Style: Formatting Your Documents;191
15.1;Understanding Word’s Many Types of Formatting;191
15.1.1;Understanding Direct Formatting and When to Use It;191
15.1.2;Understanding Styles and When to Use Them;192
15.2;Formatting Your Documents the Best Way;193
15.3;Applying Styles to a Document;194
15.3.1;Applying Different Quick Styles, Colors, Fonts, or Paragraph Spacing;195
15.3.2;Changing the Styles in the Quick Style Gallery;197
15.3.3;Using the Apply Styles Pane;197
15.3.4;Applying Styles Using the Keyboard;198
15.3.5;See Which Styles a Document Uses;199
15.3.6;Managing Styles with the Styles Pane and the Manage Styles Dialog Box;200
15.3.6.1;Working with the Styles Pane;200
15.3.6.2;Working with the Manage Styles Dialog Box;202
15.4;Creating Custom Styles;204
15.4.1;Creating a Custom Style by Example;204
15.4.1.1;Choosing the Font Formatting for a Style;204
15.4.1.2;Choosing the Paragraph Formatting for the Style;205
15.4.1.3;Adding Bullets or Numbering to the Style;210
15.4.1.4;Adding Borders and Shading to the Style;210
15.4.1.5;Adding Language Formatting to the Style;212
15.4.1.6;Creating the Style;213
15.4.2;Modifying an Existing Style;215
15.4.2.1;Changing a Style Using the Modify Style dialog Box;215
15.4.2.2;Updating a Style with New Formatting;215
15.5;Applying Direct Formatting on Top of Styles;215
15.5.1;Copying and Pasting Formatting Using the Format Painter;216
15.5.2;Seeing Which Formatting You’ve Applied to Text;217
15.5.2.1;Using the Style Inspector to Examine a Style;217
15.5.2.2;Seeing Formatting Details with the Reveal Formatting Pane;218
15.6;Navigating Quickly Around Your Documents;220
15.6.1;Using the Navigation Pane;220
15.6.2;Using Find;221
15.6.2.1;Displaying Reading Highlights;223
15.6.2.2;Searching Only Part of the Document;223
15.6.2.3;Changing the Search Direction;223
15.6.2.4;Finding Search Terms That Match the Case You Type;223
15.6.2.5;Restricting the Search to Whole Words;223
15.6.2.6;Using Wildcards to Find Variable Text;223
15.6.2.7;Finding Words That Sound Like Other Words;224
15.6.2.8;Finding All Forms of a Word;224
15.6.2.9;Searching for Special Characters;224
15.6.2.10;Searching Only at the Start or End of a Word;225
15.6.2.11;Ignoring Punctuation and White Space;225
15.6.2.12;Finding Formatting;226
15.6.3;Replacing Text, Formatting, and Styles;227
15.6.3.1;Replacing Text;228
15.6.3.2;Replacing Formatting or Styles;228
15.6.4;Navigating with Go To;229
15.7;Summary;230
16;CHAPTER 8 Creating Complex Documents and Layouts;231
16.1;Working with Word’s Extra Table Features;231
16.1.1;Converting Existing Text into a Table;231
16.1.2;Converting a Table to Text;234
16.1.3;Nesting One Table Inside Another Table;235
16.2;Creating Complex Documents with Multiple Sections;235
16.3;Adding Headers, Footers, and Page Numbers;237
16.3.1;Adding Headers and Footers to a Document;237
16.3.1.1;Creating Different Headers and Footers for Different Pages;239
16.3.1.2;Using Different Headers and Footers in Different Sections of a Document;239
16.3.1.3;Delete a Header or Footer;239
16.3.2;Inserting Page Numbers in a Document;240
16.4;Creating Newspaper-Style Columns of Text;241
16.4.1;Breaking Your Columns with Column Breaks;244
16.4.2;Removing Multiple Columns from a Section or Document;244
16.5;Using Bookmarks, Fields, and References;245
16.5.1;Marking Important Parts of a Document with Bookmarks;245
16.5.1.1;appears in the bookmark.;245
16.5.1.2;Navigating from Bookmark to Bookmark;246
16.5.1.3;Seeing Where Bookmarks Are in Your Documents;246
16.5.1.4;Deleting a Bookmark You No Longer Need;247
16.5.2;Inserting Automated Information with Fields;247
16.5.2.1;Inserting a Field;247
16.5.2.2;Examining and Updating a Field;250
16.5.3;Adding Cross-References to Other Parts of a Document;250
16.6;Creating Long Documents with Outline View;253
16.6.1;How Outlines Work;253
16.6.2;Developing the Outline of a Document;253
16.6.2.1;Switching to Outline View;253
16.6.2.2;Creating Headings in Outline View;254
16.6.3;Promoting and Demoting Headings;255
16.6.4;Expanding and Collapsing the Outline and Headings;255
16.6.5;Moving Paragraphs Up and Down the Document;257
16.6.6;Returning from Outline View to Your Previous View;257
16.7;Adding Footnotes and Endnotes;257
16.7.1;Adding a Footnote;258
16.7.2;Adding an Endnote;259
16.7.3;Customizing Footnotes and Endnotes to Suit Your Document;260
16.7.4;Converting Footnotes to Endnotes or Endnotes to Footnotes;261
16.7.5;Navigating Among and Viewing Footnotes or Endnotes;262
16.8;Summary;263
17;CHAPTER 9 Revising and Reviewing Documents;264
17.1;Understanding How You Can Work on Documents with Your Colleagues;264
17.2;Editing a Document Simultaneously with Your Colleagues;265
17.3;Sharing Documents with Your Colleagues on a Network;269
17.4;Tracking the Changes in a Document;270
17.4.1;Choosing Which Changes to Track;271
17.4.2;Turning On Track Changes for a Document;274
17.4.3;Ensuring Your Colleagues Use the Track Changes Feature;274
17.4.4;Working in a Document with Track Changes On;278
17.4.5;Choosing How to View the Document’s Changes and Markup;279
17.4.6;Controlling Which Changes Word Displays;279
17.4.7;Integrating Tracked Changes into a Document;280
17.4.8;Using Track Changes in Full Screen Reading view;281
17.5;Adding Comments to a Document;282
17.5.1;Adding a Comment;283
17.5.2;Viewing and Reviewing Comments;286
17.5.3;Deleting Comments;287
17.6;Comparing or Combining Different Versions of the Same Document;287
17.7;Using Word’s Document Versions;290
17.8;Summary;292
18;CHAPTER 10 Printing, Finalizing, and Sharing Documents;293
18.1;Using Word’s Features for Printing Documents;293
18.1.1;Printing a Custom Range of Pages;294
18.1.2;Choosing Whether to Print Markup—Or Only Markup;295
18.1.3;Printing Document Properties, Styles, AutoText Entries, and Key Assignments;295
18.2;Finalizing a Document;296
18.2.1;Removing Sensitive Information from a Document;296
18.2.2;Marking a Document as Final;298
18.2.3;Encrypting a Document with a Password;300
18.2.4;Limiting the People Who Can Open, Edit, and Print the Document;301
18.2.5;Signing a Final Document with a Digital Signature;304
18.3;Making a Document You Can Open with Earlier Versions of Word;307
18.4;Creating Documents for Digital Distribution;309
18.5;Summary;312
19;CHAPTER 11 Creating Workbooks and Entering Data;313
19.1;Creating and Saving a New Workbook;313
19.1.1;Creating a New Workbook;313
19.1.2;Saving a Workbook;315
19.2;Navigating the Excel Interface, Worksheets, and Workbooks;315
19.2.1;Understanding Workbooks, Worksheets, Columns, and Rows;317
19.2.2;Moving the Active Cell;318
19.2.3;Selecting and Manipulating Cells;319
19.3;Entering Data in Your Worksheets;320
19.3.1;Typing Data in a Cell;320
19.3.2;Editing a Cell;321
19.3.3;Entering Data Quickly Using AutoFill;323
19.3.3.1;Using AutoFill’s Built-in Capabilities;323
19.3.3.2;Creating Your Own Custom AutoFill Lists;325
19.3.4;Pasting Data into a Worksheet;326
19.3.4.1;Using Paste and Paste Options;326
19.3.4.2;Controlling Pasted Data with the Paste Special Command;327
19.3.5;Copying and Moving Data with Drag and Drop;329
19.4;Inserting, Deleting, and Rearranging Worksheets;331
19.4.1;Inserting and Deleting Worksheets;331
19.4.2;Rearranging the Worksheets in a Workbook;332
19.5;Making Excel Display Worksheets the Way You Need;333
19.5.1;Understanding Excel’s Views;333
19.5.2;Splitting the Window to View Separate Parts of a Worksheet;334
19.5.3;Opening Extra Windows to Show Other Parts of a Workbook;336
19.5.4;Changing the Window and Arranging Open Windows;336
19.5.5;Zooming to Show the Data You Need to See;337
19.5.6;Comparing Two Windows Side by Side;338
19.5.7;Freezing Rows and Columns So That They Stay on Screen;338
19.6;Summary;339
20;CHAPTER 12 Formatting Your Worksheets;340
20.1;Working with Rows and Columns;340
20.1.1;Inserting and Deleting Rows, Columns, and Cells;340
20.1.2;Setting Row Height;342
20.1.3;Setting Column Width;343
20.1.4;Hiding Rows and Columns;343
20.2;Formatting Cells and Ranges;344
20.2.1;Understanding the Three Main Tools for Applying Formatting;344
20.2.2;Controlling How Data Appears by Applying Number Formatting;346
20.2.3;Setting the Workbook’s Overall Look by Applying a Theme;349
20.2.4;Setting Alignment;349
20.2.5;Choosing Font Formatting;350
20.2.6;Applying Borders and Fills;351
20.2.7;Applying Protection to Cells;352
20.3;Applying Conditional Formatting to Identify Particular Values;353
20.3.1;Understanding Excel’s Preset Types of Conditional Formatting;353
20.3.2;Applying a Preset Form of Conditional Formatting;354
20.4;Using Data Validation to Check for Invalid Entries;355
20.5;Formatting Quickly with Table Formatting and Styles;358
20.5.1;Formatting with Table Formatting;358
20.5.2;Formatting with Styles;358
20.5.2.1;Meeting Excel’s Styles;359
20.5.2.2;Applying a Style;360
20.5.2.3;Creating Custom Styles;360
20.5.2.4;Copying Styles from One Workbook to Another;362
20.5.2.5;Deleting Styles You Don’t Need;363
20.6;Adding Headers and Footers to Your Worksheets;363
20.7;Printing Your Excel Worksheets and Workbooks;364
20.7.1;Telling Excel Which Part of the Worksheet to Print;365
20.7.2;Checking the Page Layout and Where the Page Breaks Fall;365
20.7.3;Printing a Worksheet or Workbook;368
20.8;Sharing Your Workbooks with Your Colleagues;368
20.8.1;Protecting a Workbook or Some of Its Worksheets;369
20.8.1.1;Protecting a Workbook;369
20.8.1.2;Protecting a Worksheet;370
20.8.2;Sharing a Workbook So That Your Colleagues Can Edit It;371
20.8.3;Working in a Shared Workbook;372
20.8.4;Resolving Conflicts in a Shared Workbook;373
20.9;Summary;373
21;CHAPTER 13 Crunching Numbers with Formulas and Functions;374
21.1;Understanding the Difference Between Formulas and Functions;374
21.2;Referring to Cells and Ranges in Formulas and Functions;375
21.2.1;Referring to a Cell;375
21.2.2;Referring to Ranges;376
21.2.3;Referring to Named Cells and Ranges;377
21.3;Performing Custom Calculations by Creating Formulas;378
21.3.1;Meeting Excel’s Calculation Operators;378
21.3.2;Using the Calculation Operators;380
21.3.3;Understanding the Order in Which Excel Evaluates Operators;383
21.3.4;Nesting Parts of Formulas to Override Operator Precedence;384
21.3.5;Entering Formulas Quickly by Copying and Using AutoFill;384
21.3.6;Troubleshooting Common Problems with Formulas;385
21.3.6.1;Understanding Common Errors—and Resolving Them;385
21.3.6.2;Seeing the Details of an Error in a Formula;386
21.3.6.3;Tracing an Error Back to Its Source;386
21.3.6.4;Displaying All the Formulas in a Worksheet;387
21.3.6.5;Seeing Which Cells a Formula Uses;387
21.3.6.6;Removing Circular References;388
21.4;Performing Standard Calculations by Inserting Functions;389
21.4.1;Understanding Function Names and Arguments;389
21.4.2;Inserting Functions with the Function Drop-Down List;390
21.4.3;Finding the Functions You Need with the Insert Function Dialog Box;392
21.4.4;Inserting Functions with the Function Library;393
21.4.5;Providing the Arguments for the Function;394
21.4.6;Inserting Functions by Typing Them into a Worksheet;396
21.5;Summary;397
22;CHAPTER 14 Creating Powerful and Persuasive Charts;398
22.1;Learning the Essentials of Charts in Excel;398
22.1.1;Understanding Embedded Charts and Chart Sheets;398
22.1.2;Understanding the Components of a Chart;400
22.1.2.1;Chart Area and Plot Area;401
22.1.2.2;Chart Axes;401
22.1.2.3;Categories and Data Series;402
22.1.2.4;Chart Title and Axis Titles;402
22.1.2.5;Data Markers, Gridlines, and Data Labels;402
22.1.3;Understanding Excel’s Chart Types and Choosing Which to Use;402
22.2;Creating, Laying Out, and Formatting a Chart;403
22.2.1;Creating a Chart;404
22.2.2;Changing a Chart from an Embedded Chart to a Chart Sheet;406
22.2.3;Changing the Chart Type;407
22.2.4;Switching the Rows and Columns in a Chart;407
22.2.5;Changing the Source Data for a Chart;407
22.2.6;Choosing the Layout for the Chart;408
22.2.7;Changing the Order of the Data Series;409
22.2.8;Adding a Separate Data Series to a Chart;409
22.2.9;Applying a Style to a Chart;410
22.2.10;Adding a Title to a Chart;411
22.2.11;Adding Axis Titles to the Chart;412
22.2.12;Changing the Scale or Numbering of an Axis;413
22.2.13;Adding a Legend to a Chart;415
22.2.14;Adding Axis Labels from a Range Separate from the Chart Data;415
22.2.15;Adding Data Labels to the Chart;415
22.2.16;Choosing Which Gridlines to Display;416
22.2.17;Formatting a Chart Wall and Chart Floor;417
22.2.18;Naming an Embedded Chart;419
22.2.19;Formatting Individual Chart Elements;419
22.3;Copying Chart Formatting;420
22.4;Reusing Your Own Designs by Creating Custom Chart Types;421
22.5;Summary;421
23;CHAPTER 15 Creating and Using Excel Database Tables;422
23.1;Understanding What You Can and Can’t Do with Excel Database Tables;422
23.2;Creating a Database Table and Entering Data;423
23.2.1;Creating a Database Table;423
23.2.2;Customizing the Database Table’s Looks;426
23.2.3;Entering Data in a Database Table;427
23.2.3.1;Entering Data Directly in the Database Table;427
23.2.3.2;Entering Data Using a Data-Entry Form;428
23.3;Resizing a Database Table;430
23.4;Sorting a Database Table by One or More Fields;431
23.4.1;Sorting Quickly by a Single Field;431
23.4.2;Sorting a Database Table by Multiple Fields;431
23.5;Identifying and Removing Duplicate Records in a Database Table;433
23.6;Filtering a Database Table;435
23.7;Summary;440
24;CHAPTER 16 Starting to Build a Presentation;441
24.1;Creating a Presentation;441
24.2;Changing the Slide Size or Orientation;446
24.3;Navigating the PowerPoint Window;447
24.4;Add Content to a Slide;448
24.5;Adding, Deleting, and Rearranging Slides;448
24.5.1;Adding a Slide;449
24.5.2;Deleting a Slide;450
24.5.3;Rearranging Slides;450
24.6;Using Views to Work on Your Presentation;451
24.6.1;Creating Your Slides in Normal View;451
24.6.2;Rearranging Your Slides in Slide Sorter View;451
24.6.3;Creating Notes Pages in Notes Page View;453
24.6.4;Viewing a Presentation in Reading View;453
24.6.5;Running a Presentation in Slide Show View;454
24.6.6;Opening Extra Windows to See Different Parts of the Presentation;455
24.7;Creating the Outline of a Presentation;455
24.8;Organizing Your Slides into Sections;456
24.9;Collaborating on a Presentation with Your Colleagues;458
24.9.1;Editing a Presentation Simultaneously with Your Colleagues;459
24.9.2;Comparing Two Copies of the Same Presentation;463
24.10;Summary;465
25;CHAPTER 17 Creating Clear and Compelling Slides;466
25.1;Planning the Slides in Your Presentation;466
25.2;Choosing Slide Layouts to Suit the Contents;467
25.2.1;Using PowerPoint’s Built-in Slide Layouts;467
25.2.2;Creating Custom Slide Layouts;468
25.3;Formatting Text on Your Slides;469
25.3.1;Changing the Font, Font Size, and Alignment;469
25.3.2;Changing the Indentation and Line Spacing of Text;470
25.3.3;Rotating Text;471
25.3.4;Using Bulleted Lists;474
25.3.4.1;Creating a Bulleted List;474
25.3.4.2;Making Sure Your Bulleted Lists Are Readable;474
25.3.4.3;Livening Up Your Slides with Custom Bullets;475
25.4;Adding Tables, SmartArt, Charts, and Hyperlinks to Slides;478
25.4.1;Adding Tables to Slides;478
25.4.1.1;Creating a Table from Scratch;479
25.4.1.2;Importing a Table from Word or OneNote;481
25.4.1.3;Creating a Table from Excel Worksheet Data;482
25.4.2;Adding SmartArt Graphics to Slides;483
25.4.3;Adding Charts to Slides;484
25.4.3.1;Creating a Chart in a New Embedded Workbook;485
25.4.3.2;Pasting a Chart from Excel into a PowerPoint Slide;487
25.4.4;Adding Hyperlinks to Slides;489
25.5;Summary;490
26;CHAPTER 18 Adding Life and Interest to a Presentation;491
26.1;Adding Pictures to a Presentation;491
26.2;Creating a Photo Album;492
26.3;Adding Movies and Sounds to a Presentation;495
26.3.1;Adding a Movie to a Slide;495
26.3.2;Adding a YouTube Video to a Slide;499
26.3.3;Adding a Sound to a Slide;500
26.4;Adding Transitions to Slides;501
26.5;Adding Animations to Slides;504
26.5.1;Understanding the Essentials of Animations;504
26.5.2;Adding an Animation to an Object;505
26.5.3;Changing the Order of Animations;506
26.5.4;Using Animation to Display Bulleted Paragraphs One at a Time;507
26.5.5;Animating SmartArt Graphics, Charts, and Tables;509
26.5.5.1;Animating a SmartArt Graphic;509
26.5.5.2;Animating a Chart;511
26.5.5.3;Animating a Table;511
26.6;Keeping Extra Information Up Your Sleeve with Hidden Slides;512
26.7;Creating Custom Slide Shows within a Presentation;512
26.7.1;Opening the Custom Shows Dialog Box;513
26.7.1.1;Creating a Custom Slide Show;513
26.7.1.2;Playing a Custom Slide Show;514
26.7.1.3;Editing or Deleting a Custom Slide Show;515
26.8;Summary;515
27;CHAPTER 19 Delivering a Presentation Live or Online;516
27.1;Getting Ready to Deliver a Presentation in Person;516
27.1.1;Setting Up Your Display and Choosing the Resolution;516
27.1.2;Using Presenter View;518
27.1.3;Practicing Your Presentation;520
27.1.4;Rehearsing Timings for Slides;520
27.2;Delivering a Presentation to a Live Audience;521
27.2.1;Starting a Presentation;521
27.2.2;Displaying the Slides You Need;521
27.2.3;Annotating the Slides;523
27.2.4;Controlling a Presentation Using the Keyboard;524
27.2.5;Displaying a White Screen or Black Screen;525
27.3;Creating a Handout for a Presentation;526
27.4;Recording Narration into a Presentation;527
27.5;Exporting and Sharing a Presentation;529
27.5.1;Broadcasting a Slide Show;530
27.5.2;Publishing Slides to a Slide Library or a SharePoint Site;533
27.6;Summary;535
28;CHAPTER 20 Making the Most of E-mail;536
28.1;Setting Up Outlook;536
28.1.1;Changing the Default Settings for an E-mail Account;539
28.2;Meeting the Outlook Interface;543
28.2.1;Using the Ribbon;544
28.2.2;Using and Customizing the Navigation Pane;545
28.2.3;Using and Customizing the Message List and Reading Pane;548
28.2.3.1;Arranging and Sorting the Message List;548
28.2.3.2;Changing the Sort Order;550
28.2.3.3;Choosing Whether to Group Items;550
28.2.3.4;Viewing Conversations;550
28.2.4;Using and Customizing the Reading Pane;552
28.2.5;Using and Customizing the To-Do Bar;554
28.2.6;Using and Customizing the People Pane;556
28.3;Sending and Receiving Messages;559
28.3.1;Sending an E-mail Message;559
28.3.1.1;Creating a New Message;559
28.3.1.2;Choosing Which Account to Send the Message From;561
28.3.1.3;Addressing the Message;561
28.3.1.4;Adding the Subject Line and Message Contents;563
28.3.1.5;Choosing Options for a Message;564
28.3.1.6;Checking the Spelling in a Message;566
28.3.1.7;Sending the Message;566
28.3.2;Receiving and Reading Messages;567
28.4;Sending and Receiving Attachments;568
28.4.1;Sending a File As an Attachment;568
28.4.2;Receiving a File as an Attachment;569
28.5;Replying to and Forwarding Messages;571
28.6;Deleting, Storing, and Organizing Messages;572
28.6.1;Moving a Message to a Mail Folder;573
28.6.2;Creating a New Mail Folder;573
28.7;Adding Consistent Closings to Your Messages with Signatures;575
28.8;Dealing with Spam;577
28.8.1;Removing Non-Spam Messages from the Junk E-mail Folder;577
28.8.2;Marking Spam Messages as Junk;578
28.9;Summary;578
29;CHAPTER 21 Keeping Your Contacts in Order;579
29.1;Creating Contacts;579
29.1.1;Creating a Contact from Scratch;579
29.1.2;Importing Contacts from Other Address Books;585
29.1.2.1;Importing Data from Windows Contacts;586
29.1.2.2;Importing Contacts from Yahoo! Address Book;587
29.1.2.3;Importing Contacts from Google Contacts;587
29.1.2.4;Importing Contacts from a CSV File;588
29.1.2.5;Importing Contacts from vCard Files;591
29.1.2.6;Importing Contacts from an Excel Worksheet;592
29.1.3;Mapping Custom Fields When Importing Contact Data;594
29.2;Working with Contacts;595
29.2.1;Viewing and Sorting Your Contacts;595
29.2.1.1;Changing the View;596
29.2.1.2;Changing the Arrangement and Grouping;599
29.2.1.3;Searching for a Contact;600
29.2.2;Editing Contact Information;600
29.2.3;Communicating with Your Contacts;601
29.3;Summary;602
30;CHAPTER 22 Managing Your Calendar;603
30.1;Meeting the Calendar Interface;603
30.1.1;Displaying the Dates You Want;605
30.1.2;Customizing the Calendar Settings;607
30.1.3;Understanding Appointments, Events and Meetings;608
30.1.4;Understanding and Using the Calendar Views;609
30.2;Creating Appointments and Events;611
30.2.1;Creating One-Shot Appointments;611
30.2.1.1;Creating a One-Shot Appointment Quickly;611
30.2.1.2;Creating a One-Shot Appointment or Event with Full Details;611
30.2.2;Creating Repeating Appointments;613
30.3;Scheduling Meetings;615
30.3.1;Setting Up a Meeting;615
30.3.2;Tracking the Status of Meeting Invitations You’ve Sent;618
30.3.3;Dealing with Invitations to Meetings;619
30.4;Summary;619
31;CHAPTER 23 Working with Tasks and Notes;620
31.1;Creating Tasks;620
31.1.1;Meeting the Tasks Interface;620
31.1.2;Viewing the Task List;622
31.1.3;Creating One-Shot Tasks;624
31.1.3.1;Creating a One-Shot Task by Working in the Task List;624
31.1.3.2;Creating a One-Shot Task Using a Task Window;624
31.1.4;Creating Recurring Tasks;627
31.1.5;Managing Your Tasks;629
31.1.5.1;Adding Details to a Task;629
31.1.5.2;Marking a Task for Follow-Up;630
31.1.5.3;Sending a Status Report on a Task;630
31.1.5.4;Marking a Finished Task as Complete;631
31.1.6;Assigning Tasks to Other People;632
31.1.7;Dealing with Tasks Other People Send to You;633
31.2;Taking Notes;633
31.2.1;Meeting the Notes Interface;633
31.2.2;Creating a Note;634
31.2.3;Viewing and Using Your Notes;635
31.3;Summary;636
32;CHAPTER 24 Taking Notes;637
32.1;Getting to Grips with the OneNote Interface;637
32.2;Working with Notebooks, Section Groups, Sections, and Pages;640
32.2.1;Working with Notebooks;640
32.2.1.1;Looking Around in the Personal Notebook;640
32.2.1.2;Deciding How to Divide Your Notes among Notebooks;640
32.2.1.3;Creating a New Notebook;640
32.2.2;Working with Sections and Section Groups;642
32.2.2.1;Creating a Section;642
32.2.2.2;Deleting a Section;642
32.2.2.3;Renaming and Reorganizing Sections;643
32.2.2.4;Creating a Section Group;643
32.2.2.5;Adding Sections to a Section Group;644
32.2.2.6;Placing One Section Group Inside Another;644
32.2.2.7;Navigating Among Sections and Section Groups;645
32.2.3;Working with Pages;646
32.2.3.1;Creating a New Blank Page;646
32.2.3.2;Creating a New Page Based on a Template;647
32.2.3.3;Creating a Page Template That Meets Your Needs;648
32.2.3.4;Renaming a Page;649
32.2.3.5;Moving or Copying a Page;649
32.2.3.6;Working with Subpages;650
32.2.3.7;Navigating from Page to Page;651
32.3;Entering Notes on a Page;651
32.3.1;Understanding Which Types of Information You Can Save in OneNote;652
32.3.2;Adding Text to a Page;652
32.3.3;Adding Graphics to Pages;654
32.3.4;Capturing Screen Clippings in Your Notebooks;654
32.3.5;Creating Drawings on Pages;654
32.3.6;Creating Tables;654
32.3.7;Printing to OneNote;655
32.3.8;Sending Outlook Items to OneNote;656
32.3.9;Sending Web Content to OneNote;656
32.3.10;Inserting a Scanner Printout;656
32.3.11;Performing Calculations;657
32.4;Using Views, Windows, and Side Notes;657
32.4.1;Using Normal View, Full Page View, and Dock to Desktop View;658
32.4.1.1;Using Full Page View to See More of Your Notes;658
32.4.1.2;Docking the OneNote Window to the Desktop;659
32.4.2;Opening Extra Windows;659
32.4.3;Working with Side Notes;659
32.5;Summary;660
33;CHAPTER 25 Organizing, Synchronizing, and Sharing Your Notes;661
33.1;Organizing Your Pages, Sections, and Notebooks;661
33.1.1;Moving Pages, Sections, and Section Groups;661
33.1.2;Merging Sections Together;662
33.1.3;Splitting a Section into Two;663
33.1.4;Merging and Splitting Notebooks;663
33.1.5;Changing the Display Name for a Notebook;663
33.2;Searching for Information;664
33.3;Protecting Your Notes with Passwords;666
33.3.1;Unlocking a Password-Protected Section;667
33.3.2;Locking Password-Protected Sections Manually;668
33.3.3;Removing Password Protection from a Section of a Notebook;668
33.4;Sharing Notebooks and Creating Shared Notebooks;669
33.4.1;Creating a New Shared Notebook;669
33.4.2;Sharing an Existing Notebook;670
33.4.3;Opening a Shared Notebook;671
33.4.4;Working in a Shared Notebook;671
33.4.5;Reviewing Changes to a Notebook;672
33.4.5.1;Viewing Changes and Marking Them as Read;673
33.4.5.2;Viewing Recent Edits;673
33.4.5.3;Reviewing Edits by Author;673
33.4.6;Choosing How to Update a Shared Notebook;674
33.4.6.1;Turning Off Synchronization for a Notebook;674
33.4.6.2;Forcing Immediate Synchronization of a Notebook;675
33.5;Using Different Versions of Pages;676
33.5.1;Viewing or Recovering an Earlier Page Version;676
33.5.2;Getting Rid of Old Page Versions to Save Space;677
33.6;Storing Notes on the Web;677
33.7;Summary;678
34;26 Making OneNote Work Your Way;679
34.1;Choosing Essential OneNote Options;679
34.1.1;Choosing Display Options;679
34.1.2;Choosing Save & Backup Options;681
34.1.3;Choosing Send to OneNote Options;683
34.1.4;Choosing Advanced Options;685
34.1.5;Choosing Audio & Video Options;688
34.2;Recording Audio and Video into Your Notebooks;691
34.2.1;Recording Audio into a Notebook;691
34.2.2;Recording Video into a Notebook;692
34.2.3;Exporting or Removing an Audio or Video File;692
34.2.4;Searching for Words in Audio and Video Recordings;692
34.3;Printing Your Notebooks;693
34.3.1;Using Print Preview;693
34.3.2;Printing a Document;695
34.4;Using OneNote with the Other Office Programs;695
34.4.1;Exporting a Page or Section to a Word Document;695
34.4.2;Exporting Data to an Excel Worksheet or a PowerPoint Presentation;697
34.4.3;Creating an Outlook Message from OneNote;697
34.4.4;Creating an Outlook Task from OneNote;697
34.4.5;Transferring a OneNote Notebook to Another PC;699
34.4.6;Retrieving Material from the Notebook Recycle Bin;700
34.5;Summary;702
35;Index;703