Office 2013 Bible

Lisa A. Bucki has been teaching and writing about Microsoft Office, computers, and software for more than 18 years. She coauthored Wiley's Office 2010 Bible . John Walkenbach (aka "Mr. Spreadsheet") is a bestselling Excel author and creator of The Spreadsheet Page at www.spreadsheetpage.com. Faithe Wempen , M.A., is an A+ certified hardware guru, Microsoft Office Specialist Master Instructor, and software consultant with over 120 computer books to her credit. Michael Alexander is a Microsoft Certified Application Developer (MCAD), Microsoft MVP, and author of eight books on advanced business analysis with Access and Excel. Dick Kusleika has been helping users get the most out of Microsoft Office products for more than 15 years through online forums, blogging, books, and conferences.

Introduction XXI Part I: Common Office Features 1 Chapter 1: Welcome to Microsoft Office 2013 3 Chapter 2: Navigating in Office 27 Part II: Creating Documents with Word 2013 101 Chapter 4: Diving Into Document Creation 103 Chapter 5: Font/Character Formatting 139 Chapter 6: Paragraph Formatting 165 Chapter 7: Using Styles to Create a Great Looking Document 191 Chapter 8: Controlling Document Appearance with Sections and More 215 Chapter 9: Adding Tables and Graphics to a Document 259 Chapter 10: Data Documents and Mail Merge 327 Chapter 11: Managing Document Security, Comments, and Tracked Changes 367 Part III: Making the Numbers Work with Excel 2013 399 Chapter 12: Using Excel Worksheets and Workbooks 401 Chapter 13: Entering and Editing Worksheet Data 419 Chapter 14: Essential Worksheet and Cell Range Operations 443 Chapter 15: Introducing Formulas and Functions 491 Chapter 16: Working with Dates and Times 521 Chapter 17: Creating Formulas That Count and Sum 555 Chapter 18: Getting Started Making Charts 583 Chapter 19: Communicating Data Visually 603 Part IV: Persuading and Informing with PowerPoint 2013 645 Chapter 20: A First Look at PowerPoint 2013 647 Chapter 21: Creating a Presentation, Slides, and Text 671 Chapter 22: Working with Layouts, Themes, and Masters 725 Chapter 23: Working with Tables and Charts 767 Chapter 24: Using SmartArt Diagrams, Clip Art, and Pictures 829 Chapter 25: Building Animation Effects, Transitions, and Support Materials 889 Chapter 26: Delivering a Live Presentation 923 Part V: Organizing Messages, Contacts, and Time with Outlook 957 Chapter 27: Fundamentals of E-mail 959 Chapter 28: Processing and Securing E-mail 1011 Chapter 29: Working with Contacts 1045 Chapter 30: Working with Appointments and Tasks 1073 Part VI: Designing Publications with Publisher 1111 Chapter 31: Introducing Publisher 1113 Chapter 32: Designing Dazzling Publications with Publisher 1141 Part VII: Managing Information with Access and OneNote 1163 Chapter 33: An Introduction to Database Development 1165 Chapter 34: Creating Access Tables 1181 Chapter 35: Creating and Entering Data with Basic Access Forms 1231 Chapter 36: Selecting Data with Queries 1281 Chapter 37: Presenting Data with Access Reports 1313 Chapter 38: Keeping Information at Hand with OneNote 1337 Part VIII: Sharing and Collaborating in the Cloud and Applications 1361 Chapter 39: Collaborating in the Cloud with SkyDrive 1363 Chapter 40: Integrating Office Application Information 1381 Appendix A: Customizing Office 1405 Appendix B: Optimizing Your Office Installation 1419 Index 1433