{"appState":{"pageLoadApiCallsStatus":true},"categoryState":{"relatedCategories":{"headers":{"timestamp":"2023-09-15T12:01:06+00:00"},"categoryId":33642,"data":{"title":"Microsoft Products","slug":"microsoft-products","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}],"parentCategory":{"categoryId":33618,"title":"Software","slug":"software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"}},"childCategories":[{"categoryId":33643,"title":"Access","slug":"access","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33643"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0},"hasArticle":true,"hasBook":true,"articleCount":63,"bookCount":10},{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0},"hasArticle":true,"hasBook":true,"articleCount":1076,"bookCount":26},{"categoryId":33645,"title":"OneDrive","slug":"onedrive","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33645"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0},"hasArticle":true,"hasBook":false,"articleCount":3,"bookCount":0},{"categoryId":33646,"title":"Outlook","slug":"outlook","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33646"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0},"hasArticle":true,"hasBook":true,"articleCount":90,"bookCount":5},{"categoryId":33647,"title":"PowerPoint","slug":"powerpoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33647"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0},"hasArticle":true,"hasBook":true,"articleCount":191,"bookCount":5},{"categoryId":33648,"title":"Project","slug":"project","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33648"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0},"hasArticle":true,"hasBook":true,"articleCount":51,"bookCount":4},{"categoryId":33649,"title":"SharePoint","slug":"sharepoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33649"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0},"hasArticle":true,"hasBook":true,"articleCount":165,"bookCount":4},{"categoryId":33650,"title":"Teams","slug":"teams","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33650"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0},"hasArticle":true,"hasBook":true,"articleCount":12,"bookCount":1},{"categoryId":33651,"title":"Word","slug":"word","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33651"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0},"hasArticle":true,"hasBook":true,"articleCount":354,"bookCount":7},{"categoryId":33652,"title":"General Microsoft","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0},"hasArticle":true,"hasBook":true,"articleCount":386,"bookCount":29}],"description":"Hundreds of how-tos and tips for Word, Excel, Access, SharePoint, Project, and all your other Microsoft favorites.","relatedArticles":{"self":"https://dummies-api.dummies.com/v2/articles?category=33642&offset=0&size=5"},"hasArticle":true,"hasBook":true,"articleCount":2395,"bookCount":92},"_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"}},"relatedCategoriesLoadedStatus":"success"},"listState":{"list":{"count":10,"total":2403,"items":[{"headers":{"creationTime":"2016-03-26T13:02:06+00:00","modifiedTime":"2023-08-28T15:09:04+00:00","timestamp":"2023-08-28T18:01: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":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"How to Insert and Delete Cells and Ranges","strippedTitle":"how to insert and delete cells and ranges","slug":"how-to-insert-and-delete-cells-and-ranges","canonicalUrl":"","seo":{"metaDescription":"In Excel 2013, you can insert and delete individual cells or even ranges that don’t neatly correspond to entire rows or columns. When you do so, the surrounding","noIndex":0,"noFollow":0},"content":"<p>In Excel 2013, you can insert and delete individual cells or even ranges that don’t neatly correspond to entire rows or columns. When you do so, the surrounding cells shift. In the case of an insertion, cells move down or to the right of the area where the new cells are being inserted. In the case of a deletion, cells move up or to the left to fill in the voided space.</p>\r\n<p class=\"Remember\">Deleting a cell is different from clearing a cell’s content, and this becomes apparent when you start working with individual cells and ranges. When you clear the content, the cell itself remains. When you delete the cell itself, the adjacent cells shift.</p>\r\n<p>When shifting cells, Excel is smart enough that it tries to guess which direction you want existing content to move when you insert or delete cells. If you have content immediately to the right of a deleted cell, for example, Excel shifts it left. If you have content immediately below the deleted cell, Excel shifts it up. You can still override that, though, as needed.</p>\r\n<p>In the following exercise, you insert and delete cells. </p>\r\n<ol class=\"level-one\">\r\n <li><p class=\"first-para\">In the Lesson 5 Mortgage file from the preceding exercise, select A1:A6 and then choose Home→Delete.</p>\r\n<p class=\"child-para\">Excel guesses that you want to move the existing content to the left, and it does so.</p>\r\n </li>\r\n <li><p class=\"first-para\">Click cell A1, and choose Home→Insert.</p>\r\n<p class=\"child-para\">Excel guesses that you want to move the existing content down, which is incorrect. The content in column B is off by one row, as shown in this figure.</p>\r\n<img src=\"https://www.dummies.com/wp-content/uploads/418443.image0.jpg\" width=\"318\" height=\"379\" alt=\"image0.jpg\"/>\r\n </li>\r\n <li><p class=\"first-para\">Press Ctrl+Z to undo the insertion; then from the Home tab, click the down arrow to the right of the Insert button and choose Insert Cells.</p>\r\n<p class=\"child-para\">The Insert dialog box opens, as shown.</p>\r\n<img src=\"https://www.dummies.com/wp-content/uploads/418444.image1.jpg\" width=\"316\" height=\"313\" alt=\"image1.jpg\"/>\r\n </li>\r\n <li><p class=\"first-para\">Select Shift Cells Right and then click OK.</p>\r\n<p class=\"child-para\">A new cell A1 is inserted, and the previous A1 content moves into B1.</p>\r\n </li>\r\n <li><p class=\"first-para\">Save the changes to the workbook.</p>\r\n </li>\r\n</ol>","description":"<p>In Excel 2013, you can insert and delete individual cells or even ranges that don’t neatly correspond to entire rows or columns. When you do so, the surrounding cells shift. In the case of an insertion, cells move down or to the right of the area where the new cells are being inserted. In the case of a deletion, cells move up or to the left to fill in the voided space.</p>\r\n<p class=\"Remember\">Deleting a cell is different from clearing a cell’s content, and this becomes apparent when you start working with individual cells and ranges. When you clear the content, the cell itself remains. When you delete the cell itself, the adjacent cells shift.</p>\r\n<p>When shifting cells, Excel is smart enough that it tries to guess which direction you want existing content to move when you insert or delete cells. If you have content immediately to the right of a deleted cell, for example, Excel shifts it left. If you have content immediately below the deleted cell, Excel shifts it up. You can still override that, though, as needed.</p>\r\n<p>In the following exercise, you insert and delete cells. </p>\r\n<ol class=\"level-one\">\r\n <li><p class=\"first-para\">In the Lesson 5 Mortgage file from the preceding exercise, select A1:A6 and then choose Home→Delete.</p>\r\n<p class=\"child-para\">Excel guesses that you want to move the existing content to the left, and it does so.</p>\r\n </li>\r\n <li><p class=\"first-para\">Click cell A1, and choose Home→Insert.</p>\r\n<p class=\"child-para\">Excel guesses that you want to move the existing content down, which is incorrect. The content in column B is off by one row, as shown in this figure.</p>\r\n<img src=\"https://www.dummies.com/wp-content/uploads/418443.image0.jpg\" width=\"318\" height=\"379\" alt=\"image0.jpg\"/>\r\n </li>\r\n <li><p class=\"first-para\">Press Ctrl+Z to undo the insertion; then from the Home tab, click the down arrow to the right of the Insert button and choose Insert Cells.</p>\r\n<p class=\"child-para\">The Insert dialog box opens, as shown.</p>\r\n<img src=\"https://www.dummies.com/wp-content/uploads/418444.image1.jpg\" width=\"316\" height=\"313\" alt=\"image1.jpg\"/>\r\n </li>\r\n <li><p class=\"first-para\">Select Shift Cells Right and then click OK.</p>\r\n<p class=\"child-para\">A new cell A1 is inserted, and the previous A1 content moves into B1.</p>\r\n </li>\r\n <li><p class=\"first-para\">Save the changes to the workbook.</p>\r\n </li>\r\n</ol>","blurb":"","authors":[],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":208038,"title":"Office 2013 All-In-One For Dummies Cheat Sheet","slug":"office-2013-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208038"}},{"articleId":204397,"title":"How to Create and Enter Data in an Access 2013 Form","slug":"how-to-create-and-enter-data-in-an-access-2013-form","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/204397"}},{"articleId":204396,"title":"How to Establish Data-Validation Rules in Excel 2013","slug":"how-to-establish-data-validation-rules-in-excel-2013","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/204396"}},{"articleId":204395,"title":"How to Record an Audio Note in OneNote 2013","slug":"how-to-record-an-audio-note-in-onenote-2013","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/204395"}},{"articleId":204394,"title":"How to Present a PowerPoint 2013 Presentation Online","slug":"how-to-present-a-powerpoint-2013-presentation-online","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/204394"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281795,"slug":"office-2013-all-in-one-for-dummies","isbn":"9781118516362","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1118516362/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1118516362/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/1118516362-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1118516362/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1118516362/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/office-2013-all-in-one-for-dummies-cover-9781118516362-201x255.jpg","width":201,"height":255},"title":"Office 2013 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9034\">Peter Weverka</b> is a veteran technology author with several <i>For Dummies</i> titles to his credit, including multiple editions of <i>Office All-in-One For Dummies.</i> He's also written books on Word, PowerPoint, OneNote, Quicken, and Internet tools.</p>","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":" <p><b>Peter Weverka</b> is a veteran <i>For Dummies</i> author who has written about a wide variety of applications. Along with two bestselling editions of <i>Office All-in-One For Dummies</i>, Peter has written <i>PowerPoint All-in-One For Dummies</i> and <i>Microsoft Money For Dummies</i>.</p>","hasArticle":false,"_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;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118516362&quot;]}]\" id=\"du-slot-64ece0df0910e\"></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;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118516362&quot;]}]\" id=\"du-slot-64ece0df0a1c2\"></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},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Explore","lifeExpectancy":"Two years","lifeExpectancySetFrom":"2023-08-07T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":155408},{"headers":{"creationTime":"2016-03-26T07:18:27+00:00","modifiedTime":"2023-08-17T14:10:21+00:00","timestamp":"2023-08-17T15: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":"How to Use Wildcard Operators When Finding Stuff in Word 2016","strippedTitle":"how to use wildcard operators when finding stuff in word 2016","slug":"how-to-use-wildcard-operators-when-finding-stuff-in-word-2016","canonicalUrl":"","seo":{"metaDescription":"Word 2016 permits you to use wildcard operators in searches. A wildcard operator is a character that represents characters in a search expression. Wildcards are","noIndex":0,"noFollow":0},"content":"<p>Word 2016 permits you to use wildcard operators in searches. A <i>wildcard operator</i> is a character that represents characters in a search expression. Wildcards aren't for everybody. Using them requires a certain amount of expertise, but after you know how to use them, wildcards can be invaluable in searches and macros.</p>\r\n<p>The following table explains the wildcard operators that you can use in searches. Click the Use Wildcards check box if you want to search using wildcards.</p>\r\n<h2 id=\"tab1\" >Wildcards for Searches</h2>\r\n<table>\r\n<tr>\r\n<th>Operator</th>\r\n<th>What It Finds</th>\r\n<th>Example</th>\r\n</tr>\r\n<tr>\r\n<td>?</td>\r\n<td>Any single character</td>\r\n<td><b>b?t</b> finds <i>bat, bet, bit,</i> and <i>but.</i></td>\r\n</tr>\r\n<tr>\r\n<td>*</td>\r\n<td>Zero or more characters</td>\r\n<td><b>t*o</b> finds <i>to, two,</i> and <i>tattoo.</i></td>\r\n</tr>\r\n<tr>\r\n<td>[<i>xyz</i>]</td>\r\n<td>A specific character, <i>x, y,</i> or <i>z</i></td>\r\n<td><b>t[aeiou]pper</b> finds <i>tapper, tipper,</i> and\r\n<i>topper.</i></td>\r\n</tr>\r\n<tr>\r\n<td>[<i>x-z</i>]</td>\r\n<td>A range of characters, <i>x</i> through <i>z</i></td>\r\n<td><b>[1-4]000</b> finds <i>1000, 2000, 3000,</i> and <i>4000,</i>\r\nbut not <i>5000.</i></td>\r\n</tr>\r\n<tr>\r\n<td>[!<i>xy</i>]</td>\r\n<td>Not the specific character or characters, <i>xy</i></td>\r\n<td><b>p[!io]t</b> finds <i>pat</i> and <i>pet,</i> but not\r\n<i>pit</i> or <i>pot.</i></td>\r\n</tr>\r\n<tr>\r\n<td><</td>\r\n<td>Characters at the beginning of words</td>\r\n<td><b><info</b> finds <i>information, infomaniac,</i> and\r\n<i>infomercial.</i></td>\r\n</tr>\r\n<tr>\r\n<td>></td>\r\n<td>Characters at the end of words</td>\r\n<td><b>ese></b> finds <i>these, journalese,</i> and\r\n<i>legalese.</i></td>\r\n</tr>\r\n<tr>\r\n<td>@@</td>\r\n<td>One or more instances of the previous character</td>\r\n<td><b>sho@@t</b> finds <i>shot</i> and <i>shoot.</i></td>\r\n</tr>\r\n<tr>\r\n<td>{<i>n</i>}</td>\r\n<td>Exactly <i>n</i> instances of the previous character</td>\r\n<td><b>sho{2}t</b> finds <i>shoot</i> but not <i>shot.</i></td>\r\n</tr>\r\n<tr>\r\n<td>{<i>n</i>,}</td>\r\n<td>At least <i>n</i> instances of the previous character</td>\r\n<td><b>^p{3,}</b> finds three or more paragraph breaks in a row,\r\nbut not a single paragraph break or two paragraph breaks in a\r\nrow.</td>\r\n</tr>\r\n<tr>\r\n<td>{<i>n</i>,<i>m</i>}</td>\r\n<td>From <i>n</i> to <i>m</i> instances of the previous\r\ncharacter</td>\r\n<td><b>10{2,4}</b> finds <i>100, 1000,</i> and <i>10000,</i> but\r\nnot <i>10</i> or <i>100000.</i></td>\r\n</tr>\r\n</table>\r\n<p class=\"Warning\">You can't conduct a whole-word-only search with a wildcard. For example, a search for <b>f*s</b> not only finds <i>fads</i> and <i>fits</i> but also all text strings that begin with <i>f</i> and end with <i>s,</i> such as <i>for the birds.</i> Wildcard searches can yield many, many results and are sometimes useless.</p>\r\n<p class=\"Tip\">To search for an asterisk (*), question mark (?), or other character that serves as a wildcard search operator, place a backslash () before it in the text box.</p>","description":"<p>Word 2016 permits you to use wildcard operators in searches. A <i>wildcard operator</i> is a character that represents characters in a search expression. Wildcards aren't for everybody. Using them requires a certain amount of expertise, but after you know how to use them, wildcards can be invaluable in searches and macros.</p>\r\n<p>The following table explains the wildcard operators that you can use in searches. Click the Use Wildcards check box if you want to search using wildcards.</p>\r\n<h2 id=\"tab1\" >Wildcards for Searches</h2>\r\n<table>\r\n<tr>\r\n<th>Operator</th>\r\n<th>What It Finds</th>\r\n<th>Example</th>\r\n</tr>\r\n<tr>\r\n<td>?</td>\r\n<td>Any single character</td>\r\n<td><b>b?t</b> finds <i>bat, bet, bit,</i> and <i>but.</i></td>\r\n</tr>\r\n<tr>\r\n<td>*</td>\r\n<td>Zero or more characters</td>\r\n<td><b>t*o</b> finds <i>to, two,</i> and <i>tattoo.</i></td>\r\n</tr>\r\n<tr>\r\n<td>[<i>xyz</i>]</td>\r\n<td>A specific character, <i>x, y,</i> or <i>z</i></td>\r\n<td><b>t[aeiou]pper</b> finds <i>tapper, tipper,</i> and\r\n<i>topper.</i></td>\r\n</tr>\r\n<tr>\r\n<td>[<i>x-z</i>]</td>\r\n<td>A range of characters, <i>x</i> through <i>z</i></td>\r\n<td><b>[1-4]000</b> finds <i>1000, 2000, 3000,</i> and <i>4000,</i>\r\nbut not <i>5000.</i></td>\r\n</tr>\r\n<tr>\r\n<td>[!<i>xy</i>]</td>\r\n<td>Not the specific character or characters, <i>xy</i></td>\r\n<td><b>p[!io]t</b> finds <i>pat</i> and <i>pet,</i> but not\r\n<i>pit</i> or <i>pot.</i></td>\r\n</tr>\r\n<tr>\r\n<td><</td>\r\n<td>Characters at the beginning of words</td>\r\n<td><b><info</b> finds <i>information, infomaniac,</i> and\r\n<i>infomercial.</i></td>\r\n</tr>\r\n<tr>\r\n<td>></td>\r\n<td>Characters at the end of words</td>\r\n<td><b>ese></b> finds <i>these, journalese,</i> and\r\n<i>legalese.</i></td>\r\n</tr>\r\n<tr>\r\n<td>@@</td>\r\n<td>One or more instances of the previous character</td>\r\n<td><b>sho@@t</b> finds <i>shot</i> and <i>shoot.</i></td>\r\n</tr>\r\n<tr>\r\n<td>{<i>n</i>}</td>\r\n<td>Exactly <i>n</i> instances of the previous character</td>\r\n<td><b>sho{2}t</b> finds <i>shoot</i> but not <i>shot.</i></td>\r\n</tr>\r\n<tr>\r\n<td>{<i>n</i>,}</td>\r\n<td>At least <i>n</i> instances of the previous character</td>\r\n<td><b>^p{3,}</b> finds three or more paragraph breaks in a row,\r\nbut not a single paragraph break or two paragraph breaks in a\r\nrow.</td>\r\n</tr>\r\n<tr>\r\n<td>{<i>n</i>,<i>m</i>}</td>\r\n<td>From <i>n</i> to <i>m</i> instances of the previous\r\ncharacter</td>\r\n<td><b>10{2,4}</b> finds <i>100, 1000,</i> and <i>10000,</i> but\r\nnot <i>10</i> or <i>100000.</i></td>\r\n</tr>\r\n</table>\r\n<p class=\"Warning\">You can't conduct a whole-word-only search with a wildcard. For example, a search for <b>f*s</b> not only finds <i>fads</i> and <i>fits</i> but also all text strings that begin with <i>f</i> and end with <i>s,</i> such as <i>for the birds.</i> Wildcard searches can yield many, many results and are sometimes useless.</p>\r\n<p class=\"Tip\">To search for an asterisk (*), question mark (?), or other character that serves as a wildcard search operator, place a backslash () before it in the text box.</p>","blurb":"","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":" <p><b>Richard Sutz</b> is the founder and CEO of The Literacy Company, developers of The Reader&#39;s Edge<sup>&#174;</sup> speed&#45;reading program. Sutz&#39;s program teaches silent reading fluency for effective and efficient speed reading.<b> Peter Weverka</b> is the author of many <i>For Dummies </i>books. His articles and stories have appeared in <i>Harper&#39;s, SPY,</i> and other magazines ","hasArticle":false,"_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":[{"label":"Wildcards for Searches","target":"#tab1"}],"relatedArticles":{"fromBook":[{"articleId":210392,"title":"Viewing a File Through More Than One Window","slug":"viewing-a-file-through-more-than-one-window","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/210392"}},{"articleId":210391,"title":"Choosing a Theme for a Word 2016 Document","slug":"choosing-a-theme-for-a-word-2016-document","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/210391"}},{"articleId":210389,"title":"Introducing Word 2016 Styles","slug":"introducing-word-2016-styles","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/210389"}},{"articleId":210390,"title":"Creating a Template in Word 2016","slug":"creating-a-template-in-word-2016","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/210390"}},{"articleId":210388,"title":"Moving Around Quickly in Word 2016 Documents","slug":"moving-around-quickly-in-word-2016-documents","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/210388"}}],"fromCategory":[{"articleId":294664,"title":"Windows 365 For Dummies Cheat Sheet","slug":"windows-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/294664"}},{"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"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281797,"slug":"office-2016-all-in-one-for-dummies","isbn":"9781119083122","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119083125/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119083125/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/1119083125-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119083125/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119083125/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/office-2016-all-in-one-for-dummies-cover-9781119083122-203x255.jpg","width":203,"height":255},"title":"Office 2016 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9034\">Peter Weverka</b> is a veteran <i>For Dummies</i> author. In addition to previous books on Microsoft Office, Peter has written guides to Windows, the Internet, and Quicken. </p>","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":" <p><b>Richard Sutz</b> is the founder and CEO of The Literacy Company, developers of The Reader&#39;s Edge<sup>&#174;</sup> speed&#45;reading program. Sutz&#39;s program teaches silent reading fluency for effective and efficient speed reading.<b> Peter Weverka</b> is the author of many <i>For Dummies </i>books. His articles and stories have appeared in <i>Harper&#39;s, SPY,</i> and other magazines ","hasArticle":false,"_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;9781119083122&quot;]}]\" id=\"du-slot-64de362f0f912\"></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;9781119083122&quot;]}]\" id=\"du-slot-64de362f0ff8f\"></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},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2023-08-17T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":139875},{"headers":{"creationTime":"2023-03-13T17:58:31+00:00","modifiedTime":"2023-08-03T16:44:40+00:00","timestamp":"2023-08-03T18: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}],"title":"How to Play Microsoft Flight Simulator","strippedTitle":"how to play microsoft flight simulator","slug":"what-you-need-to-play-microsoft-flight-simulator","canonicalUrl":"","seo":{"metaDescription":"This article explains what you need to play Microsoft Flight Simulator, including platforms, game versions, and controllers.","noIndex":0,"noFollow":0},"content":"Giving people a chance to fly without all the time, money, and risk that goes into actual piloting makes flight-simulator video games such a fun and rewarding experience. Microsoft Flight Simulator is currently the best of its kind for casual players and hardcore enthusiasts alike.\r\n\r\nCurrently, you can purchase three different versions of Flight Simulator: the Standard, Deluxe, and Premium Deluxe editions. Differences among editions include the number and type of available airports and aircraft, and of course, the price.\r\n\r\nEven the Standard version of Flight Simulator includes around 37,000 airports! Other good news is that the game is largely the same across platforms (PC and Xbox series), so you won’t compromise the experience when it comes to choosing the platform you want to play on.\r\n<h2 id=\"tab1\" >What platforms can you use to play Microsoft Flight Simulator?</h2>\r\nFlight Simulator originally debuted as a PC-only title when it first released in August 2020. It also received a special virtual-reality version in December 2020, the first time any flight simulator had done so. Though it remained a PC exclusive title for some time, on July 27, 2021, Flight Simulator debuted on Xbox Series X and Xbox Series S.\r\n\r\nThe game likely won’t be available on PlayStation 4, PlayStation 5, or Nintendo Switch in the near future, given that it’s a Microsoft-owned property. So, if you’re interested in playing, you need to have a PC or Xbox series platform. Here are a couple of thoughts for your platform choice:\r\n<ul>\r\n \t<li><strong>On an Xbox:</strong> You may find that picking up an Xbox console (if you don’t already have one) makes playing the game simpler. Flight Simulator is highly playable on Xbox consoles and may be more accessible for those who aren’t comfortable configuring PC games and software.</li>\r\n \t<li><strong>On a PC:</strong> Flight Simulator can be quite demanding on computers that don’t have pricey gaming equipment. On the other hand, you can expect awesome graphics if you play on a gaming PC that has the latest and greatest graphic card and processor.</li>\r\n</ul>\r\n<h2 id=\"tab2\" >Which version should you buy?</h2>\r\nEach version of Flight Simulator differs in scope of content, such as airplanes and airports. The versions (depicted below) are priced in tiers, and depending on the experience you want from the game, you can expect more or less content based on how much you’re willing to pay. Hey, becoming a pilot isn’t cheap!\r\n\r\n[caption id=\"attachment_297818\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297818\" src=\"https://www.dummies.com/wp-content/uploads/microsoft-flight-simulator-versions.jpg\" alt=\"Infographic showing Microsoft Flight Simulator version\" width=\"630\" height=\"355\" /> ©Microsoft<br />Flight Simulator versions[/caption]\r\n\r\nHere’s a quick reference guide to what each version contains:\r\n<ul>\r\n \t<li><strong>Standard Edition:</strong> The base version of the game. It comes with 20 different planes and 30 enhanced airports, and it retails for $59.99 (USD, 2023).</li>\r\n \t<li><strong>Deluxe Edition:</strong> This version of the game comes with everything in the Standard Edition, plus five additional enhanced airports and five additional airplanes. It retails for $89.99 (USD, 2023). The enhanced airports included are:\r\n<ul>\r\n \t<li>Amsterdam Airport Schiphol (Netherlands)</li>\r\n \t<li>Cairo International Airport (Egypt)</li>\r\n \t<li>Cape Town International Airport (South Africa)</li>\r\n \t<li>O’Hare International Airport (USA)</li>\r\n \t<li>Adolfo Suarez Madrid-Barajas Airport (Spain)</li>\r\n</ul>\r\n</li>\r\n</ul>\r\n<ul>\r\n \t<li>The additional airplanes included are:\r\n<ul>\r\n \t<li>Diamond Aircraft DA40-TDI</li>\r\n \t<li>Diamond Aircraft DV20</li>\r\n \t<li>Textron Aviation Inc. Beechcraft Baron G58</li>\r\n \t<li>Textron Aviation Inc. Cessna 152 Aerobat</li>\r\n \t<li>Textron Aviation Inc. Cessna 172 Skyhawk</li>\r\n</ul>\r\n</li>\r\n \t<li><strong>Premium Deluxe Edition:</strong> This version of the game comes with everything that the Deluxe Edition includes, as well as five more enhanced airports and another five airplanes. It retails for $119.99 (USD, 2023). The enhanced airports included are:\r\n<ul>\r\n \t<li>Denver International Airport (USA)</li>\r\n \t<li>Dubai International Airport (UAE)</li>\r\n \t<li>Frankfurt Airport (Germany)</li>\r\n \t<li>Heathrow Airport (UK)</li>\r\n \t<li>San Francisco International Airport (USA)</li>\r\n</ul>\r\n</li>\r\n \t<li>The additional planes included are:\r\n<ul>\r\n \t<li>Boeing Company 787-10 Dreamliner</li>\r\n \t<li>Cirrus Aircraft SR22</li>\r\n \t<li>Pipistrel Virus SW 121</li>\r\n \t<li>Textron Aviation Inc. Cessna Citation Longitude</li>\r\n \t<li>Zlin Aviation Shock Ultra</li>\r\n</ul>\r\n</li>\r\n</ul>\r\n<p class=\"article-tips tip\">If you decide that you want to upgrade to the Deluxe or Premium Deluxe editions later on, you just have to pay the difference on the platform of your choice. You can download the additional content you were missing to the installation you already have. No pressure!</p>\r\n\r\n<h2 id=\"tab3\" >Wait, what are enhanced airports?</h2>\r\nDon’t confuse the small number of enhanced airports in the different versions of the game with the total number of airports that you can fly out of (around 37,000). More enhanced airports come with the Deluxe and Premium Deluxe versions, which means you get adapted constructions of airports (for example, Chicago O’Hare) that are more true-to-life than what they’d normally be in-game.\r\n\r\nGame designers handcraft an <em>enhanced airport</em> from the ground up to look exactly like the locations in question; the standard, procedurally generated airports aren’t nearly as detailed.\r\n\r\nSo, if you have a soft spot in your heart for the San Francisco International Airport, you might want to pick up the version of the game that includes its enhanced version so that you can see it just like it looks in your mind’s eye.\r\n\r\nThe enhanced airports may end up making it a much more exciting game to jump into — and you want to get the most out of your money, of course!\r\n<h2 id=\"tab4\" >What do you need to get started?</h2>\r\nDepending on which version of Flight Simulator you plan on playing, the answer to what you need varies. For the most part, whether you’re playing on PC, Xbox Series X, or Xbox Series S, you need only a copy of the game, your platform of choice, and some type of input.\r\n\r\nYour input can be a mouse and keyboard, game controller (I recommend an Xbox controller if you have one), or flight stick. Obviously, you can find a wide variety of all these things. But if you want to use a controller, you can simply use the Xbox gamepad that comes with your Xbox Series X or Xbox Series S by default.\r\n\r\nOtherwise, you need your sense of adventure and a little patience. Rome wasn’t built in a day. You can’t earn your fictional pilot’s license in a day, either. You have a lot to learn, but don’t get discouraged.\r\n\r\nAs with all things, practice makes perfect, and the more time you spend learning to fly, the more you retain. The more you retain, the better you perform. The better you perform, the more you want to fly. And then, before you know it, you might want to try your luck behind the controls of a real plane! <em>You</em> might want to; not me. I’m still a little too terrified. Heights are not my thing.","description":"Giving people a chance to fly without all the time, money, and risk that goes into actual piloting makes flight-simulator video games such a fun and rewarding experience. Microsoft Flight Simulator is currently the best of its kind for casual players and hardcore enthusiasts alike.\r\n\r\nCurrently, you can purchase three different versions of Flight Simulator: the Standard, Deluxe, and Premium Deluxe editions. Differences among editions include the number and type of available airports and aircraft, and of course, the price.\r\n\r\nEven the Standard version of Flight Simulator includes around 37,000 airports! Other good news is that the game is largely the same across platforms (PC and Xbox series), so you won’t compromise the experience when it comes to choosing the platform you want to play on.\r\n<h2 id=\"tab1\" >What platforms can you use to play Microsoft Flight Simulator?</h2>\r\nFlight Simulator originally debuted as a PC-only title when it first released in August 2020. It also received a special virtual-reality version in December 2020, the first time any flight simulator had done so. Though it remained a PC exclusive title for some time, on July 27, 2021, Flight Simulator debuted on Xbox Series X and Xbox Series S.\r\n\r\nThe game likely won’t be available on PlayStation 4, PlayStation 5, or Nintendo Switch in the near future, given that it’s a Microsoft-owned property. So, if you’re interested in playing, you need to have a PC or Xbox series platform. Here are a couple of thoughts for your platform choice:\r\n<ul>\r\n \t<li><strong>On an Xbox:</strong> You may find that picking up an Xbox console (if you don’t already have one) makes playing the game simpler. Flight Simulator is highly playable on Xbox consoles and may be more accessible for those who aren’t comfortable configuring PC games and software.</li>\r\n \t<li><strong>On a PC:</strong> Flight Simulator can be quite demanding on computers that don’t have pricey gaming equipment. On the other hand, you can expect awesome graphics if you play on a gaming PC that has the latest and greatest graphic card and processor.</li>\r\n</ul>\r\n<h2 id=\"tab2\" >Which version should you buy?</h2>\r\nEach version of Flight Simulator differs in scope of content, such as airplanes and airports. The versions (depicted below) are priced in tiers, and depending on the experience you want from the game, you can expect more or less content based on how much you’re willing to pay. Hey, becoming a pilot isn’t cheap!\r\n\r\n[caption id=\"attachment_297818\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297818\" src=\"https://www.dummies.com/wp-content/uploads/microsoft-flight-simulator-versions.jpg\" alt=\"Infographic showing Microsoft Flight Simulator version\" width=\"630\" height=\"355\" /> ©Microsoft<br />Flight Simulator versions[/caption]\r\n\r\nHere’s a quick reference guide to what each version contains:\r\n<ul>\r\n \t<li><strong>Standard Edition:</strong> The base version of the game. It comes with 20 different planes and 30 enhanced airports, and it retails for $59.99 (USD, 2023).</li>\r\n \t<li><strong>Deluxe Edition:</strong> This version of the game comes with everything in the Standard Edition, plus five additional enhanced airports and five additional airplanes. It retails for $89.99 (USD, 2023). The enhanced airports included are:\r\n<ul>\r\n \t<li>Amsterdam Airport Schiphol (Netherlands)</li>\r\n \t<li>Cairo International Airport (Egypt)</li>\r\n \t<li>Cape Town International Airport (South Africa)</li>\r\n \t<li>O’Hare International Airport (USA)</li>\r\n \t<li>Adolfo Suarez Madrid-Barajas Airport (Spain)</li>\r\n</ul>\r\n</li>\r\n</ul>\r\n<ul>\r\n \t<li>The additional airplanes included are:\r\n<ul>\r\n \t<li>Diamond Aircraft DA40-TDI</li>\r\n \t<li>Diamond Aircraft DV20</li>\r\n \t<li>Textron Aviation Inc. Beechcraft Baron G58</li>\r\n \t<li>Textron Aviation Inc. Cessna 152 Aerobat</li>\r\n \t<li>Textron Aviation Inc. Cessna 172 Skyhawk</li>\r\n</ul>\r\n</li>\r\n \t<li><strong>Premium Deluxe Edition:</strong> This version of the game comes with everything that the Deluxe Edition includes, as well as five more enhanced airports and another five airplanes. It retails for $119.99 (USD, 2023). The enhanced airports included are:\r\n<ul>\r\n \t<li>Denver International Airport (USA)</li>\r\n \t<li>Dubai International Airport (UAE)</li>\r\n \t<li>Frankfurt Airport (Germany)</li>\r\n \t<li>Heathrow Airport (UK)</li>\r\n \t<li>San Francisco International Airport (USA)</li>\r\n</ul>\r\n</li>\r\n \t<li>The additional planes included are:\r\n<ul>\r\n \t<li>Boeing Company 787-10 Dreamliner</li>\r\n \t<li>Cirrus Aircraft SR22</li>\r\n \t<li>Pipistrel Virus SW 121</li>\r\n \t<li>Textron Aviation Inc. Cessna Citation Longitude</li>\r\n \t<li>Zlin Aviation Shock Ultra</li>\r\n</ul>\r\n</li>\r\n</ul>\r\n<p class=\"article-tips tip\">If you decide that you want to upgrade to the Deluxe or Premium Deluxe editions later on, you just have to pay the difference on the platform of your choice. You can download the additional content you were missing to the installation you already have. No pressure!</p>\r\n\r\n<h2 id=\"tab3\" >Wait, what are enhanced airports?</h2>\r\nDon’t confuse the small number of enhanced airports in the different versions of the game with the total number of airports that you can fly out of (around 37,000). More enhanced airports come with the Deluxe and Premium Deluxe versions, which means you get adapted constructions of airports (for example, Chicago O’Hare) that are more true-to-life than what they’d normally be in-game.\r\n\r\nGame designers handcraft an <em>enhanced airport</em> from the ground up to look exactly like the locations in question; the standard, procedurally generated airports aren’t nearly as detailed.\r\n\r\nSo, if you have a soft spot in your heart for the San Francisco International Airport, you might want to pick up the version of the game that includes its enhanced version so that you can see it just like it looks in your mind’s eye.\r\n\r\nThe enhanced airports may end up making it a much more exciting game to jump into — and you want to get the most out of your money, of course!\r\n<h2 id=\"tab4\" >What do you need to get started?</h2>\r\nDepending on which version of Flight Simulator you plan on playing, the answer to what you need varies. For the most part, whether you’re playing on PC, Xbox Series X, or Xbox Series S, you need only a copy of the game, your platform of choice, and some type of input.\r\n\r\nYour input can be a mouse and keyboard, game controller (I recommend an Xbox controller if you have one), or flight stick. Obviously, you can find a wide variety of all these things. But if you want to use a controller, you can simply use the Xbox gamepad that comes with your Xbox Series X or Xbox Series S by default.\r\n\r\nOtherwise, you need your sense of adventure and a little patience. Rome wasn’t built in a day. You can’t earn your fictional pilot’s license in a day, either. You have a lot to learn, but don’t get discouraged.\r\n\r\nAs with all things, practice makes perfect, and the more time you spend learning to fly, the more you retain. The more you retain, the better you perform. The better you perform, the more you want to fly. And then, before you know it, you might want to try your luck behind the controls of a real plane! <em>You</em> might want to; not me. I’m still a little too terrified. Heights are not my thing.","blurb":"","authors":[{"authorId":35237,"name":"Brittany Vincent","slug":"brittany-vincent","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/35237"}}],"primaryCategoryTaxonomy":{"categoryId":33642,"title":"Microsoft Products","slug":"microsoft-products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[{"label":"What platforms can you use to play Microsoft Flight Simulator?","target":"#tab1"},{"label":"Which version should you buy?","target":"#tab2"},{"label":"Wait, what are enhanced airports?","target":"#tab3"},{"label":"What do you need to get started?","target":"#tab4"}],"relatedArticles":{"fromBook":[{"articleId":297842,"title":"How to Read Aircraft Instruments in Microsoft Flight Simulator","slug":"how-to-read-the-instruments-in-a-microsoft-flight-simulator-aircraft","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297842"}},{"articleId":297824,"title":"10 Tips for Microsoft Flight Simulator Beginners","slug":"10-tips-for-microsoft-flight-simulator-beginners","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297824"}},{"articleId":297672,"title":"Microsoft Flight Simulator For Dummies Cheat Sheet","slug":"microsoft-flight-simulator-for-dummies","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297672"}}],"fromCategory":[{"articleId":297842,"title":"How to Read Aircraft Instruments in Microsoft Flight Simulator","slug":"how-to-read-the-instruments-in-a-microsoft-flight-simulator-aircraft","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297842"}},{"articleId":297824,"title":"10 Tips for Microsoft Flight Simulator Beginners","slug":"10-tips-for-microsoft-flight-simulator-beginners","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297824"}},{"articleId":297672,"title":"Microsoft Flight Simulator For Dummies Cheat Sheet","slug":"microsoft-flight-simulator-for-dummies","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297672"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":296845,"slug":"microsoft-flight-simulator-for-dummies","isbn":"9781119828457","categoryList":["technology","software","microsoft-products"],"amazon":{"default":"https://www.amazon.com/gp/product/1119828457/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119828457/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/1119828457-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119828457/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119828457/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/microsoft-flight-simulator-for-dummies-cover-9781119828457-203x255.jpg","width":203,"height":255},"title":"Microsoft Flight Simulator For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"","authors":[{"authorId":35237,"name":"Brittany Vincent","slug":"brittany-vincent","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/35237"}}],"_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;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119828457&quot;]}]\" id=\"du-slot-64cbeb601f0f3\"></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;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119828457&quot;]}]\" id=\"du-slot-64cbeb601f621\"></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},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Explore","lifeExpectancy":"One year","lifeExpectancySetFrom":"2023-03-13T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":297816},{"headers":{"creationTime":"2023-03-14T18:29:24+00:00","modifiedTime":"2023-08-03T16:44:03+00:00","timestamp":"2023-08-03T18: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}],"title":"How to Read Aircraft Instruments in Microsoft Flight Simulator","strippedTitle":"how to read aircraft instruments in microsoft flight simulator","slug":"how-to-read-the-instruments-in-a-microsoft-flight-simulator-aircraft","canonicalUrl":"","seo":{"metaDescription":"To be able to fly successfully in Flight Simulator, you need to know how to use the instruments in the cockpit. Here's a rundown.","noIndex":0,"noFollow":0},"content":"To successfully fly in Microsoft Flight Simulator, you need to know how to use the various instruments included in your cockpit. At first, getting to know and understand each instrument may seem confusing. But, with a little time and guidance, you can discover what every instrument does, as well as how to read it during flight.\r\n\r\nThe instruments in Flight Simulator can tell you how fast you’re going (<em>airspeed</em>), how high up you are (<em>altitude</em>), and other vital information you need to know, such as the direction you’re flying (your <em>current heading</em>).\r\n\r\nFlight Simulator has two primary types of cockpits that you can become acquainted with:\r\n<ul>\r\n \t<li><strong>An analog cockpit</strong> relies on <em>analog instruments</em> that appear as dials and gauges and rely on mechanical measurements to display information. You need to know how to read the various needles and indicators that relay these measurements.</li>\r\n \t<li><strong>A glass cockpit</strong> relies on multiple electronic panels to sift through and display important information to you digitally during flight. This means you’ll get a direct readout rather than you having to interpret analog dials and gauges.</li>\r\n</ul>\r\n<h2 id=\"tab1\" >Reading analog instruments</h2>\r\nMany of the planes in Flight Simulator have analog cockpits, especially the older planes. In fact, many of the planes that you fly during the game’s tutorial lessons rely on analog instruments for vital information such as heading, altitude, and so on. For that reason alone, you need to know how to read analog instruments early on in your career with Flight Simulator.\r\n\r\nHowever, some planes are hybrids with a combination of analog and digital systems. For example, the Cessna 172 includes a digital radio and navigation system but uses analog gauges for nearly everything else.\r\n<p class=\"article-tips tip\">Coming to terms with the instruments in your aircraft is about identifying each panel — where it is and what it does. Although a cockpit may look daunting at first, knowing the basics of each instrument (position and function) can make your flights easier in the long run.</p>\r\nOverall, the exact layout, functionality, and appearance of instruments may vary depending on your aircraft. However, several fundamental instrument types are in each cockpit, so get acquainted with them. For this example, I present the cockpit of a Cessna 152, as shown below.\r\n\r\n[caption id=\"attachment_297841\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297841\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-analog-cockpit.jpg\" alt=\"Screenshot showing an analog cockpit\" width=\"630\" height=\"431\" /> ©Microsoft<br />View of a Cessna 152 analog cockpit[/caption]\r\n\r\nThe callouts in the figure above correspond with some of the instruments in this list:\r\n<ul>\r\n \t<li>\r\n<p class=\"first-para\"><strong>Airspeed indicator:</strong> Displays your <em>airspeed</em> (how fast you’re traveling), measured in <em>knots</em> (which is one nautical mile per hour). Pay special attention to this instrument during flight because aircraft are very sensitive to speed.</p>\r\n<p class=\"child-para\">For example, unlike cars, which will just stop in one place if you run out of speed, an airplane will drop like a rock. This situation is obviously bad for the pilot. The white lines on the airspeed indicator signal that you can extend the flaps at those speeds.</p>\r\n<p class=\"child-para\">Remember that the higher the speed, the lower the <em>tilt</em> (using the rudders to pivot the plane up or down). The green line marks the speed range in which you can safely tilt the rudders at their full range of movement. The yellow range means you’re quickly approaching the limit of the plane’s structural strength.</p>\r\n</li>\r\n \t<li><strong>Attitude indicator:</strong> Shows the current orientation of the plane in space. You make use of this instrument when you have to fly based on your instruments to ensure your angle of approach does not exceed recommendations. The brown portion in this indicator signifies the ground, and the blue part indicates the sky.</li>\r\n \t<li>\r\n<p class=\"first-para\"><strong>Altimeter:</strong> Shows you the current <em>ceiling</em> (meaning the maximum density altitude an aircraft can reach) in feet or meters. Keep in mind that the altimeter measures the elevation of your craft Above Sea Level (ASL).</p>\r\n<p class=\"child-para\">Just because you’re on the ground doesn’t mean that you have an altimeter value of zero. When your craft is on the ground, the altimeter shows a value of anywhere from a few hundred feet to several thousand feet, depending on the elevation above sea level of the airport you’re currently visiting.</p>\r\n<p class=\"\">Before takeoff, tune the altimeter to the barometric pressure at the airport’s location.</p>\r\n</li>\r\n \t<li><strong>Throttle RPM meter:</strong> Shows you the current revolutions per minute (RPMs) of the plane’s engine.</li>\r\n \t<li><strong>Flaps control:</strong> Controls the flaps on the rear of the wings. Essentially, you can adjust these mechanisms to provide more load-bearing force — allowing the plane to take off from a shorter distance — or keep the plane airborne at a low speed. Additionally, flaps may be used to slow down the plane.</li>\r\n \t<li><strong>Fuel Mixture control:</strong> Regulates how much fuel is injected into the engine. You need to reduce or increase the ratio of fuel to air being injected, depending on the altitude and density of the air that you’re flying through.</li>\r\n \t<li><strong>Throttle:</strong> The throttle is pretty self-explanatory; it’s essentially your gas pedal. It controls the amount of fuel and air that is being injected into the engine. The more open the throttle, the more power the engine produces. Unlike cars, which have a gearbox to transfer power to the wheels, airplanes are direct drive, which means an increase in throttle always manifests as a higher RPM.</li>\r\n \t<li><strong>Pitch Trim:</strong> By far one of the most important mechanisms in the cockpit. When set correctly, it allows the plane to fly without the pilot having to continuously hold the steering bar (also called the <em>yoke</em>). You may need to make adjustments to the pitch trim (which maneuvers the aircraft elevators) constantly throughout the flight in order to maintain altitude or a steady climb or decent.</li>\r\n \t<li><strong>Vertical Speed indicator:</strong> Showcases the current speed of ascent or descent. It measures your plane’s speed in feet per minute. This instrument never sticks rigidly in one place; expect it to fluctuate. When landing or ascending, the standard rate of speed on this instrument varies from plane to plane.</li>\r\n \t<li><strong>Current Heading:</strong> Shows the aircraft’s current heading course throughout the flight. The <em>heading</em> is essentially the direction that the aircraft is traveling relative to the magnetic north. The cardinal headings include:\r\n<ul>\r\n \t<li>North at 360 or 0 degrees</li>\r\n \t<li>East at 90 degrees</li>\r\n \t<li>South at 180 degrees</li>\r\n \t<li>West at 270 degrees</li>\r\n</ul>\r\n</li>\r\n</ul>\r\nThe Current Heading indicator itself gets input from a gyroscope, so you can expect it to show the wrong direction when not calibrated properly. Unfortunately, it becomes misaligned by itself often, and you need to calibrate it throughout your flight by resetting it every 10 to 15 minutes and ensuring it lines up with your compass.\r\n\r\n<strong>Parking brake:</strong> The parking brake is exactly what it sounds like. Use it at every takeoff and taxi situation to avoid any issues with air traffic control. Remember, when your aircraft’s engine is on, it generates thrust, even at idle. If you don’t make sure your parking brake is on, you may look down to hit a switch and find you’re rolling along.","description":"To successfully fly in Microsoft Flight Simulator, you need to know how to use the various instruments included in your cockpit. At first, getting to know and understand each instrument may seem confusing. But, with a little time and guidance, you can discover what every instrument does, as well as how to read it during flight.\r\n\r\nThe instruments in Flight Simulator can tell you how fast you’re going (<em>airspeed</em>), how high up you are (<em>altitude</em>), and other vital information you need to know, such as the direction you’re flying (your <em>current heading</em>).\r\n\r\nFlight Simulator has two primary types of cockpits that you can become acquainted with:\r\n<ul>\r\n \t<li><strong>An analog cockpit</strong> relies on <em>analog instruments</em> that appear as dials and gauges and rely on mechanical measurements to display information. You need to know how to read the various needles and indicators that relay these measurements.</li>\r\n \t<li><strong>A glass cockpit</strong> relies on multiple electronic panels to sift through and display important information to you digitally during flight. This means you’ll get a direct readout rather than you having to interpret analog dials and gauges.</li>\r\n</ul>\r\n<h2 id=\"tab1\" >Reading analog instruments</h2>\r\nMany of the planes in Flight Simulator have analog cockpits, especially the older planes. In fact, many of the planes that you fly during the game’s tutorial lessons rely on analog instruments for vital information such as heading, altitude, and so on. For that reason alone, you need to know how to read analog instruments early on in your career with Flight Simulator.\r\n\r\nHowever, some planes are hybrids with a combination of analog and digital systems. For example, the Cessna 172 includes a digital radio and navigation system but uses analog gauges for nearly everything else.\r\n<p class=\"article-tips tip\">Coming to terms with the instruments in your aircraft is about identifying each panel — where it is and what it does. Although a cockpit may look daunting at first, knowing the basics of each instrument (position and function) can make your flights easier in the long run.</p>\r\nOverall, the exact layout, functionality, and appearance of instruments may vary depending on your aircraft. However, several fundamental instrument types are in each cockpit, so get acquainted with them. For this example, I present the cockpit of a Cessna 152, as shown below.\r\n\r\n[caption id=\"attachment_297841\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297841\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-analog-cockpit.jpg\" alt=\"Screenshot showing an analog cockpit\" width=\"630\" height=\"431\" /> ©Microsoft<br />View of a Cessna 152 analog cockpit[/caption]\r\n\r\nThe callouts in the figure above correspond with some of the instruments in this list:\r\n<ul>\r\n \t<li>\r\n<p class=\"first-para\"><strong>Airspeed indicator:</strong> Displays your <em>airspeed</em> (how fast you’re traveling), measured in <em>knots</em> (which is one nautical mile per hour). Pay special attention to this instrument during flight because aircraft are very sensitive to speed.</p>\r\n<p class=\"child-para\">For example, unlike cars, which will just stop in one place if you run out of speed, an airplane will drop like a rock. This situation is obviously bad for the pilot. The white lines on the airspeed indicator signal that you can extend the flaps at those speeds.</p>\r\n<p class=\"child-para\">Remember that the higher the speed, the lower the <em>tilt</em> (using the rudders to pivot the plane up or down). The green line marks the speed range in which you can safely tilt the rudders at their full range of movement. The yellow range means you’re quickly approaching the limit of the plane’s structural strength.</p>\r\n</li>\r\n \t<li><strong>Attitude indicator:</strong> Shows the current orientation of the plane in space. You make use of this instrument when you have to fly based on your instruments to ensure your angle of approach does not exceed recommendations. The brown portion in this indicator signifies the ground, and the blue part indicates the sky.</li>\r\n \t<li>\r\n<p class=\"first-para\"><strong>Altimeter:</strong> Shows you the current <em>ceiling</em> (meaning the maximum density altitude an aircraft can reach) in feet or meters. Keep in mind that the altimeter measures the elevation of your craft Above Sea Level (ASL).</p>\r\n<p class=\"child-para\">Just because you’re on the ground doesn’t mean that you have an altimeter value of zero. When your craft is on the ground, the altimeter shows a value of anywhere from a few hundred feet to several thousand feet, depending on the elevation above sea level of the airport you’re currently visiting.</p>\r\n<p class=\"\">Before takeoff, tune the altimeter to the barometric pressure at the airport’s location.</p>\r\n</li>\r\n \t<li><strong>Throttle RPM meter:</strong> Shows you the current revolutions per minute (RPMs) of the plane’s engine.</li>\r\n \t<li><strong>Flaps control:</strong> Controls the flaps on the rear of the wings. Essentially, you can adjust these mechanisms to provide more load-bearing force — allowing the plane to take off from a shorter distance — or keep the plane airborne at a low speed. Additionally, flaps may be used to slow down the plane.</li>\r\n \t<li><strong>Fuel Mixture control:</strong> Regulates how much fuel is injected into the engine. You need to reduce or increase the ratio of fuel to air being injected, depending on the altitude and density of the air that you’re flying through.</li>\r\n \t<li><strong>Throttle:</strong> The throttle is pretty self-explanatory; it’s essentially your gas pedal. It controls the amount of fuel and air that is being injected into the engine. The more open the throttle, the more power the engine produces. Unlike cars, which have a gearbox to transfer power to the wheels, airplanes are direct drive, which means an increase in throttle always manifests as a higher RPM.</li>\r\n \t<li><strong>Pitch Trim:</strong> By far one of the most important mechanisms in the cockpit. When set correctly, it allows the plane to fly without the pilot having to continuously hold the steering bar (also called the <em>yoke</em>). You may need to make adjustments to the pitch trim (which maneuvers the aircraft elevators) constantly throughout the flight in order to maintain altitude or a steady climb or decent.</li>\r\n \t<li><strong>Vertical Speed indicator:</strong> Showcases the current speed of ascent or descent. It measures your plane’s speed in feet per minute. This instrument never sticks rigidly in one place; expect it to fluctuate. When landing or ascending, the standard rate of speed on this instrument varies from plane to plane.</li>\r\n \t<li><strong>Current Heading:</strong> Shows the aircraft’s current heading course throughout the flight. The <em>heading</em> is essentially the direction that the aircraft is traveling relative to the magnetic north. The cardinal headings include:\r\n<ul>\r\n \t<li>North at 360 or 0 degrees</li>\r\n \t<li>East at 90 degrees</li>\r\n \t<li>South at 180 degrees</li>\r\n \t<li>West at 270 degrees</li>\r\n</ul>\r\n</li>\r\n</ul>\r\nThe Current Heading indicator itself gets input from a gyroscope, so you can expect it to show the wrong direction when not calibrated properly. Unfortunately, it becomes misaligned by itself often, and you need to calibrate it throughout your flight by resetting it every 10 to 15 minutes and ensuring it lines up with your compass.\r\n\r\n<strong>Parking brake:</strong> The parking brake is exactly what it sounds like. Use it at every takeoff and taxi situation to avoid any issues with air traffic control. Remember, when your aircraft’s engine is on, it generates thrust, even at idle. If you don’t make sure your parking brake is on, you may look down to hit a switch and find you’re rolling along.","blurb":"","authors":[{"authorId":35237,"name":"Brittany Vincent","slug":"brittany-vincent","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/35237"}}],"primaryCategoryTaxonomy":{"categoryId":33642,"title":"Microsoft Products","slug":"microsoft-products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[{"label":"Reading analog instruments","target":"#tab1"}],"relatedArticles":{"fromBook":[{"articleId":297824,"title":"10 Tips for Microsoft Flight Simulator Beginners","slug":"10-tips-for-microsoft-flight-simulator-beginners","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297824"}},{"articleId":297816,"title":"How to Play Microsoft Flight Simulator","slug":"what-you-need-to-play-microsoft-flight-simulator","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297816"}},{"articleId":297672,"title":"Microsoft Flight Simulator For Dummies Cheat Sheet","slug":"microsoft-flight-simulator-for-dummies","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297672"}}],"fromCategory":[{"articleId":297824,"title":"10 Tips for Microsoft Flight Simulator Beginners","slug":"10-tips-for-microsoft-flight-simulator-beginners","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297824"}},{"articleId":297816,"title":"How to Play Microsoft Flight Simulator","slug":"what-you-need-to-play-microsoft-flight-simulator","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297816"}},{"articleId":297672,"title":"Microsoft Flight Simulator For Dummies Cheat Sheet","slug":"microsoft-flight-simulator-for-dummies","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297672"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":296845,"slug":"microsoft-flight-simulator-for-dummies","isbn":"9781119828457","categoryList":["technology","software","microsoft-products"],"amazon":{"default":"https://www.amazon.com/gp/product/1119828457/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119828457/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/1119828457-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119828457/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119828457/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/microsoft-flight-simulator-for-dummies-cover-9781119828457-203x255.jpg","width":203,"height":255},"title":"Microsoft Flight Simulator For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"","authors":[{"authorId":35237,"name":"Brittany Vincent","slug":"brittany-vincent","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/35237"}}],"_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;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119828457&quot;]}]\" id=\"du-slot-64cbeb6018d67\"></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;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119828457&quot;]}]\" id=\"du-slot-64cbeb60192aa\"></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},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Explore","lifeExpectancy":"One year","lifeExpectancySetFrom":"2023-03-14T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":297842},{"headers":{"creationTime":"2018-09-11T17:50:58+00:00","modifiedTime":"2023-06-07T18:38:25+00:00","timestamp":"2023-06-07T21:01: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":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"How to Share Excel 2019 Workbooks Saved on Your OneDrive","strippedTitle":"how to share excel 2019 workbooks saved on your onedrive","slug":"how-to-share-excel-2019-workbooks-saved-on-your-onedrive","canonicalUrl":"","seo":{"metaDescription":"To share Excel 2019 workbooks from your OneDrive, you follow these steps: Open the workbook file you want to share in Excel 2019 and then click the Share button","noIndex":0,"noFollow":0},"content":"To share Excel 2019 workbooks from your OneDrive, you follow these steps:\r\n<ol>\r\n \t<li><strong>Open the workbook file you want to share in Excel 2019 and then click the Share button at the far right of the row with the Ribbon.</strong> If you’ve not yet saved the workbook on your OneDrive, a Share dialog box appears inviting you to upload the workbook file to OneDrive. Once you have clicked the OneDrive button and the file is uploaded to the cloud, the Share dialog box changes into the Send Link dialog box (similar to the one shown in the figure) where you specify the people with whom to share the file.</li>\r\n \t<li><strong>Begin typing the name or e-mail address of the first person with whom you want to share the workbook in the text box with the insertion point.</strong> When Excel finds a match to the person’s name in your Outlook address book or verifies the e-mail address you entered, click the button below this text box to add this recipient.</li>\r\n \t<li><strong>(Optional) Click the Anyone with This Link Can Edit drop-down button to open the Link Settings dialog box where you can modify the people for whom the link works, deny editing privileges to those with whom you share the file, and/or set an expiration date after which the link is no longer operational before clicking the Apply button.</strong></li>\r\n \t<li><strong>By default, Excel 2019 creates a sharing link that enables anyone who can access the workbook file online access to the file even when they are not logged into Office 365 or OneDrive.</strong>\r\n<ul>\r\n \t<li>To restrict access to only coworkers in your company who are logged into Office 365, click the People in <<em>organization</em>> option (where <em>organization</em> is the name of your company as in People in Mind Over Media, the name of my company).</li>\r\n \t<li>To restrict the file sharing to only those to whom you’ve given prior access to the workbook file or its folder on your SharePoint site, click the People with Existing Access option.</li>\r\n \t<li>To create a sharing link that only particular people can use, click the Specific People option before you click the Apply button.</li>\r\n</ul>\r\nThen, in the Send Link dialog box, click the ellipsis (…) to the right of the Send Link title and click Manage Access on the drop-menu to open the Permissions dialog box where you select the names of the people with whom to share the workbook file before you click the back arrow button to return to the Send Link dialog box.\r\n\r\nBy default, Excel allows the people with whom you share your workbooks to make editing changes to the workbook that are automatically saved on your OneDrive. If you want to restrict your recipients to reviewing the data without being able to make changes, be sure to click the Allow Editing check box to remove its check mark before you click Apply.\r\n\r\nIf you wish to set an expiration date after which the sharing link is no longer operational, click the Set Expiration Date button to open the pop-up calendar where you select an expiration date by clicking it in the calendar. After selecting the expiration date, click somewhere in the dialog box to close the pop-up calendar and enter the date in the Link Settings dialog box.</li>\r\n \t<li><strong>(Optional) Click the Add a Message text box and type any personal message that you want to incorporate as part of the e-mail with the generic invitation to share the file.</strong>By default, Excel creates a generic invitation.</li>\r\n \t<li><strong>After adding all the recipients with whom you wish to share the workbook file in this manner, click the Send button in the Send Link pane.</strong>As soon as you click this Share button, Excel e-mails the invitation to share the workbook to each of the recipients.</li>\r\n</ol>\r\nAll the people with whom you share a workbook receive an e-mail message containing a hyperlink to the workbook on your OneDrive. When they follow this link (and sign into the site if this is required), a copy of the workbook opens on a new page in their default web browser using the Excel Online web app. If you’ve given the user permission to edit the file, the web app contains an Edit Workbook drop-down button.\r\n\r\nWhen the coworkers with whom you’ve shared the workbook click this button in Excel Online, they have a choice between choosing the Edit in Excel or Edit in Excel Online option from its drop-down menu. When the user chooses Edit in Excel, the workbook is downloaded and opened in his version of Excel. When the user chooses Edit in Excel Online, the browser opens the workbook in a new version of the Excel Online, containing Home, Insert, Data, Review, and View tabs, each with a more limited set of command options than Excel 2019, which you can use in making any necessary changes and which are automatically saved to workbook on the OneDrive when you close Excel Online.\r\n\r\nWhile sharing a workbook with the default Anyone Can Edit option, all changes made by the people with whom you’ve shared the workbook are automatically saved by the AutoSave feature. If you happen to have the workbook open in Excel 2019 on your computer with the same worksheet displayed, their editing changes automatically appear in your worksheet (in as close to real time as the speed of your Internet access provides). Likewise, all the editing changes that you make to the workbook in Excel 2019 are automatically updated in their workbooks in Excel Online. Microsoft refers to this process as co-authoring.\r\n<p class=\"article-tips tip\">If a questionable editing change appears in your worksheet when co-authoring with a coworker, add a comment to the cell containing the edit-in-question (Review-->New Comment) that communicates your reservations about the change they made. A small balloon then appears above the cell where you made the comment in the user’s worksheet in Excel Online. When the coworker clicks this balloon, Excel Online displays the text of your comment calling into question their edit in a Comments task pane. They can then reply to your reservations by typing their explanation for the change in the same comment in this task pane and then updating it in your workbook by clicking the Post button or they can just go ahead and make any necessary updates reflecting your reservations directly in the worksheet in Excel Online.</p>","description":"To share Excel 2019 workbooks from your OneDrive, you follow these steps:\r\n<ol>\r\n \t<li><strong>Open the workbook file you want to share in Excel 2019 and then click the Share button at the far right of the row with the Ribbon.</strong> If you’ve not yet saved the workbook on your OneDrive, a Share dialog box appears inviting you to upload the workbook file to OneDrive. Once you have clicked the OneDrive button and the file is uploaded to the cloud, the Share dialog box changes into the Send Link dialog box (similar to the one shown in the figure) where you specify the people with whom to share the file.</li>\r\n \t<li><strong>Begin typing the name or e-mail address of the first person with whom you want to share the workbook in the text box with the insertion point.</strong> When Excel finds a match to the person’s name in your Outlook address book or verifies the e-mail address you entered, click the button below this text box to add this recipient.</li>\r\n \t<li><strong>(Optional) Click the Anyone with This Link Can Edit drop-down button to open the Link Settings dialog box where you can modify the people for whom the link works, deny editing privileges to those with whom you share the file, and/or set an expiration date after which the link is no longer operational before clicking the Apply button.</strong></li>\r\n \t<li><strong>By default, Excel 2019 creates a sharing link that enables anyone who can access the workbook file online access to the file even when they are not logged into Office 365 or OneDrive.</strong>\r\n<ul>\r\n \t<li>To restrict access to only coworkers in your company who are logged into Office 365, click the People in <<em>organization</em>> option (where <em>organization</em> is the name of your company as in People in Mind Over Media, the name of my company).</li>\r\n \t<li>To restrict the file sharing to only those to whom you’ve given prior access to the workbook file or its folder on your SharePoint site, click the People with Existing Access option.</li>\r\n \t<li>To create a sharing link that only particular people can use, click the Specific People option before you click the Apply button.</li>\r\n</ul>\r\nThen, in the Send Link dialog box, click the ellipsis (…) to the right of the Send Link title and click Manage Access on the drop-menu to open the Permissions dialog box where you select the names of the people with whom to share the workbook file before you click the back arrow button to return to the Send Link dialog box.\r\n\r\nBy default, Excel allows the people with whom you share your workbooks to make editing changes to the workbook that are automatically saved on your OneDrive. If you want to restrict your recipients to reviewing the data without being able to make changes, be sure to click the Allow Editing check box to remove its check mark before you click Apply.\r\n\r\nIf you wish to set an expiration date after which the sharing link is no longer operational, click the Set Expiration Date button to open the pop-up calendar where you select an expiration date by clicking it in the calendar. After selecting the expiration date, click somewhere in the dialog box to close the pop-up calendar and enter the date in the Link Settings dialog box.</li>\r\n \t<li><strong>(Optional) Click the Add a Message text box and type any personal message that you want to incorporate as part of the e-mail with the generic invitation to share the file.</strong>By default, Excel creates a generic invitation.</li>\r\n \t<li><strong>After adding all the recipients with whom you wish to share the workbook file in this manner, click the Send button in the Send Link pane.</strong>As soon as you click this Share button, Excel e-mails the invitation to share the workbook to each of the recipients.</li>\r\n</ol>\r\nAll the people with whom you share a workbook receive an e-mail message containing a hyperlink to the workbook on your OneDrive. When they follow this link (and sign into the site if this is required), a copy of the workbook opens on a new page in their default web browser using the Excel Online web app. If you’ve given the user permission to edit the file, the web app contains an Edit Workbook drop-down button.\r\n\r\nWhen the coworkers with whom you’ve shared the workbook click this button in Excel Online, they have a choice between choosing the Edit in Excel or Edit in Excel Online option from its drop-down menu. When the user chooses Edit in Excel, the workbook is downloaded and opened in his version of Excel. When the user chooses Edit in Excel Online, the browser opens the workbook in a new version of the Excel Online, containing Home, Insert, Data, Review, and View tabs, each with a more limited set of command options than Excel 2019, which you can use in making any necessary changes and which are automatically saved to workbook on the OneDrive when you close Excel Online.\r\n\r\nWhile sharing a workbook with the default Anyone Can Edit option, all changes made by the people with whom you’ve shared the workbook are automatically saved by the AutoSave feature. If you happen to have the workbook open in Excel 2019 on your computer with the same worksheet displayed, their editing changes automatically appear in your worksheet (in as close to real time as the speed of your Internet access provides). Likewise, all the editing changes that you make to the workbook in Excel 2019 are automatically updated in their workbooks in Excel Online. Microsoft refers to this process as co-authoring.\r\n<p class=\"article-tips tip\">If a questionable editing change appears in your worksheet when co-authoring with a coworker, add a comment to the cell containing the edit-in-question (Review-->New Comment) that communicates your reservations about the change they made. A small balloon then appears above the cell where you made the comment in the user’s worksheet in Excel Online. When the coworker clicks this balloon, Excel Online displays the text of your comment calling into question their edit in a Comments task pane. They can then reply to your reservations by typing their explanation for the change in the same comment in this task pane and then updating it in your workbook by clicking the Post button or they can just go ahead and make any necessary updates reflecting your reservations directly in the worksheet in Excel Online.</p>","blurb":"","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":" <p><b>Paul McFedries</b> has worked, programmed, and even talked to computers large and small since 1975. Primarily a writer, he has worked as a programmer, consultant, and database and website developer. His more than 95 books have sold 4&#43; million copies worldwide. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9027"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":259741,"title":"How to Use the Excel 2019 Solver","slug":"how-to-use-the-excel-2019-solver","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259741"}},{"articleId":259735,"title":"How to Password-Protect Your Excel 2019 File","slug":"how-to-password-protect-your-excel-2019-file","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259735"}},{"articleId":259729,"title":"How to Create Forecast Worksheets in Excel 2019","slug":"how-to-create-forecast-worksheets-in-excel-2019","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259729"}},{"articleId":259724,"title":"How to Use the 3D Map Feature in Excel 2019","slug":"how-to-use-the-3d-map-feature-in-excel-2019","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259724"}},{"articleId":259717,"title":"Transforming a Data Query in the Power Query Editor in Excel 2019","slug":"transforming-a-data-query-in-the-power-query-editor-in-excel-2019","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259717"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281708,"slug":"excel-2019-all-in-one-for-dummies","isbn":"9781119517948","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/111951794X/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/111951794X/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/111951794X-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/111951794X/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/111951794X/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/excel-2019-all-in-one-for-dummies-cover-9781119517948-203x255.jpg","width":203,"height":255},"title":"Excel 2019 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9027\">Greg Harvey, PhD,</b> is a veteran computer educator dating back to the days of DOS and Lotus 1-2-3. He has taught spreadsheet and database management courses at Golden Gate University and written dozens of books, including many in the <i>For Dummies</i> series. </p>","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":" <p><b>Paul McFedries</b> has worked, programmed, and even talked to computers large and small since 1975. Primarily a writer, he has worked as a programmer, consultant, and database and website developer. His more than 95 books have sold 4&#43; million copies worldwide. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9027"}}],"_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;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119517948&quot;]}]\" id=\"du-slot-6480f00ec46e9\"></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;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119517948&quot;]}]\" id=\"du-slot-6480f00ec5736\"></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},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Five years","lifeExpectancySetFrom":"2023-06-07T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":255344},{"headers":{"creationTime":"2016-03-26T15:32:02+00:00","modifiedTime":"2023-06-07T13:49:06+00:00","timestamp":"2023-06-07T15:01: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":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"Some Excel Worksheet Functions for Statistical Analysis","strippedTitle":"some excel worksheet functions for statistical analysis","slug":"some-excel-worksheet-functions","canonicalUrl":"","seo":{"metaDescription":"Excel can help you make all sorts of calculations. Here's a selection of Excel's statistical worksheet functions. Each one returns a value into a selected cell.","noIndex":0,"noFollow":0},"content":"Excel can help you make all sorts of calculations. Here's a selection of Excel's statistical worksheet functions. Each one returns a value into a selected cell.\r\n\r\nCheck out these functions for central tendency and variability.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><strong>Function</strong></td>\r\n<td><strong>What it calculates</strong></td>\r\n</tr>\r\n<tr>\r\n<td>AVERAGE</td>\r\n<td>Mean of a set of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>AVERAGEIF</td>\r\n<td>Mean of a set of numbers that meet a condition</td>\r\n</tr>\r\n<tr>\r\n<td>AVERAGEIFS</td>\r\n<td>Mean of a set of numbers that meet one or more conditions</td>\r\n</tr>\r\n<tr>\r\n<td>HARMEAN</td>\r\n<td>Harmonic mean of a set of positive numbers</td>\r\n</tr>\r\n<tr>\r\n<td>GEOMEAN</td>\r\n<td>Geometric mean of a set of positive numbers</td>\r\n</tr>\r\n<tr>\r\n<td>MODE.SNGL</td>\r\n<td>Mode of a set of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>MEDIAN</td>\r\n<td>Median of a set of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>VAR.P</td>\r\n<td>Variance of a set of numbers considered to be a population</td>\r\n</tr>\r\n<tr>\r\n<td>VAR.S</td>\r\n<td>Variance of a set of numbers considered to be a sample</td>\r\n</tr>\r\n<tr>\r\n<td>STDEV.P</td>\r\n<td>Standard deviation of a set of numbers considered to be a population</td>\r\n</tr>\r\n<tr>\r\n<td>STDEV.S</td>\r\n<td>Standard deviation of a set of numbers considered to be a sample</td>\r\n</tr>\r\n<tr>\r\n<td>STANDARDIZE</td>\r\n<td>A standard score based on a given mean and standard deviation</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\nThese handy functions for relative standing can also be very useful.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><strong>Function</strong></td>\r\n<td><strong>What it calculates</strong></td>\r\n</tr>\r\n<tr>\r\n<td>RANK.EQ</td>\r\n<td>Rank of a number in a set of numbers. If more than one number has the same rank, it returns the top rank of those numbers.</td>\r\n</tr>\r\n<tr>\r\n<td>RANK.AVG</td>\r\n<td>Rank of a number in a set of numbers. If more than one number has the same rank, it returns their average.</td>\r\n</tr>\r\n<tr>\r\n<td>PERCENTRANK.INC</td>\r\n<td>Rank of a number in a set of numbers, expressed as a percent of the numbers it's greater than or equal to.</td>\r\n</tr>\r\n<tr>\r\n<td>PERCENTRANT.EXC</td>\r\n<td>Rank of a number in a set of numbers, expressed as a percent of the numbers it's greater than.</td>\r\n</tr>\r\n<tr>\r\n<td>PERCENTILE.INC</td>\r\n<td>The indicated percentile in a set of numbers, in terms of \"greater than or equal to.\"</td>\r\n</tr>\r\n<tr>\r\n<td>PERCENTILE.EXC</td>\r\n<td>The indicated percentile in a set of numbers, in terms of \"greater than.\"</td>\r\n</tr>\r\n<tr>\r\n<td>QUARTILE.INC</td>\r\n<td>The 1st, 2nd, 3rd, or 4th quartile of a set of numbers, in terms of \"greater than or equal to.\"</td>\r\n</tr>\r\n<tr>\r\n<td>QUARTILE.EXC</td>\r\n<td>The 1st, 2nd, 3rd, or 4th quartile of a set of numbers, in terms of \"greater than.\"</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\nThese functions for correlation and regression are also good ones to know.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><strong>Function</strong></td>\r\n<td><strong>What it Calculates</strong></td>\r\n</tr>\r\n<tr>\r\n<td>CORREL</td>\r\n<td>Correlation coefficient between two sets of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>PEARSON</td>\r\n<td>Same as CORREL. (Go figure!)</td>\r\n</tr>\r\n<tr>\r\n<td>RSQ</td>\r\n<td>Coefficient of determination between two sets of numbers (square of the correlation coefficient)</td>\r\n</tr>\r\n<tr>\r\n<td>SLOPE</td>\r\n<td>Slope of a regression line through two sets of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>INTERCEPT</td>\r\n<td>Intercept of a regression line through two sets of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>STEYX</td>\r\n<td>Standard error of estimate for a regression line through two sets of numbers</td>\r\n</tr>\r\n</tbody>\r\n</table>","description":"Excel can help you make all sorts of calculations. Here's a selection of Excel's statistical worksheet functions. Each one returns a value into a selected cell.\r\n\r\nCheck out these functions for central tendency and variability.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><strong>Function</strong></td>\r\n<td><strong>What it calculates</strong></td>\r\n</tr>\r\n<tr>\r\n<td>AVERAGE</td>\r\n<td>Mean of a set of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>AVERAGEIF</td>\r\n<td>Mean of a set of numbers that meet a condition</td>\r\n</tr>\r\n<tr>\r\n<td>AVERAGEIFS</td>\r\n<td>Mean of a set of numbers that meet one or more conditions</td>\r\n</tr>\r\n<tr>\r\n<td>HARMEAN</td>\r\n<td>Harmonic mean of a set of positive numbers</td>\r\n</tr>\r\n<tr>\r\n<td>GEOMEAN</td>\r\n<td>Geometric mean of a set of positive numbers</td>\r\n</tr>\r\n<tr>\r\n<td>MODE.SNGL</td>\r\n<td>Mode of a set of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>MEDIAN</td>\r\n<td>Median of a set of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>VAR.P</td>\r\n<td>Variance of a set of numbers considered to be a population</td>\r\n</tr>\r\n<tr>\r\n<td>VAR.S</td>\r\n<td>Variance of a set of numbers considered to be a sample</td>\r\n</tr>\r\n<tr>\r\n<td>STDEV.P</td>\r\n<td>Standard deviation of a set of numbers considered to be a population</td>\r\n</tr>\r\n<tr>\r\n<td>STDEV.S</td>\r\n<td>Standard deviation of a set of numbers considered to be a sample</td>\r\n</tr>\r\n<tr>\r\n<td>STANDARDIZE</td>\r\n<td>A standard score based on a given mean and standard deviation</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\nThese handy functions for relative standing can also be very useful.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><strong>Function</strong></td>\r\n<td><strong>What it calculates</strong></td>\r\n</tr>\r\n<tr>\r\n<td>RANK.EQ</td>\r\n<td>Rank of a number in a set of numbers. If more than one number has the same rank, it returns the top rank of those numbers.</td>\r\n</tr>\r\n<tr>\r\n<td>RANK.AVG</td>\r\n<td>Rank of a number in a set of numbers. If more than one number has the same rank, it returns their average.</td>\r\n</tr>\r\n<tr>\r\n<td>PERCENTRANK.INC</td>\r\n<td>Rank of a number in a set of numbers, expressed as a percent of the numbers it's greater than or equal to.</td>\r\n</tr>\r\n<tr>\r\n<td>PERCENTRANT.EXC</td>\r\n<td>Rank of a number in a set of numbers, expressed as a percent of the numbers it's greater than.</td>\r\n</tr>\r\n<tr>\r\n<td>PERCENTILE.INC</td>\r\n<td>The indicated percentile in a set of numbers, in terms of \"greater than or equal to.\"</td>\r\n</tr>\r\n<tr>\r\n<td>PERCENTILE.EXC</td>\r\n<td>The indicated percentile in a set of numbers, in terms of \"greater than.\"</td>\r\n</tr>\r\n<tr>\r\n<td>QUARTILE.INC</td>\r\n<td>The 1st, 2nd, 3rd, or 4th quartile of a set of numbers, in terms of \"greater than or equal to.\"</td>\r\n</tr>\r\n<tr>\r\n<td>QUARTILE.EXC</td>\r\n<td>The 1st, 2nd, 3rd, or 4th quartile of a set of numbers, in terms of \"greater than.\"</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\nThese functions for correlation and regression are also good ones to know.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><strong>Function</strong></td>\r\n<td><strong>What it Calculates</strong></td>\r\n</tr>\r\n<tr>\r\n<td>CORREL</td>\r\n<td>Correlation coefficient between two sets of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>PEARSON</td>\r\n<td>Same as CORREL. (Go figure!)</td>\r\n</tr>\r\n<tr>\r\n<td>RSQ</td>\r\n<td>Coefficient of determination between two sets of numbers (square of the correlation coefficient)</td>\r\n</tr>\r\n<tr>\r\n<td>SLOPE</td>\r\n<td>Slope of a regression line through two sets of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>INTERCEPT</td>\r\n<td>Intercept of a regression line through two sets of numbers</td>\r\n</tr>\r\n<tr>\r\n<td>STEYX</td>\r\n<td>Standard error of estimate for a regression line through two sets of numbers</td>\r\n</tr>\r\n</tbody>\r\n</table>","blurb":"","authors":[{"authorId":9759,"name":"Joseph Schmuller","slug":"joseph-schmuller","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9759"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":227942,"title":"How to Use Excel’s POISSON.DIST Function","slug":"use-excels-poisson-dist-function","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227942"}},{"articleId":227936,"title":"How to Find Correlation in Excel","slug":"find-correlation-excel","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227936"}},{"articleId":227931,"title":"Using More Than Two Samples in Excel: Kruskal-Wallis One-Way ANOVA","slug":"using-two-samples-excel-kruskal-wallis-one-way-anova","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227931"}},{"articleId":227927,"title":"Juggling Many Relationships at Once in Excel: Multiple Regression","slug":"juggling-many-relationships-excel-multiple-regression","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227927"}},{"articleId":227920,"title":"How to Use 3D Maps in Excel","slug":"use-3d-maps-excel","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227920"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281873,"slug":"statistical-analysis-with-excel-for-dummies","isbn":"9781119844549","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/1119844541/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119844541/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/1119844541-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119844541/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119844541/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/9781119844549-203x255.jpg","width":203,"height":255},"title":"Statistical Analysis with Excel For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"","authors":[{"authorId":9759,"name":"Joseph Schmuller","slug":"joseph-schmuller","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9759"}}],"_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;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119844549&quot;]}]\" id=\"du-slot-64809baeda83f\"></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;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119844549&quot;]}]\" id=\"du-slot-64809baedb23e\"></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},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Five years","lifeExpectancySetFrom":"2023-06-07T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":168991},{"headers":{"creationTime":"2016-03-27T08:59:54+00:00","modifiedTime":"2023-06-05T20:45:54+00:00","timestamp":"2023-06-05T21: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":"PowerPoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33647"},"slug":"powerpoint","categoryId":33647}],"title":"How To Hyperlink Between Slides in PowerPoint 2016","strippedTitle":"how to hyperlink between slides in powerpoint 2016","slug":"how-to-create-a-hyperlink-to-another-slide-in-powerpoint-2016","canonicalUrl":"","seo":{"metaDescription":"Follow these step-by-step instructions for how to create a hyperlink to another element in your PowerPoint presentation.","noIndex":0,"noFollow":0},"content":"In PowerPoint 2016, a hyperlink is simply a bit of text or a graphic image that you can click when viewing a slide to summon another slide, another presentation, or perhaps some other type of document, such as a Word document or an Excel spreadsheet. The hyperlink may also lead to a page on the web.\r\n\r\nAdding a hyperlink to a presentation is easy. Just follow these steps:","description":"In PowerPoint 2016, a hyperlink is simply a bit of text or a graphic image that you can click when viewing a slide to summon another slide, another presentation, or perhaps some other type of document, such as a Word document or an Excel spreadsheet. The hyperlink may also lead to a page on the web.\r\n\r\nAdding a hyperlink to a presentation is easy. Just follow these steps:","blurb":"","authors":[{"authorId":8946,"name":"Doug Lowe","slug":"doug-lowe","description":" <p><b>Doug Lowe</b> began writing computer books before Java was invented. He's covered dinosaurs such as COBOL, FORTRAN, and IBM mainframe computers, as well as web programming, Microsoft PowerPoint, and networking. Doug has written more than 30 <i>For Dummies</i> computer guides. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/8946"}}],"primaryCategoryTaxonomy":{"categoryId":33647,"title":"PowerPoint","slug":"powerpoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33647"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":207424,"title":"PowerPoint 2016 For Dummies Cheat Sheet","slug":"powerpoint-2016-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207424"}},{"articleId":203196,"title":"How to Show Your PowerPoint 2016 Presentation Online","slug":"how-to-show-your-powerpoint-2016-presentation-online","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/203196"}},{"articleId":203194,"title":"How to Insert WordArt into Your PowerPoint 2016 Presentation","slug":"how-to-insert-wordart-into-your-powerpoint-2016-presentation","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/203194"}},{"articleId":203193,"title":"How to Insert a Picture into Your PowerPoint 2016 Presentation","slug":"how-to-insert-a-picture-into-your-powerpoint-2016-presentation","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/203193"}},{"articleId":203192,"title":"How to Share Your PowerPoint 2016 Presentation via OneDrive","slug":"how-to-share-your-powerpoint-2016-presentation-via-onedrive","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/203192"}}],"fromCategory":[{"articleId":288823,"title":"PowerPoint 2021 For Dummies Cheat Sheet","slug":"powerpoint-2021-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288823"}},{"articleId":257590,"title":"How to Remove Picture Backgrounds in PowerPoint 2019","slug":"how-to-remove-picture-backgrounds-in-powerpoint-2019","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257590"}},{"articleId":257584,"title":"Audio Options in Microsoft PowerPoint 2019","slug":"audio-options-in-microsoft-powerpoint-2019","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257584"}},{"articleId":257577,"title":"How to Share Presentations via the PowerPoint Web App","slug":"how-to-share-presentations-via-the-powerpoint-web-app","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257577"}},{"articleId":257571,"title":"How to Share a PowerPoint 2019 Presentation in the Cloud","slug":"how-to-share-a-powerpoint-2019-presentation-in-the-cloud","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257571"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281825,"slug":"powerpoint-2016-for-dummies","isbn":"9781119077053","categoryList":["technology","software","microsoft-products","powerpoint"],"amazon":{"default":"https://www.amazon.com/gp/product/1119077052/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119077052/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/1119077052-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119077052/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119077052/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/powerpoint-2016-for-dummies-cover-9781119077053-205x255.jpg","width":205,"height":255},"title":"PowerPoint 2016 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"8946\">Doug Lowe </b>is a veteran author with more than 40 <i>For Dummies</i> books to his credit, including titles on everything from Microsoft Office productivity with PowerPoint to networking to programming in ASP.NET. </p>","authors":[{"authorId":8946,"name":"Doug Lowe","slug":"doug-lowe","description":" <p><b>Doug Lowe</b> began writing computer books before Java was invented. He's covered dinosaurs such as COBOL, FORTRAN, and IBM mainframe computers, as well as web programming, Microsoft PowerPoint, and networking. Doug has written more than 30 <i>For Dummies</i> computer guides. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/8946"}}],"_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;powerpoint&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119077053&quot;]}]\" id=\"du-slot-647e4d0f17707\"></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;powerpoint&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119077053&quot;]}]\" id=\"du-slot-647e4d0f18386\"></div></div>"},"articleType":{"articleType":"Step by Step","articleList":null,"content":[{"title":"Select the text or graphic object that you want to make into a hyperlink.","thumb":{"src":null,"width":0,"height":0},"image":{"src":"https://www.dummies.com/wp-content/uploads/497029.image0.jpg","width":520,"height":400},"content":"<p>The most common type of hyperlink is based on a word or two of text in a slide’s body text area.</p>\n"},{"title":"Choose Insert→Links→Hyperlink.","thumb":{"src":null,"width":0,"height":0},"image":{"src":"https://www.dummies.com/wp-content/uploads/497030.image1.jpg","width":535,"height":280},"content":"<p>Alternatively, click the Insert Hyperlink button found on the standard toolbar or use the keyboard shortcut Ctrl+K. One way or the other, the Insert Hyperlink dialog box appears.</p>\n"},{"title":"Click the Place in This Document icon on the left side of the dialog box.","thumb":{"src":null,"width":0,"height":0},"image":{"src":"https://www.dummies.com/wp-content/uploads/497031.image2.jpg","width":535,"height":280},"content":"<p>This option enables you to link one part of your PowerPoint presentation to another part. A list of the slides in the current presentation appears in the dialog box.</p>\n<p>The other three options in the Insert Hyperlink dialog box enable you to link to another file in another application, to a web page on the Internet, or to an e-mail address. You can, however, choose now or another time to edit the new document by clicking the appropriate button.</p>\n"},{"title":"Click the slide that you want the hyperlink to lead to and then click OK.","thumb":{"src":null,"width":0,"height":0},"image":{"src":"https://www.dummies.com/wp-content/uploads/497032.image3.jpg","width":520,"height":400},"content":"<p>The Insert Hyperlink dialog box vanishes, and the hyperlink is created.</p>\n<p>If you selected text in Step 1, the text changes color and is underlined. If you selected a graphical object, the picture isn’t highlighted in any way to indicate that it is a hyperlink. However, the cursor always changes to a pointing hand whenever it passes over a hyperlink in Slide Show View or Reading View, thus providing a visual clue that the user has found a hyperlink.</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},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Five years","lifeExpectancySetFrom":"2022-09-15T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":203189},{"headers":{"creationTime":"2016-03-26T15:27:38+00:00","modifiedTime":"2023-04-17T20:54:53+00:00","timestamp":"2023-04-17T21: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":"PowerPoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33647"},"slug":"powerpoint","categoryId":33647}],"title":"Applying Artistic Effects in PowerPoint 2013","strippedTitle":"applying artistic effects in powerpoint 2013","slug":"how-to-apply-artistic-effects-to-powerpoint-2013-pictures","canonicalUrl":"","seo":{"metaDescription":"The Artistic Effects command in PowerPoint 2013 applies one of several special filters to your picture in an effort to make the picture look like it was created","noIndex":0,"noFollow":0},"content":"The Artistic Effects command in PowerPoint 2013 applies one of several special filters to your picture in an effort to make the picture look like it was created by an artist rather than photographed with a $60 digital camera. Depending on the nature of the original picture, the results may or may not be convincing; the only way to find out is to try.\r\n\r\nHere is a list of the artistic effects that are available on the Artistic Effects button:\r\n<ul class=\"level-one\">\r\n \t<li>\r\n<p class=\"first-para\">Marker</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Pencil Grayscale</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Pencil Sketch</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Line Drawing</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Chalk Sketch</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Paint Strokes</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Paint Brush</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Glow Diffused</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Blur</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Light Screen</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Watercolor Sponge</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Film Grain</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Mosaic Bubbles</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Glass</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Cement</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Texturizer</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Crisscross Etching</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Pastels Smooth</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Plastic Wrap</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Cutout</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Photocopy</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Glow Edges</p>\r\n</li>\r\n</ul>\r\nTo apply one of these effects, simply double-click the picture, click the Artistic Effects button on the Picture Tools Format tab, and choose the effect you want from the gallery.\r\n\r\nTo give you an idea of what these effects can accomplish, this figure shows how a photograph appears with the Pencil Sketch, Watercolor Sponge, and Plastic Wrap filters applied.\r\n\r\n<img src=\"https://www.dummies.com/wp-content/uploads/367779.image0.jpg\" alt=\"image0.jpg\" width=\"535\" height=\"193\" />","description":"The Artistic Effects command in PowerPoint 2013 applies one of several special filters to your picture in an effort to make the picture look like it was created by an artist rather than photographed with a $60 digital camera. Depending on the nature of the original picture, the results may or may not be convincing; the only way to find out is to try.\r\n\r\nHere is a list of the artistic effects that are available on the Artistic Effects button:\r\n<ul class=\"level-one\">\r\n \t<li>\r\n<p class=\"first-para\">Marker</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Pencil Grayscale</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Pencil Sketch</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Line Drawing</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Chalk Sketch</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Paint Strokes</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Paint Brush</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Glow Diffused</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Blur</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Light Screen</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Watercolor Sponge</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Film Grain</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Mosaic Bubbles</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Glass</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Cement</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Texturizer</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Crisscross Etching</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Pastels Smooth</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Plastic Wrap</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Cutout</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Photocopy</p>\r\n</li>\r\n \t<li>\r\n<p class=\"first-para\">Glow Edges</p>\r\n</li>\r\n</ul>\r\nTo apply one of these effects, simply double-click the picture, click the Artistic Effects button on the Picture Tools Format tab, and choose the effect you want from the gallery.\r\n\r\nTo give you an idea of what these effects can accomplish, this figure shows how a photograph appears with the Pencil Sketch, Watercolor Sponge, and Plastic Wrap filters applied.\r\n\r\n<img src=\"https://www.dummies.com/wp-content/uploads/367779.image0.jpg\" alt=\"image0.jpg\" width=\"535\" height=\"193\" />","blurb":"","authors":[{"authorId":8946,"name":"Doug Lowe","slug":"doug-lowe","description":" <p><b>Doug Lowe</b> began writing computer books before Java was invented. He's covered dinosaurs such as COBOL, FORTRAN, and IBM mainframe computers, as well as web programming, Microsoft PowerPoint, and networking. Doug has written more than 30 <i>For Dummies</i> computer guides. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/8946"}}],"primaryCategoryTaxonomy":{"categoryId":33647,"title":"PowerPoint","slug":"powerpoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33647"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":208051,"title":"PowerPoint 2013 For Dummies Cheat Sheet","slug":"powerpoint-2013-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208051"}},{"articleId":204875,"title":"How to Create a Hyperlink to Another PowerPoint 2013 Slide","slug":"how-to-create-a-hyperlink-to-another-powerpoint-2013-slide","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/204875"}},{"articleId":204874,"title":"9 Things That Often Go Wrong in PowerPoint 2013","slug":"9-things-that-often-go-wrong-in-powerpoint-2013","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/204874"}},{"articleId":204873,"title":"How to Add Recurring Text or Other Elements in PowerPoint 2013","slug":"how-to-add-recurring-text-or-other-elements-in-powerpoint-2013","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/204873"}},{"articleId":204872,"title":"How to Add Comments to PowerPoint 2013 Presentations","slug":"how-to-add-comments-to-powerpoint-2013-presentations","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/204872"}}],"fromCategory":[{"articleId":288823,"title":"PowerPoint 2021 For Dummies Cheat Sheet","slug":"powerpoint-2021-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288823"}},{"articleId":257590,"title":"How to Remove Picture Backgrounds in PowerPoint 2019","slug":"how-to-remove-picture-backgrounds-in-powerpoint-2019","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257590"}},{"articleId":257584,"title":"Audio Options in Microsoft PowerPoint 2019","slug":"audio-options-in-microsoft-powerpoint-2019","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257584"}},{"articleId":257577,"title":"How to Share Presentations via the PowerPoint Web App","slug":"how-to-share-presentations-via-the-powerpoint-web-app","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257577"}},{"articleId":257571,"title":"How to Share a PowerPoint 2019 Presentation in the Cloud","slug":"how-to-share-a-powerpoint-2019-presentation-in-the-cloud","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257571"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281824,"slug":"powerpoint-2013-for-dummies","isbn":"9781118502532","categoryList":["technology","software","microsoft-products","powerpoint"],"amazon":{"default":"https://www.amazon.com/gp/product/1118502531/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1118502531/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/1118502531-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1118502531/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1118502531/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/powerpoint-2013-for-dummies-cover-9781118502532-204x255.jpg","width":204,"height":255},"title":"PowerPoint 2013 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"8946\">Doug Lowe</b> is the bestselling author of more than 40 <i>For Dummies</i> books. He's covered everything from Microsoft Office to creating web pages to technologies such as Java and ASP.NET, and has written several editions of both <i>PowerPoint For Dummies</i> and <i>Networking For Dummies.</i></p>","authors":[{"authorId":8946,"name":"Doug Lowe","slug":"doug-lowe","description":" <p><b>Doug Lowe</b> began writing computer books before Java was invented. He's covered dinosaurs such as COBOL, FORTRAN, and IBM mainframe computers, as well as web programming, Microsoft PowerPoint, and networking. Doug has written more than 30 <i>For Dummies</i> computer guides. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/8946"}}],"_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;powerpoint&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118502532&quot;]}]\" id=\"du-slot-643db39012db2\"></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;powerpoint&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118502532&quot;]}]\" id=\"du-slot-643db39013653\"></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},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Five years","lifeExpectancySetFrom":"2023-04-17T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":168479},{"headers":{"creationTime":"2016-03-26T07:21:05+00:00","modifiedTime":"2023-04-14T18:00:01+00:00","timestamp":"2023-04-14T18: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":"Shortcuts in Word, Excel, and PowerPoint 2016","strippedTitle":"shortcuts in word, excel, and powerpoint 2016","slug":"common-shortcuts-in-word-excel-and-powerpoint-2016","canonicalUrl":"","seo":{"metaDescription":"Keep this handy list of Office 2016 keyboard shortcuts nearby when you're working in Word, Excel, and PowerPoint.","noIndex":0,"noFollow":0},"content":"By touching a couple of keys in combination in Office 2016 programs, you can save time with simple tasks, 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 2016. Both mouse and keyboard methods are provided here.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<th>To do this</th>\r\n<th>With the mouse</th>\r\n<th>With the keyboard</th>\r\n</tr>\r\n<tr>\r\n<td>Open a file</td>\r\n<td>File→Open</td>\r\n<td>Ctrl+O</td>\r\n</tr>\r\n<tr>\r\n<td>Create a new file</td>\r\n<td>File→New</td>\r\n<td>Ctrl+N</td>\r\n</tr>\r\n<tr>\r\n<td>Print active document</td>\r\n<td>File→Print</td>\r\n<td>Ctrl+P</td>\r\n</tr>\r\n<tr>\r\n<td>Save your work (first time), or resave with same settings</td>\r\n<td>File→Save</td>\r\n<td>Ctrl+S</td>\r\n</tr>\r\n<tr>\r\n<td>Save your work with different name, location, or type</td>\r\n<td>File→Save As</td>\r\n<td>F12</td>\r\n</tr>\r\n<tr>\r\n<td>Copy selection to Clipboard</td>\r\n<td>Home→ Copy</td>\r\n<td>Ctrl+C</td>\r\n</tr>\r\n<tr>\r\n<td>Cut selection to Clipboard</td>\r\n<td>Home→ Cut</td>\r\n<td>Ctrl+X</td>\r\n</tr>\r\n<tr>\r\n<td>Paste selection to Clipboard</td>\r\n<td>Home→ Paste</td>\r\n<td>Ctrl+V</td>\r\n</tr>\r\n<tr>\r\n<td>Open the Paste Special dialog box</td>\r\n<td>Home→Paste→Paste Special</td>\r\n<td>Ctrl+Shift+V</td>\r\n</tr>\r\n<tr>\r\n<td>Display shortcut menu for selected item</td>\r\n<td>Right-click item</td>\r\n<td>Shift+F10</td>\r\n</tr>\r\n<tr>\r\n<td>Left-align a paragraph</td>\r\n<td>Home→ Left Align</td>\r\n<td>Ctrl+L</td>\r\n</tr>\r\n<tr>\r\n<td>Center a paragraph</td>\r\n<td>Home→ Center</td>\r\n<td>Ctrl+E</td>\r\n</tr>\r\n<tr>\r\n<td>Right-align a paragraph</td>\r\n<td>Home→ Right Align</td>\r\n<td>Ctrl+R</td>\r\n</tr>\r\n<tr>\r\n<td>Make text bold</td>\r\n<td>Home→ Bold</td>\r\n<td>Ctrl+B</td>\r\n</tr>\r\n<tr>\r\n<td>Make text italicized</td>\r\n<td>Home→ Italic</td>\r\n<td>Ctrl+I</td>\r\n</tr>\r\n<tr>\r\n<td>Make text underlined</td>\r\n<td>Home→Underline</td>\r\n<td>Ctrl+U</td>\r\n</tr>\r\n<tr>\r\n<td>Make text larger</td>\r\n<td>Home→Increase Font Size</td>\r\n<td>Ctrl+></td>\r\n</tr>\r\n<tr>\r\n<td>Make text smaller</td>\r\n<td>Home→Decrease Font Size</td>\r\n<td>Ctrl+<</td>\r\n</tr>\r\n<tr>\r\n<td>Undo previous action</td>\r\n<td>Undo button on Quick Access toolbar</td>\r\n<td>Ctrl+Z</td>\r\n</tr>\r\n<tr>\r\n<td>Redo previous Undo</td>\r\n<td>Redo button on Quick Access toolbar</td>\r\n<td>Ctrl+Y</td>\r\n</tr>\r\n<tr>\r\n<td>Insert hyperlink</td>\r\n<td>Insert→Hyperlink</td>\r\n<td>Ctrl+K</td>\r\n</tr>\r\n<tr>\r\n<td>Get help</td>\r\n<td>Type in Tellme what you want to do box</td>\r\n<td>F1</td>\r\n</tr>\r\n<tr>\r\n<td>Close the active file</td>\r\n<td>File→Close</td>\r\n<td>Ctrl+F4</td>\r\n</tr>\r\n<tr>\r\n<td>Close the application</td>\r\n<td>Close button on application window</td>\r\n<td>Alt+F4</td>\r\n</tr>\r\n<tr>\r\n<td>Check spelling</td>\r\n<td>Review→Spelling</td>\r\n<td>F7</td>\r\n</tr>\r\n</tbody>\r\n</table>","description":"By touching a couple of keys in combination in Office 2016 programs, you can save time with simple tasks, 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 2016. Both mouse and keyboard methods are provided here.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<th>To do this</th>\r\n<th>With the mouse</th>\r\n<th>With the keyboard</th>\r\n</tr>\r\n<tr>\r\n<td>Open a file</td>\r\n<td>File→Open</td>\r\n<td>Ctrl+O</td>\r\n</tr>\r\n<tr>\r\n<td>Create a new file</td>\r\n<td>File→New</td>\r\n<td>Ctrl+N</td>\r\n</tr>\r\n<tr>\r\n<td>Print active document</td>\r\n<td>File→Print</td>\r\n<td>Ctrl+P</td>\r\n</tr>\r\n<tr>\r\n<td>Save your work (first time), or resave with same settings</td>\r\n<td>File→Save</td>\r\n<td>Ctrl+S</td>\r\n</tr>\r\n<tr>\r\n<td>Save your work with different name, location, or type</td>\r\n<td>File→Save As</td>\r\n<td>F12</td>\r\n</tr>\r\n<tr>\r\n<td>Copy selection to Clipboard</td>\r\n<td>Home→ Copy</td>\r\n<td>Ctrl+C</td>\r\n</tr>\r\n<tr>\r\n<td>Cut selection to Clipboard</td>\r\n<td>Home→ Cut</td>\r\n<td>Ctrl+X</td>\r\n</tr>\r\n<tr>\r\n<td>Paste selection to Clipboard</td>\r\n<td>Home→ Paste</td>\r\n<td>Ctrl+V</td>\r\n</tr>\r\n<tr>\r\n<td>Open the Paste Special dialog box</td>\r\n<td>Home→Paste→Paste Special</td>\r\n<td>Ctrl+Shift+V</td>\r\n</tr>\r\n<tr>\r\n<td>Display shortcut menu for selected item</td>\r\n<td>Right-click item</td>\r\n<td>Shift+F10</td>\r\n</tr>\r\n<tr>\r\n<td>Left-align a paragraph</td>\r\n<td>Home→ Left Align</td>\r\n<td>Ctrl+L</td>\r\n</tr>\r\n<tr>\r\n<td>Center a paragraph</td>\r\n<td>Home→ Center</td>\r\n<td>Ctrl+E</td>\r\n</tr>\r\n<tr>\r\n<td>Right-align a paragraph</td>\r\n<td>Home→ Right Align</td>\r\n<td>Ctrl+R</td>\r\n</tr>\r\n<tr>\r\n<td>Make text bold</td>\r\n<td>Home→ Bold</td>\r\n<td>Ctrl+B</td>\r\n</tr>\r\n<tr>\r\n<td>Make text italicized</td>\r\n<td>Home→ Italic</td>\r\n<td>Ctrl+I</td>\r\n</tr>\r\n<tr>\r\n<td>Make text underlined</td>\r\n<td>Home→Underline</td>\r\n<td>Ctrl+U</td>\r\n</tr>\r\n<tr>\r\n<td>Make text larger</td>\r\n<td>Home→Increase Font Size</td>\r\n<td>Ctrl+></td>\r\n</tr>\r\n<tr>\r\n<td>Make text smaller</td>\r\n<td>Home→Decrease Font Size</td>\r\n<td>Ctrl+<</td>\r\n</tr>\r\n<tr>\r\n<td>Undo previous action</td>\r\n<td>Undo button on Quick Access toolbar</td>\r\n<td>Ctrl+Z</td>\r\n</tr>\r\n<tr>\r\n<td>Redo previous Undo</td>\r\n<td>Redo button on Quick Access toolbar</td>\r\n<td>Ctrl+Y</td>\r\n</tr>\r\n<tr>\r\n<td>Insert hyperlink</td>\r\n<td>Insert→Hyperlink</td>\r\n<td>Ctrl+K</td>\r\n</tr>\r\n<tr>\r\n<td>Get help</td>\r\n<td>Type in Tellme what you want to do box</td>\r\n<td>F1</td>\r\n</tr>\r\n<tr>\r\n<td>Close the active file</td>\r\n<td>File→Close</td>\r\n<td>Ctrl+F4</td>\r\n</tr>\r\n<tr>\r\n<td>Close the application</td>\r\n<td>Close button on application window</td>\r\n<td>Alt+F4</td>\r\n</tr>\r\n<tr>\r\n<td>Check spelling</td>\r\n<td>Review→Spelling</td>\r\n<td>F7</td>\r\n</tr>\r\n</tbody>\r\n</table>","blurb":"","authors":[{"authorId":9025,"name":"Faithe Wempen","slug":"faithe-wempen","description":" <p><b>Nancy C. Muir</b> is the owner of a writing and consulting company that specializes in business and technology topics. She is the author of more than 100 books, and she has taught technology courses online. ","hasArticle":false,"_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":207433,"title":"Office 2016 At Work For Dummies Cheat Sheet","slug":"office-2016-at-work-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207433"}},{"articleId":140208,"title":"Word 2016 Text Entry and Formatting Shortcuts","slug":"word-2016-text-entry-and-formatting-shortcuts","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/140208"}},{"articleId":140209,"title":"Word 2016 Symbol Shortcuts","slug":"word-2016-symbol-shortcuts","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/140209"}},{"articleId":140198,"title":"Word 2016 View Shortcuts","slug":"word-2016-view-shortcuts","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/140198"}},{"articleId":140191,"title":"Excel 2016 Number Formatting Shortcuts","slug":"excel-2016-number-formatting-shortcuts","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/140191"}}],"fromCategory":[{"articleId":294664,"title":"Windows 365 For Dummies Cheat Sheet","slug":"windows-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/294664"}},{"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"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281798,"slug":"office-2016-at-work-for-dummies","isbn":"9781119144601","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119144604/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119144604/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/1119144604-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119144604/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119144604/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/office-2016-at-work-for-dummies-cover-9781119144601-170x255.jpg","width":170,"height":255},"title":"Office 2016 at Work For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9025\">Faithe Wempen, M.A.,</b> has written more than 140 books on computer hardware and software, including <i>Microsoft Office 2016 for Seniors for Dummies</i> and <i>The PowerPoint Bible</i>. A Microsoft Office Master Instructor, she has educated more than a quarter of a million 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":" <p><b>Nancy C. Muir</b> is the owner of a writing and consulting company that specializes in business and technology topics. She is the author of more than 100 books, and she has taught technology courses online. ","hasArticle":false,"_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;9781119144601&quot;]}]\" id=\"du-slot-643994e0948a8\"></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;9781119144601&quot;]}]\" id=\"du-slot-643994e095208\"></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},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Five years","lifeExpectancySetFrom":"2022-09-30T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":140212},{"headers":{"creationTime":"2023-03-13T20:48:40+00:00","modifiedTime":"2023-03-15T13:56:16+00:00","timestamp":"2023-03-15T15:01: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}],"title":"10 Tips for Microsoft Flight Simulator Beginners","strippedTitle":"10 tips for microsoft flight simulator beginners","slug":"10-tips-for-microsoft-flight-simulator-beginners","canonicalUrl":"","seo":{"metaDescription":"These 10 tips will help you enjoy your time spent flying with Microsoft Flight Simulator, whether you're a beginner or seasoned player.","noIndex":0,"noFollow":0},"content":"Like real-world flying, Microsoft Flight Simulator 2020 has a seemingly never-ending bag of tricks. Despite being an incredibly realistic sim, don’t forget that Flight Simulator is also a game — and there are <em>always</em> secrets and hints in games.\r\n\r\nThese tips can make hopping into the cockpit and exploring the virtual world a little easier for beginners — and maybe even a bit more fun, too! Even a seasoned Flight Simulator veteran might find these tricks worth retaining, especially if you plan to play the game for many moons to come.\r\n\r\nFor more information related to these tips, check out my book <em>Microsoft Flight Simulator For Dummies</em>.\r\n<h2 id=\"tab1\" >Start in midair</h2>\r\nDid you know you can completely skip the takeoff sequence? It's true, and you may prefer starting in midair if you want to (initially) avoid what can be a lengthy learning experience.\r\n\r\nTo start your flights already in midair, follow these steps:\r\n<ol>\r\n \t<li>Go to the World Map.</li>\r\n \t<li>Left-click or press A anywhere on the World Map that isn't an airport.</li>\r\n \t<li>Choose the Set As Departure option from the pop-up menu shown in the figure below.</li>\r\n \t<li>Press the Fly button in the lower right of the screen to start your flight.</li>\r\n</ol>\r\n[caption id=\"attachment_297828\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297828\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-departure-point.jpg\" alt=\"Flight simulator screenshot showing how to choose a departure point for a start in midair\" width=\"630\" height=\"384\" /> ©Microsoft<br />Choosing a departure point for starting a flight in midair[/caption]\r\n\r\nWhen you complete these steps, you can begin your journey at around 1,500 feet in the air.\r\n<h2 id=\"tab2\" >Find animals quickly</h2>\r\nHow do you find animals so that you can get up close and personal? You can actually seek them out in a very simple way, and it only takes a few seconds. Follow these steps to get all the animal experiences you crave:\r\n<ol>\r\n \t<li>Go to the World Map.</li>\r\n \t<li>Type the word \"fauna\" in the search bar (found on the left side of the screen) and click the Search icon.</li>\r\n \t<li>Click to choose your next destination from the list of locations that feature animals.</li>\r\n \t<li>After you start your flight and you’re on your way to the chosen destination, access the Pause menu by pressing Escape or the Menu button.</li>\r\n \t<li>Click the Assistance tab.</li>\r\n \t<li>Click the Navigation menu and find the Fauna Markers option.</li>\r\n \t<li>Click to toggle on the option.</li>\r\n</ol>\r\nMarkers appear on the map to show where you can find animals along your route. You need to decide which animals you want to find, but with Fauna Markers turned on, this decision becomes less of a headache.\r\n<h2 id=\"tab3\" >Refuel your aircraft anywhere</h2>\r\nIn Flight Simulator, you can refuel while flying without missing a beat. You just need to change your keybindings (options that are tied to a specific input device key or key combination), but that change doesn't take very long. Just follow these steps:\r\n<ol>\r\n \t<li>Access the Pause Menu and click the Controls tab.</li>\r\n \t<li>In the Controls Options window that appears (see below), choose the input type that you’re using. You can choose from Keyboard, Mouse, or Controller.</li>\r\n \t<li>Scroll down the resulting list of options and select the Repair and Refuel keybinding option. If you don’t want to scroll, you can type Repair and Refuel in the search bar in the left column of the Controls Options window, as shown in the figure below.</li>\r\n \t<li>Choose a key on your input device to which you want to bind the Repair and Refuel option.</li>\r\n \t<li>Press escape or the Menu button to exit the Pause menu screen.</li>\r\n</ol>\r\n[caption id=\"attachment_297826\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297826\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-keybinding.jpg\" alt=\"Flight Simulator screenshot showing how to searching for the Repair and Refuel option for keybinding\" width=\"630\" height=\"276\" /> ©Microsoft<br />Searching for the Repair and Refuel option for keybinding[/caption]\r\n\r\nAfter you follow the preceding steps, you should still be in midair. You can press the key you just selected to instantly repair any issues with your aircraft that might be plaguing you at present, as well as receive an automatic refueling. You don't need to do anything special after that. Your gas gauge should be full once more!\r\n<h2 id=\"tab4\" >Turn off satellite overlay</h2>\r\nYou can toggle on an instrument flight rules (IFR) view that may mitigate potential issues with locating landmarks. When you use IFR view, you get a plain gray map that makes it a lot easier to see things like distance between points at a glance.\r\n\r\nTo turn on IFR view in the World Map, follow these steps:\r\n<ol>\r\n \t<li>From the main screen open the World Map.</li>\r\n \t<li>Choose the Open Filters option that appears in the shortcut bar in the lower part of your screen. A window appears, as shown below, where you can scroll through filter options.</li>\r\n \t<li>Click the arrows to the left and right of the Background Map option to toggle the IFR option to replace Satellite.</li>\r\n</ol>\r\n[caption id=\"attachment_297829\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297829\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-IFR-view.jpg\" alt=\"Screenshot showing how to set IFR view\" width=\"630\" height=\"260\" /> ©Microsoft<br />Setting the World Map to IFR view[/caption]\r\n\r\nAfter following the preceding steps, you should have a better, more granular view of the Earth below.\r\n<h2 id=\"tab5\" >Explore outside the plane</h2>\r\nDid you know you can leave the plane in midair to look at the world around you? No, you aren't physically exiting the plane. But using a feature called <em>Active Pause,</em> you can take a look at your surroundings without having to land.\r\n\r\nActive Pause stops your plane right where it is, and you can explore your aircraft's cockpit, immediate surroundings in the air, or the entire world around you. Here's how to turn on Active Pause:\r\n<ol>\r\n \t<li>Press Escape or the Menu button to go to the Pause menu, click on options, and click on the Assistance menu, which is shown in the figure below.</li>\r\n \t<li>Look for the Play/Pause icon on the toolbar that appears when you hover the mouse near the top of your screen. This icon represents a toggle for Active Pause.</li>\r\n \t<li>Click the Play/Pause icon to activate the Active Pause play mode.</li>\r\n</ol>\r\n[caption id=\"attachment_297830\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297830\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-active-pause.jpg\" alt=\"Screenshot showing the Active Pause mode\" width=\"630\" height=\"384\" /> ©Microsoft<br />Using the Active Pause mode[/caption]\r\n\r\nToggling on the Active Pause mode activates a drone that you can maneuver using the standard aircraft controls on the keyboard or controller. You can explore to your heart's content without ruining your flight. And you don't even have to stop playing to do it!\r\n<h2 id=\"tab6\" >Explore the streets</h2>\r\nYou may be playing a flight sim, but you still have plenty of ways to interact with the world around you. The same drone that allows you to exit the cockpit and travel around the world (during an Active Pause; see the preceding section) enables you to travel down to the streets and have a look around.\r\n\r\nIt may take a bit of doing because your plane is fairly high up in the sky, but you absolutely can take your drone down to the streets (see below).\r\n\r\n[caption id=\"attachment_297827\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297827\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-street-view.jpg\" alt=\"Screenshot showing street view in Flight Simulator\" width=\"630\" height=\"355\" /> ©Microsoft<br />The street view in Flight Simulator[/caption]\r\n<h2 id=\"tab7\" >Speed up your flight</h2>\r\nYou can speed up the game's <em>sim rate</em> (the rate at which your flight proceeds along its route) in order to reach your destination more quickly. You can also fly to your endpoint more slowly if you want. You can adjust the sim rate up and down at your leisure.\r\n\r\n<strong>Follow these steps to adjust your game's sim rate if you’re playing on a PC:</strong>\r\n<ol>\r\n \t<li>Press the R key on your keyboard.</li>\r\n \t<li>Hold the CTRL key and press either the plus (+) key or the minus (–) key on the number pad. As I’m sure you can guess, pressing + speeds up the sim rate and pressing – slows it down.</li>\r\n</ol>\r\n<strong>Follow these steps to set your sim rate if you’re playing on a console:</strong>\r\n<ol>\r\n \t<li>Press Escape or the Menu button to go to the Pause menu, select Options, and select Controls Options. From the Controls Options screen, as shown below, you need to assign a button for the sim rate.</li>\r\n \t<li>Type the search term sim rate in the search box on the left side of the Controls Options window, and then click the Search icon.</li>\r\n \t<li>Click to select the Sim Rate option.</li>\r\n \t<li>When prompted, choose a key or console button when prompted that you want to bind to your Sim Rate option.</li>\r\n</ol>\r\n[caption id=\"attachment_297831\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297831\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-sim-rates.jpg\" alt=\"Screenshot showing how to bind a keyboard button to adjust sim rates\" width=\"630\" height=\"276\" /> ©Microsoft<br />Bind a keyboard button so you can adjust sim rates[/caption]\r\n\r\nAfter following the preceding steps, you can adjust the sim rate on your console easily:\r\n<ul>\r\n \t<li><strong>Slow down:</strong> Press your chosen button and the left trigger.</li>\r\n \t<li><strong>Speed up:</strong> Press your chosen button and the right trigger.</li>\r\n</ul>\r\nBy adjusting your sim rate, you can take those cross-country (or across-the-globe) flights in record time.\r\n<h2 id=\"tab8\" >Fast travel to flight phases</h2>\r\nIf you don't care much for the lengthy cruise phase of a flight, you might opt to skip it entirely. You can do that. Instead of actively flying through the entire trip, you can fast travel to a phase that's more appealing to you. To use the Travel To option, just follow these steps:\r\n<ol>\r\n \t<li>Press Escape or the Menu button to open your Pause menu.</li>\r\n \t<li>Click the Travel To button (which looks similar to a fast-forward button, as noted the figure below) to reveal your Travel To options. The Travel To window that appears lists the phases of your flight plan that you can choose from. The figure below shows Cruise, Descent, Approach, Final, and Taxi.</li>\r\n \t<li>Select the phase to which you want to fast travel.</li>\r\n</ol>\r\n[caption id=\"attachment_297834\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297834\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-fast-travel.jpg\" alt=\"Screenshot showing fast travel options\" width=\"630\" height=\"349\" /> ©Microsoft<br />Fast travel options[/caption]\r\n\r\nAfter you make your selection, your game skips to that phase. Hate taking off or cruising? Use this trick to skip past all of it!\r\n<h2 id=\"tab9\" >Customize your pilot avatar</h2>\r\nYou're more than just your plane in Flight Simulator. You have a pilot avatar, too! You might not see your avatar much while playing the game (your view is as the avatar in the cockpit), but you do have a character that represents you. Plus, you can change what your avatar looks like.\r\n\r\nTo customize your pilot avatar, follow these steps:\r\n<ol>\r\n \t<li>Press Escape or the Menu button to open the Pause menu.</li>\r\n \t<li>Click Options and then General.</li>\r\n \t<li>In the General Options window that appears, click the Misc tab on the left.</li>\r\n \t<li>Under Pilot Avatar Settings, repeatedly click the forward or backward arrow beside the Pilot Avatar to scroll through your options. You can choose from 24 different pilot models. Find the one that suits you. The models appear on the right side of the General Options window, as shown below.</li>\r\n \t<li>When you find the avatar that matches your mood today, select it by making your choices and leaving the Misc menu.</li>\r\n</ol>\r\n[caption id=\"attachment_297833\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297833\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-avatar.jpg\" alt=\"Screenshot showing pilot avatar options\" width=\"630\" height=\"276\" /> ©Microsoft<br />Pilot avatar options[/caption]\r\n\r\nNow you can have a pilot that (hopefully) better represents you in the virtual world!\r\n<h2 id=\"tab10\" >Change your ATC call sign</h2>\r\nYou can actually change your <em>call sign,</em> or title, that the air traffic control team uses to identify and address you over the radio. Follow these steps to customize your call sign:\r\n<ol>\r\n \t<li>Press Escape or the Menu button to go to the Pause menu.</li>\r\n \t<li>Select the correct option to go to the World Map.</li>\r\n \t<li>Choose ATC Options by clicking on your airplane in the upper left part of the screen, then select Customization from the menu on the left column.</li>\r\n \t<li>In the text box next to Call Sign (see below), type in your desired call sign. For example, perhaps you’d like to be known as 8675309. Choose a fun call sign, but don't be naughty. The game doesn’t recognize profanity, so keep it G-rated (or you may be banned from online play).</li>\r\n \t<li>Save your choice by leaving the menu and return to your game.</li>\r\n</ol>\r\n[caption id=\"attachment_297832\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297832\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-change-call-sign.jpg\" alt=\"Screenshot showing how to customize your call sign\" width=\"630\" height=\"355\" /> ©Microsoft<br />Call sign customization window[/caption]\r\n\r\nAfter you complete the preceding steps, ATC calls you by your desired call sign.","description":"Like real-world flying, Microsoft Flight Simulator 2020 has a seemingly never-ending bag of tricks. Despite being an incredibly realistic sim, don’t forget that Flight Simulator is also a game — and there are <em>always</em> secrets and hints in games.\r\n\r\nThese tips can make hopping into the cockpit and exploring the virtual world a little easier for beginners — and maybe even a bit more fun, too! Even a seasoned Flight Simulator veteran might find these tricks worth retaining, especially if you plan to play the game for many moons to come.\r\n\r\nFor more information related to these tips, check out my book <em>Microsoft Flight Simulator For Dummies</em>.\r\n<h2 id=\"tab1\" >Start in midair</h2>\r\nDid you know you can completely skip the takeoff sequence? It's true, and you may prefer starting in midair if you want to (initially) avoid what can be a lengthy learning experience.\r\n\r\nTo start your flights already in midair, follow these steps:\r\n<ol>\r\n \t<li>Go to the World Map.</li>\r\n \t<li>Left-click or press A anywhere on the World Map that isn't an airport.</li>\r\n \t<li>Choose the Set As Departure option from the pop-up menu shown in the figure below.</li>\r\n \t<li>Press the Fly button in the lower right of the screen to start your flight.</li>\r\n</ol>\r\n[caption id=\"attachment_297828\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297828\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-departure-point.jpg\" alt=\"Flight simulator screenshot showing how to choose a departure point for a start in midair\" width=\"630\" height=\"384\" /> ©Microsoft<br />Choosing a departure point for starting a flight in midair[/caption]\r\n\r\nWhen you complete these steps, you can begin your journey at around 1,500 feet in the air.\r\n<h2 id=\"tab2\" >Find animals quickly</h2>\r\nHow do you find animals so that you can get up close and personal? You can actually seek them out in a very simple way, and it only takes a few seconds. Follow these steps to get all the animal experiences you crave:\r\n<ol>\r\n \t<li>Go to the World Map.</li>\r\n \t<li>Type the word \"fauna\" in the search bar (found on the left side of the screen) and click the Search icon.</li>\r\n \t<li>Click to choose your next destination from the list of locations that feature animals.</li>\r\n \t<li>After you start your flight and you’re on your way to the chosen destination, access the Pause menu by pressing Escape or the Menu button.</li>\r\n \t<li>Click the Assistance tab.</li>\r\n \t<li>Click the Navigation menu and find the Fauna Markers option.</li>\r\n \t<li>Click to toggle on the option.</li>\r\n</ol>\r\nMarkers appear on the map to show where you can find animals along your route. You need to decide which animals you want to find, but with Fauna Markers turned on, this decision becomes less of a headache.\r\n<h2 id=\"tab3\" >Refuel your aircraft anywhere</h2>\r\nIn Flight Simulator, you can refuel while flying without missing a beat. You just need to change your keybindings (options that are tied to a specific input device key or key combination), but that change doesn't take very long. Just follow these steps:\r\n<ol>\r\n \t<li>Access the Pause Menu and click the Controls tab.</li>\r\n \t<li>In the Controls Options window that appears (see below), choose the input type that you’re using. You can choose from Keyboard, Mouse, or Controller.</li>\r\n \t<li>Scroll down the resulting list of options and select the Repair and Refuel keybinding option. If you don’t want to scroll, you can type Repair and Refuel in the search bar in the left column of the Controls Options window, as shown in the figure below.</li>\r\n \t<li>Choose a key on your input device to which you want to bind the Repair and Refuel option.</li>\r\n \t<li>Press escape or the Menu button to exit the Pause menu screen.</li>\r\n</ol>\r\n[caption id=\"attachment_297826\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297826\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-keybinding.jpg\" alt=\"Flight Simulator screenshot showing how to searching for the Repair and Refuel option for keybinding\" width=\"630\" height=\"276\" /> ©Microsoft<br />Searching for the Repair and Refuel option for keybinding[/caption]\r\n\r\nAfter you follow the preceding steps, you should still be in midair. You can press the key you just selected to instantly repair any issues with your aircraft that might be plaguing you at present, as well as receive an automatic refueling. You don't need to do anything special after that. Your gas gauge should be full once more!\r\n<h2 id=\"tab4\" >Turn off satellite overlay</h2>\r\nYou can toggle on an instrument flight rules (IFR) view that may mitigate potential issues with locating landmarks. When you use IFR view, you get a plain gray map that makes it a lot easier to see things like distance between points at a glance.\r\n\r\nTo turn on IFR view in the World Map, follow these steps:\r\n<ol>\r\n \t<li>From the main screen open the World Map.</li>\r\n \t<li>Choose the Open Filters option that appears in the shortcut bar in the lower part of your screen. A window appears, as shown below, where you can scroll through filter options.</li>\r\n \t<li>Click the arrows to the left and right of the Background Map option to toggle the IFR option to replace Satellite.</li>\r\n</ol>\r\n[caption id=\"attachment_297829\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297829\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-IFR-view.jpg\" alt=\"Screenshot showing how to set IFR view\" width=\"630\" height=\"260\" /> ©Microsoft<br />Setting the World Map to IFR view[/caption]\r\n\r\nAfter following the preceding steps, you should have a better, more granular view of the Earth below.\r\n<h2 id=\"tab5\" >Explore outside the plane</h2>\r\nDid you know you can leave the plane in midair to look at the world around you? No, you aren't physically exiting the plane. But using a feature called <em>Active Pause,</em> you can take a look at your surroundings without having to land.\r\n\r\nActive Pause stops your plane right where it is, and you can explore your aircraft's cockpit, immediate surroundings in the air, or the entire world around you. Here's how to turn on Active Pause:\r\n<ol>\r\n \t<li>Press Escape or the Menu button to go to the Pause menu, click on options, and click on the Assistance menu, which is shown in the figure below.</li>\r\n \t<li>Look for the Play/Pause icon on the toolbar that appears when you hover the mouse near the top of your screen. This icon represents a toggle for Active Pause.</li>\r\n \t<li>Click the Play/Pause icon to activate the Active Pause play mode.</li>\r\n</ol>\r\n[caption id=\"attachment_297830\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297830\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-active-pause.jpg\" alt=\"Screenshot showing the Active Pause mode\" width=\"630\" height=\"384\" /> ©Microsoft<br />Using the Active Pause mode[/caption]\r\n\r\nToggling on the Active Pause mode activates a drone that you can maneuver using the standard aircraft controls on the keyboard or controller. You can explore to your heart's content without ruining your flight. And you don't even have to stop playing to do it!\r\n<h2 id=\"tab6\" >Explore the streets</h2>\r\nYou may be playing a flight sim, but you still have plenty of ways to interact with the world around you. The same drone that allows you to exit the cockpit and travel around the world (during an Active Pause; see the preceding section) enables you to travel down to the streets and have a look around.\r\n\r\nIt may take a bit of doing because your plane is fairly high up in the sky, but you absolutely can take your drone down to the streets (see below).\r\n\r\n[caption id=\"attachment_297827\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297827\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-street-view.jpg\" alt=\"Screenshot showing street view in Flight Simulator\" width=\"630\" height=\"355\" /> ©Microsoft<br />The street view in Flight Simulator[/caption]\r\n<h2 id=\"tab7\" >Speed up your flight</h2>\r\nYou can speed up the game's <em>sim rate</em> (the rate at which your flight proceeds along its route) in order to reach your destination more quickly. You can also fly to your endpoint more slowly if you want. You can adjust the sim rate up and down at your leisure.\r\n\r\n<strong>Follow these steps to adjust your game's sim rate if you’re playing on a PC:</strong>\r\n<ol>\r\n \t<li>Press the R key on your keyboard.</li>\r\n \t<li>Hold the CTRL key and press either the plus (+) key or the minus (–) key on the number pad. As I’m sure you can guess, pressing + speeds up the sim rate and pressing – slows it down.</li>\r\n</ol>\r\n<strong>Follow these steps to set your sim rate if you’re playing on a console:</strong>\r\n<ol>\r\n \t<li>Press Escape or the Menu button to go to the Pause menu, select Options, and select Controls Options. From the Controls Options screen, as shown below, you need to assign a button for the sim rate.</li>\r\n \t<li>Type the search term sim rate in the search box on the left side of the Controls Options window, and then click the Search icon.</li>\r\n \t<li>Click to select the Sim Rate option.</li>\r\n \t<li>When prompted, choose a key or console button when prompted that you want to bind to your Sim Rate option.</li>\r\n</ol>\r\n[caption id=\"attachment_297831\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297831\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-sim-rates.jpg\" alt=\"Screenshot showing how to bind a keyboard button to adjust sim rates\" width=\"630\" height=\"276\" /> ©Microsoft<br />Bind a keyboard button so you can adjust sim rates[/caption]\r\n\r\nAfter following the preceding steps, you can adjust the sim rate on your console easily:\r\n<ul>\r\n \t<li><strong>Slow down:</strong> Press your chosen button and the left trigger.</li>\r\n \t<li><strong>Speed up:</strong> Press your chosen button and the right trigger.</li>\r\n</ul>\r\nBy adjusting your sim rate, you can take those cross-country (or across-the-globe) flights in record time.\r\n<h2 id=\"tab8\" >Fast travel to flight phases</h2>\r\nIf you don't care much for the lengthy cruise phase of a flight, you might opt to skip it entirely. You can do that. Instead of actively flying through the entire trip, you can fast travel to a phase that's more appealing to you. To use the Travel To option, just follow these steps:\r\n<ol>\r\n \t<li>Press Escape or the Menu button to open your Pause menu.</li>\r\n \t<li>Click the Travel To button (which looks similar to a fast-forward button, as noted the figure below) to reveal your Travel To options. The Travel To window that appears lists the phases of your flight plan that you can choose from. The figure below shows Cruise, Descent, Approach, Final, and Taxi.</li>\r\n \t<li>Select the phase to which you want to fast travel.</li>\r\n</ol>\r\n[caption id=\"attachment_297834\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297834\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-fast-travel.jpg\" alt=\"Screenshot showing fast travel options\" width=\"630\" height=\"349\" /> ©Microsoft<br />Fast travel options[/caption]\r\n\r\nAfter you make your selection, your game skips to that phase. Hate taking off or cruising? Use this trick to skip past all of it!\r\n<h2 id=\"tab9\" >Customize your pilot avatar</h2>\r\nYou're more than just your plane in Flight Simulator. You have a pilot avatar, too! You might not see your avatar much while playing the game (your view is as the avatar in the cockpit), but you do have a character that represents you. Plus, you can change what your avatar looks like.\r\n\r\nTo customize your pilot avatar, follow these steps:\r\n<ol>\r\n \t<li>Press Escape or the Menu button to open the Pause menu.</li>\r\n \t<li>Click Options and then General.</li>\r\n \t<li>In the General Options window that appears, click the Misc tab on the left.</li>\r\n \t<li>Under Pilot Avatar Settings, repeatedly click the forward or backward arrow beside the Pilot Avatar to scroll through your options. You can choose from 24 different pilot models. Find the one that suits you. The models appear on the right side of the General Options window, as shown below.</li>\r\n \t<li>When you find the avatar that matches your mood today, select it by making your choices and leaving the Misc menu.</li>\r\n</ol>\r\n[caption id=\"attachment_297833\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297833\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-avatar.jpg\" alt=\"Screenshot showing pilot avatar options\" width=\"630\" height=\"276\" /> ©Microsoft<br />Pilot avatar options[/caption]\r\n\r\nNow you can have a pilot that (hopefully) better represents you in the virtual world!\r\n<h2 id=\"tab10\" >Change your ATC call sign</h2>\r\nYou can actually change your <em>call sign,</em> or title, that the air traffic control team uses to identify and address you over the radio. Follow these steps to customize your call sign:\r\n<ol>\r\n \t<li>Press Escape or the Menu button to go to the Pause menu.</li>\r\n \t<li>Select the correct option to go to the World Map.</li>\r\n \t<li>Choose ATC Options by clicking on your airplane in the upper left part of the screen, then select Customization from the menu on the left column.</li>\r\n \t<li>In the text box next to Call Sign (see below), type in your desired call sign. For example, perhaps you’d like to be known as 8675309. Choose a fun call sign, but don't be naughty. The game doesn’t recognize profanity, so keep it G-rated (or you may be banned from online play).</li>\r\n \t<li>Save your choice by leaving the menu and return to your game.</li>\r\n</ol>\r\n[caption id=\"attachment_297832\" align=\"alignnone\" width=\"630\"]<img class=\"size-full wp-image-297832\" src=\"https://www.dummies.com/wp-content/uploads/flight-simulator-change-call-sign.jpg\" alt=\"Screenshot showing how to customize your call sign\" width=\"630\" height=\"355\" /> ©Microsoft<br />Call sign customization window[/caption]\r\n\r\nAfter you complete the preceding steps, ATC calls you by your desired call sign.","blurb":"","authors":[{"authorId":35237,"name":"Brittany Vincent","slug":"brittany-vincent","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/35237"}}],"primaryCategoryTaxonomy":{"categoryId":33642,"title":"Microsoft Products","slug":"microsoft-products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[{"label":"Start in midair","target":"#tab1"},{"label":"Find animals quickly","target":"#tab2"},{"label":"Refuel your aircraft anywhere","target":"#tab3"},{"label":"Turn off satellite overlay","target":"#tab4"},{"label":"Explore outside the plane","target":"#tab5"},{"label":"Explore the streets","target":"#tab6"},{"label":"Speed up your flight","target":"#tab7"},{"label":"Fast travel to flight phases","target":"#tab8"},{"label":"Customize your pilot avatar","target":"#tab9"},{"label":"Change your ATC call sign","target":"#tab10"}],"relatedArticles":{"fromBook":[{"articleId":297842,"title":"How to Read Aircraft Instruments in Microsoft Flight Simulator","slug":"how-to-read-the-instruments-in-a-microsoft-flight-simulator-aircraft","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297842"}},{"articleId":297816,"title":"How To Play Microsoft Flight Simulator","slug":"what-you-need-to-play-microsoft-flight-simulator","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297816"}},{"articleId":297672,"title":"Microsoft Flight Simulator For Dummies Cheat Sheet","slug":"microsoft-flight-simulator-for-dummies","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297672"}}],"fromCategory":[{"articleId":297842,"title":"How to Read Aircraft Instruments in Microsoft Flight Simulator","slug":"how-to-read-the-instruments-in-a-microsoft-flight-simulator-aircraft","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297842"}},{"articleId":297816,"title":"How To Play Microsoft Flight Simulator","slug":"what-you-need-to-play-microsoft-flight-simulator","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297816"}},{"articleId":297672,"title":"Microsoft Flight Simulator For Dummies Cheat Sheet","slug":"microsoft-flight-simulator-for-dummies","categoryList":["technology","software","microsoft-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/297672"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":296845,"slug":"microsoft-flight-simulator-for-dummies","isbn":"9781119828457","categoryList":["technology","software","microsoft-products"],"amazon":{"default":"https://www.amazon.com/gp/product/1119828457/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119828457/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/1119828457-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119828457/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119828457/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/microsoft-flight-simulator-for-dummies-cover-9781119828457-203x255.jpg","width":203,"height":255},"title":"Microsoft Flight Simulator For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"","authors":[{"authorId":35237,"name":"Brittany Vincent","slug":"brittany-vincent","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/35237"}}],"_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;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119828457&quot;]}]\" id=\"du-slot-6411ddaea3954\"></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;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119828457&quot;]}]\" id=\"du-slot-6411ddaea46fe\"></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},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Explore","lifeExpectancy":"One year","lifeExpectancySetFrom":"2023-03-13T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":297824}],"_links":{"self":{"self":"https://dummies-api.dummies.com/v2/categories/33642/categoryArticles?sortField=time&sortOrder=1&size=10&offset=0"},"next":{"self":"https://dummies-api.dummies.com/v2/categories/33642/categoryArticles?sortField=time&sortOrder=1&size=10&offset=10"},"last":{"self":"https://dummies-api.dummies.com/v2/categories/33642/categoryArticles?sortField=time&sortOrder=1&size=10&offset=2393"}}},"objectTitle":"","status":"success","pageType":"article-category","objectId":"33642","page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{"categoriesFilter":[{"itemId":0,"itemName":"All Categories","count":2395},{"itemId":33643,"itemName":"Access","count":63},{"itemId":33644,"itemName":"Excel","count":1076},{"itemId":33652,"itemName":"General Microsoft","count":386},{"itemId":33642,"itemName":"Microsoft Products","count":4},{"itemId":33645,"itemName":"OneDrive","count":3},{"itemId":33646,"itemName":"Outlook","count":90},{"itemId":33647,"itemName":"PowerPoint","count":191},{"itemId":33648,"itemName":"Project","count":51},{"itemId":33649,"itemName":"SharePoint","count":165},{"itemId":33650,"itemName":"Teams","count":12},{"itemId":33651,"itemName":"Word","count":354}],"articleTypeFilter":[{"articleType":"All Types","count":2395},{"articleType":"Articles","count":1900},{"articleType":"Cheat Sheet","count":61},{"articleType":"Step by Step","count":407},{"articleType":"Videos","count":27}]},"filterDataLoadedStatus":"success","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2023-09-15T10:50:01+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"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":299891,"title":"For the College Bound","hasSubCategories":false,"url":"/collection/for-the-college-bound-299891"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":287569,"title":"For the Hopeless Romantic","hasSubCategories":false,"url":"/collection/for-the-hopeless-romantic-287569"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"ArticleCategory","path":"/category/articles/microsoft-products-33642/","hash":"","query":{},"params":{"category":"microsoft-products-33642"},"fullPath":"/category/articles/microsoft-products-33642/","meta":{"routeType":"category","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"sfmcState":{"status":"initial"},"profileState":{"auth":{},"userOptions":{},"status":"success"}}
Logo
  • Articles Open Article Categories
  • Books Open Book Categories
  • Collections Open Collections list
  • Custom Solutions

Article Categories

Book Categories

Collections

Explore all collections
BYOB (Be Your Own Boss)
Be a Rad Dad
Career Shifting
Contemplating the Cosmos
For Those Seeking Peace of Mind
For the Aspiring Aficionado
For the Budding Cannabis Enthusiast
For the College Bound
For the Exam-Season Crammer
For the Hopeless Romantic
Log In
  • Home
  • Technology Articles
  • Software Articles
  • Microsoft Products Articles

Microsoft Products Articles

Hundreds of how-tos and tips for Word, Excel, Access, SharePoint, Project, and all your other Microsoft favorites.

Browse By Category

Access

Excel

OneDrive

Outlook

PowerPoint

Project

SharePoint

Teams

Word

General Microsoft

Previous slideNext slide

Access

Excel

OneDrive

Outlook

PowerPoint

Project

SharePoint

Teams

Word

General Microsoft

Articles From Microsoft Products

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
page 41
page 42
page 43
page 44
page 45
page 46
page 47
page 48
page 49
page 50
page 51
page 52
page 53
page 54
page 55
page 56
page 57
page 58
page 59
page 60
page 61
page 62
page 63
page 64
page 65
page 66
page 67
page 68
page 69
page 70
page 71
page 72
page 73
page 74
page 75
page 76
page 77
page 78
page 79
page 80
page 81
page 82
page 83
page 84
page 85
page 86
page 87
page 88
page 89
page 90
page 91
page 92
page 93
page 94
page 95
page 96
page 97
page 98
page 99
page 100
page 101
page 102
page 103
page 104
page 105
page 106
page 107
page 108
page 109
page 110
page 111
page 112
page 113
page 114
page 115
page 116
page 117
page 118
page 119
page 120
page 121
page 122
page 123
page 124
page 125
page 126
page 127
page 128
page 129
page 130
page 131
page 132
page 133
page 134
page 135
page 136
page 137
page 138
page 139
page 140
page 141
page 142
page 143
page 144
page 145
page 146
page 147
page 148
page 149
page 150
page 151
page 152
page 153
page 154
page 155
page 156
page 157
page 158
page 159
page 160
page 161
page 162
page 163
page 164
page 165
page 166
page 167
page 168
page 169
page 170
page 171
page 172
page 173
page 174
page 175
page 176
page 177
page 178
page 179
page 180
page 181
page 182
page 183
page 184
page 185
page 186
page 187
page 188
page 189
page 190
page 191
page 192
page 193
page 194
page 195
page 196
page 197
page 198
page 199
page 200
page 201
page 202
page 203
page 204
page 205
page 206
page 207
page 208
page 209
page 210
page 211
page 212
page 213
page 214
page 215
page 216
page 217
page 218
page 219
page 220
page 221
page 222
page 223
page 224
page 225
page 226
page 227
page 228
page 229
page 230
page 231
page 232
page 233
page 234
page 235
page 236
page 237
page 238
page 239
page 240
page 241

Filter Results

2,403 results
2,403 results
Excel How to Insert and Delete Cells and Ranges

Article / Updated 08-28-2023

In Excel 2013, you can insert and delete individual cells or even ranges that don’t neatly correspond to entire rows or columns. When you do so, the surrounding cells shift. In the case of an insertion, cells move down or to the right of the area where the new cells are being inserted. In the case of a deletion, cells move up or to the left to fill in the voided space. Deleting a cell is different from clearing a cell’s content, and this becomes apparent when you start working with individual cells and ranges. When you clear the content, the cell itself remains. When you delete the cell itself, the adjacent cells shift. When shifting cells, Excel is smart enough that it tries to guess which direction you want existing content to move when you insert or delete cells. If you have content immediately to the right of a deleted cell, for example, Excel shifts it left. If you have content immediately below the deleted cell, Excel shifts it up. You can still override that, though, as needed. In the following exercise, you insert and delete cells. In the Lesson 5 Mortgage file from the preceding exercise, select A1:A6 and then choose Home→Delete. Excel guesses that you want to move the existing content to the left, and it does so. Click cell A1, and choose Home→Insert. Excel guesses that you want to move the existing content down, which is incorrect. The content in column B is off by one row, as shown in this figure. Press Ctrl+Z to undo the insertion; then from the Home tab, click the down arrow to the right of the Insert button and choose Insert Cells. The Insert dialog box opens, as shown. Select Shift Cells Right and then click OK. A new cell A1 is inserted, and the previous A1 content moves into B1. Save the changes to the workbook.

View Article
General Microsoft How to Use Wildcard Operators When Finding Stuff in Word 2016

Article / Updated 08-17-2023

Word 2016 permits you to use wildcard operators in searches. A wildcard operator is a character that represents characters in a search expression. Wildcards aren't for everybody. Using them requires a certain amount of expertise, but after you know how to use them, wildcards can be invaluable in searches and macros. The following table explains the wildcard operators that you can use in searches. Click the Use Wildcards check box if you want to search using wildcards. Wildcards for Searches Operator What It Finds Example ? Any single character b?t finds bat, bet, bit, and but. * Zero or more characters t*o finds to, two, and tattoo. [xyz] A specific character, x, y, or z t[aeiou]pper finds tapper, tipper, and topper. [x-z] A range of characters, x through z [1-4]000 finds 1000, 2000, 3000, and 4000, but not 5000. [!xy] Not the specific character or characters, xy p[!io]t finds pat and pet, but not pit or pot. < Characters at the beginning of words finds information, infomaniac, and infomercial. > Characters at the end of words ese> finds these, journalese, and legalese. @@ One or more instances of the previous character sho@@t finds shot and shoot. {n} Exactly n instances of the previous character sho{2}t finds shoot but not shot. {n,} At least n instances of the previous character ^p{3,} finds three or more paragraph breaks in a row, but not a single paragraph break or two paragraph breaks in a row. {n,m} From n to m instances of the previous character 10{2,4} finds 100, 1000, and 10000, but not 10 or 100000. You can't conduct a whole-word-only search with a wildcard. For example, a search for f*s not only finds fads and fits but also all text strings that begin with f and end with s, such as for the birds. Wildcard searches can yield many, many results and are sometimes useless. To search for an asterisk (*), question mark (?), or other character that serves as a wildcard search operator, place a backslash () before it in the text box.

View Article
Microsoft Products How to Play Microsoft Flight Simulator

Article / Updated 08-03-2023

Giving people a chance to fly without all the time, money, and risk that goes into actual piloting makes flight-simulator video games such a fun and rewarding experience. Microsoft Flight Simulator is currently the best of its kind for casual players and hardcore enthusiasts alike. Currently, you can purchase three different versions of Flight Simulator: the Standard, Deluxe, and Premium Deluxe editions. Differences among editions include the number and type of available airports and aircraft, and of course, the price. Even the Standard version of Flight Simulator includes around 37,000 airports! Other good news is that the game is largely the same across platforms (PC and Xbox series), so you won’t compromise the experience when it comes to choosing the platform you want to play on. What platforms can you use to play Microsoft Flight Simulator? Flight Simulator originally debuted as a PC-only title when it first released in August 2020. It also received a special virtual-reality version in December 2020, the first time any flight simulator had done so. Though it remained a PC exclusive title for some time, on July 27, 2021, Flight Simulator debuted on Xbox Series X and Xbox Series S. The game likely won’t be available on PlayStation 4, PlayStation 5, or Nintendo Switch in the near future, given that it’s a Microsoft-owned property. So, if you’re interested in playing, you need to have a PC or Xbox series platform. Here are a couple of thoughts for your platform choice: On an Xbox: You may find that picking up an Xbox console (if you don’t already have one) makes playing the game simpler. Flight Simulator is highly playable on Xbox consoles and may be more accessible for those who aren’t comfortable configuring PC games and software. On a PC: Flight Simulator can be quite demanding on computers that don’t have pricey gaming equipment. On the other hand, you can expect awesome graphics if you play on a gaming PC that has the latest and greatest graphic card and processor. Which version should you buy? Each version of Flight Simulator differs in scope of content, such as airplanes and airports. The versions (depicted below) are priced in tiers, and depending on the experience you want from the game, you can expect more or less content based on how much you’re willing to pay. Hey, becoming a pilot isn’t cheap! Here’s a quick reference guide to what each version contains: Standard Edition: The base version of the game. It comes with 20 different planes and 30 enhanced airports, and it retails for $59.99 (USD, 2023). Deluxe Edition: This version of the game comes with everything in the Standard Edition, plus five additional enhanced airports and five additional airplanes. It retails for $89.99 (USD, 2023). The enhanced airports included are: Amsterdam Airport Schiphol (Netherlands) Cairo International Airport (Egypt) Cape Town International Airport (South Africa) O’Hare International Airport (USA) Adolfo Suarez Madrid-Barajas Airport (Spain) The additional airplanes included are: Diamond Aircraft DA40-TDI Diamond Aircraft DV20 Textron Aviation Inc. Beechcraft Baron G58 Textron Aviation Inc. Cessna 152 Aerobat Textron Aviation Inc. Cessna 172 Skyhawk Premium Deluxe Edition: This version of the game comes with everything that the Deluxe Edition includes, as well as five more enhanced airports and another five airplanes. It retails for $119.99 (USD, 2023). The enhanced airports included are: Denver International Airport (USA) Dubai International Airport (UAE) Frankfurt Airport (Germany) Heathrow Airport (UK) San Francisco International Airport (USA) The additional planes included are: Boeing Company 787-10 Dreamliner Cirrus Aircraft SR22 Pipistrel Virus SW 121 Textron Aviation Inc. Cessna Citation Longitude Zlin Aviation Shock Ultra If you decide that you want to upgrade to the Deluxe or Premium Deluxe editions later on, you just have to pay the difference on the platform of your choice. You can download the additional content you were missing to the installation you already have. No pressure! Wait, what are enhanced airports? Don’t confuse the small number of enhanced airports in the different versions of the game with the total number of airports that you can fly out of (around 37,000). More enhanced airports come with the Deluxe and Premium Deluxe versions, which means you get adapted constructions of airports (for example, Chicago O’Hare) that are more true-to-life than what they’d normally be in-game. Game designers handcraft an enhanced airport from the ground up to look exactly like the locations in question; the standard, procedurally generated airports aren’t nearly as detailed. So, if you have a soft spot in your heart for the San Francisco International Airport, you might want to pick up the version of the game that includes its enhanced version so that you can see it just like it looks in your mind’s eye. The enhanced airports may end up making it a much more exciting game to jump into — and you want to get the most out of your money, of course! What do you need to get started? Depending on which version of Flight Simulator you plan on playing, the answer to what you need varies. For the most part, whether you’re playing on PC, Xbox Series X, or Xbox Series S, you need only a copy of the game, your platform of choice, and some type of input. Your input can be a mouse and keyboard, game controller (I recommend an Xbox controller if you have one), or flight stick. Obviously, you can find a wide variety of all these things. But if you want to use a controller, you can simply use the Xbox gamepad that comes with your Xbox Series X or Xbox Series S by default. Otherwise, you need your sense of adventure and a little patience. Rome wasn’t built in a day. You can’t earn your fictional pilot’s license in a day, either. You have a lot to learn, but don’t get discouraged. As with all things, practice makes perfect, and the more time you spend learning to fly, the more you retain. The more you retain, the better you perform. The better you perform, the more you want to fly. And then, before you know it, you might want to try your luck behind the controls of a real plane! You might want to; not me. I’m still a little too terrified. Heights are not my thing.

View Article
Microsoft Products How to Read Aircraft Instruments in Microsoft Flight Simulator

Article / Updated 08-03-2023

To successfully fly in Microsoft Flight Simulator, you need to know how to use the various instruments included in your cockpit. At first, getting to know and understand each instrument may seem confusing. But, with a little time and guidance, you can discover what every instrument does, as well as how to read it during flight. The instruments in Flight Simulator can tell you how fast you’re going (airspeed), how high up you are (altitude), and other vital information you need to know, such as the direction you’re flying (your current heading). Flight Simulator has two primary types of cockpits that you can become acquainted with: An analog cockpit relies on analog instruments that appear as dials and gauges and rely on mechanical measurements to display information. You need to know how to read the various needles and indicators that relay these measurements. A glass cockpit relies on multiple electronic panels to sift through and display important information to you digitally during flight. This means you’ll get a direct readout rather than you having to interpret analog dials and gauges. Reading analog instruments Many of the planes in Flight Simulator have analog cockpits, especially the older planes. In fact, many of the planes that you fly during the game’s tutorial lessons rely on analog instruments for vital information such as heading, altitude, and so on. For that reason alone, you need to know how to read analog instruments early on in your career with Flight Simulator. However, some planes are hybrids with a combination of analog and digital systems. For example, the Cessna 172 includes a digital radio and navigation system but uses analog gauges for nearly everything else. Coming to terms with the instruments in your aircraft is about identifying each panel — where it is and what it does. Although a cockpit may look daunting at first, knowing the basics of each instrument (position and function) can make your flights easier in the long run. Overall, the exact layout, functionality, and appearance of instruments may vary depending on your aircraft. However, several fundamental instrument types are in each cockpit, so get acquainted with them. For this example, I present the cockpit of a Cessna 152, as shown below. The callouts in the figure above correspond with some of the instruments in this list: Airspeed indicator: Displays your airspeed (how fast you’re traveling), measured in knots (which is one nautical mile per hour). Pay special attention to this instrument during flight because aircraft are very sensitive to speed. For example, unlike cars, which will just stop in one place if you run out of speed, an airplane will drop like a rock. This situation is obviously bad for the pilot. The white lines on the airspeed indicator signal that you can extend the flaps at those speeds. Remember that the higher the speed, the lower the tilt (using the rudders to pivot the plane up or down). The green line marks the speed range in which you can safely tilt the rudders at their full range of movement. The yellow range means you’re quickly approaching the limit of the plane’s structural strength. Attitude indicator: Shows the current orientation of the plane in space. You make use of this instrument when you have to fly based on your instruments to ensure your angle of approach does not exceed recommendations. The brown portion in this indicator signifies the ground, and the blue part indicates the sky. Altimeter: Shows you the current ceiling (meaning the maximum density altitude an aircraft can reach) in feet or meters. Keep in mind that the altimeter measures the elevation of your craft Above Sea Level (ASL). Just because you’re on the ground doesn’t mean that you have an altimeter value of zero. When your craft is on the ground, the altimeter shows a value of anywhere from a few hundred feet to several thousand feet, depending on the elevation above sea level of the airport you’re currently visiting. Before takeoff, tune the altimeter to the barometric pressure at the airport’s location. Throttle RPM meter: Shows you the current revolutions per minute (RPMs) of the plane’s engine. Flaps control: Controls the flaps on the rear of the wings. Essentially, you can adjust these mechanisms to provide more load-bearing force — allowing the plane to take off from a shorter distance — or keep the plane airborne at a low speed. Additionally, flaps may be used to slow down the plane. Fuel Mixture control: Regulates how much fuel is injected into the engine. You need to reduce or increase the ratio of fuel to air being injected, depending on the altitude and density of the air that you’re flying through. Throttle: The throttle is pretty self-explanatory; it’s essentially your gas pedal. It controls the amount of fuel and air that is being injected into the engine. The more open the throttle, the more power the engine produces. Unlike cars, which have a gearbox to transfer power to the wheels, airplanes are direct drive, which means an increase in throttle always manifests as a higher RPM. Pitch Trim: By far one of the most important mechanisms in the cockpit. When set correctly, it allows the plane to fly without the pilot having to continuously hold the steering bar (also called the yoke). You may need to make adjustments to the pitch trim (which maneuvers the aircraft elevators) constantly throughout the flight in order to maintain altitude or a steady climb or decent. Vertical Speed indicator: Showcases the current speed of ascent or descent. It measures your plane’s speed in feet per minute. This instrument never sticks rigidly in one place; expect it to fluctuate. When landing or ascending, the standard rate of speed on this instrument varies from plane to plane. Current Heading: Shows the aircraft’s current heading course throughout the flight. The heading is essentially the direction that the aircraft is traveling relative to the magnetic north. The cardinal headings include: North at 360 or 0 degrees East at 90 degrees South at 180 degrees West at 270 degrees The Current Heading indicator itself gets input from a gyroscope, so you can expect it to show the wrong direction when not calibrated properly. Unfortunately, it becomes misaligned by itself often, and you need to calibrate it throughout your flight by resetting it every 10 to 15 minutes and ensuring it lines up with your compass. Parking brake: The parking brake is exactly what it sounds like. Use it at every takeoff and taxi situation to avoid any issues with air traffic control. Remember, when your aircraft’s engine is on, it generates thrust, even at idle. If you don’t make sure your parking brake is on, you may look down to hit a switch and find you’re rolling along.

View Article
Excel How to Share Excel 2019 Workbooks Saved on Your OneDrive

Article / Updated 06-07-2023

To share Excel 2019 workbooks from your OneDrive, you follow these steps: Open the workbook file you want to share in Excel 2019 and then click the Share button at the far right of the row with the Ribbon. If you’ve not yet saved the workbook on your OneDrive, a Share dialog box appears inviting you to upload the workbook file to OneDrive. Once you have clicked the OneDrive button and the file is uploaded to the cloud, the Share dialog box changes into the Send Link dialog box (similar to the one shown in the figure) where you specify the people with whom to share the file. Begin typing the name or e-mail address of the first person with whom you want to share the workbook in the text box with the insertion point. When Excel finds a match to the person’s name in your Outlook address book or verifies the e-mail address you entered, click the button below this text box to add this recipient. (Optional) Click the Anyone with This Link Can Edit drop-down button to open the Link Settings dialog box where you can modify the people for whom the link works, deny editing privileges to those with whom you share the file, and/or set an expiration date after which the link is no longer operational before clicking the Apply button. By default, Excel 2019 creates a sharing link that enables anyone who can access the workbook file online access to the file even when they are not logged into Office 365 or OneDrive. To restrict access to only coworkers in your company who are logged into Office 365, click the People in <organization> option (where organization is the name of your company as in People in Mind Over Media, the name of my company). To restrict the file sharing to only those to whom you’ve given prior access to the workbook file or its folder on your SharePoint site, click the People with Existing Access option. To create a sharing link that only particular people can use, click the Specific People option before you click the Apply button. Then, in the Send Link dialog box, click the ellipsis (…) to the right of the Send Link title and click Manage Access on the drop-menu to open the Permissions dialog box where you select the names of the people with whom to share the workbook file before you click the back arrow button to return to the Send Link dialog box. By default, Excel allows the people with whom you share your workbooks to make editing changes to the workbook that are automatically saved on your OneDrive. If you want to restrict your recipients to reviewing the data without being able to make changes, be sure to click the Allow Editing check box to remove its check mark before you click Apply. If you wish to set an expiration date after which the sharing link is no longer operational, click the Set Expiration Date button to open the pop-up calendar where you select an expiration date by clicking it in the calendar. After selecting the expiration date, click somewhere in the dialog box to close the pop-up calendar and enter the date in the Link Settings dialog box. (Optional) Click the Add a Message text box and type any personal message that you want to incorporate as part of the e-mail with the generic invitation to share the file.By default, Excel creates a generic invitation. After adding all the recipients with whom you wish to share the workbook file in this manner, click the Send button in the Send Link pane.As soon as you click this Share button, Excel e-mails the invitation to share the workbook to each of the recipients. All the people with whom you share a workbook receive an e-mail message containing a hyperlink to the workbook on your OneDrive. When they follow this link (and sign into the site if this is required), a copy of the workbook opens on a new page in their default web browser using the Excel Online web app. If you’ve given the user permission to edit the file, the web app contains an Edit Workbook drop-down button. When the coworkers with whom you’ve shared the workbook click this button in Excel Online, they have a choice between choosing the Edit in Excel or Edit in Excel Online option from its drop-down menu. When the user chooses Edit in Excel, the workbook is downloaded and opened in his version of Excel. When the user chooses Edit in Excel Online, the browser opens the workbook in a new version of the Excel Online, containing Home, Insert, Data, Review, and View tabs, each with a more limited set of command options than Excel 2019, which you can use in making any necessary changes and which are automatically saved to workbook on the OneDrive when you close Excel Online. While sharing a workbook with the default Anyone Can Edit option, all changes made by the people with whom you’ve shared the workbook are automatically saved by the AutoSave feature. If you happen to have the workbook open in Excel 2019 on your computer with the same worksheet displayed, their editing changes automatically appear in your worksheet (in as close to real time as the speed of your Internet access provides). Likewise, all the editing changes that you make to the workbook in Excel 2019 are automatically updated in their workbooks in Excel Online. Microsoft refers to this process as co-authoring. If a questionable editing change appears in your worksheet when co-authoring with a coworker, add a comment to the cell containing the edit-in-question (Review-->New Comment) that communicates your reservations about the change they made. A small balloon then appears above the cell where you made the comment in the user’s worksheet in Excel Online. When the coworker clicks this balloon, Excel Online displays the text of your comment calling into question their edit in a Comments task pane. They can then reply to your reservations by typing their explanation for the change in the same comment in this task pane and then updating it in your workbook by clicking the Post button or they can just go ahead and make any necessary updates reflecting your reservations directly in the worksheet in Excel Online.

View Article
Excel Some Excel Worksheet Functions for Statistical Analysis

Article / Updated 06-07-2023

Excel can help you make all sorts of calculations. Here's a selection of Excel's statistical worksheet functions. Each one returns a value into a selected cell. Check out these functions for central tendency and variability. Function What it calculates AVERAGE Mean of a set of numbers AVERAGEIF Mean of a set of numbers that meet a condition AVERAGEIFS Mean of a set of numbers that meet one or more conditions HARMEAN Harmonic mean of a set of positive numbers GEOMEAN Geometric mean of a set of positive numbers MODE.SNGL Mode of a set of numbers MEDIAN Median of a set of numbers VAR.P Variance of a set of numbers considered to be a population VAR.S Variance of a set of numbers considered to be a sample STDEV.P Standard deviation of a set of numbers considered to be a population STDEV.S Standard deviation of a set of numbers considered to be a sample STANDARDIZE A standard score based on a given mean and standard deviation These handy functions for relative standing can also be very useful. Function What it calculates RANK.EQ Rank of a number in a set of numbers. If more than one number has the same rank, it returns the top rank of those numbers. RANK.AVG Rank of a number in a set of numbers. If more than one number has the same rank, it returns their average. PERCENTRANK.INC Rank of a number in a set of numbers, expressed as a percent of the numbers it's greater than or equal to. PERCENTRANT.EXC Rank of a number in a set of numbers, expressed as a percent of the numbers it's greater than. PERCENTILE.INC The indicated percentile in a set of numbers, in terms of "greater than or equal to." PERCENTILE.EXC The indicated percentile in a set of numbers, in terms of "greater than." QUARTILE.INC The 1st, 2nd, 3rd, or 4th quartile of a set of numbers, in terms of "greater than or equal to." QUARTILE.EXC The 1st, 2nd, 3rd, or 4th quartile of a set of numbers, in terms of "greater than." These functions for correlation and regression are also good ones to know. Function What it Calculates CORREL Correlation coefficient between two sets of numbers PEARSON Same as CORREL. (Go figure!) RSQ Coefficient of determination between two sets of numbers (square of the correlation coefficient) SLOPE Slope of a regression line through two sets of numbers INTERCEPT Intercept of a regression line through two sets of numbers STEYX Standard error of estimate for a regression line through two sets of numbers

View Article
PowerPoint How To Hyperlink Between Slides in PowerPoint 2016

Step by Step / Updated 06-05-2023

In PowerPoint 2016, a hyperlink is simply a bit of text or a graphic image that you can click when viewing a slide to summon another slide, another presentation, or perhaps some other type of document, such as a Word document or an Excel spreadsheet. The hyperlink may also lead to a page on the web. Adding a hyperlink to a presentation is easy. Just follow these steps:

View Step by Step
PowerPoint Applying Artistic Effects in PowerPoint 2013

Article / Updated 04-17-2023

The Artistic Effects command in PowerPoint 2013 applies one of several special filters to your picture in an effort to make the picture look like it was created by an artist rather than photographed with a $60 digital camera. Depending on the nature of the original picture, the results may or may not be convincing; the only way to find out is to try. Here is a list of the artistic effects that are available on the Artistic Effects button: Marker Pencil Grayscale Pencil Sketch Line Drawing Chalk Sketch Paint Strokes Paint Brush Glow Diffused Blur Light Screen Watercolor Sponge Film Grain Mosaic Bubbles Glass Cement Texturizer Crisscross Etching Pastels Smooth Plastic Wrap Cutout Photocopy Glow Edges To apply one of these effects, simply double-click the picture, click the Artistic Effects button on the Picture Tools Format tab, and choose the effect you want from the gallery. To give you an idea of what these effects can accomplish, this figure shows how a photograph appears with the Pencil Sketch, Watercolor Sponge, and Plastic Wrap filters applied.

View Article
General Microsoft Shortcuts in Word, Excel, and PowerPoint 2016

Article / Updated 04-14-2023

By touching a couple of keys in combination in Office 2016 programs, you can save time with simple tasks, 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 2016. Both mouse and keyboard methods are provided here. To do this With the mouse With the keyboard Open a file File→Open Ctrl+O Create a new file File→New Ctrl+N Print active document File→Print Ctrl+P Save your work (first time), or resave with same settings File→Save Ctrl+S Save your work with different name, location, or type File→Save As F12 Copy selection to Clipboard Home→ Copy Ctrl+C Cut selection to Clipboard Home→ Cut Ctrl+X Paste selection to Clipboard Home→ Paste Ctrl+V Open the Paste Special dialog box Home→Paste→Paste Special Ctrl+Shift+V Display shortcut menu for selected item Right-click item Shift+F10 Left-align a paragraph Home→ Left Align Ctrl+L Center a paragraph Home→ Center Ctrl+E Right-align a paragraph Home→ Right Align Ctrl+R Make text bold Home→ Bold Ctrl+B Make text italicized Home→ Italic Ctrl+I Make text underlined Home→Underline Ctrl+U Make text larger Home→Increase Font Size Ctrl+> Make text smaller Home→Decrease Font Size Ctrl+< Undo previous action Undo button on Quick Access toolbar Ctrl+Z Redo previous Undo Redo button on Quick Access toolbar Ctrl+Y Insert hyperlink Insert→Hyperlink Ctrl+K Get help Type in Tellme what you want to do box F1 Close the active file File→Close Ctrl+F4 Close the application Close button on application window Alt+F4 Check spelling Review→Spelling F7

View Article
Microsoft Products 10 Tips for Microsoft Flight Simulator Beginners

Article / Updated 03-15-2023

Like real-world flying, Microsoft Flight Simulator 2020 has a seemingly never-ending bag of tricks. Despite being an incredibly realistic sim, don’t forget that Flight Simulator is also a game — and there are always secrets and hints in games. These tips can make hopping into the cockpit and exploring the virtual world a little easier for beginners — and maybe even a bit more fun, too! Even a seasoned Flight Simulator veteran might find these tricks worth retaining, especially if you plan to play the game for many moons to come. For more information related to these tips, check out my book Microsoft Flight Simulator For Dummies. Start in midair Did you know you can completely skip the takeoff sequence? It's true, and you may prefer starting in midair if you want to (initially) avoid what can be a lengthy learning experience. To start your flights already in midair, follow these steps: Go to the World Map. Left-click or press A anywhere on the World Map that isn't an airport. Choose the Set As Departure option from the pop-up menu shown in the figure below. Press the Fly button in the lower right of the screen to start your flight. When you complete these steps, you can begin your journey at around 1,500 feet in the air. Find animals quickly How do you find animals so that you can get up close and personal? You can actually seek them out in a very simple way, and it only takes a few seconds. Follow these steps to get all the animal experiences you crave: Go to the World Map. Type the word "fauna" in the search bar (found on the left side of the screen) and click the Search icon. Click to choose your next destination from the list of locations that feature animals. After you start your flight and you’re on your way to the chosen destination, access the Pause menu by pressing Escape or the Menu button. Click the Assistance tab. Click the Navigation menu and find the Fauna Markers option. Click to toggle on the option. Markers appear on the map to show where you can find animals along your route. You need to decide which animals you want to find, but with Fauna Markers turned on, this decision becomes less of a headache. Refuel your aircraft anywhere In Flight Simulator, you can refuel while flying without missing a beat. You just need to change your keybindings (options that are tied to a specific input device key or key combination), but that change doesn't take very long. Just follow these steps: Access the Pause Menu and click the Controls tab. In the Controls Options window that appears (see below), choose the input type that you’re using. You can choose from Keyboard, Mouse, or Controller. Scroll down the resulting list of options and select the Repair and Refuel keybinding option. If you don’t want to scroll, you can type Repair and Refuel in the search bar in the left column of the Controls Options window, as shown in the figure below. Choose a key on your input device to which you want to bind the Repair and Refuel option. Press escape or the Menu button to exit the Pause menu screen. After you follow the preceding steps, you should still be in midair. You can press the key you just selected to instantly repair any issues with your aircraft that might be plaguing you at present, as well as receive an automatic refueling. You don't need to do anything special after that. Your gas gauge should be full once more! Turn off satellite overlay You can toggle on an instrument flight rules (IFR) view that may mitigate potential issues with locating landmarks. When you use IFR view, you get a plain gray map that makes it a lot easier to see things like distance between points at a glance. To turn on IFR view in the World Map, follow these steps: From the main screen open the World Map. Choose the Open Filters option that appears in the shortcut bar in the lower part of your screen. A window appears, as shown below, where you can scroll through filter options. Click the arrows to the left and right of the Background Map option to toggle the IFR option to replace Satellite. After following the preceding steps, you should have a better, more granular view of the Earth below. Explore outside the plane Did you know you can leave the plane in midair to look at the world around you? No, you aren't physically exiting the plane. But using a feature called Active Pause, you can take a look at your surroundings without having to land. Active Pause stops your plane right where it is, and you can explore your aircraft's cockpit, immediate surroundings in the air, or the entire world around you. Here's how to turn on Active Pause: Press Escape or the Menu button to go to the Pause menu, click on options, and click on the Assistance menu, which is shown in the figure below. Look for the Play/Pause icon on the toolbar that appears when you hover the mouse near the top of your screen. This icon represents a toggle for Active Pause. Click the Play/Pause icon to activate the Active Pause play mode. Toggling on the Active Pause mode activates a drone that you can maneuver using the standard aircraft controls on the keyboard or controller. You can explore to your heart's content without ruining your flight. And you don't even have to stop playing to do it! Explore the streets You may be playing a flight sim, but you still have plenty of ways to interact with the world around you. The same drone that allows you to exit the cockpit and travel around the world (during an Active Pause; see the preceding section) enables you to travel down to the streets and have a look around. It may take a bit of doing because your plane is fairly high up in the sky, but you absolutely can take your drone down to the streets (see below). Speed up your flight You can speed up the game's sim rate (the rate at which your flight proceeds along its route) in order to reach your destination more quickly. You can also fly to your endpoint more slowly if you want. You can adjust the sim rate up and down at your leisure. Follow these steps to adjust your game's sim rate if you’re playing on a PC: Press the R key on your keyboard. Hold the CTRL key and press either the plus (+) key or the minus (–) key on the number pad. As I’m sure you can guess, pressing + speeds up the sim rate and pressing – slows it down. Follow these steps to set your sim rate if you’re playing on a console: Press Escape or the Menu button to go to the Pause menu, select Options, and select Controls Options. From the Controls Options screen, as shown below, you need to assign a button for the sim rate. Type the search term sim rate in the search box on the left side of the Controls Options window, and then click the Search icon. Click to select the Sim Rate option. When prompted, choose a key or console button when prompted that you want to bind to your Sim Rate option. After following the preceding steps, you can adjust the sim rate on your console easily: Slow down: Press your chosen button and the left trigger. Speed up: Press your chosen button and the right trigger. By adjusting your sim rate, you can take those cross-country (or across-the-globe) flights in record time. Fast travel to flight phases If you don't care much for the lengthy cruise phase of a flight, you might opt to skip it entirely. You can do that. Instead of actively flying through the entire trip, you can fast travel to a phase that's more appealing to you. To use the Travel To option, just follow these steps: Press Escape or the Menu button to open your Pause menu. Click the Travel To button (which looks similar to a fast-forward button, as noted the figure below) to reveal your Travel To options. The Travel To window that appears lists the phases of your flight plan that you can choose from. The figure below shows Cruise, Descent, Approach, Final, and Taxi. Select the phase to which you want to fast travel. After you make your selection, your game skips to that phase. Hate taking off or cruising? Use this trick to skip past all of it! Customize your pilot avatar You're more than just your plane in Flight Simulator. You have a pilot avatar, too! You might not see your avatar much while playing the game (your view is as the avatar in the cockpit), but you do have a character that represents you. Plus, you can change what your avatar looks like. To customize your pilot avatar, follow these steps: Press Escape or the Menu button to open the Pause menu. Click Options and then General. In the General Options window that appears, click the Misc tab on the left. Under Pilot Avatar Settings, repeatedly click the forward or backward arrow beside the Pilot Avatar to scroll through your options. You can choose from 24 different pilot models. Find the one that suits you. The models appear on the right side of the General Options window, as shown below. When you find the avatar that matches your mood today, select it by making your choices and leaving the Misc menu. Now you can have a pilot that (hopefully) better represents you in the virtual world! Change your ATC call sign You can actually change your call sign, or title, that the air traffic control team uses to identify and address you over the radio. Follow these steps to customize your call sign: Press Escape or the Menu button to go to the Pause menu. Select the correct option to go to the World Map. Choose ATC Options by clicking on your airplane in the upper left part of the screen, then select Customization from the menu on the left column. In the text box next to Call Sign (see below), type in your desired call sign. For example, perhaps you’d like to be known as 8675309. Choose a fun call sign, but don't be naughty. The game doesn’t recognize profanity, so keep it G-rated (or you may be banned from online play). Save your choice by leaving the menu and return to your game. After you complete the preceding steps, ATC calls you by your desired call sign.

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
page 41
page 42
page 43
page 44
page 45
page 46
page 47
page 48
page 49
page 50
page 51
page 52
page 53
page 54
page 55
page 56
page 57
page 58
page 59
page 60
page 61
page 62
page 63
page 64
page 65
page 66
page 67
page 68
page 69
page 70
page 71
page 72
page 73
page 74
page 75
page 76
page 77
page 78
page 79
page 80
page 81
page 82
page 83
page 84
page 85
page 86
page 87
page 88
page 89
page 90
page 91
page 92
page 93
page 94
page 95
page 96
page 97
page 98
page 99
page 100
page 101
page 102
page 103
page 104
page 105
page 106
page 107
page 108
page 109
page 110
page 111
page 112
page 113
page 114
page 115
page 116
page 117
page 118
page 119
page 120
page 121
page 122
page 123
page 124
page 125
page 126
page 127
page 128
page 129
page 130
page 131
page 132
page 133
page 134
page 135
page 136
page 137
page 138
page 139
page 140
page 141
page 142
page 143
page 144
page 145
page 146
page 147
page 148
page 149
page 150
page 151
page 152
page 153
page 154
page 155
page 156
page 157
page 158
page 159
page 160
page 161
page 162
page 163
page 164
page 165
page 166
page 167
page 168
page 169
page 170
page 171
page 172
page 173
page 174
page 175
page 176
page 177
page 178
page 179
page 180
page 181
page 182
page 183
page 184
page 185
page 186
page 187
page 188
page 189
page 190
page 191
page 192
page 193
page 194
page 195
page 196
page 197
page 198
page 199
page 200
page 201
page 202
page 203
page 204
page 205
page 206
page 207
page 208
page 209
page 210
page 211
page 212
page 213
page 214
page 215
page 216
page 217
page 218
page 219
page 220
page 221
page 222
page 223
page 224
page 225
page 226
page 227
page 228
page 229
page 230
page 231
page 232
page 233
page 234
page 235
page 236
page 237
page 238
page 239
page 240
page 241

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