Office 2013: The Missing Manual

The Missing Credits......Page 13
Introduction......Page 15
	Part One:	Using Office......Page 27
	Chapter 1:	Using Office 2013’s Common Features......Page 29
The Start Screen......Page 30
Working with the Ribbon......Page 32
Going Backstage......Page 34
Customizing Office Applications......Page 40
	Part Two:	Word......Page 47
First Things First: Word’s Start Page......Page 49
Creating a New Document......Page 55
Saving a Document......Page 59
Opening an Existing Document......Page 63
Different Ways to View Your Work......Page 66
Selecting and Moving Text......Page 75
Finding and Replacing Text......Page 81
Text Formatting: Font, Size, and Style......Page 88
Paragraph Formatting: Aligning, Indenting, Spacing......Page 96
Working with Lists......Page 102
Formatting a Document......Page 109
Creating a Table......Page 127
Adding Information to a Table......Page 132
Editing a Table......Page 133
Formatting a Table......Page 137
Inserting Images......Page 143
Editing an Image......Page 148
Fun with Fonts and Art That’s Smart......Page 160
Adding Charts and Diagrams......Page 165
Checking Spelling and Grammar......Page 169
Getting Things Right with AutoCorrect......Page 176
Word’s Built-in Research Tools......Page 183
Getting Started with Printing......Page 189
Selecting Print Options and Settings......Page 191
Sending a Fax......Page 193
Printing Envelopes......Page 197
Printing Labels......Page 201
Merging Names and Addresses with Documents......Page 203
Inserting Page Breaks......Page 209
Breaking a Document into Sections......Page 210
Footnotes and Endnotes......Page 213
Citations and Bibliographies......Page 217
Helping Readers Navigate Your Document......Page 224
Themes: The Way to Better Designs......Page 235
Templates: Reusable Document Blueprints......Page 239
Saving Time with Macros......Page 248
	Chapter 9:	Desktop and Web Publishing......Page 255
Newsletters and Brochures......Page 256
Web Page Design......Page 262
Sharing a Document......Page 273
Getting Feedback......Page 279
Comparing Documents......Page 290
Protecting Your Documents......Page 292
Coauthoring and Simultaneous Editing......Page 301
	Part Three:	Outlook......Page 303
Setting Up Outlook......Page 305
Taking a Quick Look Around......Page 307
Composing and Sending Email......Page 311
Receiving Email......Page 327
Printing a Message......Page 336
Fighting Spam......Page 337
Saving Time with Quick Steps......Page 340
Managing Multiple Email Accounts......Page 343
Adding and Editing Contacts......Page 345
Finding a Contact......Page 357
Viewing Contacts......Page 358
Communicating with a Contact......Page 365
Gathering Contacts into a Group......Page 366
Printing Your Contacts......Page 371
Contacts and Social Networking......Page 372
Finding Folders in the Navigation Pane......Page 375
Creating a New Folder......Page 376
Filling Up and Managing Folders......Page 378
Categorizing Items......Page 379
Searching Folders......Page 382
Cleaning Out Folders......Page 390
	Chapter 14:	Getting Organized with Outlook’s Calendar, Tasks, and Notes......Page 397
Your Schedule, Your Calendar......Page 398
Creating an Appointment or Meeting......Page 399
Editing Events......Page 404
Viewing Your Schedule......Page 407
Tasks......Page 408
Adding a Task......Page 409
Managing Tasks......Page 412
Viewing Tasks......Page 416
Taking Notes in Outlook......Page 417
	Part Four:	Excel......Page 423
Starting a Workbook......Page 425
Adding Information to a Worksheet......Page 426
Using the Ribbon......Page 434
Using the Status Bar......Page 440
Saving Files......Page 443
Opening Files......Page 456
Adding Different Types of Data......Page 460
Printing......Page 468
Controlling Pagination......Page 480
Selecting Cells......Page 485
Moving Cells Around......Page 492
Adding and Moving Columns or Rows......Page 503
Worksheets and Workbooks......Page 506
	Chapter 17:	Formatting Cells......Page 515
Formatting Cell Values......Page 516
Formatting Cell Appearance......Page 528
Creating a Basic Formula......Page 541
Functions......Page 547
Formula Errors......Page 554
Logical Operators......Page 558
Formula Shortcuts......Page 560
Copying Formulas......Page 568
Rounding Numbers......Page 575
Manipulating Text......Page 577
Solving Formula Errors......Page 580
	Chapter 20:	Creating Basic Charts......Page 589
Charting 101......Page 590
Basic Tasks with Charts......Page 597
Practical Charting......Page 604
Chart Types......Page 614
Chart Styles and Layouts......Page 620
Adding Chart Elements......Page 625
	Part Five:	PowerPoint......Page 637
Creating a New Presentation......Page 639
Saving a Presentation......Page 650
Opening an Existing Presentation......Page 652
Viewing a Presentation......Page 653
Printing a Presentation......Page 660
Editing Text......Page 663
Embedding Other Files in Slides......Page 672
Adding Tables to Slides......Page 674
Adding Images to Slides......Page 680
Arranging Objects on a Slide......Page 693
Copying, Rearranging, and Deleting Slides......Page 699
Headers and Footers......Page 704
Organizing Your Presentation with Sections......Page 707
Navigating with Links and Action Buttons......Page 710
Slide Masters: Powerful Slide Blueprints......Page 717
Collaborating with Others......Page 724
Putting Media Clips in a Presentation......Page 729
Animating Objects......Page 745
Creating Transitions Between Slides......Page 760
Start, Navigate, End: Tips and Shortcuts......Page 763
Before the Show: Prep Work......Page 767
At the Event......Page 777
Other Presentation Options......Page 784
Sharing Your Presentation......Page 792
	Part Six:	Access......Page 795
	Chapter 26:	Creating Your First Database......Page 797
Understanding Access Databases......Page 798
Starting a Database......Page 799
Building Your First Table......Page 804
Saving Databases......Page 814
Opening Databases......Page 819
The Navigation Pane......Page 823
Understanding Data Types......Page 829
Design View......Page 830
Access Data Types......Page 835
The Primary Key......Page 861
Six Principles of Database Design......Page 863
Data Integrity Basics......Page 869
Lookups......Page 877
 Chapter 28: Mastering the Datasheet: Sorting, Searching, and Filtering......Page 883
Datasheet Customization......Page 884
Datasheet Navigation......Page 890
Printing the Datasheet......Page 901
	Chapter 29:	Linking Tables with Relationships......Page 905
Relationship Basics......Page 906
Using a Relationship......Page 910
More Exotic Relationships......Page 927
	Part Seven:	Other Office Tools......Page 933
Creating a New Publication......Page 935
Adding Text......Page 944
Adding Pictures, Shapes, and Other Objects......Page 953
Designing and Laying Out Pages......Page 956
Reviewing Your Design......Page 961
Printing a Publication......Page 963
	Chapter 31:	OneNote......Page 965
What Is OneNote?......Page 966
Creating and Filling Up a Notebook......Page 968
Organizing a Notebook......Page 975
Managing Individual Notes......Page 979
Viewing Your Notebooks......Page 986
Sharing Notes......Page 987
Using OneNote with Other Office Programs......Page 990
	Chapter 32:	SkyDrive and Office Web Apps......Page 995
Introducing Office on the Web......Page 996
Setting Up Office Web Apps......Page 997
What’s New in Office Web Apps......Page 999
Creating and Editing Files......Page 1001
Working with Folders in SkyDrive......Page 1003
Managing Files in SkyDrive......Page 1007
Sharing Files and Folders......Page 1011
Docs.com: Office Web Apps for Facebook......Page 1017
Index......Page 1023