Learn how to...* Get super productive with Office 2013's powerful new tools* Create, edit, and read Office files on the Web and mobile devices* Craft high-impact documents with powerful visuals* Prepare and analyze data visually with Excel charts and PivotTables* Make winning presentations with PowerPoint's new tools; even add audio and video* Work with others to review and refine your documents* Use Outlook to take control of your messages, schedules, and tasks* Take notes anywhere with OneNote: never forget a great idea again!* Publish Office content straight to Facebook, Twitter, or LinkedIn* And more

IntroductionPART I: MICROSOFT OFFICE 2013Chapter 1 Getting Started with Microsoft Office 2013 2Using the Ribbon 4Exploring Backstage View 6Using the Quick Access Toolbar 8Using the Mini Toolbar 9Using Contextual Tabs 10Using Task Panes 11Chapter 2 Working with Office Applications 12Setting Up Your Account 14Opening a File 16Using the Clipboard to Cut, Copy, and Paste 18Saving a File to Your Computer 20Saving as a PDF or an XPS Document 22Sharing a File 24Printing a File 26Closing a File 28Customizing Office 30Chapter 3 Working with Text 32Using the Font Dialog Box to Format Text 34Aligning Text 35Finding and Replacing Text 36Inserting WordArt 38Formatting WordArt 39Checking Spelling 40Chapter 4 Working with Pictures 42Inserting a Picture from Your Computer 44Inserting an Online Picture from Office.com 46Enhancing a Picture 48Applying a Picture Style 50Applying a Picture Border 51Resizing a Picture 52Cropping a Picture 53Chapter 5 Working with Shapes, SmartArt, and Screenshots 54Inserting a Shape 56Formatting a Shape 58Inserting a SmartArt Graphic 60Inserting a Screenshot 62Chapter 6 Using Microsoft Office on the Web and Mobile Devices 64Getting Started with SkyDrive 66Creating a New Folder 67Managing Folders 68Uploading Files to SkyDrive 70Creating a New File in SkyDrive 72Editing a File in SkyDrive 74PART II: MICROSOFT WORD 2013Chapter 7 Creating a Document in Microsoft Word 76Starting a Blank Document 78Starting a New Document 80Selecting Text 81Creating a Document from a Template 82Creating Bullet and Number Lists 84Changing Text Color 86Applying Styles 87Adding Quick Parts 88Creating a Table 90Creating a Quick Table 91Applying a Table Style 92Inserting Rows and Columns 93Deleting Rows and Columns 94Deleting a Table 95Merging Table Cells 96Splitting Table Cells 97Chapter 8 Enhancing Word Documents 98Inserting a Cover Page 100Inserting a Blank Page 101Inserting a Page Break 102Inserting Page Numbers 103Adding Headers and Footers 104Editing Headers and Footers 106Inserting a Text Box 108Inserting a Drop Cap 110Inserting a Date 111Inserting a Symbol 112Inserting a Hyperlink 114Inserting a Bookmark 115Chapter 9 Controlling Page Layout 116Changing Page Margins 118Modifying Page Orientation 119Changing Page Size 120Creating Columns 121Applying Page Borders 122Adding Indents 124Changing Line Spacing 126Controlling Paragraph Spacing 127Setting Tabs 128Applying a Theme 130Chapter 10 Reviewing and Viewing Word Documents 132Tracking Changes with Document Reviewers 134Adding Comments 136Viewing Document Markup 138Accepting or Rejecting Changes 139Exploring Document Views 140Zooming In and Out of Documents 142PART III: MICROSOFT EXCEL 2013Chapter 11 Creating an Excel Workbook 144Creating a Workbook from a Template 146Creating a Blank Workbook 148Navigating the Worksheet Screen 149Entering Data 150Inserting a New Row 151Inserting a New Column 152Deleting Rows and Columns 153Inserting a New Worksheet 154Renaming Worksheet Tabs 155Deleting a Worksheet 156Hiding a Worksheet 157Protecting a Workbook with a Password 158Chapter 12 Formatting Worksheet Data 160Wrapping Text 162Merging and Centering Text 163Formatting Numbers 164Applying Cell Styles 165Formatting as a Table 166Adjusting Column Width 168Adjusting Row Height 169Finding Data 170Freezing Panes 171Sorting Data 172Filtering Data 174Chapter 13 Working with Cell Formulas and Functions 176Creating a Simple Formula 178Copying Formulas Using Fill 179Creating a Compound Formula 180Creating an Absolute Reference in a Formula 182Using the SUM Function 184Using the AutoSum Button 186Using the AVERAGE Function 187Chapter 14 Working with Charts, PivotTables, and Sparklines 188Inserting a Chart 190Applying a Chart Style 192Modifying a Chart 193Creating a PivotTable 194Adding a Sparkline 196PART IV: MICROSOFT POWERPOINT 2013Chapter 15 Creating and Managing PowerPoint Presentations 198Creating a New PowerPoint Presentation 200Exploring Normal View 202Adding Slides to Your Presentation 203Adding a Slide with a Bullet List 205Adding Sections to Your Presentation 206Creating a Presentation Outline 208Chapter 16 Editing and Formatting Presentations 210Applying a New Slide Layout 212Applying a New Theme 213Formatting a Slide's Background 214Organizing Your Presentation with Slide Sorter View 216Copying and Moving Slides from One Presentation to Another 218Deleting a Slide 220Using Slide Masters 221Inserting a Hyperlink to the Web 222Inserting a Hyperlink to Another Slide in Your Presentation 223Adding Headers and Footers 224Creating Handouts in Microsoft Word 225Printing Your Presentation 226Chapter 17 Working with Audio, Video, and Animation 228Inserting Online Video 230Inserting a Video Clip from Your Computer 232Formatting Video Clips 233Inserting an Audio Clip from Your Computer 234Setting Slide Transitions 236Animating Slide Objects 238Customizing Animations on the Animation Pane 240Chapter 18 Reviewing and Making Presentations 242Adding Comments 244Managing Comments 245Comparing Presentations 246Setting Up a Slide Show 248Rehearsing Timings 250Recording Voice Narrations 251Presenting Your Show 252Presenting Online 254Exploring Presenter View 256Creating Videos from PowerPoint Presentations 257PART V: MICROSOFT OUTLOOK 2013Chapter 19 Sending and Receiving Messages 258Add an Email Account 260Exploring the Outlook Layout 262Sending an Email Message 264Receiving and Reading Your Email 265Replying to a Message 266Forwarding a Message 268Attaching Files to a Message 269Creating an Email Signature 270Creating Email Rules to Manage Spam 272Chapter 20 Organizing and Scheduling in Outlook 274Viewing Your Contacts 276Emailing a Contact 277Adding a New Contact 278Viewing the Calendar 280Scheduling an Appointment 281Scheduling a Meeting 282Sharing Your Calendar 284Creating a Task 286Managing Tasks 288Creating Notes 289Subscribing to RSS Feeds 290PART VI: MICROSOFT ONENOTE 2013Chapter 21 Creating Notebooks 294Creating a New Notebook 296Adding a Page Title 297Creating a Section 298Moving a Section 299Adding Notes 300Adding Pages 301Creating Subpages 302Adding a Picture 303Applying Tags 304Inserting Links 305Applying a Template 306Change Notebook Views 307Chapter 22 Enhancing and Managing Notebooks 308Attaching Files 310Inserting Tables 311Recording Audio 312Recording Video 313Adding a Timestamp 314Emailing a Page 315Drawing in Your Notebook 316Sending a Task to Outlook 318Sending a File to OneNote 319Glossary 320Index 324