{"appState":{"pageLoadApiCallsStatus":true},"categoryState":{"relatedCategories":{"headers":{"timestamp":"2022-05-17T12:31:16+00:00"},"categoryId":33652,"data":{"title":"General (Microsoft)","slug":"general-microsoft","image":{"src":null,"width":0,"height":0},"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General (Microsoft)","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"parentCategory":{"categoryId":33642,"title":"Microsoft Products","slug":"microsoft-products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"}},"childCategories":[],"description":"Get started with Microsoft 365, add graphics to all your Office files, share stuff straight to Facebook, speed up your work with keyboard shortcuts, and tons more neat stuff.","relatedArticles":{"self":"https://dummies-api.dummies.com/v2/articles?category=33652&offset=0&size=5"}},"_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"relatedCategoriesLoadedStatus":"success"},"listState":{"list":{"count":10,"total":391,"items":[{"headers":{"creationTime":"2018-09-18T16:01:59+00:00","modifiedTime":"2022-03-25T18:40:47+00:00","timestamp":"2022-03-26T00:01:04+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General (Microsoft)","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"Office 2019 All-in-One For Dummies Cheat Sheet","strippedTitle":"office 2019 all-in-one for dummies cheat sheet","slug":"office-2019-all-in-one-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Get started with Office 2019 with handy tips for opening files quickly, customizing the Quick Access toolbar and changing color scemes.","noIndex":0,"noFollow":0},"content":"Master the commands in one Office 2019 program and you are well on your way to mastering the other programs. Following is key information you can take to any Office 2019 program you are working in.","description":"Master the commands in one Office 2019 program and you are well on your way to mastering the other programs. Following is key information you can take to any Office 2019 program you are working in.","blurb":"","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":"Peter Weverka is a veteran technology author with dozens of books to his credit. In addition to previous editions of Office All-in-One For Dummies, he has written books on PowerPoint, OneNote, Word, and Quicken, as well as the bestselling Windows 10 For Seniors For Dummies.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9034"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General (Microsoft)","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":259408,"title":"What Is Outlook?","slug":"what-is-outlook","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259408"}},{"articleId":259402,"title":"Detecting and Correcting Errors in Excel 2019 Formulas","slug":"detecting-and-correcting-errors-in-excel-2019-formulas","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259402"}},{"articleId":259390,"title":"How to Touch Up a Picture Using Office 2019 Tools","slug":"how-to-touch-up-a-picture-using-office-2019-tools","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259390"}},{"articleId":259292,"title":"How Excel Formulas Work","slug":"how-excel-formulas-work","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259292"}},{"articleId":259285,"title":"Office 2019 Chart Tricks for the Daring and Heroic","slug":"office-2019-chart-tricks-for-the-daring-and-heroic","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259285"}}],"fromCategory":[{"articleId":291623,"title":"Office 2021 For Macs For Dummies Cheat Sheet","slug":"office-2021-for-macs-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/291623"}},{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290233"}},{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290196"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289688"}},{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281801,"slug":"office-2019-all-in-one-for-dummies","isbn":"9781119513278","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119513278/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119513278/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119513278-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119513278/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119513278/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/office-2019-all-in-one-for-dummies-cover-9781119513278-203x255.jpg","width":203,"height":255},"title":"Office 2019 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n <p><b data-author-id=\"9034\">Peter Weverka</b> is a veteran tech writer and long-time <i>For Dummies</i> author. Among his credits are <i>Office 2016 All-in-One For Dummies</i> and <i>Windows 10 For Seniors For Dummies</i>, both top sellers in their respective categories. </p>","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":"Peter Weverka is a veteran technology author with dozens of books to his credit. In addition to previous editions of Office All-in-One For Dummies, he has written books on PowerPoint, OneNote, Word, and Quicken, as well as the bestselling Windows 10 For Seniors For Dummies.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9034"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513278&quot;]}]\" id=\"du-slot-623e57c03071a\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513278&quot;]}]\" id=\"du-slot-623e57c031090\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":255550,"title":"Speedy Ways to Open Office 2019 Files","slug":"speedy-ways-to-open-office-2019-files","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255550"}},{"articleId":255553,"title":"Customize the Office 2019 Quick Access Toolbar","slug":"customize-the-office-2019-quick-access-toolbar","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255553"}},{"articleId":255556,"title":"Change the Background and Color Schemes of the Office 2019 Applications","slug":"change-the-background-and-color-schemes-of-the-office-2019-applications","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255556"}}],"content":[{"title":"Speedy ways to open Office 2019 files","thumb":null,"image":null,"content":"<p>In the interest of getting to work faster, Office 2019 (and Windows 10) offers these speed techniques for opening files:</p>\n<ul>\n<li><strong>Backstage:</strong> Click the File tab in any Office application to open what Microsoft calls the backstage. From there, you can quickly open files:\n<ul>\n<li>On the Home window (go to the Home category), click the name of a file in the Recent list or Pinned list. The Recent list shows the names of files you recently opened. The Pinned list shows the names of files you deemed important enough to &#8220;pin.&#8221; To pin a file, click its push-pin icon.</li>\n<li>On the Open screen (go to the Open category), click the name of a file in the Pinned list or Recent list. The Pinned list appears at the top of the window. Scroll through files on the Recent list to find one you worked on recently.</li>\n</ul>\n</li>\n<li><strong>Windows Start screen</strong>: This screen (which appears when you click the Start button in the lower-left corner of the screen) offers a means of quickly opening files. Scroll to the name of an Office application and right-click its name. A pop-up menu appears. Under the word <em>Recent</em> on the menu are the names of files you recently opened. Click the name of a file to open it.</li>\n<li><strong>Windows taskbar:</strong> Right-click an Office application icon on the taskbar to see a list of files you recently opened. Then select the name of a file. The taskbar is located along the bottom of the Windows screen.</li>\n<li><strong>Ctrl+N:</strong> To open a new file in any Office application, press Ctrl+N. Pressing this keyboard shortcut opens a blank, default file.</li>\n</ul>\n"},{"title":"Customize the Office 2019 Quick Access toolbar","thumb":null,"image":null,"content":"<p>The Quick Access toolbar is always there in the upper-left corner of Office applications. This toolbar offers the AutoSave, Save, Undo, and Redo buttons, as well as the Touch/Mouse Mode button if your computer has a touchscreen. Put your favorite buttons on the Quick Access toolbar to keep them within reach:</p>\n<ul>\n<li>Right-click a button and choose Add to Quick Access Toolbar on the shortcut menu.</li>\n<li>Click the Customize Quick Access Toolbar button (located to the right of the Quick Access toolbar) and choose a button name on the drop-down list.</li>\n</ul>\n<p>If you change your mind about putting a button on the Quick Access toolbar, right-click the button and choose Remove from Quick Access toolbar on the shortcut menu.</p>\n"},{"title":"Change the background and color schemes of the Office 2019 applications","thumb":null,"image":null,"content":"<p>Want to play interior decorator with Word, Excel, PowerPoint, Outlook, Access, and Publisher? Follow these steps to change the look of the Office 2019 application screens:</p>\n<ol>\n<li><strong>In any Office application, go to the File tab and choose Account.</strong><br />\nThe Account window opens.</li>\n<li><strong>Choose an Office Background option.</strong><br />\nThese options — Clouds, Spring, Underwater, and others — place a faint design motif in the upper-right corner of screens.</li>\n<li><strong>Choose an Office Theme option.</strong><br />\nThese options — Colorful, Dark Gray, Black, and White — change the overall color of Office screens. If you choose the Colorful option, each Office application appears in a different color. For example, the Word screen is blue; the PowerPoint screen is red.</li>\n</ol>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Two years","lifeExpectancySetFrom":"2022-03-25T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":255559},{"headers":{"creationTime":"2022-03-17T18:33:43+00:00","modifiedTime":"2022-03-17T19:24:03+00:00","timestamp":"2022-03-18T00:01:13+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General (Microsoft)","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"Office 2021 For Macs For Dummies Cheat Sheet","strippedTitle":"office 2021 for macs for dummies cheat sheet","slug":"office-2021-for-macs-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Keep this Cheat Sheet handy for quick tips on Microsoft Office apps, including Outlook, Word, and PowerPoint.","noIndex":0,"noFollow":0},"content":"Microsoft Office apps are chock full of options and features that are just too tough to squeeze into the pages of a single book.\r\n\r\nThis cheat sheet includes a handful of helpful tips and tricks to give your Office experience a boost, including learning how to create automatic replies to senders, check your documents for accessibility issues, embed fonts in your Word documents and PowerPoint presentations for better portability when sharing, and even check the current weather when perusing your Outlook Calendar.","description":"Microsoft Office apps are chock full of options and features that are just too tough to squeeze into the pages of a single book.\r\n\r\nThis cheat sheet includes a handful of helpful tips and tricks to give your Office experience a boost, including learning how to create automatic replies to senders, check your documents for accessibility issues, embed fonts in your Word documents and PowerPoint presentations for better portability when sharing, and even check the current weather when perusing your Outlook Calendar.","blurb":"","authors":[{"authorId":8989,"name":"Bob LeVitus","slug":"bob-levitus","description":"Bob \"Dr. Mac\" LeVitus has been writing the \"Dr. Mac\" column for the Houston Chronicle for more than 20 years. A regular contributor to a variety of technology publications, he's a proud Mac aficionado who's written or co-written more than 85 how-to books on all things Mac, including multiple Mac operating systems, the iPhone, the iPad, Office for the Mac, and GarageBand. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/8989"}},{"authorId":9260,"name":"Dwight Spivey","slug":"dwight-spivey","description":"Dwight Spivey has been a technical author and editor for over a decade, drawing on his talent for explaining technology to ordinary humans. He works as an educational technology administrator at Spring Hill College in Alabama. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9260"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General (Microsoft)","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[],"fromCategory":[{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290233"}},{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290196"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289688"}},{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}},{"articleId":265311,"title":"How to Change a Chart's Appearance in Office 365","slug":"how-to-change-a-charts-appearance-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265311"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":291207,"slug":"office-2021-for-macs-for-dummies","isbn":"9781119840442","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119840449/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119840449/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119840449-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119840449/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119840449/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/9781119840442-203x255.jpg","width":203,"height":255},"title":"Office 2021 for Macs For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"\n <p>Bob \"Dr. Mac\" LeVitus has been writing the \"Dr. Mac\" column for the Houston Chronicle for more than 20 years. A regular contributor to a variety of technology publications, he's a proud Mac aficionado who's written or co-written more than 85 how-to books on all things Mac, including multiple Mac operating systems, the iPhone, the iPad, Office for the Mac, and GarageBand. <b data-author-id=\"9260\">Dwight Spivey</b> has been a technical author and editor for over a decade, drawing on his talent for explaining technology to ordinary humans. He works as an educational technology administrator at Spring Hill College in Alabama.</p>","authors":[{"authorId":8989,"name":"Bob LeVitus","slug":"bob-levitus","description":"Bob \"Dr. Mac\" LeVitus has been writing the \"Dr. Mac\" column for the Houston Chronicle for more than 20 years. A regular contributor to a variety of technology publications, he's a proud Mac aficionado who's written or co-written more than 85 how-to books on all things Mac, including multiple Mac operating systems, the iPhone, the iPad, Office for the Mac, and GarageBand. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/8989"}},{"authorId":9260,"name":"Dwight Spivey","slug":"dwight-spivey","description":"Dwight Spivey has been a technical author and editor for over a decade, drawing on his talent for explaining technology to ordinary humans. He works as an educational technology administrator at Spring Hill College in Alabama. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9260"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119840442&quot;]}]\" id=\"du-slot-6233cbc933d4e\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119840442&quot;]}]\" id=\"du-slot-6233cbc9346c9\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":0,"title":"","slug":null,"categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/"}}],"content":[{"title":"Send automatic out-of-office replies from Outlook ","thumb":null,"image":null,"content":"<p>If you’re going to be away from your email for a bit (perhaps you’re going on vacation or taking the weekend off) and don’t want to leave folks waiting breathlessly for your reply, set up Outlook to automatically send an out-of-office reply to let them know you’ll be back in touch at a particular time.</p>\n<p>For Exchange and Outlook.com accounts:</p>\n<ol>\n<li>Click the Mail button in the lower left of the navigation pane (if you’re not in Mail already), and then select the account for which you want to set up automatic replies.</li>\n<li>On the Ribbon’s Tools tab, click the Out of Office button.</li>\n<li>In the Automatic Replies dialog, select the Send Automatic Replies for Account <em>email address</em> box.</li>\n<li>Under Reply Once to Senders within My Organization, enter the text of your automatic reply.</li>\n<li>To set start and end dates for automatic replies, select the Send Replies Only during This Time Period box, and add the start and end dates and times.</li>\n<li>If you want to send automatic replies to those outside your organization, click to select the Send Replies Outside My Organization box, select either the Send Only to My Contacts or the Send to All External Senders option, and then add the text of your automatic reply in the Reply Once to Senders Outside My Organization box.</li>\n<li>Click OK to set up the automatic replies for this account.</li>\n<li>Repeat Steps 1 to 7 for other Exchange or Outlook.com accounts as necessary.</li>\n</ol>\n<p>To disable automatic replies, select the account in the navigation pane, click the Out of Office button in the Tools tab of the ribbon, and deselect the Send Automatic Replies for Account <em>email address</em> box.</p>\n<p>Note that these steps apply to only Exchange and Outlook.com email accounts. If you want to set up automatic replies for other types of accounts, it’s best to do so using their instructions and their web-based interfaces.</p>\n<p>If you use Outlook to set automatic replies for other account types, you must set up rules to do so. This means you’ll need to leave your computer on and Outlook open for Outlook to be able to apply the rules to incoming messages, and chances are extremely slim you’ll want to do that if you plan to be away for a while.</p>\n"},{"title":"Use the accessibility checker in Office apps","thumb":null,"image":null,"content":"<p>It’s best practice (and just plain nice) to make certain that everyone, including people with disabilities, receiving your documents, spreadsheets, presentations, and emails can read and edit them as intended. Microsoft has included an accessibility checker for just such a purpose.</p>\n<p>To use this great tool:</p>\n<ol>\n<li><strong> In Word, Excel, or PowerPoint, click the ribbon’s Review tab and click the Check Accessibility button.</strong></li>\n</ol>\n<p>When creating an email or replying to one while using Outlook, click the ribbon’s Options tab and click the Check Accessibility button.</p>\n<ol start=\"2\">\n<li><strong> A list of results will appear, along with any potential errors and warnings.</strong> The Accessibility Checker provides recommendations to help resolve each issue.</li>\n<li><strong> Click an error or warning to see why it may create a problem for someone, as well as how you can fix it.</strong></li>\n</ol>\n"},{"title":"Embed fonts in Word and PowerPoint files","thumb":null,"image":null,"content":"<p>Sometimes, sharing documents and presentations with others can be a precarious proposition, especially if they don’t have the same fonts installed on their Mac or PC as you do.</p>\n<p>Thankfully, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, and PowerPoint 2021 for Mac allow you the option of embedding your fonts so that they travel with the file. This feature helps retain the fonts, layout, and styling of your document or presentation.</p>\n<p>Note that you must be a Microsoft 365 subscriber or have PowerPoint 2021 for Mac to take advantage of this cool feature.</p>\n<p>To embed fonts in a file:</p>\n<ol>\n<li>Click either Word or PowerPoint (depending on which app you’re using) in the menu at the top of the screen and select Preferences.</li>\n<li>in the Output and Sharing section of Preferences, click Save.</li>\n<li>Click to select the box entitled Embed Fonts in the File (near the bottom of the dialog in the Font Embedding section).</li>\n</ol>\n<p>It’s best not to select Embed only the Characters Used in the Document (Word) or Presentation (PowerPoint).</p>\n<ol start=\"4\">\n<li>Close the Preferences dialog and save the file.</li>\n</ol>\n<p>The fonts you’ve used in the file are embedded as part of the saved file.</p>\n<p>Note that if you want to keep your files as small as possible, it’s best to use OpenType (.OTF) or TrueType (.TTF) fonts in your documents and presentations.</p>\n"},{"title":"Check the weather in Outlook","thumb":null,"image":null,"content":"<p>Knocking out email after email and wondering what the world might be like outside your door? Outlook can give you a quick heads up by displaying the current weather for you in Calendar view.</p>\n<p>To check the weather in Outlook:</p>\n<ol>\n<li>Click the Calendar button at the bottom left of the navigation pane.</li>\n</ol>\n<p>The current weather appears toward the upper right of the Outlook window (just above your events listing).</p>\n<ol start=\"2\">\n<li>Click the current weather icon (or hover your cursor over it for just a second) to view a few more details, such as wind speed, humidity, and precipitation for your area.</li>\n<li>Click the See More Online link to view much more detailed weather info, including weather radar and a forecast, on MSN.com.</li>\n<li>Close the Preferences dialog when finished.</li>\n</ol>\n<p>If you want to turn this feature off, choose Outlook→Preferences from the menu, click Calendar, and then deselect the Show Current Weather on Calendar box in the Weather section at the bottom of the dialog.</p>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2022-03-17T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":291623},{"headers":{"creationTime":"2018-09-12T20:20:07+00:00","modifiedTime":"2022-03-15T20:20:30+00:00","timestamp":"2022-03-16T00:01:10+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General (Microsoft)","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"Microsoft Office 2019 For Dummies Cheat Sheet","strippedTitle":"microsoft office 2019 for dummies cheat sheet","slug":"microsoft-office-2019-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"","noIndex":0,"noFollow":0},"content":"Microsoft Office 2019 comes jam-packed with features. This Cheat Sheet can help you navigate around those features easier by providing keyboard shortcuts and tips for using the mouse, and ribbon to get fast access to the most commonly used commands. You’ll master Office 2019 in no time!","description":"Microsoft Office 2019 comes jam-packed with features. This Cheat Sheet can help you navigate around those features easier by providing keyboard shortcuts and tips for using the mouse, and ribbon to get fast access to the most commonly used commands. You’ll master Office 2019 in no time!","blurb":"","authors":[{"authorId":9043,"name":"Wallace Wang","slug":"wallace-wang","description":"Wallace Wang is a stand-up comedian and the author of more than 10 best-selling For Dummies books. He focuses on screenwriting, movies, and comedy.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9043"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General (Microsoft)","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":258146,"title":"10 Ways to Make Office 2019 Easier to Use","slug":"10-ways-to-make-office-2019-easier-to-use","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258146"}},{"articleId":258139,"title":"Access Report Design: Applying Themes and Conditional Formatting in Access 2019","slug":"access-report-design-applying-themes-and-conditional-formatting-in-access-2019","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258139"}},{"articleId":258132,"title":"Access 2019 Reports: Editing the Data in a Report","slug":"access-2019-reports-editing-the-data-in-a-report","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258132"}},{"articleId":258092,"title":"How to Use the Report Wizard in Access 2019","slug":"how-to-use-the-report-wizard-in-access-2019","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258092"}},{"articleId":258013,"title":"10 Useful Features in Office 2019","slug":"10-useful-features-in-office-2019","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258013"}}],"fromCategory":[{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290233"}},{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290196"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289688"}},{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}},{"articleId":265311,"title":"How to Change a Chart's Appearance in Office 365","slug":"how-to-change-a-charts-appearance-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265311"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281802,"slug":"office-2019-for-dummies","isbn":"9781119513988","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119513987/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119513987/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119513987-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119513987/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119513987/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/office-2019-for-dummies-cover-9781119513988-203x255.jpg","width":203,"height":255},"title":"Office 2019 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n \t <p><b data-author-id=\"9043\">Wallace Wang</b> is the bestselling author of more than 50 computer books, with over three million of his <i>For Dummies</i> books in print. They include numerous versions of <i>Office For Dummies</i> as well as <i>Beginning Programming For Dummies</i>. When not playing with computers, Wallace splits his time between teaching, writing, game designing, screenwriting, and stand-up comedy. </p>","authors":[{"authorId":9043,"name":"Wallace Wang","slug":"wallace-wang","description":"Wallace Wang is a stand-up comedian and the author of more than 10 best-selling For Dummies books. He focuses on screenwriting, movies, and comedy.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9043"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513988&quot;]}]\" id=\"du-slot-623128c6a598c\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513988&quot;]}]\" id=\"du-slot-623128c6a6305\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":255427,"title":"Microsoft Office 2019 Keyboard Shortcuts","slug":"microsoft-office-2019-keyboard-shortcuts","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255427"}},{"articleId":255430,"title":"Microsoft Office 2019 Mouse Button Functions","slug":"microsoft-office-2019-mouse-button-functions","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255430"}},{"articleId":255433,"title":"Microsoft Office 2019 Ribbon Tabs","slug":"microsoft-office-2019-ribbon-tabs","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255433"}}],"content":[{"title":"Office 2019 keyboard shortcuts","thumb":null,"image":null,"content":"<p>Microsoft Office 2019 provides hundreds of commands, but you’ll likely only use a handful of those commands on a regular basis. To save time, use these Office 2019 keyboard shortcuts. With little effort, you can open files, find content, edit that content, and more.</p>\n<table>\n<tbody>\n<tr>\n<td width=\"295\"><strong>Function</strong></td>\n<td width=\"111\"><strong>Keystroke</strong></td>\n</tr>\n<tr>\n<td width=\"295\">Copy</td>\n<td width=\"111\">Ctrl+C</td>\n</tr>\n<tr>\n<td width=\"295\">Cut</td>\n<td width=\"111\">Ctrl+X</td>\n</tr>\n<tr>\n<td width=\"295\">Find</td>\n<td width=\"111\">Ctrl+F</td>\n</tr>\n<tr>\n<td width=\"295\">Go To</td>\n<td width=\"111\">Ctrl+G</td>\n</tr>\n<tr>\n<td width=\"295\">Help</td>\n<td width=\"111\">F1</td>\n</tr>\n<tr>\n<td width=\"295\">Hyperlink</td>\n<td width=\"111\">Ctrl+K</td>\n</tr>\n<tr>\n<td width=\"295\">New</td>\n<td width=\"111\">Ctrl+N</td>\n</tr>\n<tr>\n<td width=\"295\">Open</td>\n<td width=\"111\">Ctrl+O</td>\n</tr>\n<tr>\n<td width=\"295\">Paste</td>\n<td width=\"111\">Ctrl+V</td>\n</tr>\n<tr>\n<td width=\"295\">Print</td>\n<td width=\"111\">Ctrl+P</td>\n</tr>\n<tr>\n<td width=\"295\">Replace</td>\n<td width=\"111\">Ctrl+H</td>\n</tr>\n<tr>\n<td width=\"295\">Save</td>\n<td width=\"111\">Ctrl+S</td>\n</tr>\n<tr>\n<td width=\"295\">Select All</td>\n<td width=\"111\">Ctrl+A</td>\n</tr>\n<tr>\n<td width=\"295\">Spell Check</td>\n<td width=\"111\">F7</td>\n</tr>\n<tr>\n<td width=\"295\">Undo</td>\n<td width=\"111\">Ctrl+Z</td>\n</tr>\n<tr>\n<td width=\"295\">Redo</td>\n<td width=\"111\">Ctrl+Y</td>\n</tr>\n</tbody>\n</table>\n<p>&nbsp;</p>\n"},{"title":"Mouse button functions","thumb":null,"image":null,"content":"<p>You can control Microsoft Office 2019 with your mouse or your keyboard. The mouse actions in this table work whether you’re using Word, Excel, Access, PowerPoint, or Outlook.</p>\n<table width=\"522\">\n<tbody>\n<tr>\n<td width=\"174\"><strong>Mouse Button Used</strong></td>\n<td width=\"174\"><strong>Action</strong></td>\n<td width=\"174\"><strong>Purpose</strong></td>\n</tr>\n<tr>\n<td width=\"174\">Left mouse button</td>\n<td width=\"174\">Click</td>\n<td width=\"174\">Moves the cursor, highlights an object, pulls down a menu, or chooses a menu command</td>\n</tr>\n<tr>\n<td width=\"174\">Left mouse button</td>\n<td width=\"174\">Double-click</td>\n<td width=\"174\">Highlights a word or edits an embedded object</td>\n</tr>\n<tr>\n<td width=\"174\">Left mouse button</td>\n<td width=\"174\">Triple-click</td>\n<td width=\"174\">Highlights a paragraph</td>\n</tr>\n<tr>\n<td width=\"174\">Left mouse button</td>\n<td width=\"174\">Drag</td>\n<td width=\"174\">Moves an object, resizes an object, highlights text, or highlights multiple objects</td>\n</tr>\n<tr>\n<td width=\"174\">Wheel mouse button</td>\n<td width=\"174\">Click</td>\n<td width=\"174\">Automatically scrolls a document when you move the mouse up or down</td>\n</tr>\n<tr>\n<td width=\"174\">Wheel mouse button</td>\n<td width=\"174\">Roll</td>\n<td width=\"174\">Scrolls a document up or down</td>\n</tr>\n<tr>\n<td width=\"174\">Right mouse button</td>\n<td width=\"174\">Right-click</td>\n<td width=\"174\">Displays a shortcut pop-up menu</td>\n</tr>\n</tbody>\n</table>\n<p>&nbsp;</p>\n"},{"title":"Office 2019 ribbon tabs","thumb":null,"image":null,"content":"<p>Microsoft Office 2019 displays commands in a series of icons stored on different tabs. This combination of icons and tabs is known as the Ribbon interface, which appears in Word, PowerPoint, Excel, Outlook, and Access.</p>\n<p>The following tables show the commands grouped under each ribbon tab for each of the five programs.</p>\n<p>Here are the commands for Microsoft Word 2019:</p>\n<table width=\"522\">\n<tbody>\n<tr>\n<td width=\"174\"><strong>Ribbon Tab Name</strong></td>\n<td width=\"174\"><strong>Command Groups</strong></td>\n<td width=\"174\"><strong>Dialog Box Shortcut Key</strong></td>\n</tr>\n<tr>\n<td width=\"174\">Home</td>\n<td width=\"174\">Clipboard, Font, Paragraph, Styles, and Editing</td>\n<td width=\"174\">Ctrl+D (Font) Alt+Ctrl+Shift+S (Styles)</td>\n</tr>\n<tr>\n<td width=\"174\">Insert</td>\n<td width=\"174\">Pages, Tables, Illustrations, Add-ins, Media, Links, Comments, Header &amp; Footer, Text, and Symbols</td>\n<td width=\"174\"></td>\n</tr>\n<tr>\n<td width=\"174\">Draw</td>\n<td width=\"174\">Tools, Pens, and Convert</td>\n<td width=\"174\"></td>\n</tr>\n<tr>\n<td width=\"174\">Design</td>\n<td width=\"174\">Document Formatting and Page Background</td>\n<td width=\"174\"></td>\n</tr>\n<tr>\n<td width=\"174\">Layout</td>\n<td width=\"174\">Page Setup, Paragraph, and Arrange</td>\n<td width=\"174\"></td>\n</tr>\n<tr>\n<td width=\"174\">References</td>\n<td width=\"174\">Table of Contents, Footnotes, Research, Citations &amp; Bibliography, Captions, Index, and Table of Authorities</td>\n<td width=\"174\"></td>\n</tr>\n<tr>\n<td width=\"174\">Mailings</td>\n<td width=\"174\">Create, Start Mail Merge, Write &amp; Insert Fields, Preview Results, and Finish</td>\n<td width=\"174\"></td>\n</tr>\n<tr>\n<td width=\"174\">Review</td>\n<td width=\"174\">Proofing, Speech, Accessibility, Language, Comments, Tracking, Changes, Compare, Protect, and OneNote</td>\n<td width=\"174\"></td>\n</tr>\n<tr>\n<td width=\"174\">View</td>\n<td width=\"174\">Views, Immersive, Page Movement, Show, Zoom, Window, Macros, and SharePoint</td>\n<td width=\"174\"></td>\n</tr>\n</tbody>\n</table>\n<p>&nbsp;</p>\n<p>Here are the useful things you should know for Excel 2019:</p>\n<table width=\"590\">\n<tbody>\n<tr>\n<td width=\"197\"><strong>Ribbon Tab Name</strong></td>\n<td width=\"197\"><strong>Command Groups</strong></td>\n<td width=\"197\"><strong>Dialog Box Shortcut Key</strong></td>\n</tr>\n<tr>\n<td width=\"197\">Home</td>\n<td width=\"197\">Clipboard, Font, Alignment, Number, Styles, Cells, and Editing</td>\n<td width=\"197\">Ctrl+Shift+F (Format Cells)</td>\n</tr>\n<tr>\n<td width=\"197\">Insert</td>\n<td width=\"197\">Tables, Illustrations, Add-ins, Charts, Tours, Sparklines, Filter, Links, and Symbols</td>\n<td width=\"197\"></td>\n</tr>\n<tr>\n<td width=\"197\">Draw</td>\n<td width=\"197\">Tools, Pens, and Convert</td>\n<td width=\"197\"></td>\n</tr>\n<tr>\n<td width=\"197\">Page Layout</td>\n<td width=\"197\">Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange</td>\n<td width=\"197\"></td>\n</tr>\n<tr>\n<td width=\"197\">Formulas</td>\n<td width=\"197\">Function Library, Defined Names, Formula Auditing, and Calculation</td>\n<td width=\"197\"></td>\n</tr>\n<tr>\n<td width=\"197\">Data</td>\n<td width=\"197\">Get &amp; Transform, Queries &amp; Connections, Sort &amp; Filter, Data Tools, Forecast, and Outline</td>\n<td width=\"197\"></td>\n</tr>\n<tr>\n<td width=\"197\">Review</td>\n<td width=\"197\">Proofing, Accessibility, Insights, Language, Comments, and Protect</td>\n<td width=\"197\"></td>\n</tr>\n<tr>\n<td width=\"197\">View</td>\n<td width=\"197\">Workbook Views, Show, Zoom, Window, and Macros</td>\n<td width=\"197\"></td>\n</tr>\n</tbody>\n</table>\n<p>&nbsp;</p>\n<p>Here are the Microsoft PowerPoint commands that you should know:</p>\n<table width=\"590\">\n<tbody>\n<tr>\n<td width=\"295\"><strong>Ribbon Tab Name</strong></td>\n<td width=\"295\"><strong>Command Groups</strong></td>\n</tr>\n<tr>\n<td width=\"295\">Home</td>\n<td width=\"295\">Clipboard, Slides, Font, Paragraph, Drawing, and Editing</td>\n</tr>\n<tr>\n<td width=\"295\">Insert</td>\n<td width=\"295\">Slides, Tables, Images, Illustrations, Add-ins, Links, Comments, Text, Symbols, and Media</td>\n</tr>\n<tr>\n<td width=\"295\">Draw</td>\n<td width=\"295\">Tools, Pens, Stencils, and Convert</td>\n</tr>\n<tr>\n<td width=\"295\">Design</td>\n<td width=\"295\">Themes, Variants, and Customize</td>\n</tr>\n<tr>\n<td width=\"295\">Transitions</td>\n<td width=\"295\">Preview, Transition To This Slide, and Timing</td>\n</tr>\n<tr>\n<td width=\"295\">Animations</td>\n<td width=\"295\">Preview, Animation, Advanced Animation, and Timing</td>\n</tr>\n<tr>\n<td width=\"295\">Slide Show</td>\n<td width=\"295\">Start Slide Show, Set Up, and Monitors</td>\n</tr>\n<tr>\n<td width=\"295\">Review</td>\n<td width=\"295\">Proofing, Accessibility, Insights, Language, Comments, Compare and OneNote</td>\n</tr>\n<tr>\n<td width=\"295\">View</td>\n<td width=\"295\">Presentation Views, Master Views, Show, Zoom, Color/Grayscale, Window, and Macros</td>\n</tr>\n</tbody>\n</table>\n<p>&nbsp;</p>\n<p>This list wouldn’t be complete without these useful Outlook 2019 commands:</p>\n<table width=\"590\">\n<tbody>\n<tr>\n<td width=\"295\"><strong>Ribbon Tab Name</strong></td>\n<td width=\"295\"><strong>Command Groups</strong></td>\n</tr>\n<tr>\n<td width=\"295\">Home (Mail)</td>\n<td width=\"295\">New, Delete, Respond, Quick Steps, Move, Tags, Find, and Send/Receive</td>\n</tr>\n<tr>\n<td width=\"295\">Send/Receive (Mail)</td>\n<td width=\"295\">Send &amp; Receive, Download, Server, and Preferences</td>\n</tr>\n<tr>\n<td width=\"295\">Folder (Mail)</td>\n<td width=\"295\">New, Actions, Clean Up, Favorites, IMAP, and Properties</td>\n</tr>\n<tr>\n<td width=\"295\">View (Mail)</td>\n<td width=\"295\">Current View, Messages, Arrangement, Layout, People Pane, and Window</td>\n</tr>\n<tr>\n<td width=\"295\">Home (Calendar)</td>\n<td width=\"295\">New, Skype Meeting, Go To, Arrange, Manage Calendars, Share, and Find</td>\n</tr>\n<tr>\n<td width=\"295\">Send/Receive (Calendar)</td>\n<td width=\"295\">Send &amp; Receive, Download, and Preferences</td>\n</tr>\n<tr>\n<td width=\"295\">Folder (Calendar)</td>\n<td width=\"295\">New, Actions, Share, and Properties</td>\n</tr>\n<tr>\n<td width=\"295\">View (Calendar)</td>\n<td width=\"295\">Current View, Arrangement, Color, Layout, People Pane, and Window</td>\n</tr>\n<tr>\n<td width=\"295\">Home (Contacts)</td>\n<td width=\"295\">New, Delete, Communicate, Current View, Actions, Share, Tags, and Find</td>\n</tr>\n<tr>\n<td width=\"295\">Send/Receive (Contacts)</td>\n<td width=\"295\">Send &amp; Receive, Download, and Preferences</td>\n</tr>\n<tr>\n<td width=\"295\">Folder (Contacts)</td>\n<td width=\"295\">New, Actions, Share, and Properties</td>\n</tr>\n<tr>\n<td width=\"295\">View (Contacts)</td>\n<td width=\"295\">Current View, Arrangement, Layout, People Pane, and Window</td>\n</tr>\n<tr>\n<td width=\"295\">Home (Tasks)</td>\n<td width=\"295\">New, Delete, Respond, Manage Task, Follow Up, Current View, Actions, Tags, and Find</td>\n</tr>\n<tr>\n<td width=\"295\">Send/Receive (Tasks)</td>\n<td width=\"295\">Send &amp; Receive, Download, and Preferences</td>\n</tr>\n<tr>\n<td width=\"295\">Folder (Tasks)</td>\n<td width=\"295\">New, Actions, Share, and Properties</td>\n</tr>\n<tr>\n<td width=\"295\">View (Tasks)</td>\n<td width=\"295\">Current View, Arrangement, Layout, People Pane, and Window</td>\n</tr>\n</tbody>\n</table>\n<p>And finally, don’t forget these handy Microsoft Access 2019 commands:</p>\n<table width=\"590\">\n<tbody>\n<tr>\n<td width=\"295\"><strong>Ribbon Tab Name</strong></td>\n<td width=\"295\"><strong>Command Groups</strong></td>\n</tr>\n<tr>\n<td width=\"295\">Home</td>\n<td width=\"295\">Views, Clipboard, Sort &amp; Filter, Records, Find, and Text Formatting</td>\n</tr>\n<tr>\n<td width=\"295\">Create</td>\n<td width=\"295\">Templates, Tables, Queries, Forms, Reports, and Macros &amp; Code</td>\n</tr>\n<tr>\n<td width=\"295\">External Data</td>\n<td width=\"295\">Import &amp; Link and Export</td>\n</tr>\n<tr>\n<td width=\"295\">Database Tools</td>\n<td width=\"295\">Tools, Macro, Relationships, Analyze, Move Data, and Add-Ins</td>\n</tr>\n</tbody>\n</table>\n<p>&nbsp;</p>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Two years","lifeExpectancySetFrom":"2022-03-15T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":255436},{"headers":{"creationTime":"2016-03-27T16:52:39+00:00","modifiedTime":"2022-02-24T18:50:54+00:00","timestamp":"2022-02-25T00:01:03+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General (Microsoft)","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"Office 365 For Dummies Cheat Sheet","strippedTitle":"office 365 for dummies cheat sheet","slug":"microsoft-office-365-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Office 365 can be tricky to learn, but it's not impossible. This guide explains the key services, productivity tools, and security features in Office 365 so you can easily navigate the technology.","noIndex":0,"noFollow":0},"content":"Millions of users have realized the value of Office 365. Making the best use of the services that make up Office 365, however, can be a challenge. This guide is a quick reference to the key services, productivity tools, and security features in Office 365 to help you maximize your investment in the technology.","description":"Millions of users have realized the value of Office 365. Making the best use of the services that make up Office 365, however, can be a challenge. This guide is a quick reference to the key services, productivity tools, and security features in Office 365 to help you maximize your investment in the technology.","blurb":"","authors":[{"authorId":10888,"name":"Rosemarie Withee","slug":"rosemarie-withee","description":"Rosemarie Withee is a technology professional who has authored a number of books in the For Dummies series, including the most recent editions of Office 365 For Dummies and SharePoint For Dummies. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10888"}},{"authorId":9718,"name":"Ken Withee","slug":"ken-withee","description":"Ken Withee is a Microsoft certified technology specialist in SharePoint, SQL Server, and .NET.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9718"}},{"authorId":10015,"name":"Jennifer Reed","slug":"jennifer-reed","description":"Jennifer Reed is the founder of Cloud611, an IT services company that helps small and midsize businesses take advantage of cloud technologies to drive business outcomes. As a solutions architect, Reed has helped migrate thousands of users to Office 365.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10015"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General (Microsoft)","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":259020,"title":"How to Use Microsoft Teams","slug":"how-to-use-microsoft-teams","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259020"}},{"articleId":259010,"title":"Office 365: Building Reports with Power BI","slug":"office-365-building-reports-with-power-bi","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259010"}},{"articleId":259000,"title":"Working Efficiently with Office 365 Online","slug":"working-efficiently-with-office-365-online","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259000"}},{"articleId":258986,"title":"Office 365 on Mobile: Apps that Keep You Going","slug":"office-365-on-mobile-apps-that-keep-you-going","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258986"}},{"articleId":258981,"title":"What is Microsoft SharePoint: A Brief Tour","slug":"what-is-microsoft-sharepoint-a-brief-tour","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258981"}}],"fromCategory":[{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290233"}},{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290196"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289688"}},{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}},{"articleId":265311,"title":"How to Change a Chart's Appearance in Office 365","slug":"how-to-change-a-charts-appearance-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265311"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281805,"slug":"office-365-for-dummies-3rd-edition","isbn":"9781119513353","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119513359/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119513359/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119513359-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119513359/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119513359/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/office-365-for-dummies-3rd-edition-cover-9781119513353-203x255.jpg","width":203,"height":255},"title":"Office 365 For Dummies, 3rd Edition","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n <p><b data-author-id=\"10888\">Rosemarie Withee</b> is President of Portal Integrators and Founder of Scrum Now with office in Seattle, WA and Laguna, Philippines. <b data-author-id=\"9718\">Ken Withee</b> is a Microsoft Certified Technology Specialist in SharePoint, SQL Server, and .NET. <b data-author-id=\"10015\">Jennifer Reed</b> is a Microsoft Certified Professional in Office 365 Administration and founder of Cloud611. </p>","authors":[{"authorId":10888,"name":"Rosemarie Withee","slug":"rosemarie-withee","description":"Rosemarie Withee is a technology professional who has authored a number of books in the For Dummies series, including the most recent editions of Office 365 For Dummies and SharePoint For Dummies. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10888"}},{"authorId":9718,"name":"Ken Withee","slug":"ken-withee","description":"Ken Withee is a Microsoft certified technology specialist in SharePoint, SQL Server, and .NET.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9718"}},{"authorId":10015,"name":"Jennifer Reed","slug":"jennifer-reed","description":"Jennifer Reed is the founder of Cloud611, an IT services company that helps small and midsize businesses take advantage of cloud technologies to drive business outcomes. As a solutions architect, Reed has helped migrate thousands of users to Office 365.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10015"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513353&quot;]}]\" id=\"du-slot-62181c3fd00ba\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513353&quot;]}]\" id=\"du-slot-62181c3fd0a7f\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":256080,"title":"The Office 365 Productivity Features","slug":"the-office-365-productivity-features","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/256080"}},{"articleId":256082,"title":"The Security Features in Office 365","slug":"the-security-features-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/256082"}},{"articleId":256084,"title":"How to Work Together in Office 365","slug":"how-to-work-together-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/256084"}}],"content":[{"title":"The Office 365 productivity features ","thumb":null,"image":null,"content":"<div id=\"article-content-wrapper\" data-v-89b5964a=\"\" data-v-76ccd6ad=\"\">\n<article class=\"article-content\" data-v-89b5964a=\"\" data-testid=\"articleContent\">The Office 365 service offering from Microsoft encompasses several productivity technologies that have been woven together to provide a seamless solution in the cloud for a modern workplace. Use this reference to get an overview of the four key technologies in Office 365 and understand how they enhance collaboration in the workplace.</p>\n<table width=\"663\">\n<tbody>\n<tr>\n<td width=\"330\"><strong>Component</strong></td>\n<td width=\"333\"><strong>Description</strong></td>\n</tr>\n<tr>\n<td width=\"330\">SharePoint Online</td>\n<td width=\"333\">SharePoint Online serves as the platform for team- and project-focused collaboration needs. The intranet capabilities in SharePoint Online deliver capabilities in a way that harnesses the collective knowledge of the people in the organization to not only inform and engage employees, but also to transform business processes.</td>\n</tr>\n<tr>\n<td width=\"330\">Exchange Online</td>\n<td width=\"333\">The technology that ensures email lands in your mailbox in Outlook, captures appointments and meetings in your calendar, lets you stay in touch with your contacts, and helps you stay organized with tasks, is a service in Office 365 called Exchange Online. This service also powers your web-based email and provides a robust layer of security to safeguard data in Office 365.</td>\n</tr>\n<tr>\n<td width=\"330\">Microsoft Teams</td>\n<td width=\"333\">Teams is a digital hub for teamwork. It is a persistent chat-based workspace that incorporates all the bells and whistles of modern collaboration: chats, meetings, audio conferencing, web conferencing, file sharing, social media–like interactions, third-party tool integration, and even the addition of a chatbots to help you get work done!</td>\n</tr>\n<tr>\n<td width=\"330\">Office Online</td>\n<td width=\"333\">Office Online is the cloud version of Microsoft Word, Excel, PowerPoint, OneNote, and Outlook. The apps allow users to create high-quality documents, simultaneously make changes to the documents with coauthors, and share these documents from a browser without the need for the desktop application. With an internet connection and a browser running most common devices, you can edit your documents and even quickly pick up from where you left off in your last session.</td>\n</tr>\n</tbody>\n</table>\n</article>\n</div>\n<div class=\"about-article-section\" data-v-2c35db38=\"\" data-v-76ccd6ad=\"\">\n<h2 class=\"h3 section-title\" data-v-2c35db38=\"\" data-testid=\"aboutArticleHead\"></h2>\n</div>\n"},{"title":"The security features in Office 365 ","thumb":null,"image":null,"content":"<div id=\"article-content-wrapper\" data-v-89b5964a=\"\" data-v-76ccd6ad=\"\">\n<article class=\"article-content\" data-v-89b5964a=\"\" data-testid=\"articleContent\">The current threat landscape affects all of us. Knowingly or unknowingly, we are targeted by hackers every day. This guide provides a quick overview of built-in security features in Office 365 that allow users to stay productive while minimizing security risks.</p>\n<table width=\"663\">\n<tbody>\n<tr>\n<td width=\"330\"><strong>Topic</strong></td>\n<td width=\"333\"><strong>What You Need to Know</strong></td>\n</tr>\n<tr>\n<td width=\"330\">The anatomy of a modern attack</td>\n<td width=\"333\">Understand that social engineering comes in many forms: phishing, spear phishing, scareware, and more. They all attempt to psychologically manipulate a user into divulging information or influencing an individual to perform a specific action. The end game is usually to gain access to the computing environment to do harm.&nbsp;</p>\n<p>Plan your defense against breaches by stepping through the mindset of hackers as they use social engineering to gain access to your environment in five key stages: the reconnaissance (recon), the initial breach, the elevation of privileges, the entrenchment, and ultimately, the exfiltration of data.</td>\n</tr>\n<tr>\n<td width=\"330\">Security as a shared responsibility</td>\n<td width=\"333\">Security in a cloud computing environment is a partnership between the tenant organization and the cloud service provider. Both parties have responsibilities which, if carried out, will enhance the security posture of an organization.&nbsp;</p>\n<p>In Office 365, Microsoft, as the cloud service provider, takes care of the physical security of its datacenters where all of its customers’ data are stored.</p>\n<p>On the customer side, there are tasks a tenant admin can do, such as implementing multi-factor authentication, and actions end users can perform such as email encryption to enhance security.</td>\n</tr>\n<tr>\n<td width=\"330\">Securing email</td>\n<td width=\"333\">In Office 365, you can continue to do the things you do to be productive while at the same time stay secure. In Exchange Online (the technology driving your email), for example, you can encrypt your email so that only the intended recipients of the message will be able to read it. You can apply protection to your email so if it’s confidential, the email can only be read by people within your organization. If someone accidentally forwards or copies a recipient outside of the organization on email marked confidential, that recipient will get the email but he or she won’t be able to read it. These security features for protecting email are available through the Office 365 Message Encryption (OME) service which is included in most Office 365 subscriptions or as an add-on service.</td>\n</tr>\n</tbody>\n</table>\n</article>\n</div>\n<div class=\"about-article-section\" data-v-2c35db38=\"\" data-v-76ccd6ad=\"\">\n<h2 class=\"h3 section-title\" data-v-2c35db38=\"\" data-testid=\"aboutArticleHead\"></h2>\n</div>\n"},{"title":"How to work together in Office 365 ","thumb":null,"image":null,"content":"<div id=\"article-content-wrapper\" data-v-89b5964a=\"\" data-v-76ccd6ad=\"\">\n<article class=\"article-content\" data-v-89b5964a=\"\" data-testid=\"articleContent\">For the first time in history, four cultural generations are converging in the workplace. Baby Boomers, Gen Xers, Millennials, and Centennials are working together on the same project with different collaboration needs and communication styles. Use this guide to understand the productivity tools available in Office 365 so you can pick the right tool for the right purpose.</p>\n<table width=\"663\">\n<tbody>\n<tr>\n<td width=\"330\"><strong>Component</strong></td>\n<td width=\"333\"><strong>Description</strong></td>\n</tr>\n<tr>\n<td width=\"330\">Office 365 Groups</td>\n<td width=\"333\">Groups is the service that enables users to use a single identity across the different collaboration solutions in Office 365. Powered by machine learning and artificial intelligence (AI), Groups maps the connection between the people and the content you interact with in Office 365. This AI then feeds into all the experiences in Office 365 to help you discover relevant content and save time by making efficient connections.</td>\n</tr>\n<tr>\n<td width=\"330\">Teams</td>\n<td width=\"333\">Teams is a digital hub for teamwork. It is a chat-based environment designed to foster easy connections and conversations to help build relationships. Teams is also built on top of Office 365 Groups.</td>\n</tr>\n<tr>\n<td width=\"330\">Yammer</td>\n<td width=\"333\">Yammer is your social network for the enterprise. It is your Facebook at work — but better. It’s what you use for open team discussions and can be used to crowd source ideas and collect knowledge. You can get a pulse for your organization via polls, praise, follows, and more.</td>\n</tr>\n<tr>\n<td width=\"330\">SharePoint Online</td>\n<td width=\"333\">SharePoint is your go-to solution for content management and collaboration with the benefit of custom workflows and advanced permissions. You can design beautiful sites with zero coding skills, and it integrates seamlessly across all the collaboration solutions in Office 365.</td>\n</tr>\n<tr>\n<td width=\"330\">Email/Outlook</td>\n<td width=\"333\">Outlook continues to be the undisputed leader for email and calendar. Its latest version comes with a feature called Focused Inbox that automatically sorts your email, creates @mentions to catch someone’s attention, and uses built-in AI.</td>\n</tr>\n</tbody>\n</table>\n</article>\n</div>\n<div class=\"about-article-section\" data-v-2c35db38=\"\" data-v-76ccd6ad=\"\">\n<h2 class=\"h3 section-title\" data-v-2c35db38=\"\" data-testid=\"aboutArticleHead\"></h2>\n</div>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Six months","lifeExpectancySetFrom":"2022-02-24T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":208417},{"headers":{"creationTime":"2019-06-03T21:30:43+00:00","modifiedTime":"2022-02-23T18:56:59+00:00","timestamp":"2022-02-24T17:07:37+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General (Microsoft)","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"Office 365 All-in-One For Dummies Cheat Sheet","strippedTitle":"office 365 all-in-one for dummies cheat sheet","slug":"office-365-all-in-one-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Office 365 is packed full of great features. Use this guide from Dummies.com to discover some important productivity tips for Office 365.","noIndex":0,"noFollow":0},"content":"Here are some useful <a href=\"https://www.dummies.com/software/microsoft-office/office-web-apps/microsoft-office-365-features-and-benefits/\" target=\"_blank\" rel=\"noopener\">Office 365 features</a> worth knowing about. Two of these cheat sheets explain how Office 365 lets you turn one thing into another — how to turn a Word document into a PowerPoint presentation and how to turn an Office 365 file into a PDF so that people who don’t have Office can read it. For people who get mountains of email, here are instructions for moving your Office 365 email messages as they arrive into a specific Outlook folder.","description":"Here are some useful <a href=\"https://www.dummies.com/software/microsoft-office/office-web-apps/microsoft-office-365-features-and-benefits/\" target=\"_blank\" rel=\"noopener\">Office 365 features</a> worth knowing about. Two of these cheat sheets explain how Office 365 lets you turn one thing into another — how to turn a Word document into a PowerPoint presentation and how to turn an Office 365 file into a PDF so that people who don’t have Office can read it. For people who get mountains of email, here are instructions for moving your Office 365 email messages as they arrive into a specific Outlook folder.","blurb":"","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":"Peter Weverka is a veteran technology author with dozens of books to his credit. In addition to previous editions of Office All-in-One For Dummies, he has written books on PowerPoint, OneNote, Word, and Quicken, as well as the bestselling Windows 10 For Seniors For Dummies.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9034"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General (Microsoft)","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}},{"articleId":265311,"title":"How to Change a Chart's Appearance in Office 365","slug":"how-to-change-a-charts-appearance-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265311"}},{"articleId":265298,"title":"How to Collaborate in SharePoint from Office 365","slug":"how-to-collaborate-in-sharepoint-from-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265298"}},{"articleId":265292,"title":"How to Work in Microsoft Teams from Office 365","slug":"how-to-work-in-microsoft-teams-from-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265292"}},{"articleId":265287,"title":"How to Interact with Coworkers through Microsoft Teams","slug":"how-to-interact-with-coworkers-through-microsoft-teams","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265287"}}],"fromCategory":[{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290233"}},{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290196"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289688"}},{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}},{"articleId":265311,"title":"How to Change a Chart's Appearance in Office 365","slug":"how-to-change-a-charts-appearance-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265311"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281804,"slug":"office-365-all-in-one-for-dummies","isbn":"9781119830702","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119830702/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119830702/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119830702-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119830702/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119830702/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/9781119830702-203x255.jpg","width":203,"height":255},"title":"Office 365 All-in-One For Dummies, 2nd Edition","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"\n <p><b data-author-id=\"9034\">Peter Weverka</b> is a veteran technology author with dozens of books to his credit. In addition to previous editions of Office All-in-One For Dummies, he has written books on PowerPoint, OneNote, Word, and Quicken, as well as the bestselling Windows 10 For Seniors For Dummies.</p>","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":"Peter Weverka is a veteran technology author with dozens of books to his credit. In addition to previous editions of Office All-in-One For Dummies, he has written books on PowerPoint, OneNote, Word, and Quicken, as well as the bestselling Windows 10 For Seniors For Dummies.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9034"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119830702&quot;]}]\" id=\"du-slot-6217bb5942425\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119830702&quot;]}]\" id=\"du-slot-6217bb5942dc3\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":0,"title":"","slug":null,"categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/"}},{"articleId":0,"title":"","slug":null,"categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/"}},{"articleId":0,"title":"","slug":null,"categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/"}}],"content":[{"title":"Turn a Word document into a PowerPoint presentation","thumb":null,"image":null,"content":"<p>As long as you applied heading styles (Heading 1, Heading 2, and so on) to the headings in a Word 365 document, you can turn a Word document into a PowerPoint 365 presentation.</p>\n<p>After you import the headings from the Word document into PowerPoint, you get one slide for each Level 1 heading (headings given the Heading 1 style). Level 1 headings form the title of the slides, Level 2 headings form first-level bullets, Level 3 headings form second-level bullets, and so on (paragraph text isn’t imported).</p>\n<p>Follow these steps to use headings in a Word document to create slides in a PowerPoint presentation:</p>\n<ol>\n<li>On the View tab, click the Outline View button. Outline view gives you a better idea of how Word headings become PowerPoint slides.</li>\n</ol>\n<ol start=\"2\">\n<li>Select the slide that the new slides from the Word document will follow.</li>\n<li>On the Home or Insert tab, open the drop-down list on the New Slide button and choose Slides from Outline. The Insert Outline dialog box appears.</li>\n</ol>\n<ol start=\"4\">\n<li>Select the Word document with the headings you want for your presentation and click the Insert button. PowerPoint borrows headings from the Word document for the new slides.</li>\n</ol>\n"},{"title":"Save an Office file in PDF format","thumb":null,"image":null,"content":"<p>What if you want to show an Office 365 file (a Word, Excel, PowerPoint, or Publisher file) to someone who doesn’t have Office?</p>\n<p>One way to get around this problem is to save the file in the PDF format. PDF (portable document format) files can be viewed in web browsers. Almost everyone can view them.</p>\n<p>Follow these steps to save an Office 365 file as a PDF file:</p>\n<ol>\n<li>Go to the File tab and choose Export to open the Export window.</li>\n<li>Choose Create PDF/XPS Document.</li>\n<li>Click the Create PDF/XPS button. The Publish as PDF or XPS dialog box appears.</li>\n</ol>\n<ol start=\"4\">\n<li>Select a folder for storing your PDF file, give it a name, and click the Publish button. Your file opens in the Edge browser application (or whatever your computer’s default web browser is). You can also open it in Adobe Acrobat Reader.</li>\n</ol>\n"},{"title":"Move email messages from a colleague automatically to an email folder","thumb":null,"image":null,"content":"<p>In Outlook 365, the ability to move messages as they arrive to an email folder is a great way to organize email. After you create a new folder and name it after a colleague, you can tell Outlook to put email from the colleague in the new folder automatically. In this way, you can always find and respond to email from your colleague.</p>\n<p>Create a new folder for storing the email and follow these steps to move email from your colleague automatically into the folder:</p>\n<ol>\n<li>Select an email message from your colleague.</li>\n<li>On the Home tab, click the Rules button.</li>\n<li>Choose Always Move Message From on the drop-down list. The Rules and Alerts dialog box appears.</li>\n</ol>\n<ol start=\"4\">\n<li>Choose the folder where you want to move the email automatically.</li>\n<li>Click OK.</li>\n</ol>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2022-02-23T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":262000},{"headers":{"creationTime":"2022-01-10T17:05:02+00:00","modifiedTime":"2022-01-10T17:05:02+00:00","timestamp":"2022-02-24T17:07:23+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General (Microsoft)","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"Microsoft 365 For Dummies Cheat Sheet","strippedTitle":"microsoft 365 for dummies cheat sheet","slug":"microsoft-365-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"","noIndex":0,"noFollow":0},"content":"If your organization has implemented Microsoft 365 as a productivity suite, be prepared to discover the bells and whistles of a cloud solution that has been adopted by millions of users across the globe.\r\n\r\nEven if you’re already a superuser of the bundled Office applications like Outlook, Word, Excel, and PowerPoint, you’ll find there are still a lot of features and functionalities within these tools you’ve never heard of before.\r\n\r\nBefore you become overwhelmed trying to figure out all the how-tos, take a step back and consider the following tips. You might just realize the best value of Microsoft 365 is how you can adapt it to your own personality and style.","description":"If your organization has implemented Microsoft 365 as a productivity suite, be prepared to discover the bells and whistles of a cloud solution that has been adopted by millions of users across the globe.\r\n\r\nEven if you’re already a superuser of the bundled Office applications like Outlook, Word, Excel, and PowerPoint, you’ll find there are still a lot of features and functionalities within these tools you’ve never heard of before.\r\n\r\nBefore you become overwhelmed trying to figure out all the how-tos, take a step back and consider the following tips. You might just realize the best value of Microsoft 365 is how you can adapt it to your own personality and style.","blurb":"","authors":[{"authorId":10015,"name":"Jennifer Reed","slug":"jennifer-reed","description":"Jennifer Reed is the founder of Cloud611, an IT services company that helps small and midsize businesses take advantage of cloud technologies to drive business outcomes. As a solutions architect, Reed has helped migrate thousands of users to Office 365.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10015"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General (Microsoft)","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[],"fromCategory":[{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290196"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289688"}},{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}},{"articleId":265311,"title":"How to Change a Chart's Appearance in Office 365","slug":"how-to-change-a-charts-appearance-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265311"}},{"articleId":265298,"title":"How to Collaborate in SharePoint from Office 365","slug":"how-to-collaborate-in-sharepoint-from-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265298"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":290169,"slug":"microsoft-365-for-dummies","isbn":"9781119828891","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119828899/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119828899/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119828899-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119828899/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119828899/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/microsoft-365-fd-9781119828891-203x255.jpg","width":203,"height":255},"title":"Microsoft 365 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"\n <p><b data-author-id=\"10015\">Jennifer Reed</b> is the founder of Cloud611, an IT services company that helps small and midsize businesses take advantage of cloud technologies to drive business outcomes. As a solutions architect, Reed has helped migrate thousands of users to Office 365.</p>","authors":[{"authorId":10015,"name":"Jennifer Reed","slug":"jennifer-reed","description":"Jennifer Reed is the founder of Cloud611, an IT services company that helps small and midsize businesses take advantage of cloud technologies to drive business outcomes. As a solutions architect, Reed has helped migrate thousands of users to Office 365.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10015"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119828891&quot;]}]\" id=\"du-slot-6217bb4b96211\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119828891&quot;]}]\" id=\"du-slot-6217bb4b96b81\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":0,"title":"","slug":null,"categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/"}}],"content":[{"title":"Picking the best app to match your working style","thumb":null,"image":null,"content":"<p>Knowing your working style and focusing on a few apps in Microsoft 365 that match your style is a great way to boost your productivity.</p>\n<p>With over 30 apps available in a typical work or school subscription, it’s challenging to become an expert on everything Microsoft 365. So, take stock of how you organize your work and complete your tasks and then pick the best app to speed up your adoption of the cloud service. Here are some ideas:</p>\n<ul>\n<li>If you’re the kind who likes to crunch numbers and your approach to solving problems follows a logical path, Excel and Power BI should be on your list of apps to explore. Both apps enable you to connect to, analyze, model, and discover insights from data that can be easily shared with others.</li>\n<li>If you’re organized and detail-oriented, check out Planner and Lists. Planner makes it easy to create plans, manage tasks, and share progress, while Lists enables you to drop and track all kinds of data into a list that can be automated with a workflow.</li>\n<li>If you’re the type who brings everyone together and values team collaboration, then Teams is your go-to. Its chat-based workspace is just one of the many ways you can facilitate communication and foster harmony in the organization.</li>\n<li>If you’re the visionary who has a knack for inspiring others to believe in your ideas, PowerPoint and Whiteboard are your helpers. There is nothing like visuals in your presentation, or a free-form canvas for ideation, to make your big-picture thinking tangibly relatable.</li>\n</ul>\n"},{"title":"Balancing productivity and well-being","thumb":null,"image":null,"content":"<p>Health is wealth, so don’t run yourself to the ground with the daily office grind. Being productive is great, especially with all the Microsoft 365 apps available to streamline your work. Still, it doesn’t mean you should do too much at the expense of your well-being. Here are some ways you can use Microsoft 365 apps to thrive at work while avoiding burnout:</p>\n<ul>\n<li>Sometimes it’s okay to not be okay. Check in with yourself and log how you feel each day by clicking an emoji in Viva Insights. What you do here is private, so don’t hesitate to pick the angry emoji if you’re having a bad day.</li>\n<li>Protect your time and book focus hours in your calendar in Outlook. That way you don’t end up in back-to-back meetings from 8 a.m. to 5 p.m. and then have to deal with your work tasks at night when you should be with your family or spending “me” time.</li>\n<li>If you’re invited to a meeting, ask the host what your role is and how you can contribute to the discussion. This may force your coworkers to be more mindful about sending an invitation, but they’ll thank you in the end, especially if you do the same for them.</li>\n<li>Take short breaks — even just three minutes — to do guided meditation in Viva Insights. A daily dose of mindfulness goes a long way.</li>\n<li>If one of your kids derails your day or you’re having a bad hair day, don’t turn on the video, especially if it’s an internal team meeting. You’ll be more effective in communicating your message if you’re not self-conscious about how you look or what is going on behind you.</li>\n</ul>\n"},{"title":"Ways to give Microsoft feedback about its apps","thumb":null,"image":null,"content":"<p>New features and functionalities in Microsoft 365 are constantly rolled out because that’s the nature of a cloud service. Sometimes, however, you may find bugs or features that make you go, “What were they thinking?” When that happens, let your voice be heard and give Microsoft your feedback. Here are some ways to do it:</p>\n<ul>\n<li>In Teams, you can suggest a feature or give feedback from the Help icon on the menu bar. Provide lots of details so the people at Microsoft reviewing it can quickly act on the feedback.</li>\n<li>In Word, Excel, PowerPoint, and Outlook, you can give feedback from the Help tab in the ribbon. When you click the Feedback button, a form displays with three options: I like something, I don’t like something, and I have a suggestion.</li>\n<li>Another way to find the Feedback button in the Office apps is by clicking File [right arrow] Feedback. This takes you to a page where you can Send a Smile, Send a Frown, or Suggest a Feature.</li>\n<li>Visit <a href=\"https://feedbackportal.microsoft.com/feedback/\" target=\"_blank\" rel=\"noopener\">https://feedbackportal.microsoft.com/feedback</a> and browse through the feedback others have given for each of the Microsoft 365 apps. If you find one that resonates with you, you can comment, follow, or share.</li>\n</ul>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2022-01-10T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":290233},{"headers":{"creationTime":"2022-01-07T14:29:32+00:00","modifiedTime":"2022-01-07T14:29:32+00:00","timestamp":"2022-02-24T17:07:22+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General (Microsoft)","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"Office 2021 All-in-One For Dummies Cheat Sheet","strippedTitle":"office 2021 all-in-one for dummies cheat sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"When working in Office 2021, keep this handy list of tips that will help you get your work done more efficiently.","noIndex":0,"noFollow":0},"content":"Here are a few shortcuts to help you get your work done faster in Office 2021. Read on to see how to insert one Word 2021 file into another without having to cut and paste, how to enter serial information such as numbers and dates into an Excel 2021 worksheet, and how to make a Word 2021 file the genesis for a PowerPoint 2021 presentation.","description":"Here are a few shortcuts to help you get your work done faster in Office 2021. Read on to see how to insert one Word 2021 file into another without having to cut and paste, how to enter serial information such as numbers and dates into an Excel 2021 worksheet, and how to make a Word 2021 file the genesis for a PowerPoint 2021 presentation.","blurb":"","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":"Peter Weverka is a veteran technology author with dozens of books to his credit. In addition to previous editions of Office All-in-One For Dummies, he has written books on PowerPoint, OneNote, Word, and Quicken, as well as the bestselling Windows 10 For Seniors For Dummies.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9034"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General (Microsoft)","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[],"fromCategory":[{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290233"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289688"}},{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}},{"articleId":265311,"title":"How to Change a Chart's Appearance in Office 365","slug":"how-to-change-a-charts-appearance-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265311"}},{"articleId":265298,"title":"How to Collaborate in SharePoint from Office 365","slug":"how-to-collaborate-in-sharepoint-from-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265298"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":290168,"slug":"office-2021-all-in-one-for-dummies","isbn":"9781119831419","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119831415/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119831415/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119831415-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119831415/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119831415/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/office-2021-aio-fd-9781119831419-203x255.jpg","width":203,"height":255},"title":"Office 2021 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"\n <p><b data-author-id=\"9034\">Peter Weverka</b> is a veteran technology author with dozens of books to his credit. In addition to previous editions of Office All-in-One For Dummies, he has written books on PowerPoint, OneNote, Word, and Quicken, as well as the bestselling Windows 10 For Seniors For Dummies.</p>","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":"Peter Weverka is a veteran technology author with dozens of books to his credit. In addition to previous editions of Office All-in-One For Dummies, he has written books on PowerPoint, OneNote, Word, and Quicken, as well as the bestselling Windows 10 For Seniors For Dummies.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9034"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119831419&quot;]}]\" id=\"du-slot-6217bb4a8aa8e\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119831419&quot;]}]\" id=\"du-slot-6217bb4a8b418\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":0,"title":"","slug":null,"categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/"}}],"content":[{"title":"Insert a whole file into a Word 2021 document","thumb":null,"image":null,"content":"<p>If you can recycle one Word 2021 document into another, so much the better. Say that you wrote an essay on the Scissor-Tailed Flycatcher that would fit very nicely in a broader report on North American birds. You can insert the Scissor-Tailed Flycatcher document into your report document:</p>\n<ol>\n<li>Place the cursor where you want to insert the document.</li>\n<li>On the Insert tab, open the drop-down list on the Object button and choose Text from File. You see the Insert File dialog box. (The Object button is located in the Text group on the right side of the Ribbon.)</li>\n<li>Find and select the file you want to insert. For that matter, you can insert more than one file. To do so, select more than one file in the Insert File dialog box. Files land in the document in the order in which they appear in the Insert File dialog box.</li>\n<li>Click the Insert button.</li>\n</ol>\n"},{"title":"Quickly enter serial data in Excel 2021","thumb":null,"image":null,"content":"<p>Here’s a trick for entering consecutive numbers, month names, days of the week, and other serial data quickly in an Excel 2021 worksheet. Excel recognizes certain kinds of serial data and can enter it for you with its “autofill” feature. Follow these steps to “autofill” cells:</p>\n<ol>\n<li>Click the cell that is to be first in the series. For example, if you intend to list the days of the week in consecutive cells, click where the first day is to go.</li>\n<li>Enter the first number, date, or list item in the series.</li>\n<li>Move to the adjacent cell and enter the second number, date, or list item in the series. If you want to enter the same number or piece of text in adjacent cells, taking this step isn&#8217;t necessary, but Excel needs the first and second items in the case of serial dates and numbers so that it can tell how much to increase or decrease the given amount or time period in each cell. For example, entering 5 and 10 tells Excel to increase the number by 5 each time so that the next serial entry is 15.</li>\n<li>Select the cell or cells you just entered data in. To select a single cell, click it; to select two, drag over the cells.</li>\n<li>Click the AutoFill handle and start dragging in the direction in which you want the data series to appear on your worksheet. The AutoFill handle is the little green square in the lower-right corner of the cell or block of cells you selected. As you drag, the serial data appears in a pop-up box.</li>\n</ol>\n"},{"title":"Turn a Word 2021 document into a PowerPoint 2021 presentation","thumb":null,"image":null,"content":"<p>As long as you applied heading styles (Heading 1, Heading 2, and so on) to the headings in a Word 2021 document, you can turn a Word document into a PowerPoint 2021 presentation.</p>\n<p>After you import the headings from the Word document into PowerPoint, you get one slide for each Level 1 heading (headings given the Heading 1 style). Level 1 headings form the title of the slides, Level 2 headings form first-level bullets, Level 3 headings form second-level bullets, and so on (paragraph text isn’t imported).</p>\n<p>Follow these steps to use headings in a Word document to create slides in a PowerPoint presentation:</p>\n<ol>\n<li>On the View tab, click the Outline View button. Outline view gives you a better idea of how Word headings become PowerPoint slides.</li>\n<li>Select the slide that the new slides from the Word document will follow.</li>\n<li>On the Home or Insert tab, open the drop-down list on the New Slide button and choose Slides from Outline. The Insert Outline dialog box appears.</li>\n<li>Select the Word document with the headings you want for your presentation and click the Insert button. PowerPoint borrows headings from the Word document for the new slides.</li>\n</ol>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2022-01-07T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":290196},{"headers":{"creationTime":"2021-12-07T01:54:58+00:00","modifiedTime":"2021-12-07T13:15:26+00:00","timestamp":"2022-02-24T17:07:14+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General (Microsoft)","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"Office 2021 For Seniors For Dummies Cheat Sheet","strippedTitle":"office 2021 for seniors for dummies cheat sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Learn these helpful keyboard shortcuts that will make working with your Office applications easier and quicker.","noIndex":0,"noFollow":0},"content":"After you discover keyboard shortcuts in Office, you’ll wonder how you ever functioned without them. Keyboard shortcuts make common tasks faster and easier. By pressing a key combination, you can duplicate many of the most commonly used commands and tasks.\r\n\r\nSome of the keyboard shortcuts are the same across multiple applications, whereas others are specific to a particular application.","description":"After you discover keyboard shortcuts in Office, you’ll wonder how you ever functioned without them. Keyboard shortcuts make common tasks faster and easier. By pressing a key combination, you can duplicate many of the most commonly used commands and tasks.\r\n\r\nSome of the keyboard shortcuts are the same across multiple applications, whereas others are specific to a particular application.","blurb":"","authors":[{"authorId":9025,"name":"Faithe Wempen","slug":"faithe-wempen","description":"Faithe Wempen, MA, has written more than 140 books on computer hardware and software, including Microsoft Office 2016 for Seniors for Dummies and The PowerPoint Bible. A Microsoft Office master instructor, she has educated more than 250,000 corporate students with her online courses and hundreds more as an adjunct instructor at Purdue University.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9025"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General (Microsoft)","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":260430,"title":"How to Move and Copy Content in Office 2019","slug":"how-to-move-and-copy-content-in-office-2019","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/260430"}},{"articleId":260399,"title":"How to Align and Indent Paragraphs in Word 2019","slug":"how-to-align-and-indent-paragraphs-in-word-2019","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/260399"}},{"articleId":260394,"title":"How to Insert Cover Pages and Other Building Blocks in Word 2019","slug":"how-to-insert-cover-pages-and-other-building-blocks-in-word-2019","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/260394"}},{"articleId":260389,"title":"A Quick Tour of Outlook 2019 Mail","slug":"a-quick-tour-of-outlook-2019-mail","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/260389"}},{"articleId":260381,"title":"How to Create and Categorize Notes in Outlook 2019","slug":"how-to-create-and-categorize-notes-in-outlook-2019","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/260381"}}],"fromCategory":[{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290233"}},{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290196"}},{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}},{"articleId":265311,"title":"How to Change a Chart's Appearance in Office 365","slug":"how-to-change-a-charts-appearance-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265311"}},{"articleId":265298,"title":"How to Collaborate in SharePoint from Office 365","slug":"how-to-collaborate-in-sharepoint-from-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265298"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281803,"slug":"office-for-seniors-for-dummies","isbn":"9781119844570","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119844576/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119844576/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119844576-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119844576/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119844576/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/9781119844570-203x255.jpg","width":203,"height":255},"title":"Office 2021 For Seniors For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"\n <p><b data-author-id=\"9025\">Faithe Wempen</b>, MA, has written more than 140 books on computer hardware and software, including Microsoft Office 2016 for Seniors for Dummies and The PowerPoint Bible. A Microsoft Office master instructor, she has educated more than 250,000 corporate students with her online courses and hundreds more as an adjunct instructor at Purdue University.</p>","authors":[{"authorId":9025,"name":"Faithe Wempen","slug":"faithe-wempen","description":"Faithe Wempen, MA, has written more than 140 books on computer hardware and software, including Microsoft Office 2016 for Seniors for Dummies and The PowerPoint Bible. A Microsoft Office master instructor, she has educated more than 250,000 corporate students with her online courses and hundreds more as an adjunct instructor at Purdue University.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9025"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119844570&quot;]}]\" id=\"du-slot-6217bb423e9e9\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119844570&quot;]}]\" id=\"du-slot-6217bb423f38b\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":0,"title":"","slug":null,"categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/"}}],"content":[{"title":"Common shortcuts in Word, Excel, and PowerPoint","thumb":null,"image":null,"content":"<p>By pressing a couple of keys in combination, you can save time with simple tasks in Office, such as copying text from one place and pasting it somewhere else. The keyboard shortcuts included here work equally well in Word, Excel, and PowerPoint. Both mouse and keyboard methods are provided here.</p>\n<table width=\"655\">\n<tbody>\n<tr>\n<td><strong>To Do This …</strong></td>\n<td><strong>With the Mouse</strong></td>\n<td>With the Keyboard</td>\n</tr>\n<tr>\n<td>Open a file</td>\n<td>File→Open</td>\n<td>Ctrl+O</td>\n</tr>\n<tr>\n<td>Create a new file</td>\n<td>File→New</td>\n<td>Ctrl+N</td>\n</tr>\n<tr>\n<td>Print active document</td>\n<td>File→Print</td>\n<td>Ctrl+P</td>\n</tr>\n<tr>\n<td>Save your work (first time), or resave with same settings</td>\n<td>File→Save</td>\n<td>Ctrl+S</td>\n</tr>\n<tr>\n<td>Save your work with different name, location, or type</td>\n<td>File→Save As</td>\n<td>F12</td>\n</tr>\n<tr>\n<td>Copy selection to Clipboard</td>\n<td>Home→Copy</td>\n<td>Ctrl+C</td>\n</tr>\n<tr>\n<td>Cut selection to Clipboard</td>\n<td>Home→Cut</td>\n<td>Ctrl+X</td>\n</tr>\n<tr>\n<td>Paste selection to Clipboard</td>\n<td>Home→Paste</td>\n<td>Ctrl+V</td>\n</tr>\n<tr>\n<td>Open the Paste Special dialog box</td>\n<td>Home→Paste→Paste Special</td>\n<td>Ctrl+Shift+V</td>\n</tr>\n<tr>\n<td>Display shortcut menu for selected item</td>\n<td>Right-click item</td>\n<td>Shift+F10</td>\n</tr>\n<tr>\n<td>Left-align a paragraph</td>\n<td>Home→Left Align</td>\n<td>Ctrl+L</td>\n</tr>\n<tr>\n<td>Center a paragraph</td>\n<td>Home→Center</td>\n<td>Ctrl+E</td>\n</tr>\n<tr>\n<td>Right-align a paragraph</td>\n<td>Home→Right Align</td>\n<td>Ctrl+R</td>\n</tr>\n<tr>\n<td>Make text bold</td>\n<td>Home→Bold</td>\n<td>Ctrl+B</td>\n</tr>\n<tr>\n<td>Make text italicized</td>\n<td>Home→Italic</td>\n<td>Ctrl+I</td>\n</tr>\n<tr>\n<td>Make text underlined</td>\n<td>Home→Underline</td>\n<td>Ctrl+U</td>\n</tr>\n<tr>\n<td>Make text larger</td>\n<td>Home→Increase Font Size</td>\n<td>Ctrl+&gt;</td>\n</tr>\n<tr>\n<td>Make text smaller</td>\n<td>Home→Decrease Font Size</td>\n<td>Ctrl+&lt;</td>\n</tr>\n<tr>\n<td>Undo previous action</td>\n<td>Undo button on Quick Access toolbar</td>\n<td>Ctrl+Z</td>\n</tr>\n<tr>\n<td>Redo previous Undo</td>\n<td>Redo button on Quick Access toolbar</td>\n<td>Ctrl+Y</td>\n</tr>\n<tr>\n<td>Insert hyperlink</td>\n<td>Insert→Hyperlink</td>\n<td>Ctrl+K</td>\n</tr>\n<tr>\n<td>Get help</td>\n<td>Type in Tellme what you want to do box</td>\n<td>F1</td>\n</tr>\n<tr>\n<td>Close the active file</td>\n<td>File→Close</td>\n<td>Ctrl+F4</td>\n</tr>\n<tr>\n<td>Close the application</td>\n<td>Close button on application window</td>\n<td>Alt+F4</td>\n</tr>\n<tr>\n<td>Check spelling</td>\n<td>Review→Spelling</td>\n<td>F7</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Word text entry and formatting shortcuts","thumb":null,"image":null,"content":"<p>Word offers you many ways to interact with your document. There are multiple keyboard shortcuts that can be a great time-saver. With these keyboard shortcuts, you can speed up text editing and formatting.</p>\n<table>\n<tbody>\n<tr>\n<td width=\"336\"><strong>To Do This …</strong></td>\n<td width=\"302\"><strong>With the Keyboard</strong></td>\n</tr>\n<tr>\n<td width=\"336\">Start a new line in the same paragraph</td>\n<td width=\"302\">Shift+Enter</td>\n</tr>\n<tr>\n<td width=\"336\">Insert a page break</td>\n<td width=\"302\">Ctrl+Enter</td>\n</tr>\n<tr>\n<td width=\"336\">Insert a column break</td>\n<td width=\"302\">Ctrl+Shift+Enter</td>\n</tr>\n<tr>\n<td width=\"336\">Clear formatting</td>\n<td width=\"302\">Ctrl+spacebar</td>\n</tr>\n<tr>\n<td width=\"336\">Make text subscript</td>\n<td width=\"302\">Ctrl+=</td>\n</tr>\n<tr>\n<td width=\"336\">Make text superscript</td>\n<td width=\"302\">Ctrl+Shift++</td>\n</tr>\n<tr>\n<td width=\"336\">Delete one character to the left</td>\n<td width=\"302\">Backspace</td>\n</tr>\n<tr>\n<td width=\"336\">Delete one word to the left</td>\n<td width=\"302\">Ctrl+Backspace</td>\n</tr>\n<tr>\n<td width=\"336\">Delete one character to the right</td>\n<td width=\"302\">Delete</td>\n</tr>\n<tr>\n<td width=\"336\">Delete one word to the right</td>\n<td width=\"302\">Ctrl+Delete</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Word view shortcuts","thumb":null,"image":null,"content":"<p>Ever feel like you just don’t have the right perspective? Well, Word makes it easy to change your document view so that you can gain a different perspective. With these keyboard shortcuts, you can switch among various views in Word.</p>\n<table width=\"655\">\n<tbody>\n<tr>\n<td><strong>Switch to This View</strong></td>\n<td><strong>With the Keyboard</strong></td>\n</tr>\n<tr>\n<td>Print Layout</td>\n<td>Alt+Ctrl+P</td>\n</tr>\n<tr>\n<td>Outline</td>\n<td>Alt+Ctrl+O</td>\n</tr>\n<tr>\n<td>Draft</td>\n<td>Alt+Ctrl+N</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Word symbol shortcuts","thumb":null,"image":null,"content":"<p>Depending on how you choose to use Word, you may need a special symbol. With these keyboard shortcuts, you can insert common symbols in Word. Use these keyboard shortcuts instead of the Insert→Symbol command to insert common typographical symbols.</p>\n<table width=\"655\">\n<tbody>\n<tr>\n<td><strong>Symbol</strong></td>\n<td><strong>Shortcut</strong></td>\n</tr>\n<tr>\n<td>Em dash</td>\n<td>Alt+Ctrl+minus sign</td>\n</tr>\n<tr>\n<td>En dash</td>\n<td>Ctrl+minus sign</td>\n</tr>\n<tr>\n<td>Copyright</td>\n<td>Alt+Ctrl+C</td>\n</tr>\n<tr>\n<td>Registered trademark</td>\n<td>Alt+Ctrl+R</td>\n</tr>\n<tr>\n<td>Trademark</td>\n<td>Alt+Ctrl+T</td>\n</tr>\n<tr>\n<td>Ellipsis</td>\n<td>Alt+Ctrl+period</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Excel number formatting shortcuts","thumb":null,"image":null,"content":"<p>Many shortcuts are available that can save you time with simple tasks in Excel, such as copying text from one place and pasting it somewhere else in your document. You can use these keyboard shortcuts instead of the Number drop-down list on the Home tab to apply number formatting to cells in Excel.</p>\n<table width=\"655\">\n<tbody>\n<tr>\n<td><strong>To Apply This Number Format …</strong></td>\n<td><strong>Use This Key Combination</strong></td>\n</tr>\n<tr>\n<td>General</td>\n<td>Ctrl+Shift+~</td>\n</tr>\n<tr>\n<td>Currency with two decimal places, negative numbers<br />\nin parentheses</td>\n<td>Ctrl+Shift+$</td>\n</tr>\n<tr>\n<td>Percentage, no decimal places</td>\n<td>Ctrl+Shift+%</td>\n</tr>\n<tr>\n<td>Scientific, two decimal places</td>\n<td>Ctrl+Shift+^</td>\n</tr>\n<tr>\n<td>Date format with day, month, and year</td>\n<td>Ctrl+Shift+#</td>\n</tr>\n<tr>\n<td>Time format with hour and minute, AM or PM</td>\n<td>[email protected]</td>\n</tr>\n<tr>\n<td>Number format, two decimal places, thousands separator,<br />\nminus sign for negative values</td>\n<td>Ctrl+Shift+!</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Excel entry and formatting shortcuts","thumb":null,"image":null,"content":"<p>Excel offers you many tools to save time with everyday tasks. With these keyboard shortcuts, you can enter and modify data in Excel. These keyboard shortcuts can save you time when entering and formatting data in Excel.</p>\n<table width=\"655\">\n<tbody>\n<tr>\n<td><strong>To Do This …</strong></td>\n<td><strong>Use This Key Combination</strong></td>\n</tr>\n<tr>\n<td>Enter the current time</td>\n<td>Ctrl+Shift+:</td>\n</tr>\n<tr>\n<td>Enter the current date</td>\n<td>Ctrl+;</td>\n</tr>\n<tr>\n<td>Apply an outline border</td>\n<td>Ctrl+Shift+&amp;</td>\n</tr>\n<tr>\n<td>Remove an outline border</td>\n<td>Ctrl+Shift+_</td>\n</tr>\n<tr>\n<td>Display or hide formulas in cells</td>\n<td>Ctrl+`</td>\n</tr>\n<tr>\n<td>Display the Format Cells dialog box</td>\n<td>Ctrl+1</td>\n</tr>\n<tr>\n<td>Hide selected rows</td>\n<td>Ctrl+9</td>\n</tr>\n<tr>\n<td>Hide selected columns</td>\n<td>Ctrl+0</td>\n</tr>\n</tbody>\n</table>\n<p>&nbsp;</p>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Explore","lifeExpectancy":"One year","lifeExpectancySetFrom":"2021-12-06T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":289688},{"headers":{"creationTime":"2019-01-07T19:38:59+00:00","modifiedTime":"2021-10-21T20:45:47+00:00","timestamp":"2022-02-24T17:07:04+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General (Microsoft)","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"How to Use Microsoft Teams","strippedTitle":"how to use microsoft teams","slug":"how-to-use-microsoft-teams","canonicalUrl":"","seo":{"metaDescription":"Companies are staying connected virtually through Microsoft Teams. Explore the interface as well as ways to chat and set up meetings.","noIndex":0,"noFollow":0},"content":"Microsoft Teams is available to users who have licenses with following <a href=\"https://www.dummies.com/software/microsoft-office/pricing-for-office-365-determining-the-right-plan-for-your-organization/\" target=\"_blank\" rel=\"noopener\">Office 365 corporate subscriptions</a>: E1, E3, E5, Business Premium, and Business Essentials. In the education plans, it is available in the A1, A1 Plus, A5, and A3 subscriptions. Plans are in place to roll out Teams in the government cloud as well.\r\n\r\nTeams can be accessed from the web browser, a desktop application, or a mobile app. The maximum number of users who can access the full functionality of Teams is based on the number of licensed users in the organization. Guest access is allowed, which means that users from other Office 365 tenants can be invited to an organization’s Teams hub without the need for additional licenses.\r\n\r\nWith Teams, you can conduct one-on-one or group audio and video calls. You can share screens during web conferencing, schedule meetings, and also record those meetings. In addition, each user has up to 1 TB of storage space.\r\n\r\nFrom an administrator’s standpoint, Teams offers tools for managing users and third-party applications. There are reports to glean usage and settings that can be configured with policies specific to the organization. For peace of mind, Microsoft offers a 99.9 percent financially backed service-level agreement (SLA) uptime for Teams.\r\n<h2 id=\"tab1\" >Touring the Microsoft Teams user interface</h2>\r\nTabs, bots, @mentions, and red bangs are just part of the new lingo you’re going to need to add to your vocabulary to use Teams. That’s assuming you’re already a savvy social media user who knows what emojis, stickers, and giphys are all about.\r\n\r\nLet’s take a tour of the Teams user interface. When you run the desktop application, the first screen you see after you log in is shown below.\r\n\r\n<img class=\"aligncenter wp-image-259021 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-microsoft-teams.png\" alt=\"Microsoft Teams user interface\" width=\"535\" height=\"422\" />\r\n\r\n \r\n<ul>\r\n \t<li><strong>App bar:</strong> Here you can navigate to the various sections in Teams. From the top, you’ll see the following icons:\r\n<ul>\r\n \t<li><em>Activity</em> is where you’ll find mentions, replies, and other notifications.</li>\r\n \t<li><em>Chat</em> is where you’ll see your recent one-on-one or group chats and your Contacts list.</li>\r\n \t<li><em>Teams</em> displays all the teams you are a member of.</li>\r\n \t<li><em>Meetings </em>or <em>Calendar</em> is synched with your Outlook calendar and displays all your upcoming meetings.</li>\r\n \t<li><em>Files</em> aggregates all the files from all the teams you are a member of. It is also where you access your personal OneDrive for Business storage.</li>\r\n \t<li><em>Calls</em> allows you to see a history of all incoming and outgoing video and audio calls. You can also call others in your organization, simply by typing their name.</li>\r\n \t<li><em>[…]</em> includes links to apps that are tied to Teams and the channels within Teams.</li>\r\n \t<li><em>Store</em> takes you to apps and services that can be integrated into Teams.</li>\r\n \t<li><em>Feedback</em> takes you to the Microsoft Teams user voice page where you can leave feedback about the service.</li>\r\n</ul>\r\n</li>\r\n \t<li><strong>Teams section:</strong> In the image above, the Teams icon is selected in the App bar, so the list of one's teams is displayed.</li>\r\n \t<li><strong>Channel:</strong> A dedicated section within a team to organize conversations and tasks into specific topics or projects.</li>\r\n \t<li><strong>Join or Create a Team button:</strong> Clicking this button takes you through the process of creating or joining a team. This button is only visible when the Teams icon is selected in the App bar.</li>\r\n \t<li><strong>New Chat button:</strong> Clicking this button selects the Chat icon in the App bar and allows you to start a new chat with an individual or a group.</li>\r\n \t<li><strong>Command bar:</strong> This bar at the top is used to query apps or perform a search in Teams.</li>\r\n \t<li><strong>Tabs:</strong> Switch between different Teams pages with these tabs. Conversations and Files are automatically included; the + sign tab allows you to add shortcuts to content in Teams.</li>\r\n \t<li><strong>Channel Conversations:</strong> This section displays all the conversations in the selected channel. Chats in Channel Conversations are persistent, so if you’ve been away, it’s easy to scroll through to get caught up when you get back. Chats can include visual indicators such as the @mention, which indicates that the chat specifically mentions a user, or a red bang to indicate high importance. Take note that chats are open by design so everyone in the team has visibility to the conversation to help speed up the decision-making process when needed.</li>\r\n \t<li><strong>Compose box:</strong> This is where you can type a message to start a conversation. You can send a quick chat or expand the Compose box to access rich formatting tools.</li>\r\n \t<li><strong>Send icon:</strong> When you’re ready to share your chat, click the Send icon to post your chat to the team.</li>\r\n</ul>\r\n<h2 id=\"tab2\" >Getting help from the Microsoft Teams Command bar</h2>\r\nTeams is intuitive to use, but you if you need quick assistance, the Command bar is your one-stop destination for help. You can do a search across conversations, users, files, and apps. For example, if you enter the word “launch” in the command bar, the left pane will display the search results grouped by Messages, People, and Files.\r\n\r\n[caption id=\"attachment_259022\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259022 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-microsoft-teams-search-results.png\" alt=\"Microsoft Team command bar search results\" width=\"535\" height=\"164\" /> Command bar search results.[/caption]\r\n\r\nYou can also run a command right from the Command bar by entering a slash ( / ). This action will display the available commands or shortcuts. Select the appropriate command from the list to initiate the command.\r\n\r\n[caption id=\"attachment_259023\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259023 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-teams-slash-command-shortcuts.jpg\" alt=\"Microsoft Teams slash command shortcuts\" width=\"535\" height=\"420\" /> Slash command shortcuts.[/caption]\r\n\r\n \r\n<h2 id=\"tab3\" >Collaborating in the Microsoft Teams Hub</h2>\r\nMany think that the “email tree” phenomenon was isolated to big enterprise environments, but it often rears its ugly head in small organizations, too.\r\n\r\nImagine the following scenario: Someone sends an email to three people asking for their input on something. Two of the recipients immediately respond. Recipient #3 replies to Recipient #2 but forgets to reply to all. Now Recipient #2 has information the others don’t have. Recipient #1 then forwards the email to yet another person (Recipient #4) who replies to all with his feedback, which doesn’t account for what’s already been discussed prior to him being involved. Pretty soon, everyone’s mailbox explodes with replies to replies and replies to all so that the sender finally throws her hands up in frustration because now the conversation has gotten out of hand and she's spending too much time getting everyone up to speed. On top of that, she now must consolidate all the feedback manually.\r\n\r\nTeams makes email trees go away. In Teams, the sender can avoid the previous scenario by uploading the file into the Teams channel, @mention the people she needs feedback from, and start a conversation right from the document in Teams. This way, everyone sees everyone’s comments and edits. A new person joining the conversation can just scroll up to get up to speed and everyone is well-informed and happy.\r\n\r\n[caption id=\"attachment_259024\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259024 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-microsoft-teams-conversation.jpg\" alt=\"Microsoft Teams conversation\" width=\"535\" height=\"265\" /> Starting a conversation about a document in Teams.[/caption]\r\n\r\n \r\n<h2 id=\"tab4\" >Creating and managing a Microsoft Teams hub</h2>\r\nTo collaborate in Teams, you first need to be either a member of a Teams hub or the creator of one. To create a team:\r\n<ol>\r\n \t<li>Click Teams from the App bar.</li>\r\n \t<li>Click the Join or Create a Team link that appears at the bottom of the App bar.</li>\r\n \t<li>Click the Create a Team card.</li>\r\n \t<li>Enter the name and description of the team.</li>\r\n \t<li>Choose the privacy settings for your team (Private or Public). A <em>Private</em> team means only team owners can add members, while a <em>Public</em> team means anyone in your organization can join the Team.</li>\r\n \t<li>Click Next.</li>\r\n \t<li>Add members to your team by adding a name, email address, a distribution list, or a mail-enabled security group in the Add box. A team can have a maximum of 2,500 members from either your organization or external users through secure guest access.</li>\r\n \t<li>Optionally, you can choose the role of the team member (Owner or Member) by clicking the drop-down arrow next to Member. If you forget to do this, you can update the membership type later.</li>\r\n \t<li>Click Close. Team management features are accessed by clicking the ellipses next to your team name in the App bar. The following management options are available:\r\n<ul>\r\n \t<li><em>Manage team</em> launches the Members tab where you can add or remove members, change the role of a member, or search for a member.</li>\r\n \t<li><em>Add a channel</em> launches a dialog box where you can enter a channel name and the description for the channel.</li>\r\n \t<li><em>Add members</em> launches a dialog box where you can enter the names of people, distribution lists, or mail-enabled security groups to add to your team.</li>\r\n \t<li><em>Leave the team</em> launches a validation window that asks you to confirm your intent to leave the team.</li>\r\n \t<li><em>Edit team</em> launches a dialog box where you can change the team name, the team description, and privacy settings.</li>\r\n \t<li><em>Get link to team</em> launches a dialog box where you can copy the URL for the team to share with others.</li>\r\n \t<li><em>Delete the team</em> launches a validation window that asks you to confirm your intent to delete the team.</li>\r\n</ul>\r\n</li>\r\n</ol>\r\n[caption id=\"attachment_259025\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259025 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-manage-microsoft-teams.jpg\" alt=\"manage Microsoft Team members\" width=\"535\" height=\"231\" /> Managing members of the Team.[/caption]\r\n\r\n \r\n<h2 id=\"tab5\" >Chatting in Microsoft Teams</h2>\r\nWhen a new member is added to a team, that member automatically gets access to all previous conversations, files, and other types of information shared in the team’s hub. This is especially helpful for onboarding a new team member to a project. There is no need to think about what files to forward to get the new member up to speed, since they can self-serve from the content available in the hub or simply ask for help from others through chat.\r\n\r\nTo start a chat, click on the Compose Box and start typing your message while in either the Activity, Chat, or Teams sections. When you’re done, click the Send icon to post your message. Depending on the culture of your team, you can spice up your chats with emojis, giphys, or stickers. You’ll find a variety of options when you click these icons below the Compose Box.\r\n<p class=\"article-tips tip\">Sometimes conversations in a team can become noisy when there are many members talking about different topics. To help with that, take advantage of the threaded messages feature in Teams by replying directly to a specific message so the reply in in context with the original message.</p>\r\n\r\n<h2 id=\"tab6\" >Sharing files in Microsoft Teams</h2>\r\nWhen you create a Teams hub, a SharePoint site is automatically created in the backend, which, in turn, creates a document library for each channel. Files uploaded in a Teams channel show up in the Files tab and are stored in a SharePoint document library. In fact, you can click the ellipses next to the file name and then choose to open the file from its location in <a href=\"https://www.dummies.com/software/microsoft-office/what-is-microsoft-sharepoint-a-brief-tour/\" target=\"_blank\" rel=\"noopener\">SharePoint</a>.\r\n\r\n[caption id=\"attachment_259026\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259026 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-teams-sharepoint.jpg\" alt=\"Open SharePoint file from Teams\" width=\"535\" height=\"341\" /> Opening a file in SharePoint from Teams.[/caption]\r\n\r\n \r\n\r\nTo share a file in Teams:\r\n<ol>\r\n \t<li>Select Teams from the App bar.</li>\r\n \t<li>Compose a message in the Compose box from a channel.</li>\r\n \t<li>Click the Attach icon (it looks like a paperclip) below the Compose box and select the source for the attachment you want to share.</li>\r\n \t<li>Select the file from the source and upload it. The file you uploaded will now be embedded in the message.</li>\r\n \t<li>Click the Send icon (it looks like an airplane) to post your message. The file you shared will also show up in the Files tab. Alternatively, you can go directly to the Files tab and click the Upload button to upload a file. Once the file is uploaded, click the name of the file to open it. Once opened, you can start a conversation with others regarding the document.</li>\r\n</ol>\r\n<h2 id=\"tab7\" >Meeting and conferencing the Microsoft Teams way</h2>\r\nChats and conversations in Teams are fun ways to communicate with others. Sometimes, however, it’s more efficient to get on a quick call with team members to resolve an issue versus going back and forth in a chat. Fortunately, Teams provides a complete meeting solution with support for audio and video conferencing. Because calling capabilities are built into Teams, you don’t need to log out of Teams and open a separate application to start an ad-hoc meeting.\r\n\r\nFor more formal meetings, you can schedule a meeting much like how you set up meetings in Outlook. Meetings you create in Teams will show up in your <a href=\"https://www.dummies.com/software/microsoft-office/outlook/10-tips-for-using-outlook-2019s-calendar-module/\" target=\"_blank\" rel=\"noopener\">Outlook calendar</a>.\r\n<h2 id=\"tab8\" >Setting up an impromptu Microsoft Teams meeting</h2>\r\nLet’s say for example you are chatting with three members of your team about an issue. After a lengthy back and forth and waiting times in between, you decide it’ll be much faster to just get on a call and talk about the issue. To start an impromptu meeting:\r\n<ol>\r\n \t<li>Reply to the conversation thread and click the Video icon that appears at the bottom of the Compose box.</li>\r\n \t<li>From the video window that pops up, enter a subject for your call.</li>\r\n \t<li>Toggle the video camera on or off to choose between sharing your video or just audio.</li>\r\n \t<li>Click Meet Now to start the conference. A conference window will open with a pane on the right where you can invite others to join the meeting.\r\n\r\n[caption id=\"attachment_259027\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259027 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-impromptu-teams-meeting.jpg\" alt=\"impromptu Teams meeting\" width=\"535\" height=\"304\" /> Starting an impromptu meeting.[/caption]</li>\r\n \t<li>When you’re done with the meeting, click the red phone icon to end the call and leave the meeting.</li>\r\n</ol>\r\nAfter the meeting, notes and conversations are posted to the channel so others who couldn’t make it to the meeting can quickly catch up on what they’ve missed.\r\n<h2 id=\"tab9\" >Scheduling a Microsoft Teams meeting</h2>\r\nYou can set up a formal meeting ahead of time to give the invited participants notice about a meeting. Like Outlook, formal meeting requests in Teams include a Meeting Title (the equivalent of Subject in Outlook), Location, Start and End Date or Time, Details, and a list of participants. In Teams, you can select a channel to meet in. When a channel is selected, artifacts from the meeting are posted in the channel.\r\n\r\nTo schedule a Teams meeting:\r\n<ol>\r\n \t<li>Click Meetings from the Apps bar.</li>\r\n \t<li>Click the Schedule a Meeting button that appears at the bottom of the left pane.\r\n\r\n[caption id=\"attachment_259028\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259028 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-teams-meeting.png\" alt=\"schedule Teams meeting\" width=\"535\" height=\"395\" /> Scheduling a Teams meeting.[/caption]</li>\r\n \t<li>From the New meeting window, enter the Title, Location, Start and End Date/Time, Details, Channel, and the names of the people you want to invite to the meeting.</li>\r\n \t<li>If you want to check people’s availability, click Schedule Assistant above the Details section to display your participants’ availability based on their Outlook calendars.</li>\r\n \t<li>Click the Schedule a Meeting button. The meeting is now scheduled and will appear in the Meetings section in Teams as well as in your Outlook calendar.</li>\r\n</ol>","description":"Microsoft Teams is available to users who have licenses with following <a href=\"https://www.dummies.com/software/microsoft-office/pricing-for-office-365-determining-the-right-plan-for-your-organization/\" target=\"_blank\" rel=\"noopener\">Office 365 corporate subscriptions</a>: E1, E3, E5, Business Premium, and Business Essentials. In the education plans, it is available in the A1, A1 Plus, A5, and A3 subscriptions. Plans are in place to roll out Teams in the government cloud as well.\r\n\r\nTeams can be accessed from the web browser, a desktop application, or a mobile app. The maximum number of users who can access the full functionality of Teams is based on the number of licensed users in the organization. Guest access is allowed, which means that users from other Office 365 tenants can be invited to an organization’s Teams hub without the need for additional licenses.\r\n\r\nWith Teams, you can conduct one-on-one or group audio and video calls. You can share screens during web conferencing, schedule meetings, and also record those meetings. In addition, each user has up to 1 TB of storage space.\r\n\r\nFrom an administrator’s standpoint, Teams offers tools for managing users and third-party applications. There are reports to glean usage and settings that can be configured with policies specific to the organization. For peace of mind, Microsoft offers a 99.9 percent financially backed service-level agreement (SLA) uptime for Teams.\r\n<h2 id=\"tab1\" >Touring the Microsoft Teams user interface</h2>\r\nTabs, bots, @mentions, and red bangs are just part of the new lingo you’re going to need to add to your vocabulary to use Teams. That’s assuming you’re already a savvy social media user who knows what emojis, stickers, and giphys are all about.\r\n\r\nLet’s take a tour of the Teams user interface. When you run the desktop application, the first screen you see after you log in is shown below.\r\n\r\n<img class=\"aligncenter wp-image-259021 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-microsoft-teams.png\" alt=\"Microsoft Teams user interface\" width=\"535\" height=\"422\" />\r\n\r\n \r\n<ul>\r\n \t<li><strong>App bar:</strong> Here you can navigate to the various sections in Teams. From the top, you’ll see the following icons:\r\n<ul>\r\n \t<li><em>Activity</em> is where you’ll find mentions, replies, and other notifications.</li>\r\n \t<li><em>Chat</em> is where you’ll see your recent one-on-one or group chats and your Contacts list.</li>\r\n \t<li><em>Teams</em> displays all the teams you are a member of.</li>\r\n \t<li><em>Meetings </em>or <em>Calendar</em> is synched with your Outlook calendar and displays all your upcoming meetings.</li>\r\n \t<li><em>Files</em> aggregates all the files from all the teams you are a member of. It is also where you access your personal OneDrive for Business storage.</li>\r\n \t<li><em>Calls</em> allows you to see a history of all incoming and outgoing video and audio calls. You can also call others in your organization, simply by typing their name.</li>\r\n \t<li><em>[…]</em> includes links to apps that are tied to Teams and the channels within Teams.</li>\r\n \t<li><em>Store</em> takes you to apps and services that can be integrated into Teams.</li>\r\n \t<li><em>Feedback</em> takes you to the Microsoft Teams user voice page where you can leave feedback about the service.</li>\r\n</ul>\r\n</li>\r\n \t<li><strong>Teams section:</strong> In the image above, the Teams icon is selected in the App bar, so the list of one's teams is displayed.</li>\r\n \t<li><strong>Channel:</strong> A dedicated section within a team to organize conversations and tasks into specific topics or projects.</li>\r\n \t<li><strong>Join or Create a Team button:</strong> Clicking this button takes you through the process of creating or joining a team. This button is only visible when the Teams icon is selected in the App bar.</li>\r\n \t<li><strong>New Chat button:</strong> Clicking this button selects the Chat icon in the App bar and allows you to start a new chat with an individual or a group.</li>\r\n \t<li><strong>Command bar:</strong> This bar at the top is used to query apps or perform a search in Teams.</li>\r\n \t<li><strong>Tabs:</strong> Switch between different Teams pages with these tabs. Conversations and Files are automatically included; the + sign tab allows you to add shortcuts to content in Teams.</li>\r\n \t<li><strong>Channel Conversations:</strong> This section displays all the conversations in the selected channel. Chats in Channel Conversations are persistent, so if you’ve been away, it’s easy to scroll through to get caught up when you get back. Chats can include visual indicators such as the @mention, which indicates that the chat specifically mentions a user, or a red bang to indicate high importance. Take note that chats are open by design so everyone in the team has visibility to the conversation to help speed up the decision-making process when needed.</li>\r\n \t<li><strong>Compose box:</strong> This is where you can type a message to start a conversation. You can send a quick chat or expand the Compose box to access rich formatting tools.</li>\r\n \t<li><strong>Send icon:</strong> When you’re ready to share your chat, click the Send icon to post your chat to the team.</li>\r\n</ul>\r\n<h2 id=\"tab2\" >Getting help from the Microsoft Teams Command bar</h2>\r\nTeams is intuitive to use, but you if you need quick assistance, the Command bar is your one-stop destination for help. You can do a search across conversations, users, files, and apps. For example, if you enter the word “launch” in the command bar, the left pane will display the search results grouped by Messages, People, and Files.\r\n\r\n[caption id=\"attachment_259022\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259022 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-microsoft-teams-search-results.png\" alt=\"Microsoft Team command bar search results\" width=\"535\" height=\"164\" /> Command bar search results.[/caption]\r\n\r\nYou can also run a command right from the Command bar by entering a slash ( / ). This action will display the available commands or shortcuts. Select the appropriate command from the list to initiate the command.\r\n\r\n[caption id=\"attachment_259023\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259023 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-teams-slash-command-shortcuts.jpg\" alt=\"Microsoft Teams slash command shortcuts\" width=\"535\" height=\"420\" /> Slash command shortcuts.[/caption]\r\n\r\n \r\n<h2 id=\"tab3\" >Collaborating in the Microsoft Teams Hub</h2>\r\nMany think that the “email tree” phenomenon was isolated to big enterprise environments, but it often rears its ugly head in small organizations, too.\r\n\r\nImagine the following scenario: Someone sends an email to three people asking for their input on something. Two of the recipients immediately respond. Recipient #3 replies to Recipient #2 but forgets to reply to all. Now Recipient #2 has information the others don’t have. Recipient #1 then forwards the email to yet another person (Recipient #4) who replies to all with his feedback, which doesn’t account for what’s already been discussed prior to him being involved. Pretty soon, everyone’s mailbox explodes with replies to replies and replies to all so that the sender finally throws her hands up in frustration because now the conversation has gotten out of hand and she's spending too much time getting everyone up to speed. On top of that, she now must consolidate all the feedback manually.\r\n\r\nTeams makes email trees go away. In Teams, the sender can avoid the previous scenario by uploading the file into the Teams channel, @mention the people she needs feedback from, and start a conversation right from the document in Teams. This way, everyone sees everyone’s comments and edits. A new person joining the conversation can just scroll up to get up to speed and everyone is well-informed and happy.\r\n\r\n[caption id=\"attachment_259024\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259024 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-microsoft-teams-conversation.jpg\" alt=\"Microsoft Teams conversation\" width=\"535\" height=\"265\" /> Starting a conversation about a document in Teams.[/caption]\r\n\r\n \r\n<h2 id=\"tab4\" >Creating and managing a Microsoft Teams hub</h2>\r\nTo collaborate in Teams, you first need to be either a member of a Teams hub or the creator of one. To create a team:\r\n<ol>\r\n \t<li>Click Teams from the App bar.</li>\r\n \t<li>Click the Join or Create a Team link that appears at the bottom of the App bar.</li>\r\n \t<li>Click the Create a Team card.</li>\r\n \t<li>Enter the name and description of the team.</li>\r\n \t<li>Choose the privacy settings for your team (Private or Public). A <em>Private</em> team means only team owners can add members, while a <em>Public</em> team means anyone in your organization can join the Team.</li>\r\n \t<li>Click Next.</li>\r\n \t<li>Add members to your team by adding a name, email address, a distribution list, or a mail-enabled security group in the Add box. A team can have a maximum of 2,500 members from either your organization or external users through secure guest access.</li>\r\n \t<li>Optionally, you can choose the role of the team member (Owner or Member) by clicking the drop-down arrow next to Member. If you forget to do this, you can update the membership type later.</li>\r\n \t<li>Click Close. Team management features are accessed by clicking the ellipses next to your team name in the App bar. The following management options are available:\r\n<ul>\r\n \t<li><em>Manage team</em> launches the Members tab where you can add or remove members, change the role of a member, or search for a member.</li>\r\n \t<li><em>Add a channel</em> launches a dialog box where you can enter a channel name and the description for the channel.</li>\r\n \t<li><em>Add members</em> launches a dialog box where you can enter the names of people, distribution lists, or mail-enabled security groups to add to your team.</li>\r\n \t<li><em>Leave the team</em> launches a validation window that asks you to confirm your intent to leave the team.</li>\r\n \t<li><em>Edit team</em> launches a dialog box where you can change the team name, the team description, and privacy settings.</li>\r\n \t<li><em>Get link to team</em> launches a dialog box where you can copy the URL for the team to share with others.</li>\r\n \t<li><em>Delete the team</em> launches a validation window that asks you to confirm your intent to delete the team.</li>\r\n</ul>\r\n</li>\r\n</ol>\r\n[caption id=\"attachment_259025\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259025 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-manage-microsoft-teams.jpg\" alt=\"manage Microsoft Team members\" width=\"535\" height=\"231\" /> Managing members of the Team.[/caption]\r\n\r\n \r\n<h2 id=\"tab5\" >Chatting in Microsoft Teams</h2>\r\nWhen a new member is added to a team, that member automatically gets access to all previous conversations, files, and other types of information shared in the team’s hub. This is especially helpful for onboarding a new team member to a project. There is no need to think about what files to forward to get the new member up to speed, since they can self-serve from the content available in the hub or simply ask for help from others through chat.\r\n\r\nTo start a chat, click on the Compose Box and start typing your message while in either the Activity, Chat, or Teams sections. When you’re done, click the Send icon to post your message. Depending on the culture of your team, you can spice up your chats with emojis, giphys, or stickers. You’ll find a variety of options when you click these icons below the Compose Box.\r\n<p class=\"article-tips tip\">Sometimes conversations in a team can become noisy when there are many members talking about different topics. To help with that, take advantage of the threaded messages feature in Teams by replying directly to a specific message so the reply in in context with the original message.</p>\r\n\r\n<h2 id=\"tab6\" >Sharing files in Microsoft Teams</h2>\r\nWhen you create a Teams hub, a SharePoint site is automatically created in the backend, which, in turn, creates a document library for each channel. Files uploaded in a Teams channel show up in the Files tab and are stored in a SharePoint document library. In fact, you can click the ellipses next to the file name and then choose to open the file from its location in <a href=\"https://www.dummies.com/software/microsoft-office/what-is-microsoft-sharepoint-a-brief-tour/\" target=\"_blank\" rel=\"noopener\">SharePoint</a>.\r\n\r\n[caption id=\"attachment_259026\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259026 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-teams-sharepoint.jpg\" alt=\"Open SharePoint file from Teams\" width=\"535\" height=\"341\" /> Opening a file in SharePoint from Teams.[/caption]\r\n\r\n \r\n\r\nTo share a file in Teams:\r\n<ol>\r\n \t<li>Select Teams from the App bar.</li>\r\n \t<li>Compose a message in the Compose box from a channel.</li>\r\n \t<li>Click the Attach icon (it looks like a paperclip) below the Compose box and select the source for the attachment you want to share.</li>\r\n \t<li>Select the file from the source and upload it. The file you uploaded will now be embedded in the message.</li>\r\n \t<li>Click the Send icon (it looks like an airplane) to post your message. The file you shared will also show up in the Files tab. Alternatively, you can go directly to the Files tab and click the Upload button to upload a file. Once the file is uploaded, click the name of the file to open it. Once opened, you can start a conversation with others regarding the document.</li>\r\n</ol>\r\n<h2 id=\"tab7\" >Meeting and conferencing the Microsoft Teams way</h2>\r\nChats and conversations in Teams are fun ways to communicate with others. Sometimes, however, it’s more efficient to get on a quick call with team members to resolve an issue versus going back and forth in a chat. Fortunately, Teams provides a complete meeting solution with support for audio and video conferencing. Because calling capabilities are built into Teams, you don’t need to log out of Teams and open a separate application to start an ad-hoc meeting.\r\n\r\nFor more formal meetings, you can schedule a meeting much like how you set up meetings in Outlook. Meetings you create in Teams will show up in your <a href=\"https://www.dummies.com/software/microsoft-office/outlook/10-tips-for-using-outlook-2019s-calendar-module/\" target=\"_blank\" rel=\"noopener\">Outlook calendar</a>.\r\n<h2 id=\"tab8\" >Setting up an impromptu Microsoft Teams meeting</h2>\r\nLet’s say for example you are chatting with three members of your team about an issue. After a lengthy back and forth and waiting times in between, you decide it’ll be much faster to just get on a call and talk about the issue. To start an impromptu meeting:\r\n<ol>\r\n \t<li>Reply to the conversation thread and click the Video icon that appears at the bottom of the Compose box.</li>\r\n \t<li>From the video window that pops up, enter a subject for your call.</li>\r\n \t<li>Toggle the video camera on or off to choose between sharing your video or just audio.</li>\r\n \t<li>Click Meet Now to start the conference. A conference window will open with a pane on the right where you can invite others to join the meeting.\r\n\r\n[caption id=\"attachment_259027\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259027 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-impromptu-teams-meeting.jpg\" alt=\"impromptu Teams meeting\" width=\"535\" height=\"304\" /> Starting an impromptu meeting.[/caption]</li>\r\n \t<li>When you’re done with the meeting, click the red phone icon to end the call and leave the meeting.</li>\r\n</ol>\r\nAfter the meeting, notes and conversations are posted to the channel so others who couldn’t make it to the meeting can quickly catch up on what they’ve missed.\r\n<h2 id=\"tab9\" >Scheduling a Microsoft Teams meeting</h2>\r\nYou can set up a formal meeting ahead of time to give the invited participants notice about a meeting. Like Outlook, formal meeting requests in Teams include a Meeting Title (the equivalent of Subject in Outlook), Location, Start and End Date or Time, Details, and a list of participants. In Teams, you can select a channel to meet in. When a channel is selected, artifacts from the meeting are posted in the channel.\r\n\r\nTo schedule a Teams meeting:\r\n<ol>\r\n \t<li>Click Meetings from the Apps bar.</li>\r\n \t<li>Click the Schedule a Meeting button that appears at the bottom of the left pane.\r\n\r\n[caption id=\"attachment_259028\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259028 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-365-teams-meeting.png\" alt=\"schedule Teams meeting\" width=\"535\" height=\"395\" /> Scheduling a Teams meeting.[/caption]</li>\r\n \t<li>From the New meeting window, enter the Title, Location, Start and End Date/Time, Details, Channel, and the names of the people you want to invite to the meeting.</li>\r\n \t<li>If you want to check people’s availability, click Schedule Assistant above the Details section to display your participants’ availability based on their Outlook calendars.</li>\r\n \t<li>Click the Schedule a Meeting button. The meeting is now scheduled and will appear in the Meetings section in Teams as well as in your Outlook calendar.</li>\r\n</ol>","blurb":"","authors":[{"authorId":10888,"name":"Rosemarie Withee","slug":"rosemarie-withee","description":"Rosemarie Withee is a technology professional who has authored a number of books in the For Dummies series, including the most recent editions of Office 365 For Dummies and SharePoint For Dummies. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10888"}},{"authorId":9718,"name":"Ken Withee","slug":"ken-withee","description":"Ken Withee is a Microsoft certified technology specialist in SharePoint, SQL Server, and .NET.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9718"}},{"authorId":10015,"name":"Jennifer Reed","slug":"jennifer-reed","description":"Jennifer Reed is the founder of Cloud611, an IT services company that helps small and midsize businesses take advantage of cloud technologies to drive business outcomes. As a solutions architect, Reed has helped migrate thousands of users to Office 365.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10015"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General (Microsoft)","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[{"label":"Touring the Microsoft Teams user interface","target":"#tab1"},{"label":"Getting help from the Microsoft Teams Command bar","target":"#tab2"},{"label":"Collaborating in the Microsoft Teams Hub","target":"#tab3"},{"label":"Creating and managing a Microsoft Teams hub","target":"#tab4"},{"label":"Chatting in Microsoft Teams","target":"#tab5"},{"label":"Sharing files in Microsoft Teams","target":"#tab6"},{"label":"Meeting and conferencing the Microsoft Teams way","target":"#tab7"},{"label":"Setting up an impromptu Microsoft Teams meeting","target":"#tab8"},{"label":"Scheduling a Microsoft Teams meeting","target":"#tab9"}],"relatedArticles":{"fromBook":[{"articleId":259010,"title":"Office 365: Building Reports with Power BI","slug":"office-365-building-reports-with-power-bi","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259010"}},{"articleId":259000,"title":"Working Efficiently with Office 365 Online","slug":"working-efficiently-with-office-365-online","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259000"}},{"articleId":258986,"title":"Office 365 on Mobile: Apps that Keep You Going","slug":"office-365-on-mobile-apps-that-keep-you-going","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258986"}},{"articleId":258981,"title":"What is Microsoft SharePoint: A Brief Tour","slug":"what-is-microsoft-sharepoint-a-brief-tour","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258981"}},{"articleId":258972,"title":"Office 365 Email: Message Encryption and Security","slug":"office-365-email-message-encryption-and-security","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258972"}}],"fromCategory":[{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290233"}},{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290196"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289688"}},{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}},{"articleId":265311,"title":"How to Change a Chart's Appearance in Office 365","slug":"how-to-change-a-charts-appearance-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265311"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281805,"slug":"office-365-for-dummies-3rd-edition","isbn":"9781119513353","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119513359/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119513359/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119513359-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119513359/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119513359/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/office-365-for-dummies-3rd-edition-cover-9781119513353-203x255.jpg","width":203,"height":255},"title":"Office 365 For Dummies, 3rd Edition","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n <p><b data-author-id=\"10888\">Rosemarie Withee</b> is President of Portal Integrators and Founder of Scrum Now with office in Seattle, WA and Laguna, Philippines. <b data-author-id=\"9718\">Ken Withee</b> is a Microsoft Certified Technology Specialist in SharePoint, SQL Server, and .NET. <b data-author-id=\"10015\">Jennifer Reed</b> is a Microsoft Certified Professional in Office 365 Administration and founder of Cloud611. </p>","authors":[{"authorId":10888,"name":"Rosemarie Withee","slug":"rosemarie-withee","description":"Rosemarie Withee is a technology professional who has authored a number of books in the For Dummies series, including the most recent editions of Office 365 For Dummies and SharePoint For Dummies. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10888"}},{"authorId":9718,"name":"Ken Withee","slug":"ken-withee","description":"Ken Withee is a Microsoft certified technology specialist in SharePoint, SQL Server, and .NET.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9718"}},{"authorId":10015,"name":"Jennifer Reed","slug":"jennifer-reed","description":"Jennifer Reed is the founder of Cloud611, an IT services company that helps small and midsize businesses take advantage of cloud technologies to drive business outcomes. As a solutions architect, Reed has helped migrate thousands of users to Office 365.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10015"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513353&quot;]}]\" id=\"du-slot-6217bb38ce18d\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513353&quot;]}]\" id=\"du-slot-6217bb38ceb86\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2021-09-13T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":259020},{"headers":{"creationTime":"2018-12-05T16:17:30+00:00","modifiedTime":"2021-10-05T21:53:00+00:00","timestamp":"2022-02-24T17:07:02+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General (Microsoft)","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"Access 2019: How to Create an Access Database","strippedTitle":"access 2019: how to create an access database","slug":"access-2019-how-to-create-an-access-database","canonicalUrl":"","seo":{"metaDescription":"To create a new Access database, you first need to create a table and then define the names of the fields in the table. Here's how.","noIndex":0,"noFollow":0},"content":"To create an Access database, you need to first create a database table and then define the names of all the fields you want to store in that table. Access database tables let you divide a file into separate parts.\r\n\r\nFor example, one database table may hold the names and addresses of all your customers, a second database table may hold the names and addresses of all your employees, and a third database table may hold the names and addresses of your suppliers. Access stores all this related information in a single Access file that’s saved on your hard drive.\r\n<h2 id=\"tab1\" >Designing an Access database</h2>\r\nTo design your Access database, you can create a database from scratch or use an existing template, which you can modify. <em>Designing</em> a database means defining both the number of fields to use for storing information and the maximum amount of data each field can hold.\r\n\r\nIf you have a field that stores numbers, what are the maximum and minimum limits on the numbers you want to save in that field? If you’re storing someone’s age, you probably don’t want the field to contain negative numbers or numbers beyond 200. If your field needs to hold salaries, the field may need to hold large numbers but no negative numbers.\r\n<p class=\"article-tips tip\">In general, store information in separate field in Access. So, rather than create a single field to hold someone’s full name, create two separate fields: One field holds a first name, and the second field holds the last name. By storing last names in a separate field, you can easily yank last names out of your database to create form letters that state, “The Smith family has just won $200,000 dollars in the Publisher’s Umpteenth Sales Pitch Sweepstakes!”</p>\r\nAccess can create a blank database or a special database by using one of many <a href=\"https://templates.office.com/en-us/\" target=\"_blank\" rel=\"noopener\">templates available from the Microsoft website</a>. No matter how you create a database, you will likely need to customize it for the type of data you want to store.\r\n\r\nWhen you start Access, it gives you a choice of opening an existing database or creating a new one.\r\n<h2 id=\"tab2\" >Creating a new database</h2>\r\nTo create a database with Access already running, follow these steps:\r\n<ol>\r\n \t<li>Click the File tab.</li>\r\n \t<li>Choose New.Access displays a variety of database templates you can use.\r\n\r\n[caption id=\"attachment_258000\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-258000 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-2019-create-access-database.jpg\" alt=\"create Access database\" width=\"535\" height=\"300\" /> Creating a database[/caption]</li>\r\n \t<li>Click an icon, such as Blank Database, or any database template. When you click a template, a window appears; you see a preview of your template.</li>\r\n \t<li>Click in the File Name text box and type a descriptive name for your database.\r\n<p class=\"article-tips tip\">If you click the folder icon that appears to the right of the File Name text box, you can open a dialog box that will let you define a specific drive and folder in which to store your database file.</p>\r\n</li>\r\n \t<li>Click the Create button to create your database file. Access displays a blank database.\r\n\r\n[caption id=\"attachment_258002\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-258002 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-2019-define-access-fields.jpg\" alt=\"define Access fields\" width=\"535\" height=\"300\" /> Start defining field names.[/caption]</li>\r\n \t<li>Click the Click to Add heading. Access displays a menu for defining what type of data that field can hold, such as text or numbers.\r\n\r\n[caption id=\"attachment_258003\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-258003 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-2019-create-databse-access.jpg\" alt=\"create database Access\" width=\"535\" height=\"253\" /> The Click to Add column heading displays a menu of different options.[/caption]</li>\r\n \t<li>Choose Long Text. Access displays a generic field name, such as Field 1.</li>\r\n \t<li>Type a name for your field (such as First Name or Salary).</li>\r\n \t<li>Press Enter.Access displays another Click to Add column; its menu lets you choose the type of data to store in the next field.</li>\r\n \t<li>Choose Long Text or any other data type you want the field to hold.Access displays another generic field, such as Field1.</li>\r\n \t<li>Type a name for your field, such as Last Name.</li>\r\n \t<li>Repeat Steps 9 through 11 for each additional field you want to create.</li>\r\n \t<li>When you have finished adding fields, press Esc on the keyboard.</li>\r\n</ol>\r\n<p class=\"article-tips tip\">Check here for <a href=\"https://www.dummies.com/software/microsoft-office/access/handy-access-2019-keyboard-shortcuts/\" target=\"_blank\" rel=\"noopener\">handy Access 2019 keyboard shortcuts</a>.</p>","description":"To create an Access database, you need to first create a database table and then define the names of all the fields you want to store in that table. Access database tables let you divide a file into separate parts.\r\n\r\nFor example, one database table may hold the names and addresses of all your customers, a second database table may hold the names and addresses of all your employees, and a third database table may hold the names and addresses of your suppliers. Access stores all this related information in a single Access file that’s saved on your hard drive.\r\n<h2 id=\"tab1\" >Designing an Access database</h2>\r\nTo design your Access database, you can create a database from scratch or use an existing template, which you can modify. <em>Designing</em> a database means defining both the number of fields to use for storing information and the maximum amount of data each field can hold.\r\n\r\nIf you have a field that stores numbers, what are the maximum and minimum limits on the numbers you want to save in that field? If you’re storing someone’s age, you probably don’t want the field to contain negative numbers or numbers beyond 200. If your field needs to hold salaries, the field may need to hold large numbers but no negative numbers.\r\n<p class=\"article-tips tip\">In general, store information in separate field in Access. So, rather than create a single field to hold someone’s full name, create two separate fields: One field holds a first name, and the second field holds the last name. By storing last names in a separate field, you can easily yank last names out of your database to create form letters that state, “The Smith family has just won $200,000 dollars in the Publisher’s Umpteenth Sales Pitch Sweepstakes!”</p>\r\nAccess can create a blank database or a special database by using one of many <a href=\"https://templates.office.com/en-us/\" target=\"_blank\" rel=\"noopener\">templates available from the Microsoft website</a>. No matter how you create a database, you will likely need to customize it for the type of data you want to store.\r\n\r\nWhen you start Access, it gives you a choice of opening an existing database or creating a new one.\r\n<h2 id=\"tab2\" >Creating a new database</h2>\r\nTo create a database with Access already running, follow these steps:\r\n<ol>\r\n \t<li>Click the File tab.</li>\r\n \t<li>Choose New.Access displays a variety of database templates you can use.\r\n\r\n[caption id=\"attachment_258000\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-258000 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-2019-create-access-database.jpg\" alt=\"create Access database\" width=\"535\" height=\"300\" /> Creating a database[/caption]</li>\r\n \t<li>Click an icon, such as Blank Database, or any database template. When you click a template, a window appears; you see a preview of your template.</li>\r\n \t<li>Click in the File Name text box and type a descriptive name for your database.\r\n<p class=\"article-tips tip\">If you click the folder icon that appears to the right of the File Name text box, you can open a dialog box that will let you define a specific drive and folder in which to store your database file.</p>\r\n</li>\r\n \t<li>Click the Create button to create your database file. Access displays a blank database.\r\n\r\n[caption id=\"attachment_258002\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-258002 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-2019-define-access-fields.jpg\" alt=\"define Access fields\" width=\"535\" height=\"300\" /> Start defining field names.[/caption]</li>\r\n \t<li>Click the Click to Add heading. Access displays a menu for defining what type of data that field can hold, such as text or numbers.\r\n\r\n[caption id=\"attachment_258003\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-258003 size-full\" src=\"https://www.dummies.com/wp-content/uploads/office-2019-create-databse-access.jpg\" alt=\"create database Access\" width=\"535\" height=\"253\" /> The Click to Add column heading displays a menu of different options.[/caption]</li>\r\n \t<li>Choose Long Text. Access displays a generic field name, such as Field 1.</li>\r\n \t<li>Type a name for your field (such as First Name or Salary).</li>\r\n \t<li>Press Enter.Access displays another Click to Add column; its menu lets you choose the type of data to store in the next field.</li>\r\n \t<li>Choose Long Text or any other data type you want the field to hold.Access displays another generic field, such as Field1.</li>\r\n \t<li>Type a name for your field, such as Last Name.</li>\r\n \t<li>Repeat Steps 9 through 11 for each additional field you want to create.</li>\r\n \t<li>When you have finished adding fields, press Esc on the keyboard.</li>\r\n</ol>\r\n<p class=\"article-tips tip\">Check here for <a href=\"https://www.dummies.com/software/microsoft-office/access/handy-access-2019-keyboard-shortcuts/\" target=\"_blank\" rel=\"noopener\">handy Access 2019 keyboard shortcuts</a>.</p>","blurb":"","authors":[{"authorId":9043,"name":"Wallace Wang","slug":"wallace-wang","description":"Wallace Wang is a stand-up comedian and the author of more than 10 best-selling For Dummies books. He focuses on screenwriting, movies, and comedy.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9043"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General (Microsoft)","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[{"label":"Designing an Access database","target":"#tab1"},{"label":"Creating a new database","target":"#tab2"}],"relatedArticles":{"fromBook":[{"articleId":258146,"title":"10 Ways to Make Office 2019 Easier to Use","slug":"10-ways-to-make-office-2019-easier-to-use","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258146"}},{"articleId":258139,"title":"Access Report Design: Applying Themes and Conditional Formatting in Access 2019","slug":"access-report-design-applying-themes-and-conditional-formatting-in-access-2019","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258139"}},{"articleId":258132,"title":"Access 2019 Reports: Editing the Data in a Report","slug":"access-2019-reports-editing-the-data-in-a-report","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258132"}},{"articleId":258092,"title":"How to Use the Report Wizard in Access 2019","slug":"how-to-use-the-report-wizard-in-access-2019","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258092"}},{"articleId":258013,"title":"10 Useful Features in Office 2019","slug":"10-useful-features-in-office-2019","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258013"}}],"fromCategory":[{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290233"}},{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290196"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289688"}},{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}},{"articleId":265311,"title":"How to Change a Chart's Appearance in Office 365","slug":"how-to-change-a-charts-appearance-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265311"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281802,"slug":"office-2019-for-dummies","isbn":"9781119513988","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119513987/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119513987/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119513987-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119513987/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119513987/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/office-2019-for-dummies-cover-9781119513988-203x255.jpg","width":203,"height":255},"title":"Office 2019 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n \t <p><b data-author-id=\"9043\">Wallace Wang</b> is the bestselling author of more than 50 computer books, with over three million of his <i>For Dummies</i> books in print. They include numerous versions of <i>Office For Dummies</i> as well as <i>Beginning Programming For Dummies</i>. When not playing with computers, Wallace splits his time between teaching, writing, game designing, screenwriting, and stand-up comedy. </p>","authors":[{"authorId":9043,"name":"Wallace Wang","slug":"wallace-wang","description":"Wallace Wang is a stand-up comedian and the author of more than 10 best-selling For Dummies books. He focuses on screenwriting, movies, and comedy.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9043"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513988&quot;]}]\" id=\"du-slot-6217bb36c707e\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513988&quot;]}]\" id=\"du-slot-6217bb36c7a3f\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2021-10-05T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":257989}],"_links":{"self":{"self":"https://dummies-api.dummies.com/v2/categories/33652/categoryArticles?sortField=time&sortOrder=1&size=10&offset=0"},"next":{"self":"https://dummies-api.dummies.com/v2/categories/33652/categoryArticles?sortField=time&sortOrder=1&size=10&offset=10"},"last":{"self":"https://dummies-api.dummies.com/v2/categories/33652/categoryArticles?sortField=time&sortOrder=1&size=10&offset=381"}}},"objectTitle":"","status":"success","pageType":"article-category","objectId":"33652","page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{"categoriesFilter":[{"itemId":0,"itemName":"All Categories","count":391}],"articleTypeFilter":[{"articleType":"All Types","count":391},{"articleType":"Articles","count":283},{"articleType":"Cheat Sheet","count":17},{"articleType":"Step by Step","count":76},{"articleType":"Videos","count":15}]},"filterDataLoadedStatus":"success","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2022-05-16T12:59:10+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"<!--Optimizely Script-->\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"<!-- comScore Tag -->\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n<!-- / comScore Tag -->","enabled":true},{"pages":["all"],"location":"footer","script":"<!--BEGIN QUALTRICS WEBSITE FEEDBACK SNIPPET-->\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'><!--DO NOT REMOVE-CONTENTS PLACED HERE--></div>\r\n<!--END WEBSITE FEEDBACK SNIPPET-->","enabled":false},{"pages":["all"],"location":"header","script":"<!-- Hotjar Tracking Code for http://www.dummies.com -->\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":"<!-- //Connect Container: dummies --> <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"<!-- Facebook Pixel Code -->\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n<!-- End Facebook Pixel Code -->","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"ArticleCategory","path":"/category/articles/general-microsoft-33652/","hash":"","query":{},"params":{"category":"general-microsoft-33652"},"fullPath":"/category/articles/general-microsoft-33652/","meta":{"routeType":"category","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"sfmcState":{"newsletterSignupStatus":"initial"}}
Logo
  • Articles Open Article Categories
  • Books Open Book Categories
  • Collections Open Collections list
  • Custom Solutions
  • Home
  • Technology Articles
  • Software Articles
  • Microsoft Products Articles
  • General (Microsoft) Articles

General (Microsoft) Articles

Get started with Microsoft 365, add graphics to all your Office files, share stuff straight to Facebook, speed up your work with keyboard shortcuts, and tons more neat stuff.

Articles From General (Microsoft)

page 1
page 2
page 3
page 4
page 5
page 6
page 7
page 8
page 9
page 10
page 11
page 12
page 13
page 14
page 15
page 16
page 17
page 18
page 19
page 20
page 21
page 22
page 23
page 24
page 25
page 26
page 27
page 28
page 29
page 30
page 31
page 32
page 33
page 34
page 35
page 36
page 37
page 38
page 39
page 40

Filter Results

391 results
391 results
General (Microsoft) Office 2019 All-in-One For Dummies Cheat Sheet

Cheat Sheet / Updated 03-25-2022

Master the commands in one Office 2019 program and you are well on your way to mastering the other programs. Following is key information you can take to any Office 2019 program you are working in.

View Cheat Sheet
General (Microsoft) Office 2021 For Macs For Dummies Cheat Sheet

Cheat Sheet / Updated 03-17-2022

Microsoft Office apps are chock full of options and features that are just too tough to squeeze into the pages of a single book. This cheat sheet includes a handful of helpful tips and tricks to give your Office experience a boost, including learning how to create automatic replies to senders, check your documents for accessibility issues, embed fonts in your Word documents and PowerPoint presentations for better portability when sharing, and even check the current weather when perusing your Outlook Calendar.

View Cheat Sheet
General (Microsoft) Microsoft Office 2019 For Dummies Cheat Sheet

Cheat Sheet / Updated 03-15-2022

Microsoft Office 2019 comes jam-packed with features. This Cheat Sheet can help you navigate around those features easier by providing keyboard shortcuts and tips for using the mouse, and ribbon to get fast access to the most commonly used commands. You’ll master Office 2019 in no time!

View Cheat Sheet
General (Microsoft) Office 365 For Dummies Cheat Sheet

Cheat Sheet / Updated 02-24-2022

Millions of users have realized the value of Office 365. Making the best use of the services that make up Office 365, however, can be a challenge. This guide is a quick reference to the key services, productivity tools, and security features in Office 365 to help you maximize your investment in the technology.

View Cheat Sheet
General (Microsoft) Office 365 All-in-One For Dummies Cheat Sheet

Cheat Sheet / Updated 02-23-2022

Here are some useful Office 365 features worth knowing about. Two of these cheat sheets explain how Office 365 lets you turn one thing into another — how to turn a Word document into a PowerPoint presentation and how to turn an Office 365 file into a PDF so that people who don’t have Office can read it. For people who get mountains of email, here are instructions for moving your Office 365 email messages as they arrive into a specific Outlook folder.

View Cheat Sheet
General (Microsoft) Microsoft 365 For Dummies Cheat Sheet

Cheat Sheet / Updated 01-10-2022

If your organization has implemented Microsoft 365 as a productivity suite, be prepared to discover the bells and whistles of a cloud solution that has been adopted by millions of users across the globe. Even if you’re already a superuser of the bundled Office applications like Outlook, Word, Excel, and PowerPoint, you’ll find there are still a lot of features and functionalities within these tools you’ve never heard of before. Before you become overwhelmed trying to figure out all the how-tos, take a step back and consider the following tips. You might just realize the best value of Microsoft 365 is how you can adapt it to your own personality and style.

View Cheat Sheet
General (Microsoft) Office 2021 All-in-One For Dummies Cheat Sheet

Cheat Sheet / Updated 01-07-2022

Here are a few shortcuts to help you get your work done faster in Office 2021. Read on to see how to insert one Word 2021 file into another without having to cut and paste, how to enter serial information such as numbers and dates into an Excel 2021 worksheet, and how to make a Word 2021 file the genesis for a PowerPoint 2021 presentation.

View Cheat Sheet
General (Microsoft) Office 2021 For Seniors For Dummies Cheat Sheet

Cheat Sheet / Updated 12-07-2021

After you discover keyboard shortcuts in Office, you’ll wonder how you ever functioned without them. Keyboard shortcuts make common tasks faster and easier. By pressing a key combination, you can duplicate many of the most commonly used commands and tasks. Some of the keyboard shortcuts are the same across multiple applications, whereas others are specific to a particular application.

View Cheat Sheet
General (Microsoft) How to Use Microsoft Teams

Article / Updated 10-21-2021

Microsoft Teams is available to users who have licenses with following Office 365 corporate subscriptions: E1, E3, E5, Business Premium, and Business Essentials. In the education plans, it is available in the A1, A1 Plus, A5, and A3 subscriptions. Plans are in place to roll out Teams in the government cloud as well. Teams can be accessed from the web browser, a desktop application, or a mobile app. The maximum number of users who can access the full functionality of Teams is based on the number of licensed users in the organization. Guest access is allowed, which means that users from other Office 365 tenants can be invited to an organization’s Teams hub without the need for additional licenses. With Teams, you can conduct one-on-one or group audio and video calls. You can share screens during web conferencing, schedule meetings, and also record those meetings. In addition, each user has up to 1 TB of storage space. From an administrator’s standpoint, Teams offers tools for managing users and third-party applications. There are reports to glean usage and settings that can be configured with policies specific to the organization. For peace of mind, Microsoft offers a 99.9 percent financially backed service-level agreement (SLA) uptime for Teams. Touring the Microsoft Teams user interface Tabs, bots, @mentions, and red bangs are just part of the new lingo you’re going to need to add to your vocabulary to use Teams. That’s assuming you’re already a savvy social media user who knows what emojis, stickers, and giphys are all about. Let’s take a tour of the Teams user interface. When you run the desktop application, the first screen you see after you log in is shown below. App bar: Here you can navigate to the various sections in Teams. From the top, you’ll see the following icons: Activity is where you’ll find mentions, replies, and other notifications. Chat is where you’ll see your recent one-on-one or group chats and your Contacts list. Teams displays all the teams you are a member of. Meetings or Calendar is synched with your Outlook calendar and displays all your upcoming meetings. Files aggregates all the files from all the teams you are a member of. It is also where you access your personal OneDrive for Business storage. Calls allows you to see a history of all incoming and outgoing video and audio calls. You can also call others in your organization, simply by typing their name. […] includes links to apps that are tied to Teams and the channels within Teams. Store takes you to apps and services that can be integrated into Teams. Feedback takes you to the Microsoft Teams user voice page where you can leave feedback about the service. Teams section: In the image above, the Teams icon is selected in the App bar, so the list of one's teams is displayed. Channel: A dedicated section within a team to organize conversations and tasks into specific topics or projects. Join or Create a Team button: Clicking this button takes you through the process of creating or joining a team. This button is only visible when the Teams icon is selected in the App bar. New Chat button: Clicking this button selects the Chat icon in the App bar and allows you to start a new chat with an individual or a group. Command bar: This bar at the top is used to query apps or perform a search in Teams. Tabs: Switch between different Teams pages with these tabs. Conversations and Files are automatically included; the + sign tab allows you to add shortcuts to content in Teams. Channel Conversations: This section displays all the conversations in the selected channel. Chats in Channel Conversations are persistent, so if you’ve been away, it’s easy to scroll through to get caught up when you get back. Chats can include visual indicators such as the @mention, which indicates that the chat specifically mentions a user, or a red bang to indicate high importance. Take note that chats are open by design so everyone in the team has visibility to the conversation to help speed up the decision-making process when needed. Compose box: This is where you can type a message to start a conversation. You can send a quick chat or expand the Compose box to access rich formatting tools. Send icon: When you’re ready to share your chat, click the Send icon to post your chat to the team. Getting help from the Microsoft Teams Command bar Teams is intuitive to use, but you if you need quick assistance, the Command bar is your one-stop destination for help. You can do a search across conversations, users, files, and apps. For example, if you enter the word “launch” in the command bar, the left pane will display the search results grouped by Messages, People, and Files. You can also run a command right from the Command bar by entering a slash ( / ). This action will display the available commands or shortcuts. Select the appropriate command from the list to initiate the command. Collaborating in the Microsoft Teams Hub Many think that the “email tree” phenomenon was isolated to big enterprise environments, but it often rears its ugly head in small organizations, too. Imagine the following scenario: Someone sends an email to three people asking for their input on something. Two of the recipients immediately respond. Recipient #3 replies to Recipient #2 but forgets to reply to all. Now Recipient #2 has information the others don’t have. Recipient #1 then forwards the email to yet another person (Recipient #4) who replies to all with his feedback, which doesn’t account for what’s already been discussed prior to him being involved. Pretty soon, everyone’s mailbox explodes with replies to replies and replies to all so that the sender finally throws her hands up in frustration because now the conversation has gotten out of hand and she's spending too much time getting everyone up to speed. On top of that, she now must consolidate all the feedback manually. Teams makes email trees go away. In Teams, the sender can avoid the previous scenario by uploading the file into the Teams channel, @mention the people she needs feedback from, and start a conversation right from the document in Teams. This way, everyone sees everyone’s comments and edits. A new person joining the conversation can just scroll up to get up to speed and everyone is well-informed and happy. Creating and managing a Microsoft Teams hub To collaborate in Teams, you first need to be either a member of a Teams hub or the creator of one. To create a team: Click Teams from the App bar. Click the Join or Create a Team link that appears at the bottom of the App bar. Click the Create a Team card. Enter the name and description of the team. Choose the privacy settings for your team (Private or Public). A Private team means only team owners can add members, while a Public team means anyone in your organization can join the Team. Click Next. Add members to your team by adding a name, email address, a distribution list, or a mail-enabled security group in the Add box. A team can have a maximum of 2,500 members from either your organization or external users through secure guest access. Optionally, you can choose the role of the team member (Owner or Member) by clicking the drop-down arrow next to Member. If you forget to do this, you can update the membership type later. Click Close. Team management features are accessed by clicking the ellipses next to your team name in the App bar. The following management options are available: Manage team launches the Members tab where you can add or remove members, change the role of a member, or search for a member. Add a channel launches a dialog box where you can enter a channel name and the description for the channel. Add members launches a dialog box where you can enter the names of people, distribution lists, or mail-enabled security groups to add to your team. Leave the team launches a validation window that asks you to confirm your intent to leave the team. Edit team launches a dialog box where you can change the team name, the team description, and privacy settings. Get link to team launches a dialog box where you can copy the URL for the team to share with others. Delete the team launches a validation window that asks you to confirm your intent to delete the team. Chatting in Microsoft Teams When a new member is added to a team, that member automatically gets access to all previous conversations, files, and other types of information shared in the team’s hub. This is especially helpful for onboarding a new team member to a project. There is no need to think about what files to forward to get the new member up to speed, since they can self-serve from the content available in the hub or simply ask for help from others through chat. To start a chat, click on the Compose Box and start typing your message while in either the Activity, Chat, or Teams sections. When you’re done, click the Send icon to post your message. Depending on the culture of your team, you can spice up your chats with emojis, giphys, or stickers. You’ll find a variety of options when you click these icons below the Compose Box. Sometimes conversations in a team can become noisy when there are many members talking about different topics. To help with that, take advantage of the threaded messages feature in Teams by replying directly to a specific message so the reply in in context with the original message. Sharing files in Microsoft Teams When you create a Teams hub, a SharePoint site is automatically created in the backend, which, in turn, creates a document library for each channel. Files uploaded in a Teams channel show up in the Files tab and are stored in a SharePoint document library. In fact, you can click the ellipses next to the file name and then choose to open the file from its location in SharePoint. To share a file in Teams: Select Teams from the App bar. Compose a message in the Compose box from a channel. Click the Attach icon (it looks like a paperclip) below the Compose box and select the source for the attachment you want to share. Select the file from the source and upload it. The file you uploaded will now be embedded in the message. Click the Send icon (it looks like an airplane) to post your message. The file you shared will also show up in the Files tab. Alternatively, you can go directly to the Files tab and click the Upload button to upload a file. Once the file is uploaded, click the name of the file to open it. Once opened, you can start a conversation with others regarding the document. Meeting and conferencing the Microsoft Teams way Chats and conversations in Teams are fun ways to communicate with others. Sometimes, however, it’s more efficient to get on a quick call with team members to resolve an issue versus going back and forth in a chat. Fortunately, Teams provides a complete meeting solution with support for audio and video conferencing. Because calling capabilities are built into Teams, you don’t need to log out of Teams and open a separate application to start an ad-hoc meeting. For more formal meetings, you can schedule a meeting much like how you set up meetings in Outlook. Meetings you create in Teams will show up in your Outlook calendar. Setting up an impromptu Microsoft Teams meeting Let’s say for example you are chatting with three members of your team about an issue. After a lengthy back and forth and waiting times in between, you decide it’ll be much faster to just get on a call and talk about the issue. To start an impromptu meeting: Reply to the conversation thread and click the Video icon that appears at the bottom of the Compose box. From the video window that pops up, enter a subject for your call. Toggle the video camera on or off to choose between sharing your video or just audio. Click Meet Now to start the conference. A conference window will open with a pane on the right where you can invite others to join the meeting. When you’re done with the meeting, click the red phone icon to end the call and leave the meeting. After the meeting, notes and conversations are posted to the channel so others who couldn’t make it to the meeting can quickly catch up on what they’ve missed. Scheduling a Microsoft Teams meeting You can set up a formal meeting ahead of time to give the invited participants notice about a meeting. Like Outlook, formal meeting requests in Teams include a Meeting Title (the equivalent of Subject in Outlook), Location, Start and End Date or Time, Details, and a list of participants. In Teams, you can select a channel to meet in. When a channel is selected, artifacts from the meeting are posted in the channel. To schedule a Teams meeting: Click Meetings from the Apps bar. Click the Schedule a Meeting button that appears at the bottom of the left pane. From the New meeting window, enter the Title, Location, Start and End Date/Time, Details, Channel, and the names of the people you want to invite to the meeting. If you want to check people’s availability, click Schedule Assistant above the Details section to display your participants’ availability based on their Outlook calendars. Click the Schedule a Meeting button. The meeting is now scheduled and will appear in the Meetings section in Teams as well as in your Outlook calendar.

View Article
General (Microsoft) Access 2019: How to Create an Access Database

Article / Updated 10-05-2021

To create an Access database, you need to first create a database table and then define the names of all the fields you want to store in that table. Access database tables let you divide a file into separate parts. For example, one database table may hold the names and addresses of all your customers, a second database table may hold the names and addresses of all your employees, and a third database table may hold the names and addresses of your suppliers. Access stores all this related information in a single Access file that’s saved on your hard drive. Designing an Access database To design your Access database, you can create a database from scratch or use an existing template, which you can modify. Designing a database means defining both the number of fields to use for storing information and the maximum amount of data each field can hold. If you have a field that stores numbers, what are the maximum and minimum limits on the numbers you want to save in that field? If you’re storing someone’s age, you probably don’t want the field to contain negative numbers or numbers beyond 200. If your field needs to hold salaries, the field may need to hold large numbers but no negative numbers. In general, store information in separate field in Access. So, rather than create a single field to hold someone’s full name, create two separate fields: One field holds a first name, and the second field holds the last name. By storing last names in a separate field, you can easily yank last names out of your database to create form letters that state, “The Smith family has just won $200,000 dollars in the Publisher’s Umpteenth Sales Pitch Sweepstakes!” Access can create a blank database or a special database by using one of many templates available from the Microsoft website. No matter how you create a database, you will likely need to customize it for the type of data you want to store. When you start Access, it gives you a choice of opening an existing database or creating a new one. Creating a new database To create a database with Access already running, follow these steps: Click the File tab. Choose New.Access displays a variety of database templates you can use. Click an icon, such as Blank Database, or any database template. When you click a template, a window appears; you see a preview of your template. Click in the File Name text box and type a descriptive name for your database. If you click the folder icon that appears to the right of the File Name text box, you can open a dialog box that will let you define a specific drive and folder in which to store your database file. Click the Create button to create your database file. Access displays a blank database. Click the Click to Add heading. Access displays a menu for defining what type of data that field can hold, such as text or numbers. Choose Long Text. Access displays a generic field name, such as Field 1. Type a name for your field (such as First Name or Salary). Press Enter.Access displays another Click to Add column; its menu lets you choose the type of data to store in the next field. Choose Long Text or any other data type you want the field to hold.Access displays another generic field, such as Field1. Type a name for your field, such as Last Name. Repeat Steps 9 through 11 for each additional field you want to create. When you have finished adding fields, press Esc on the keyboard. Check here for handy Access 2019 keyboard shortcuts.

View Article
page 1
page 2
page 3
page 4
page 5
page 6
page 7
page 8
page 9
page 10
page 11
page 12
page 13
page 14
page 15
page 16
page 17
page 18
page 19
page 20
page 21
page 22
page 23
page 24
page 25
page 26
page 27
page 28
page 29
page 30
page 31
page 32
page 33
page 34
page 35
page 36
page 37
page 38
page 39
page 40

Quick Links

  • About For Dummies
  • Contact Us
  • Activate A Book Pin

Connect

Opt in to our newsletter!

By entering your email address and clicking the “Submit” button, you agree to the Terms of Use and Privacy Policy & to receive electronic communications from Dummies.com, which may include marketing promotions, news and updates.

About Dummies

Dummies has always stood for taking on complex concepts and making them easy to understand. Dummies helps everyone be more knowledgeable and confident in applying what they know. Whether it's to pass that big test, qualify for that big promotion or even master that cooking technique; people who rely on dummies, rely on it to learn the critical skills and relevant information necessary for success.

Terms of Use
Privacy Policy
Cookies Settings
Do Not Sell My Personal Info - CA Only