{"product_id":"office-2019-all-in-one-for-dummies-isbn-9781119513278","title":"Office 2019 All-in-One For Dummies","description":"\u003cp\u003e\u003cb\u003eOne practical book that's ten books in one: Learn everything you need to know about Microsoft Office with one comprehensive guide on your bookshelf\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTo know your way around all the applications within Microsoft Office would require you to be part mathematician, part storyteller, and part graphic designer--with some scheduling wizard and database architect sprinkled in. If these talents don't come naturally to you in equal measure, don't panic--\u003ci\u003eOffice 2019 All-in-One For Dummies\u003c\/i\u003e can help.\u003c\/p\u003e \u003cp\u003eThis hefty but easily accessible tome opens with Book 1, an overview of the Office suite of applications and tips for handling text and becoming more efficient. From there, you'll find a book on each of the suite's major applications:\u003c\/p\u003e \u003cul\u003e \u003cli\u003e\n\u003cb\u003eWord:\u003c\/b\u003e Learn the basics of word processing with Word, plus lay out text and pages; use Word's styles and proofing tools; construct tables, reports, and scholarly papers; and become familiar with manipulating documents.\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003eExcel:\u003c\/b\u003e In addition to refining your worksheets so they're easier to understand, you can also master formulas, functions, and data analysis.\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003ePowerPoint:\u003c\/b\u003e Find out how to make your presentations come alive with text, graphics, backgrounds, audio, and video. This book also contains a chapter with guidance and tips for delivering presentations--in person or virtually.\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003eOutlook:\u003c\/b\u003e From helping you to manage your contacts, inbox, calendar, and tasks, Outlook can organize your days and keep you working productively.\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003eAccess:\u003c\/b\u003e Not everyone needs to build and maintain databases, but if that's part of your job, this book has all the hands-on information you need to get going: Build a database table, enter data, sort and query data, and filter data into report format.\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003ePublisher:\u003c\/b\u003e The Publisher book is a quick-and-dirty introduction into desktop publishing, helping you to design a publication using built-in color schemes, templates, fonts, and finishing touches like borders and backgrounds.\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eThe last three books cover material that applies to all the applications. Book 8 shows you how to create charts, handle graphics and photos, and draw lines and shapes. Book 9 provides a quick primer on customizing the Ribbon, the Quick Access toolbar, and the Status bar, and guidance on distributing your work (via printing, emailing, converting to PDF, and more). Finally, Book 10 wraps up with how to use OneDrive, especially for file sharing and online collaboration.\u003c\/p\u003e \u003cp\u003eIf you need to make sense of Office and don't have time to waste, \u003ci\u003eOffice 2019 All-in-One For Dummies\u003c\/i\u003e is the reference you'll want to keep close by!\u003c\/p\u003e \u003cp\u003e\u003cb\u003eIntroduction \u003c\/b\u003e\u003cb\u003e1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Makes This Book Different 2\u003c\/p\u003e \u003cp\u003eFoolish Assumptions 3\u003c\/p\u003e \u003cp\u003eConventions Used in This Book 3\u003c\/p\u003e \u003cp\u003eIcons Used in This Book 4\u003c\/p\u003e \u003cp\u003eBeyond the Book 4\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 1: Common Office Tasks \u003c\/b\u003e\u003cb\u003e5\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Office Nuts and Bolts\u003c\/b\u003e\u003cb\u003e 7\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA Survey of Office Applications 7\u003c\/p\u003e \u003cp\u003eAll about Office 365 9\u003c\/p\u003e \u003cp\u003eFinding Your Way Around the Office Interface 11\u003c\/p\u003e \u003cp\u003eSaving Your Files 18\u003c\/p\u003e \u003cp\u003eNavigating the Save As and Open Windows 19\u003c\/p\u003e \u003cp\u003eOpening and Closing Files 21\u003c\/p\u003e \u003cp\u003eReading and Recording File Properties 22\u003c\/p\u003e \u003cp\u003eLocking a File with a Password 23\u003c\/p\u003e \u003cp\u003eTrusting (or not Trusting) Microsoft with Your “Content” 24\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Wrestling with the Text\u003c\/b\u003e\u003cb\u003e 27\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eManipulating the Text 27\u003c\/p\u003e \u003cp\u003eSpeaking, not Typing, the Words 30\u003c\/p\u003e \u003cp\u003eChanging the Look of Text 32\u003c\/p\u003e \u003cp\u003eQuick Ways to Handle Case, or Capitalization 39\u003c\/p\u003e \u003cp\u003eEntering Symbols and Foreign Characters 41\u003c\/p\u003e \u003cp\u003eCreating Hyperlinks 42\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Speed Techniques Worth Knowing About\u003c\/b\u003e\u003cb\u003e 47\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUndoing and Repeating Commands 47\u003c\/p\u003e \u003cp\u003eZooming In, Zooming Out 49\u003c\/p\u003e \u003cp\u003eViewing a File Through More Than One Window 50\u003c\/p\u003e \u003cp\u003eCorrecting Typos on the Fly 51\u003c\/p\u003e \u003cp\u003eEntering Text Quickly with the AutoCorrect Command 52\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 2: Word 2019\u003c\/b\u003e\u003cb\u003e 55\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Speed Techniques for Using Word\u003c\/b\u003e\u003cb\u003e 57\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing the Word Screen 57\u003c\/p\u003e \u003cp\u003eCreating a New Document 59\u003c\/p\u003e \u003cp\u003eGetting a Better Look at Your Documents 61\u003c\/p\u003e \u003cp\u003eSelecting Text in Speedy Ways 66\u003c\/p\u003e \u003cp\u003eMoving Around Quickly in Documents 67\u003c\/p\u003e \u003cp\u003eInserting a Whole File into a Document 71\u003c\/p\u003e \u003cp\u003eGetting Word to Read It 72\u003c\/p\u003e \u003cp\u003eEntering Information Quickly in a Computerized Form 72\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Laying Out Text and Pages\u003c\/b\u003e\u003cb\u003e 77\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eParagraphs and Formatting 77\u003c\/p\u003e \u003cp\u003eInserting a Section Break for Formatting Purposes 78\u003c\/p\u003e \u003cp\u003eBreaking a Line 81\u003c\/p\u003e \u003cp\u003eStarting a New Page 81\u003c\/p\u003e \u003cp\u003eSetting Up and Changing the Margins 82\u003c\/p\u003e \u003cp\u003eIndenting Paragraphs and First Lines 84\u003c\/p\u003e \u003cp\u003eNumbering the Pages 86\u003c\/p\u003e \u003cp\u003ePutting Headers and Footers on Pages 89\u003c\/p\u003e \u003cp\u003eAdjusting the Space Between Lines 93\u003c\/p\u003e \u003cp\u003eAdjusting the Space Between Paragraphs 95\u003c\/p\u003e \u003cp\u003eCreating Numbered and Bulleted Lists 96\u003c\/p\u003e \u003cp\u003eWorking with Tabs 99\u003c\/p\u003e \u003cp\u003eHyphenating Text 101\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Word Styles\u003c\/b\u003e\u003cb\u003e 105\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAll About Styles 105\u003c\/p\u003e \u003cp\u003eApplying Styles to Text and Paragraphs 107\u003c\/p\u003e \u003cp\u003eCreating a New Style 112\u003c\/p\u003e \u003cp\u003eModifying a Style 114\u003c\/p\u003e \u003cp\u003eCreating and Managing Templates 116\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Constructing the Perfect Table\u003c\/b\u003e\u003cb\u003e 123\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTalking Table Jargon 124\u003c\/p\u003e \u003cp\u003eCreating a Table 124\u003c\/p\u003e \u003cp\u003eEntering the Text and Numbers 127\u003c\/p\u003e \u003cp\u003eSelecting Different Parts of a Table 128\u003c\/p\u003e \u003cp\u003eLaying Out Your Table 128\u003c\/p\u003e \u003cp\u003eAligning Text in Columns and Rows 133\u003c\/p\u003e \u003cp\u003eMerging and Splitting Cells 134\u003c\/p\u003e \u003cp\u003eRepeating Header Rows on Subsequent Pages 135\u003c\/p\u003e \u003cp\u003eFormatting Your Table 137\u003c\/p\u003e \u003cp\u003eUsing Math Formulas in Tables 140\u003c\/p\u003e \u003cp\u003eNeat Table Tricks 141\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Taking Advantage of the Proofing Tools\u003c\/b\u003e\u003cb\u003e 147\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCorrecting Your Spelling Errors 148\u003c\/p\u003e \u003cp\u003eCorrecting Grammatical Errors 151\u003c\/p\u003e \u003cp\u003eFinding and Replacing Text 153\u003c\/p\u003e \u003cp\u003eFinding the Right Word with the Thesaurus 161\u003c\/p\u003e \u003cp\u003eProofing Text Written in a Foreign Language 162\u003c\/p\u003e \u003cp\u003eTranslating Foreign Language Text 164\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Desktop Publishing with Word\u003c\/b\u003e\u003cb\u003e 167\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExperimenting with Themes 167\u003c\/p\u003e \u003cp\u003eSprucing Up Your Pages 168\u003c\/p\u003e \u003cp\u003eMaking Use of Charts, Diagrams, Shapes, and Photos 171\u003c\/p\u003e \u003cp\u003eWorking with the Drawing Canvas 172\u003c\/p\u003e \u003cp\u003ePositioning and Wrapping Objects Relative to the Page and Text 173\u003c\/p\u003e \u003cp\u003eWorking with Text Boxes 177\u003c\/p\u003e \u003cp\u003eDropping In a Drop Cap 179\u003c\/p\u003e \u003cp\u003eWatermarking for the Elegant Effect 180\u003c\/p\u003e \u003cp\u003ePutting Newspaper-Style Columns in a Document 181\u003c\/p\u003e \u003cp\u003eLandscape Documents 183\u003c\/p\u003e \u003cp\u003ePrinting on Different Size Paper 184\u003c\/p\u003e \u003cp\u003eShowing Online Video in a Document 184\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7: Getting Word’s Help with Office Chores\u003c\/b\u003e\u003cb\u003e 187\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHighlighting Parts of a Document 187\u003c\/p\u003e \u003cp\u003eCommenting on a Document 188\u003c\/p\u003e \u003cp\u003eTracking Changes to Documents 192\u003c\/p\u003e \u003cp\u003ePrinting an Address on an Envelope 197\u003c\/p\u003e \u003cp\u003ePrinting a Single Address Label (Or a Page of the Same Label) 199\u003c\/p\u003e \u003cp\u003eChurning Out Letters, Envelopes, and Labels for Mass Mailings 200\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8: Tools for Reports and Scholarly Papers\u003c\/b\u003e\u003cb\u003e 209\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAlphabetizing a List 209\u003c\/p\u003e \u003cp\u003eOutlines for Organizing Your Work 210\u003c\/p\u003e \u003cp\u003eCollapsing and Expanding Parts of a Document 212\u003c\/p\u003e \u003cp\u003eGenerating a Table of Contents 213\u003c\/p\u003e \u003cp\u003eIndexing a Document 218\u003c\/p\u003e \u003cp\u003ePutting Cross-References in a Document 222\u003c\/p\u003e \u003cp\u003ePutting Footnotes and Endnotes in Documents 225\u003c\/p\u003e \u003cp\u003eCompiling a Bibliography 227\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 3: Excel 2019\u003c\/b\u003e\u003cb\u003e 233\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Up and Running with Excel\u003c\/b\u003e\u003cb\u003e 235\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating a New Excel Workbook 235\u003c\/p\u003e \u003cp\u003eGetting Acquainted with Excel 237\u003c\/p\u003e \u003cp\u003eEntering Data in a Worksheet 239\u003c\/p\u003e \u003cp\u003eQuickly Entering Lists and Serial Data with the\u003c\/p\u003e \u003cp\u003eAutoFill Command 245\u003c\/p\u003e \u003cp\u003eFormatting Numbers, Dates, and Time Values 248\u003c\/p\u003e \u003cp\u003eEstablishing Data-Validation Rules 249\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Refining Your Worksheet\u003c\/b\u003e\u003cb\u003e 253\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEditing Worksheet Data 253\u003c\/p\u003e \u003cp\u003eMoving Around in a Worksheet 254\u003c\/p\u003e \u003cp\u003eGetting a Better Look at the Worksheet 255\u003c\/p\u003e \u003cp\u003eComments for Documenting Your Worksheet 258\u003c\/p\u003e \u003cp\u003eSelecting Cells in a Worksheet 260\u003c\/p\u003e \u003cp\u003eDeleting, Copying, and Moving Data 261\u003c\/p\u003e \u003cp\u003eHandling the Worksheets in a Workbook 261\u003c\/p\u003e \u003cp\u003eKeeping Others from Tampering with Worksheets 264\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Formulas and Functions for Crunching Numbers\u003c\/b\u003e\u003cb\u003e 267\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHow Formulas Work 267\u003c\/p\u003e \u003cp\u003eThe Basics of Entering a Formula 273\u003c\/p\u003e \u003cp\u003eSpeed Techniques for Entering Formulas 273\u003c\/p\u003e \u003cp\u003eCopying Formulas from Cell to Cell 279\u003c\/p\u003e \u003cp\u003eDetecting and Correcting Errors in Formulas 281\u003c\/p\u003e \u003cp\u003eWorking with Functions 284\u003c\/p\u003e \u003cp\u003eA Look at Some Very Useful Functions 289\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Making a Worksheet Easier to Read and Understand\u003c\/b\u003e\u003cb\u003e 299\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLaying Out a Worksheet 299\u003c\/p\u003e \u003cp\u003eDecorating a Worksheet with Borders and Colors 305\u003c\/p\u003e \u003cp\u003eGetting Ready to Print a Worksheet 310\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Advanced Techniques for Analyzing Data\u003c\/b\u003e\u003cb\u003e 317\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSeeing What the Sparklines Say 317\u003c\/p\u003e \u003cp\u003eConditional Formats for Calling Attention to Data 319\u003c\/p\u003e \u003cp\u003eManaging Information in Lists 320\u003c\/p\u003e \u003cp\u003eForecasting with the Goal Seek Command 323\u003c\/p\u003e \u003cp\u003ePerforming What-If Analyses with Data Tables 325\u003c\/p\u003e \u003cp\u003eAnalyzing Data with PivotTables 329\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 4: Powerpoint 2019\u003c\/b\u003e\u003cb\u003e 335\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Getting Started in PowerPoint\u003c\/b\u003e\u003cb\u003e 337\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGetting Acquainted with PowerPoint 338\u003c\/p\u003e \u003cp\u003eA Brief Geography Lesson 339\u003c\/p\u003e \u003cp\u003eA Whirlwind Tour of PowerPoint 340\u003c\/p\u003e \u003cp\u003eCreating a New Presentation 341\u003c\/p\u003e \u003cp\u003eAdvice for Building Persuasive Presentations 344\u003c\/p\u003e \u003cp\u003eCreating New Slides for Your Presentation 346\u003c\/p\u003e \u003cp\u003eGetting a Better View of Your Work 350\u003c\/p\u003e \u003cp\u003eHiding and Displaying the Slides Pane and Notes Pane 352\u003c\/p\u003e \u003cp\u003eSelecting, Moving, and Deleting Slides 352\u003c\/p\u003e \u003cp\u003ePutting Together a Photo Album 354\u003c\/p\u003e \u003cp\u003eHidden Slides for All Contingencies 357\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Fashioning a Look for Your Presentation\u003c\/b\u003e\u003cb\u003e 359\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLooking at Themes and Slide Backgrounds 360\u003c\/p\u003e \u003cp\u003eChoosing a Theme for Your Presentation 361\u003c\/p\u003e \u003cp\u003eCreating Slide Backgrounds on Your Own 362\u003c\/p\u003e \u003cp\u003eChanging the Background of a Single or Handful of Slides 368\u003c\/p\u003e \u003cp\u003eChoosing the Slide Size 369\u003c\/p\u003e \u003cp\u003eUsing Master Slides and Master Styles for a Consistent Design 370\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Entering the Text\u003c\/b\u003e\u003cb\u003e 373\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEntering Text 373\u003c\/p\u003e \u003cp\u003eFun with Text Boxes and Text Box Shapes 377\u003c\/p\u003e \u003cp\u003eControlling How Text Fits in Text Frames and Text Boxes 379\u003c\/p\u003e \u003cp\u003ePositioning Text in Frames and Text Boxes 382\u003c\/p\u003e \u003cp\u003eHandling Bulleted and Numbered Lists 382\u003c\/p\u003e \u003cp\u003ePutting Footers (and Headers) on Slides 385\u003c\/p\u003e \u003cp\u003eSome background on footers and headers 386\u003c\/p\u003e \u003cp\u003ePutting a standard footer on all your slides 386\u003c\/p\u003e \u003cp\u003eCreating a nonstandard footer 387\u003c\/p\u003e \u003cp\u003eRemoving a footer from a single slide 388\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Making Your Presentations Livelier\u003c\/b\u003e\u003cb\u003e 389\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSuggestions for Enlivening Your Presentation 389\u003c\/p\u003e \u003cp\u003ePresenting Information in a Table 390\u003c\/p\u003e \u003cp\u003eExploring Transitions and Animations 393\u003c\/p\u003e \u003cp\u003eMaking Audio Part of Your Presentation 396\u003c\/p\u003e \u003cp\u003ePlaying Video on Slides 399\u003c\/p\u003e \u003cp\u003eRecording a Voice Narration for Slides 403\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Delivering a Presentation\u003c\/b\u003e\u003cb\u003e 405\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAll about Notes 405\u003c\/p\u003e \u003cp\u003eRehearsing and Timing Your Presentation 406\u003c\/p\u003e \u003cp\u003eShowing Your Presentation 408\u003c\/p\u003e \u003cp\u003eTricks for Making Presentations a Little Livelier 411\u003c\/p\u003e \u003cp\u003eDelivering a Presentation When You Can’t Be There in Person 414\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 5: Outlook 2019\u003c\/b\u003e\u003cb\u003e 425\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Outlook Basics\u003c\/b\u003e\u003cb\u003e 427\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is Outlook, Anyway? 427\u003c\/p\u003e \u003cp\u003eNavigating the Outlook Folders 429\u003c\/p\u003e \u003cp\u003eCategorizing Items 430\u003c\/p\u003e \u003cp\u003eSearching for Stray Folder Items 432\u003c\/p\u003e \u003cp\u003eDeleting Email Messages, Contacts, Tasks, and Other Items 435\u003c\/p\u003e \u003cp\u003eCleaning Out Your Folders 436\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Maintaining the Contacts Folder\u003c\/b\u003e\u003cb\u003e 441\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMaintaining a Happy and Healthy Contacts Folder 442\u003c\/p\u003e \u003cp\u003eContact Groups for Sending Messages to Groups 445\u003c\/p\u003e \u003cp\u003eFinding a Contact in the Contacts Folder 447\u003c\/p\u003e \u003cp\u003ePrinting the Contacts Folder 448\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Handling Your Email\u003c\/b\u003e\u003cb\u003e 451\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSetting Up an Email Account 451\u003c\/p\u003e \u003cp\u003eAddressing and Sending Email Messages 452\u003c\/p\u003e \u003cp\u003eSending Files and Photos 458\u003c\/p\u003e \u003cp\u003eReceiving Email Messages 460\u003c\/p\u003e \u003cp\u003eReading Your Email in the Inbox Window 461\u003c\/p\u003e \u003cp\u003eHandling Files That Were Sent to You 463\u003c\/p\u003e \u003cp\u003eTechniques for Organizing Email Messages 464\u003c\/p\u003e \u003cp\u003eAll about Email Folders 468\u003c\/p\u003e \u003cp\u003eYes, You Can Prevent Junk Mail (Sort of) 470\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Managing Your Time and Schedule \u003c\/b\u003e\u003cb\u003e473\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing the Calendar 473\u003c\/p\u003e \u003cp\u003eThe Different Kinds of Activities 474\u003c\/p\u003e \u003cp\u003eSeeing Your Schedule 475\u003c\/p\u003e \u003cp\u003eScheduling Appointments and Events 477\u003c\/p\u003e \u003cp\u003eScheduling an activity: The basics 477\u003c\/p\u003e \u003cp\u003eScheduling a recurring appointment or event 478\u003c\/p\u003e \u003cp\u003eScheduling an event 479\u003c\/p\u003e \u003cp\u003eCanceling, Rescheduling, and Altering Activities 480\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Tasks, Reminders, and Notes\u003c\/b\u003e\u003cb\u003e 481\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTasks: Seeing What Needs to Get Done 481\u003c\/p\u003e \u003cp\u003eReminders for Being Alerted to Activities and Tasks 484\u003c\/p\u003e \u003cp\u003eMaking Notes to Yourself 487\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 6: Access 2019 \u003c\/b\u003e\u003cb\u003e489\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Introducing Access\u003c\/b\u003e\u003cb\u003e 491\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is a Database, Anyway? 492\u003c\/p\u003e \u003cp\u003eTables, Queries, Forms, and Other Objects 492\u003c\/p\u003e \u003cp\u003eCreating a Database File 497\u003c\/p\u003e \u003cp\u003eFinding Your Way Around the Navigation Pane 499\u003c\/p\u003e \u003cp\u003eDesigning a Database 501\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Building Your Database Tables\u003c\/b\u003e\u003cb\u003e 507\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating a Database Table 507\u003c\/p\u003e \u003cp\u003eOpening and Viewing Tables 511\u003c\/p\u003e \u003cp\u003eEntering and Altering Table Fields 512\u003c\/p\u003e \u003cp\u003eField Properties for Making Sure That Data Entries Are Accurate 518\u003c\/p\u003e \u003cp\u003eIndexing for Faster Sorts, Searches, and Queries 526\u003c\/p\u003e \u003cp\u003eEstablishing Relationships Among Database Tables 528\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Entering the Data\u003c\/b\u003e\u003cb\u003e 535\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Two Ways to Enter Data 535\u003c\/p\u003e \u003cp\u003eEntering the Data in Datasheet View 536\u003c\/p\u003e \u003cp\u003eEntering the Data in a Form 540\u003c\/p\u003e \u003cp\u003eFinding a Missing Record 542\u003c\/p\u003e \u003cp\u003eFinding and Replacing Data 543\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Sorting, Querying, and Filtering for Data\u003c\/b\u003e\u003cb\u003e 545\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSorting Records in a Database Table 545\u003c\/p\u003e \u003cp\u003eFiltering to Find Information 546\u003c\/p\u003e \u003cp\u003eQuerying: The Basics 552\u003c\/p\u003e \u003cp\u003eSix Kinds of Queries 560\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Presenting Data in a Report\u003c\/b\u003e\u003cb\u003e 567\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating a Report 567\u003c\/p\u003e \u003cp\u003eOpening and Viewing Reports 569\u003c\/p\u003e \u003cp\u003eTweaking a Report 569\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 7: Publisher 2019\u003c\/b\u003e\u003cb\u003e 573\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Introducing Publisher\u003c\/b\u003e\u003cb\u003e 575\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e“A Print Shop in a Can” 575\u003c\/p\u003e \u003cp\u003eIntroducing Frames 576\u003c\/p\u003e \u003cp\u003eCreating a Publication 577\u003c\/p\u003e \u003cp\u003eRedesigning a Publication 578\u003c\/p\u003e \u003cp\u003eGetting a Better View of Your Work 580\u003c\/p\u003e \u003cp\u003eUnderstanding and Using the Layout Guides 582\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Refining a Publication\u003c\/b\u003e\u003cb\u003e 587\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEntering Text on the Pages 587\u003c\/p\u003e \u003cp\u003eMaking Text Fit in Text Frames 588\u003c\/p\u003e \u003cp\u003eFormatting Text 592\u003c\/p\u003e \u003cp\u003eMaking Text Wrap around a Frame or Graphic 592\u003c\/p\u003e \u003cp\u003eReplacing the Placeholder Pictures 593\u003c\/p\u003e \u003cp\u003eInserting Frames on the Pages 594\u003c\/p\u003e \u003cp\u003eMaking Frames Overlap 596\u003c\/p\u003e \u003cp\u003eInserting, Removing, and Moving Pages 596\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Putting on the Finishing Touches\u003c\/b\u003e\u003cb\u003e 599\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDecorating the Text 600\u003c\/p\u003e \u003cp\u003eTechniques for Decorating Pages 602\u003c\/p\u003e \u003cp\u003eMaster Pages for Handling Page Backgrounds 606\u003c\/p\u003e \u003cp\u003eRunning the Design Checker 608\u003c\/p\u003e \u003cp\u003eCommercially Printing a Publication 609\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 8: Working with Charts and Graphics\u003c\/b\u003e\u003cb\u003e 611\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Creating a Chart\u003c\/b\u003e\u003cb\u003e 613\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Basics: Creating a Chart 613\u003c\/p\u003e \u003cp\u003eChoosing the Right Chart 615\u003c\/p\u003e \u003cp\u003eProviding the Raw Data for Your Chart 617\u003c\/p\u003e \u003cp\u003ePositioning Your Chart in a Workbook, Page, or Slide 619\u003c\/p\u003e \u003cp\u003eHandling the gridlines 624\u003c\/p\u003e \u003cp\u003eChanging a chart element’s color, font, or other particular 624\u003c\/p\u003e \u003cp\u003eSaving a Chart as a Template So That You Can Use It Again 626\u003c\/p\u003e \u003cp\u003eChart Tricks for the Daring and Heroic 627\u003c\/p\u003e \u003cp\u003eTroubleshooting a Chart 630\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Making a SmartArt Diagram\u003c\/b\u003e\u003cb\u003e 633\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Basics: Creating SmartArt Diagrams 633\u003c\/p\u003e \u003cp\u003eCreating the Initial Diagram 636\u003c\/p\u003e \u003cp\u003eChanging the Size and Position of a Diagram 638\u003c\/p\u003e \u003cp\u003eLaying Out the Diagram Shapes 638\u003c\/p\u003e \u003cp\u003eHandling the Text on Diagram Shapes 644\u003c\/p\u003e \u003cp\u003eChanging a Diagram’s Direction 647\u003c\/p\u003e \u003cp\u003eChoosing a Look for Your Diagram 647\u003c\/p\u003e \u003cp\u003eChanging the Appearance of Diagram Shapes 648\u003c\/p\u003e \u003cp\u003eCreating a Diagram from Scratch 651\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Handling Graphics and Photos\u003c\/b\u003e\u003cb\u003e 653\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAll about Picture File Formats 653\u003c\/p\u003e \u003cp\u003eInserting a Picture in an Office File 657\u003c\/p\u003e \u003cp\u003eTouching Up a Picture 660\u003c\/p\u003e \u003cp\u003eCompressing Pictures to Save Disk Space 668\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects\u003c\/b\u003e\u003cb\u003e 671\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Basics: Making Lines, Arrows, and Shapes 672\u003c\/p\u003e \u003cp\u003eHandling Lines, Arrows, and Connectors 674\u003c\/p\u003e \u003cp\u003eHandling Rectangles, Ovals, Stars, and Other Shapes 678\u003c\/p\u003e \u003cp\u003eDrawing by Freehand 682\u003c\/p\u003e \u003cp\u003eDecorating Your Work with Icons 685\u003c\/p\u003e \u003cp\u003eInserting a 3-D Model 686\u003c\/p\u003e \u003cp\u003eWordArt for Embellishing Letters and Words 686\u003c\/p\u003e \u003cp\u003eManipulating Lines, Shapes, Art, Text Boxes, and Other Objects 688\u003c\/p\u003e \u003cp\u003eChanging an Object’s Size and Shape 691\u003c\/p\u003e \u003cp\u003eChanging an Object’s Color, Outline Color, and Transparency 692\u003c\/p\u003e \u003cp\u003eMoving and Positioning Objects 697\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 9: Office 2019: One Step Beyond\u003c\/b\u003e\u003cb\u003e 705\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Customizing an Office Program\u003c\/b\u003e\u003cb\u003e 707\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCustomizing the Ribbon 707\u003c\/p\u003e \u003cp\u003eCustomizing the Quick Access Toolbar 713\u003c\/p\u003e \u003cp\u003eCustomizing the Status Bar 716\u003c\/p\u003e \u003cp\u003eChanging the Screen Background and Office Theme 717\u003c\/p\u003e \u003cp\u003eCustomizing Keyboard Shortcuts in Word 718\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Ways of Distributing Your Work\u003c\/b\u003e\u003cb\u003e 721\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePrinting — the Old Standby 721\u003c\/p\u003e \u003cp\u003eDistributing a File in PDF Format 723\u003c\/p\u003e \u003cp\u003eSending Your File in an Email Message 725\u003c\/p\u003e \u003cp\u003eSaving an Office File as a Web Page 726\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 10: File Sharing and Collaborating\u003c\/b\u003e\u003cb\u003e 729\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Up and Running on OneDrive\u003c\/b\u003e\u003cb\u003e 731\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSigning In to OneDrive 731\u003c\/p\u003e \u003cp\u003eExploring the OneDrive Window 733\u003c\/p\u003e \u003cp\u003eManaging Your OneDrive Folders 733\u003c\/p\u003e \u003cp\u003eUploading Files to a Folder on OneDrive 738\u003c\/p\u003e \u003cp\u003eSaving a File from Office 2019 to OneDrive 739\u003c\/p\u003e \u003cp\u003eOpening a File from OneDrive 740\u003c\/p\u003e \u003cp\u003eDownloading Files from OneDrive to Your Computer 741\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: File Sharing and Collaborating\u003c\/b\u003e\u003cb\u003e 743\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSharing Files: The Big Picture 743\u003c\/p\u003e \u003cp\u003eSharing Your Files and Folders with Others 745\u003c\/p\u003e \u003cp\u003eInviting people by email 745\u003c\/p\u003e \u003cp\u003eSeeing Files and Folders Others Shared with You 748\u003c\/p\u003e \u003cp\u003eInvestigating and Managing How Files and Folders Are Shared 749\u003c\/p\u003e \u003cp\u003eIndex 751\u003c\/p\u003e   \u003cp\u003e\u003cb\u003ePeter Weverka\u003c\/b\u003e is a veteran tech writer and long-time \u003ci\u003eFor Dummies\u003c\/i\u003e author. Among his credits are \u003ci\u003eOffice 2016 All-in-One For Dummies\u003c\/i\u003e and \u003ci\u003eWindows 10 For Seniors For Dummies\u003c\/i\u003e, both top sellers in their respective categories.      \u003c\/p\u003e\u003cp\u003e\u003cb\u003e10 Books in one!\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\u003cb\u003eYour complete guide to Office 2019\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eMicrosoft Office is the productivity tool used in homes and workplaces around the globe. Getting the most out of Office requires you to be part mathematician, part graphic designer, part storyteller, part database architect, and part wizard. Or you can just consult with the simple steps in this book to get results from Office's applications. It's a crash course in every part of the Office suite, with valuable tips for making the most out of Office.  \u003c\/p\u003e\u003cp\u003e\u003cb\u003e10 Books Inside…\u003c\/b\u003e  \u003c\/p\u003e\u003cul\u003e \u003cli\u003eOffice Nuts \u0026amp; Bolts\u003c\/li\u003e \u003cli\u003eWord 2019\u003c\/li\u003e \u003cli\u003eExcel\u003csup\u003e®\u003c\/sup\u003e 2019\u003c\/li\u003e \u003cli\u003ePowerPoint\u003csup\u003e®\u003c\/sup\u003e 2019\u003c\/li\u003e \u003cli\u003eOutlook\u003csup\u003e®\u003c\/sup\u003e 2019\u003c\/li\u003e \u003cli\u003eAccess\u003csup\u003e®\u003c\/sup\u003e 2019\u003c\/li\u003e \u003cli\u003ePublisher 2019\u003c\/li\u003e \u003cli\u003eWorking with Charts \u0026amp; Graphics\u003c\/li\u003e \u003cli\u003eOffice 2019 — One Step Beyond\u003c\/li\u003e \u003cli\u003eFile Sharing \u0026amp; Collaborating\u003c\/li\u003e \u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47989709930725,"sku":"NP9781119513278","price":39.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119513278.jpg?v=1761785198","url":"https:\/\/k12savings.com\/products\/office-2019-all-in-one-for-dummies-isbn-9781119513278","provider":"K12savings","version":"1.0","type":"link"}