We are making a service for people who want a MS office 365 student A1 account with lifetime licence. If you are interested on this service check the link: https://www.fiverr.com/share/emV5Ek If you want this ebook just contact us in the previous link and you will get it with your MS accounts for 5 dollars (both book+ MS account). Note: I can’t share all the ebook here on this website, because of Copyright so I will share with you just the summary of the content.
®
Office 365 ALL-IN-ONE
We are making a service for people who want a MS office 365 student A1 account with lifetime licence. If you are interested on this service check the link: https://www.fiverr.com/share/emV5Ek If you want this ebook just contact us in the previous link and you will get it with your MS accounts for 5 dollars (both book+ MS account). Note: I can’t share all the ebook here on this website, because of Copyright so I will share with you just the summary of the content.
®
Office 365 ALL-IN-ONE
by Peter Weverka with Timothy L. Warner
Office 365® All-in-One For Dummies® Published by: John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030-5774, www.wiley.com Copyright © 2019 by John Wiley & Sons, Inc., Hoboken, New Jersey Media and software compilation copyright © 2019 by John Wiley & Sons, Inc. All rights reserved. Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the Publisher. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions. Trademarks: Wiley, For Dummies, the Dummies Man logo, Dummies.com, Making Everything Easier, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and may not be used without written permission. Microsoft and Office 365 are registered trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book.
We are making a service for people who want a MS office 365 student A1 account with lifetime licence. If you are interested on this service check the link: https://www.fiverr.com/share/emV5Ek If you want this ebook just contact us in the previous link and you will get it with your MS accounts for 5 dollars (both book+ MS account). Note: I can’t share all the ebook here on this website, because of Copyright so I will share with you just the summary of the content.
Contents at a Glance Introduction .................................................................................... 1 Book 1: Common Office Tasks.............................................. 7 CHAPTER 1: CHAPTER 2: CHAPTER 3:
Office Nuts and Bolts ............................................................................ 9 Wrestling with the Text ........................................................................ 29 Speed Techniques Worth Knowing About ............................................ 49
Book 2: Word 365 ........................................................................ 57 CHAPTER 1: CHAPTER 2: CHAPTER 3: CHAPTER 4: CHAPTER 5: CHAPTER 6: CHAPTER 7: CHAPTER 8:
Speed Techniques for Using Word ...................................................... 59 Laying Out Text and Pages ................................................................. 79 Word Styles.......................................................................................105 Constructing the Perfect Table ...........................................................123 Taking Advantage of the Proofing Tools..............................................147 Desktop Publishing with Word ............................................................167 Getting Word’s Help with Office Chores ..............................................187 Tools for Reports and Scholarly Papers ..............................................207
Book 3: Excel 365 ....................................................................... 229 CHAPTER 1: CHAPTER 2: CHAPTER 3: CHAPTER 4: CHAPTER 5:
Up and Running with Excel ................................................................231 Refining Your Worksheet ...................................................................249 Formulas and Functions for Crunching Numbers .................................263 Making a Worksheet Easier to Read and Understand ..........................295 Advanced Techniques for Analyzing Data ...........................................313
Book 4: PowerPoint 365 ............................................................ 329 CHAPTER 1: CHAPTER 2: CHAPTER 3: CHAPTER 4: CHAPTER 5:
Getting Started in PowerPoint ............................................................331 Fashioning a Look for Your Presentation .............................................353 Entering the Text ...............................................................................367 Making Your Presentations Livelier.....................................................383 Delivering a Presentation ...................................................................399
Book 5: Outlook 365 ............................................................ 419 CHAPTER 1: CHAPTER 2: CHAPTER 3: CHAPTER 4: CHAPTER 5:
Outlook Basics ..................................................................................421 Maintaining the Contacts Folder .........................................................433 Handling Your Email ..........................................................................447 Managing Your Time and Schedule ....................................................469 Tasks, Reminders, and Notes ............................................................481
Book 6: Access 365.................................................................... 489 CHAPTER 1: CHAPTER 2: CHAPTER 3: CHAPTER 4: CHAPTER 5:
Introducing Access............................................................................ 491 Building Your Database Tables.......................................................... 505 Entering the Data.............................................................................. 533 Sorting, Querying, and Filtering for Data............................................. 543 Presenting Data in a Report............................................................... 565
Book 7: Publisher 365 ................................................................ 571 CHAPTER 1: CHAPTER 2: CHAPTER 3:
Introducing Publisher ........................................................................ 573 Refining a Publication ....................................................................... 585 Putting on the Finishing Touches ....................................................... 597
Book 8: Working with Charts and Graphics ........................... 607 Creating a Chart ............................................................................... 609 Making a SmartArt Diagram .............................................................. 629 CHAPTER 3: Handling Graphics and Photos .......................................................... 649 CHAPTER 4: Drawing and Manipulating Lines, Shapes, and Other Objects .............. 665 CHAPTER 1: CHAPTER 2:
Book 9: Office 365: One Step Beyond ..................................... 699 CHAPTER 1: CHAPTER 2:
Customizing an Office Program ......................................................... 701 Ways of Distributing Your Work ......................................................... 715
Book 10: File Sharing and Collaborating........................... 723 CHAPTER 1: CHAPTER 2: CHAPTER 3: CHAPTER 4:
Up and Running on OneDrive............................................................ 725 File Sharing and Collaborating........................................................... 737 Collaborating in SharePoint ............................................................... 745 Working Together in Teams .............................................................. 757
Index ..................................................................................... 773
Table of Contents INTRODUCTION ...................................................................... 1 What Makes This Book Different ............................................................ 2 Foolish Assumptions ............................................................................. 3 Conventions Used in This Book ............................................................. 3 Icons Used in This Book ........................................................................ 4 Beyond the Book ................................................................................... 5
BOOK 1: COMMON OFFICE TASKS ....................................... 7 CHAPTER 1:
Office Nuts and Bolts ..................................................... 9 Introducing Office 365............................................................................ 9 Office 365 applications ................................................................... 10 Office 365 cloud services ............................................................... 10 Finding out what software and Office version you have .................... 11 Finding Your Way around the Office Interface ....................................... 13 The File tab and Backstage ............................................................ 13 The Quick Access toolbar ............................................................... 14 The Ribbon and its tabs.................................................................. 14 Context-sensitive tabs .................................................................... 16 The anatomy of a tab ..................................................................... 16 Mini-toolbars and shortcut menus ................................................... 18 Office 365 for keyboard lovers ........................................................ 18 Saving Your Files ................................................................................ 20 Saving a file ................................................................................... 20 Saving a file for the first time ........................................................... 20 Saving AutoRecovery information ................................................... 20 Navigating the Save As and Open Windows ......................................... 21 Opening and Closing Files ................................................................... 23 Opening a file................................................................................. 23 Closing a file .................................................................................. 23 Reading and Recording File Properties ................................................. 24 Locking a File with a Password ............................................................ 25 Password-protecting a file .............................................................. 25 Removing a password from a file .................................................... 26 Trusting (or not Trusting) Microsoft with Your “Content” ......................... 26
CHAPTER 2:
Wrestling with the Text ............................................29 Manipulating the Text .......................................................................... 29 Selecting text ................................................................................. 30 Moving and copying text ................................................................. 30 Taking advantage of the Clipboard task pane .................................. 31 Deleting text ................................................................................... 32 Table of Contents
vii
Speaking, not Typing, the Words.......................................................... 32 Changing the Look of Text ................................................................... 34 Choosing fonts for text.................................................................... 35 Changing the font size of text .......................................................... 36 Applying font styles to text .............................................................. 38 Applying text effects to text ............................................................. 38 Underlining text .............................................................................. 40 Changing the color of text ............................................................... 40 Quick Ways to Handle Case, or Capitalization ...................................... 41 Entering Symbols and Foreign Characters............................................ 42 Creating Hyperlinks ............................................................................. 44 Linking a hyperlink to a web page ................................................... 44 Creating a hyperlink to another place in your file.............................. 45 Creating an email hyperlink ............................................................ 46 Repairing and removing hyperlinks ................................................. 47 CHAPTER 3:
Speed Techniques Worth Knowing About................. 49 Undoing and Repeating Commands ..................................................... 49 Undoing a mistake ......................................................................... 50 Repeating an action — and quicker this time ................................... 50 Zooming In, Zooming Out .................................................................... 51 Viewing a File through More than One Window..................................... 52 Correcting Typos on the Fly ................................................................. 53 Entering Text Quickly with the AutoCorrect Command .......................... 55
BOOK 2: WORD 365 .............................................................. 57 CHAPTER 1:
Speed Techniques for Using Word ............................. 59 Introducing the Word Screen ................................................................ 59 Creating a New Document ................................................................... 61 Getting a Better Look at Your Documents ............................................. 63 Viewing documents in different ways............................................... 64 Splitting the screen ......................................................................... 66 Selecting Text in Speedy Ways ............................................................ 68 Moving around Quickly in Documents................................................... 69 Keys for getting around quickly ....................................................... 69 Navigating from page to page or heading to heading........................ 70 Going there fast with the Go To command....................................... 71 Bookmarks for hopping around ....................................................... 72 Inserting a Whole File into a Document ................................................ 73 Getting Word to Read It ....................................................................... 74 Entering Information Quickly in a Computerized Form ........................... 74 Creating a computerized form ......................................................... 75 Entering data in the form ................................................................ 77
viii
Office 365 All-in-One For Dummies
CHAPTER 2:
Laying Out Text and Pages........................................... 79 Paragraphs and Formatting ................................................................. 79 Inserting a Section Break for Formatting Purposes ............................... 80 Breaking a Line ................................................................................... 83 Starting a New Page............................................................................ 83 Setting Up and Changing the Margins .................................................. 84 Indenting Paragraphs and First Lines ................................................... 86 Clicking an Indent button (for left-indents) ....................................... 86 “Eyeballing� it with the ruler ............................................................ 86 Indenting in the Paragraph dialog box ............................................. 87 Numbering the Pages .......................................................................... 88 Numbering with page numbers only ................................................ 89 Including a page number in a header or footer................................. 89 Changing page number formats...................................................... 90 Putting Headers and Footers on Pages ................................................ 91 Creating, editing, and removing headers and footers ....................... 92 Fine-tuning a header or footer ........................................................ 94 Adjusting the Space between Lines...................................................... 95 Adjusting the Space between Paragraphs ............................................ 96 Creating Numbered and Bulleted Lists ................................................. 97 Simple numbered and bulleted lists ................................................ 97 Constructing lists of your own ......................................................... 98 Managing a multilevel list ............................................................... 99 Working with Tabs ............................................................................. 100 Hyphenating Text .............................................................................. 102 Automatically and manually hyphenating a document .................... 103 Unhyphenating and other hyphenation tasks ................................. 103
CHAPTER 3:
Word Styles ................................................................... 105 All about Styles ................................................................................. 105 Styles and templates .................................................................... 106 Types of styles ............................................................................. 106 Applying Styles to Text and Paragraphs ............................................. 107 Applying a style............................................................................ 107 Experimenting with style sets ....................................................... 109 Choosing which style names appear on the Style menus ............... 109 Creating a New Style......................................................................... 112 Creating a style from a paragraph................................................. 113 Creating a style from the ground up .............................................. 113 Modifying a Style ............................................................................... 115 Creating and Managing Templates..................................................... 116 Creating a new template .............................................................. 117 Opening a template so that you can modify it ................................ 120 Modifying, deleting, and renaming styles in templates .................... 121
Table of Contents
ix
CHAPTER 4:
Constructing the Perfect Table ............................. 123 Talking Table Jargon ......................................................................... 124 Creating a Table ................................................................................ 124 Entering the Text and Numbers .......................................................... 127 Selecting Different Parts of a Table .................................................... 128 Laying Out Your Table ....................................................................... 128 Changing the size of a table, columns, and rows ........................... 128 Adjusting column and row size...................................................... 129 Inserting columns and rows .......................................................... 130 Deleting columns and rows........................................................... 131 Moving columns and rows ............................................................ 132 Aligning Text in Columns and Rows ................................................... 133 Merging and Splitting Cells................................................................. 134 Repeating Header Rows on Subsequent Pages.................................. 135 Formatting Your Table ....................................................................... 137 Designing a table with a table style ............................................... 137 Calling attention to different rows and columns .............................. 138 Decorating your table with borders and colors ............................... 139 Using Math Formulas in Tables .......................................................... 140 Neat Table Tricks .............................................................................. 141 Changing the direction of header row text ..................................... 141 Wrapping text around a table ........................................................ 142 Using a picture as the table background........................................ 143 Drawing diagonal lines on tables................................................... 145 Drawing on a table ....................................................................... 145
CHAPTER 5:
Taking Advantage of the Proofing Tools .............. 147 Correcting Your Spelling Errors .......................................................... 148 Correcting misspellings one at a time ............................................ 148 Running a spell check .................................................................. 149 Preventing text from being spell checked ...................................... 151 Correcting Grammatical Errors ........................................................... 151 Finding and Replacing Text................................................................ 153 The basics: Finding stray words and phrases ................................ 153 Narrowing your search ................................................................. 154 Conducting a find-and-replace operation ....................................... 159 Finding the Right Word with the Thesaurus......................................... 161 Proofing Text Written in a Foreign Language ...................................... 162 Telling Office which languages you will use ................................... 163 Marking text as foreign language text ............................................ 163 Translating Foreign Language Text .................................................... 164
x
Office 365 All-in-One For Dummies
CHAPTER 6:
Desktop Publishing with Word ................................... 167 Experimenting with Themes............................................................... 167 Sprucing Up Your Pages ................................................................... 168 Decorating a page with a border ................................................... 169 Putting a background color on pages ............................................ 170 Getting Word’s help with cover letters ........................................... 170 Making Use of Charts, Diagrams, Shapes, and Photos ....................... 171 Working with the Drawing Canvas...................................................... 172 Positioning and Wrapping Objects Relative to the Page and Text......... 173 Wrapping text around an object .................................................... 174 Positioning an object on a page .................................................... 175 Working with Text Boxes ................................................................... 177 Inserting a text box....................................................................... 178 Making text flow from text box to text box...................................... 178 Dropping in a Drop Cap ..................................................................... 179 Watermarking for the Elegant Effect ................................................... 179 Putting Newspaper-Style Columns in a Document .............................. 181 Doing the preliminary work ........................................................... 181 Running text into columns ............................................................ 181 Landscape Documents ...................................................................... 183 Printing on Different Size Paper ......................................................... 184 Showing Online Video in a Document ................................................ 184
CHAPTER 7:
Getting Word’s Help with Office Chores ................... 187 Highlighting Parts of a Document ....................................................... 187 Commenting on a Document ............................................................. 188 Entering comments ...................................................................... 189 Replying to and resolving comments............................................. 189 Viewing and displaying comments ................................................ 190 Caring for and feeding comments ................................................. 190 Tracking Changes to Documents ....................................................... 192 Telling Word to start marking changes .......................................... 193 Reading and reviewing a document with revision marks................. 193 Marking changes when you forgot to turn on revision marks ........... 194 Accepting and rejecting changes to a document ............................ 196 Printing an Address on an Envelope .................................................. 197 Printing a Single Address Label (or a Page of the Same Label) ........... 198 Churning Out Letters, Envelopes, and Labels for Mass Mailings .......... 200 Preparing the source file .............................................................. 201 Merging the document with the source file .................................... 202 Printing form letters, envelopes, and labels ................................... 206
Table of Contents
xi
CHAPTER 8:
Tools for Reports and Scholarly Papers.................... 207 Alphabetizing a List ........................................................................... 207 Outlines for Organizing Your Work ..................................................... 208 Viewing the outline in different ways.............................................. 208 Rearranging document sections in Outline view............................. 210 Collapsing and Expanding Parts of a Document.................................. 210 Generating a Table of Contents ......................................................... 211 Creating a TOC ............................................................................ 212 Updating and removing a TOC...................................................... 212 Customizing a TOC ...................................................................... 212 Changing the structure of a TOC................................................... 213 Indexing a Document ......................................................................... 215 Marking index items in the document ............................................ 216 Generating the index .................................................................... 218 Editing an index ........................................................................... 220 Putting Cross-References in a Document ........................................... 220 Putting Footnotes and Endnotes in Documents................................... 222 Entering a footnote or endnote...................................................... 223 Choosing the numbering scheme and position of notes.................. 224 Deleting, moving, and editing notes............................................... 225 Compiling a Bibliography ................................................................... 225 Inserting a citation for your bibliography ........................................ 226 Editing a citation........................................................................... 227 Changing how citations appear in text ........................................... 228 Generating the bibliography .......................................................... 228
BOOK 3: EXCEL 365 ............................................................ 229 CHAPTER 1:
Up and Running with Excel ......................................... 231 Creating a New Excel Workbook ........................................................ 231 Getting Acquainted with Excel ............................................................ 233 Rows, columns, and cell addresses .............................................. 235 Workbooks and worksheets .......................................................... 235 Entering Data in a Worksheet............................................................. 235 The basics of entering data........................................................... 235 Entering text labels....................................................................... 237 Entering numeric values ............................................................... 237 Entering date and time values....................................................... 238 Quickly Entering Lists and Serial Data with the AutoFill Command ............................................................................. 241 Formatting Numbers, Dates, and Time Values .................................... 244 Establishing Data-Validation Rules ..................................................... 245
xii
Office 365 All-in-One For Dummies
CHAPTER 2:
Refining Your Worksheet ...................................... 249 Editing Worksheet Data ..................................................................... 249 Moving around in a Worksheet........................................................... 250 Getting a Better Look at the Worksheet .............................................. 251 Freezing and splitting columns and rows....................................... 251 Hiding columns and rows ............................................................. 253 Notes for Documenting Your Worksheet............................................. 254 Comments for Collaborating with Others on a Workbook .................... 256 Selecting Cells in a Worksheet........................................................... 257 Deleting, Copying, and Moving Data .................................................. 258 Handling the Worksheets in a Workbook ............................................ 259 Keeping Others from Tampering with Worksheets .............................. 261 Hiding a worksheet ...................................................................... 261 Protecting a worksheet ................................................................. 261
CHAPTER 3:
Formulas and Functions for Crunching Numbers ................................................ 263 How Formulas Work .......................................................................... 263 Referring to cells in formulas ........................................................ 264 Referring to formula results in formulas ......................................... 266 Operators in formulas ................................................................... 267 The Basics of Entering a Formula ...................................................... 269 Speed Techniques for Entering Formulas........................................... 269 Clicking cells to enter cell references ............................................ 269 Entering a cell range .................................................................... 270 Naming cell ranges so that you can use them in formulas .............. 271 Referring to cells in different worksheets ....................................... 274 Copying Formulas from Cell to Cell .................................................... 275 Detecting and Correcting Errors in Formulas ...................................... 276 Correcting errors one at a time ..................................................... 277 Running the error checker ............................................................ 277 Tracing cell references ................................................................. 278 Working with Functions...................................................................... 280 Using arguments in functions ....................................................... 281 Entering a function in a formula .................................................... 281 A Look at Some Very Useful Functions .............................................. 284 AVERAGE for averaging data....................................................... 285 COUNT and COUNTIF for tabulating data items ........................... 285 CONCATENATE for combining values ......................................... 287 PMT for calculating how much you can borrow.............................. 288 IF for identifying data.................................................................... 289 LEFT, MID, and RIGHT for cleaning up data ................................. 290
Table of Contents
xiii
PROPER for capitalizing words..................................................... 291 LARGE and SMALL for comparing values ..................................... 291 NETWORKDAY and TODAY for measuring time in days ............... 292 LEN for Counting Characters in Cells ............................................ 293 CHAPTER 4:
Making a Worksheet Easier to Read and Understand ....................................................... 295 Laying Out a Worksheet .................................................................... 295 Aligning numbers and text in columns and rows ............................ 296 Inserting and deleting rows and columns ....................................... 298 Changing the size of columns and rows ........................................ 299 Decorating a Worksheet with Borders and Colors ............................... 301 Cell styles for quickly formatting a worksheet................................. 301 Formatting cells with table styles................................................... 303 Slapping borders on worksheet cells ............................................. 304 Decorating worksheets with colors ................................................ 306 Getting Ready to Print a Worksheet ................................................... 306 Making a worksheet fit on a page.................................................. 306 Making a worksheet more presentable .......................................... 310 Repeating row and column headings on each page ....................... 311
CHAPTER 5:
Advanced Techniques for Analyzing Data ................ 313 Seeing What the Sparklines Say ........................................................ 313 Conditional Formats for Calling Attention to Data ................................ 314 Managing Information in Lists............................................................. 316 Sorting a list ................................................................................. 317 Filtering a list................................................................................ 318 Forecasting with the Goal Seek Command ......................................... 319 Performing What-If Analyses with Data Tables ................................... 321 Using a one-input table for analysis .............................................. 321 Using a two-input table for analysis ............................................... 323 Analyzing Data with PivotTables ........................................................ 325 Getting a PivotTable recommendation from Excel.......................... 326 Creating a PivotTable from scratch ............................................... 326 Putting the finishing touches on a PivotTable................................. 328
BOOK 4: POWERPOINT 365 ............................................... 329 CHAPTER 1:
Getting Started in PowerPoint............................... 331 Getting Acquainted with PowerPoint................................................... 332 A Brief Geography Lesson ................................................................. 333 A Whirlwind Tour of PowerPoint ......................................................... 334 Creating a New Presentation ............................................................. 335
xiv
Office 365 All-in-One For Dummies
Advice for Building Persuasive Presentations ..................................... 338 Creating New Slides for Your Presentation ......................................... 340 Inserting a new slide .................................................................... 341 Speed techniques for inserting slides ............................................ 341 Conjuring slides from Word document headings ............................ 342 Selecting a different layout for a slide............................................ 343 Getting a Better View of Your Work.................................................... 343 Changing views ........................................................................... 344 Looking at the different views ....................................................... 344 Hiding and Displaying the Slides Pane and Notes Pane ...................... 345 Selecting, Moving, and Deleting Slides............................................... 346 Selecting slides ............................................................................ 346 Moving slides ............................................................................... 346 Deleting slides ............................................................................. 347 Putting Together a Photo Album ........................................................ 347 Creating your photo album ........................................................... 347 Putting on the final touches .......................................................... 350 Editing a photo album................................................................... 350 Hidden Slides for All Contingencies.................................................... 350 Hiding a slide ............................................................................... 351 Showing a hidden slide during a presentation................................ 351 CHAPTER 2:
Fashioning a Look for Your Presentation ................. 353 Looking at Themes and Slide Backgrounds ........................................ 353 Choosing a Theme for Your Presentation ........................................... 355 Creating Slide Backgrounds on Your Own.......................................... 356 Using a solid (or transparent) color for the slide background .......... 356 Creating a gradient color blend for slide backgrounds .................... 357 Placing a picture in the slide background ...................................... 358 Using a photo of your own for a slide background.......................... 360 Using a texture for a slide background .......................................... 361 Changing the Background of a Single or Handful of Slides .................. 362 Choosing the Slide Size..................................................................... 363 Using Master Slides and Master Styles for a Consistent Design .......... 363 Switching to Slide Master view ..................................................... 364 Understanding master slides and master styles............................. 365 Editing a master slide ................................................................... 366 Changing a master slide layout..................................................... 366
CHAPTER 3:
Entering the Text .................................................... 367 Entering Text .................................................................................... 367 Choosing fonts for text ................................................................. 368 Changing the font size of text ....................................................... 369 Changing the look of text .............................................................. 369
Table of Contents
xv
Fun with Text Boxes and Text Box Shapes......................................... 371 Controlling How Text Fits in Text Frames and Text Boxes ................... 372 Choosing how AutoFit works in text frames ................................... 373 Choosing how AutoFits works in text boxes ................................... 375 Positioning Text in Frames and Text Boxes ........................................ 375 Handling Bulleted and Numbered Lists ............................................... 376 Creating a standard bulleted or numbered list................................ 377 Choosing a different bullet character, size, and color ..................... 377 Choosing a different list-numbering style, size, and color ............... 379 Putting Footers (and Headers) on Slides ............................................ 379 Some background on footers and headers .................................... 380 Putting a standard footer on all your slides .................................... 380 Creating a nonstandard footer ...................................................... 381 Removing a footer from a single slide ........................................... 382 CHAPTER 4:
Making Your Presentations Livelier...................... 383 Suggestions for Enlivening Your Presentation..................................... 383 Presenting Information in a Table ....................................................... 384 Exploring Transitions and Animations ................................................. 387 Showing transitions between slides............................................... 387 Animating parts of a slide ............................................................. 388 Making Audio Part of Your Presentation ............................................. 390 Inserting an audio file on a slide .................................................... 390 Telling PowerPoint when and how to play an audio file .................. 391 Playing audio during a presentation .............................................. 393 Playing Video on Slides ..................................................................... 393 Inserting a video on a slide ........................................................... 393 Fine-tuning a video presentation ................................................... 394 Experimenting with the look of the video........................................ 395 Recording a Voice Narration for Slides ............................................... 396
CHAPTER 5:
Delivering a Presentation ...................................... 399 All about Notes .................................................................................. 399 Rehearsing and Timing Your Presentation.......................................... 400 Showing Your Presentation ................................................................ 402 Starting and ending a presentation................................................ 402 Going from slide to slide ............................................................... 402 Tricks for Making Presentations a Little Livelier ................................... 405 Wielding a pen or highlighter in a presentation............................... 406 Blanking the screen ...................................................................... 408 Zooming in ................................................................................... 408 Delivering a Presentation When You Can’t Be There in Person ........... 408 Providing handouts for your audience ........................................... 409 Creating a self-running, kiosk-style presentation ............................ 410
xvi
Office 365 All-in-One For Dummies
Creating a user-run presentation .................................................. 412 Presenting a Presentation Online ................................................. 414 Creating a presentation video ....................................................... 415
BOOK 5: OUTLOOK 365 ...................................................... 419 CHAPTER 1:
Outlook Basics .............................................................. 421 What Is Outlook, Anyway? ................................................................. 421 Navigating the Outlook Folders .......................................................... 422 Categorizing Items ............................................................................ 423 Creating a category...................................................................... 423 Assigning items to categories ....................................................... 424 Arranging items by category in folders .......................................... 425 Searching for Stray Folder Items ........................................................ 425 Conducting an instant search ....................................................... 426 Refining a search ......................................................................... 426 Conducting an advanced search................................................... 427 Deleting Email Messages, Contacts, Tasks, and Other Items .............. 428 Cleaning Out Your Folders ................................................................ 429 Archiving the old stuff ................................................................... 429 Running the Mailbox Cleanup command ....................................... 431
CHAPTER 2:
Maintaining the Contacts Folder ........................... 433 Maintaining a Happy and Healthy Contacts Folder .............................. 434 Entering a new contact in the Contacts folder ................................ 434 Changing a contact’s information .................................................. 436 Contact Groups for Sending Messages to Groups .............................. 437 Creating a contact group .............................................................. 437 Addressing email to a contact group ............................................. 439 Editing a contact group................................................................. 439 Finding a Contact in the Contacts Folder ............................................ 440 Linking Duplicate Contacts ................................................................ 440 Sharing Contacts with Coworkers ...................................................... 441 Sharing your Contacts folder ........................................................ 442 Sharing someone else’s contacts ................................................. 443 Printing the Contacts Folder............................................................... 443 Different ways to print contact information ..................................... 443 Changing the look of printed pages............................................... 444
CHAPTER 3:
Handling Your Email .............................................. 447 Setting Up an Email Account ............................................................. 447 Addressing and Sending Email Messages .......................................... 448 The basics: Sending an email message ........................................ 449 Addressing an email message ...................................................... 450
Table of Contents
xvii
Sending copies and blind copies of messages ............................... 452 Replying to and forwarding email messages .................................. 452 Sending Files and Photos .................................................................. 454 Sending a file along with a message ............................................. 454 Including a photo in an email message.......................................... 455 Receiving Email Messages ................................................................ 456 Getting your email ........................................................................ 456 Being notified that email has arrived.............................................. 457 Reading Your Email in the Inbox Window ........................................... 457 Handling Files That Were Sent to You ................................................ 459 Opening a file you received .......................................................... 460 Saving a file you received ............................................................. 460 Techniques for Organizing Email Messages ....................................... 460 Flagging email messages ............................................................. 462 Rules for earmarking messages as they arrive .............................. 462 All about Email Folders ...................................................................... 464 Moving email messages to different folders ................................... 464 Creating a new folder for storing email .......................................... 465 Yes, You Can Prevent Junk Mail (Sort of) ........................................... 466 Defining what constitutes junk email.............................................. 466 Preventative medicine for junk email ............................................. 467 CHAPTER 4:
Managing Your Time and Schedule ........................... 469 Introducing the Calendar .................................................................... 469 The Different Kinds of Activities .......................................................... 470 Seeing Your Schedule ....................................................................... 472 Going to a different day, week, or month ....................................... 472 Rearranging the Calendar window ................................................ 472 Scheduling Appointments and Events ................................................ 473 Scheduling an activity: The basics ................................................ 473 Scheduling a recurring appointment or event ................................. 474 Scheduling an event ..................................................................... 475 Canceling, Rescheduling, and Altering Activities ................................. 476 Managing Meetings with the Calendar ................................................ 476 Scheduling and inviting coworkers to a meeting............................. 476 Accepting (or declining) meeting invitations ................................... 478 Canceling and rescheduling meetings ........................................... 480
CHAPTER 5:
Tasks, Reminders, and Notes ............................... 481 Tasks: Seeing What Needs to Get Done ............................................ 481 Entering a task in the Tasks window ............................................. 482 Examining tasks in the Tasks window ........................................... 484 Handling and managing tasks ....................................................... 484
xviii
Office 365 All-in-One For Dummies
Reminders for Being Alerted to Activities and Tasks ........................... 484 Handling reminder messages ....................................................... 485 Scheduling a reminder message................................................... 486 Making reminders work your way.................................................. 486 Making Notes to Yourself ................................................................... 487
BOOK 6: ACCESS 365 ......................................................... 489 CHAPTER 1:
Introducing Access ................................................ 491 What Is a Database, Anyway? ........................................................... 491 Tables, Queries, Forms, and Other Objects........................................ 492 Database tables for storing information ......................................... 492 Forms for entering data ................................................................ 494 Queries for getting the data out..................................................... 494 Reports for presenting and examining data ................................... 496 Macros and modules .................................................................... 497 Creating a Database File ................................................................... 497 Creating a blank database file ...................................................... 498 Getting the help of a template ....................................................... 498 Finding Your Way around the Navigation Pane................................... 499 Designing a Database ....................................................................... 500 Deciding what information you need ............................................. 501 Separating information into different database tables..................... 501 Choosing fields for database tables .............................................. 503 Deciding on a primary key field for each database table................. 503 Mapping the relationships between tables ..................................... 504
CHAPTER 2:
Building Your Database Tables ............................. 505 Creating a Database Table ................................................................ 505 Creating a database table from scratch ......................................... 506 Creating a database table from a template .................................... 507 Importing a table from another database ....................................... 508 Opening and Viewing Tables ............................................................. 509 Entering and Altering Table Fields ..................................................... 510 Creating a field............................................................................. 510 All about data types...................................................................... 512 Designating the primary key field .................................................. 513 Moving, renaming, and deleting fields ........................................... 515 Field Properties for Making Sure That Data Entries Are Accurate ........ 516 A look at the Field Properties settings ........................................... 516 Creating a lookup data-entry list ................................................... 521 Indexing for Faster Sorts, Searches, and Queries ............................... 524 Indexing a field............................................................................. 525 Indexing based on more than one field.......................................... 525
Table of Contents
xix
Establishing Relationships among Database Tables ........................... 526 Types of relationships................................................................... 528 Handling tables in the Relationships window ................................. 528 Forging relationships between tables ............................................ 530 Editing table relationships ............................................................. 532 CHAPTER 3:
Entering the Data.................................................... 533 The Two Ways to Enter Data ............................................................. 533 Entering the Data in Datasheet View .................................................. 534 Entering data ............................................................................... 535 Two tricks for entering data quicker ............................................... 536 Changing the appearance of the datasheet ................................... 537 Entering the Data in a Form ............................................................... 538 Creating a form ............................................................................ 538 Entering the data .......................................................................... 539 Finding a Missing Record................................................................... 540 Finding and Replacing Data ............................................................... 541
CHAPTER 4:
Sorting, Querying, and Filtering for Data.............. 543 Sorting Records in a Database Table ................................................. 543 Ascending versus descending sorts .............................................. 544 Sorting records............................................................................. 544 Filtering to Find Information................................................................ 544 Different ways to filter a database table ......................................... 546 “Unfiltering” a database table ........................................................ 547 Filtering by selection..................................................................... 547 Filtering for input .......................................................................... 548 Filtering by form ........................................................................... 549 Querying: The Basics ........................................................................ 550 Creating a new query ................................................................... 551 Viewing queries in Datasheet and Design views ............................ 552 Finding your way around the Query Design window ....................... 552 Choosing which database tables to query ..................................... 553 Choosing which fields to query...................................................... 553 Sorting the query results ............................................................... 554 Choosing which fields appear in query results ............................... 555 Entering criteria for a query........................................................... 555 At last — saving and running a query ............................................ 558 Six Kinds of Queries .......................................................................... 559 Select query ................................................................................. 559 Top-value query ........................................................................... 559 Summary query............................................................................ 559 Calculation query ......................................................................... 560 Delete query ................................................................................ 561 Update query ............................................................................... 563
xx
Office 365 All-in-One For Dummies
CHAPTER 5:
Presenting Data in a Report ................................... 565 Creating a Report .............................................................................. 565 Opening and Viewing Reports ........................................................... 567 Tweaking a Report ............................................................................ 567
BOOK 7: PUBLISHER 365 ................................................... 571 CHAPTER 1:
Introducing Publisher ............................................ 573 “A Print Shop in a Can� ...................................................................... 573 Introducing Frames ........................................................................... 574 Creating a Publication ....................................................................... 575 Redesigning a Publication ................................................................. 576 Choosing a different template ....................................................... 576 Choosing a color scheme ............................................................. 577 Choosing a font scheme............................................................... 577 Setting up your pages .................................................................. 577 Getting a Better View of Your Work.................................................... 578 Zooming in and out ...................................................................... 578 Viewing single pages and two-page spreads ................................. 579 Going from page to page.............................................................. 579 Understanding and Using the Layout Guides ...................................... 579 Making use of layout guides ......................................................... 580 Snapping objects to ruler and grid lines......................................... 582
CHAPTER 2:
Refining a Publication ............................................ 585 Entering Text on the Pages ............................................................... 585 Making Text Fit in Text Frames .......................................................... 586 Fitting overflow text in a single frame ............................................ 587 Making text flow from frame to frame ............................................ 588 Filling out a text frame .................................................................. 589 Formatting Text ................................................................................. 589 Making Text Wrap around a Frame or Graphic ................................... 590 Replacing the Placeholder Pictures .................................................... 591 Inserting Frames on the Pages .......................................................... 591 Inserting a new frame................................................................... 592 Changing the size and position of frames ...................................... 593 Making Frames Overlap .................................................................... 593 Inserting, Removing, and Moving Pages ............................................ 594
CHAPTER 3:
Putting on the Finishing Touches .............................. 597 Decorating the Text ........................................................................... 597 Drawing a horizontal rule on a frame............................................. 598 Dropping in a drop cap ................................................................. 599
Table of Contents
xxi
Techniques for Decorating Pages ...................................................... 600 Plugging in a page part ................................................................. 600 Experimenting with borders and accents ....................................... 600 Taking advantage of attention getters............................................ 602 Backgrounds for pages................................................................. 602 Master Pages for Handling Page Backgrounds ...........................603 Switching to Master Page view ..................................................... 604 Changing the look of a master page .............................................. 604 Applying (or unapplying) a master page to publication pages .......... 604 Running the Design Checker ............................................................. 605 Commercially Printing a Publication ................................................... 606
BOOK 8: WORKING WITH CHARTS AND GRAPHICS ....... 607 CHAPTER 1:
Creating a Chart ..................................................... 609 The Basics: Creating a Chart ............................................................. 609 Choosing the Right Chart ................................................................... 611 Providing the Raw Data for Your Chart ............................................... 613 Positioning Your Chart in a Workbook, Page, or Slide ......................... 615 Changing a Chart’s Appearance......................................................... 616 Changing the chart type ............................................................... 617 Changing the size and shape of a chart......................................... 617 Choosing a new look for your chart ............................................... 617 Changing the layout of a chart ...................................................... 618 Handling the gridlines ................................................................... 619 Changing a chart element’s color, font, or other particular .............. 620 Saving a Chart as a Template So That You Can Use It Again .............. 622 Saving a chart as a template......................................................... 622 Creating a chart from a template ................................................... 622 Chart Tricks for the Daring and Heroic................................................ 623 Decorating a chart with a picture ................................................... 623 Annotating a chart ........................................................................ 624 Displaying the raw data alongside the chart ................................... 625 Placing a trendline on a chart........................................................ 625 Troubleshooting a Chart .................................................................... 626
CHAPTER 2:
Making a SmartArt Diagram .................................. 629 The Basics: Creating SmartArt Diagrams............................................ 629 Choosing a diagram ..................................................................... 630 Making the diagram your own ....................................................... 631 Creating the Initial Diagram ................................................................ 632 Creating a diagram ....................................................................... 632 Swapping one diagram for another................................................ 633
xxii
Office 365 All-in-One For Dummies
Changing the Size and Position of a Diagram ..................................... 634 Laying Out the Diagram Shapes ........................................................ 634 Selecting a diagram shape ........................................................... 634 Removing a shape from a diagram ............................................... 635 Moving diagram shapes to different positions ................................ 635 Adding shapes to diagrams apart from hierarchy diagrams ............ 635 Adding shapes to hierarchy diagrams ........................................... 636 Adding shapes to Organization charts........................................... 638 Promoting and demoting shapes in hierarchy diagrams ................. 640 Handling the Text on Diagram Shapes ............................................... 640 Entering text on a diagram shape ................................................. 640 Entering bulleted lists on diagram shapes ..................................... 641 Changing a Diagram’s Direction......................................................... 642 Choosing a Look for Your Diagram .................................................... 643 Changing the Appearance of Diagram Shapes ................................... 644 Changing the size of a diagram shape .......................................... 644 Exchanging one shape for another ............................................... 645 Changing a shape’s color, fill, or outline ........................................ 645 Changing fonts and font sizes on shapes ...................................... 647 Creating a Diagram from Scratch ....................................................... 647 CHAPTER 3:
Handling Graphics and Photos ................................... 649 All about Picture File Formats ............................................................ 649 Bitmap and vector graphics .......................................................... 650 Resolution ................................................................................... 651 Compression ............................................................................... 652 Color depth .................................................................................. 652 Choosing file formats for graphics................................................. 653 Inserting a Picture in an Office File..................................................... 653 Inserting a picture of your own ...................................................... 653 Obtaining a picture online ............................................................. 654 Touching Up a Picture ....................................................................... 656 Softening and sharpening pictures................................................ 657 Correcting a picture’s brightness and contrast ............................... 657 Recoloring a picture ..................................................................... 658 Choosing an artistic effect ............................................................ 660 Selecting a picture style ............................................................... 660 Cropping off part of a picture ........................................................ 661 Removing the background............................................................ 662 Compressing Pictures to Save Disk Space......................................... 663
Table of Contents
xxiii
CHAPTER 4:
Drawing and Manipulating Lines, Shapes, and Other Objects..................................... 665 The Basics: Making Lines, Arrows, and Shapes .................................. 666 Handling Lines, Arrows, and Connectors............................................. 668 Changing the length and position of a line or arrow......................... 668 Changing the appearance of a line, arrow, or connector ................. 668 Attaching and handling arrowheads on lines and connectors .......... 669 Connecting shapes by using connectors ........................................ 670 Handling Rectangles, Ovals, Stars, and Other Shapes......................... 672 Drawing a shape .......................................................................... 673 Changing a shape’s symmetry ...................................................... 674 Using a shape as a text box .......................................................... 675 Drawing by Freehand ......................................................................... 676 Freehand drawing with a pen or highlighter .................................... 676 Changing the look of freehand drawings ........................................ 677 Drawing a math expression ........................................................... 678 Decorating Your Work with Icons ........................................................ 679 Inserting a 3-D Model ......................................................................... 680 WordArt for Embellishing Letters and Words ....................................... 680 Creating WordArt ......................................................................... 681 Editing WordArt ............................................................................ 681 Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects ......... 682 Selecting objects so that you can manipulate them......................... 683 Hiding and displaying the rulers and grid ........................................ 684 Changing an Object’s Size and Shape ................................................ 685 Changing an Object’s Color, Outline Color, and Transparency ............. 686 Filling an object with color, a picture, or a texture............................ 687 Making a color transparent ............................................................ 689 Putting the outline around an object............................................... 690 Moving and Positioning Objects .......................................................... 691 Tricks for aligning and distributing objects ...................................... 691 When objects overlap: Choosing which appears above the other ............................................................................................ 694 Rotating and flipping objects ......................................................... 696 Grouping objects to make working with them easier ....................... 697
BOOK 9: OFFICE 365: ONE STEP BEYOND ........................ 699 CHAPTER 1:
Customizing an Office Program ................................701 Customizing the Ribbon ..................................................................... 701 Displaying and selecting tab, group, and command names ............. 703 Moving tabs and groups on the Ribbon .......................................... 704 Adding, removing, and renaming tabs, groups, and commands............................................................................. 704 Creating new tabs and groups....................................................... 706 Resetting your Ribbon customizations ........................................... 706
xxiv
Office 365 All-in-One For Dummies
Customizing the Quick Access Toolbar .............................................. 707 Adding buttons to the Quick Access toolbar .................................. 708 Changing the order of buttons on the Quick Access toolbar............ 709 Removing buttons from the Quick Access toolbar .......................... 710 Placing the Quick Access toolbar above or below the Ribbon......... 710 Customizing the Status Bar ............................................................... 710 Changing the Screen Background and Office Theme.......................... 711 Customizing Keyboard Shortcuts in Word .......................................... 712 CHAPTER 2:
Ways of Distributing Your Work ............................ 715 Printing — the Old Standby ............................................................... 715 Distributing a File in PDF Format ....................................................... 717 About PDF files ............................................................................ 718 Saving an Office file as a PDF ...................................................... 718 Sending Your File in an Email Message ............................................. 719 Saving an Office File as a Web Page ................................................. 720 Turning a file into a web page....................................................... 720 Opening a web page in your browser ............................................ 721
BOOK 10: FILE SHARING AND COLLABORATING ........... 723 CHAPTER 1:
Up and Running on OneDrive ..................................... 725 Signing in to OneDrive....................................................................... 725 Exploring the OneDrive Window ........................................................ 726 Managing Your OneDrive Folders ...................................................... 727 Creating a folder .......................................................................... 727 Viewing and locating folders in the OneDrive window .................... 728 Selecting folders and files............................................................. 728 Going from folder to folder in OneDrive ......................................... 730 Deleting, moving, and renaming folders ........................................ 731 Uploading Files to a Folder on OneDrive ............................................ 732 Saving a File from Office 365 to OneDrive.......................................... 732 Opening a File from OneDrive ........................................................... 734 Starting in an Office desktop application ....................................... 734 Starting in OneDrive..................................................................... 734 Downloading Files from OneDrive to Your Computer .......................... 735
CHAPTER 2:
File Sharing and Collaborating .............................. 737 Sharing Files: The Big Picture............................................................ 737 Sharing Your Files and Folders with Others ........................................ 739 Inviting people by email ................................................................ 739 Generating a link to shared files ................................................... 740 Generating HTML code ................................................................ 741 Seeing Files and Folders Others Shared with You .............................. 742 Investigating and Managing How Files and Folders Are Shared ........... 743
Table of Contents
xxv
CHAPTER 3:
Collaborating in SharePoint .................................. 745 Introducing Team Sites ...................................................................... 745 Logging in to a team site............................................................... 746 Finding your way around a team site ............................................. 747 Working with Document Libraries ....................................................... 747 Opening a file in a document library .............................................. 748 Working with coworkers on the same file....................................... 748 Uploading files to a document library............................................. 750 Sharing files with coworkers.......................................................... 751 Viewing files offline....................................................................... 753 Delving Deeper into Office 365........................................................... 755
CHAPTER 4:
Working Together in Teams .................................. 757 Introducing Microsoft Teams and Channels ........................................ 758 Opening a team and viewing its channels...................................... 758 Putting a team or channel on the Favorites list............................... 759 Setting Your Status............................................................................ 761 All about Conversations ..................................................................... 762 Liking and bookmarking conversations.......................................... 762 Starting a conversation ................................................................. 763 Posting to a conversation ............................................................. 763 Chatting Privately with a Colleague .................................................... 764 Filtering and Searching ...................................................................... 765 Filtering your activity feed ............................................................. 765 Searching for content ................................................................... 766 Choosing Notification Settings............................................................ 767 Sharing and Editing Files with Coworkers ........................................... 768 Uploading a file to a channel ......................................................... 768 Collaborating on a file................................................................... 769 Holding Meetings with Coworkers ...................................................... 770 Conducting a video or audio meeting ............................................ 770 Scheduling a meeting and inviting attendees ................................. 771
INDEX ................................................................................... 773
xxvi
Office 365 All-in-One For Dummies
We are making a service for people who want a MS office 365 student A1 account with lifetime licence. If you are interested on this service check the link: https://www.fiverr.com/share/emV5Ek If you want this ebook just contact us in the previous link and you will get it with your MS accounts for 5 dollars (both book+ MS account). Note: I can’t share all the ebook here on this website, because of Copyright so I will share with you just the summary of the content.
Table of Contents
xxvii