{"id":168611,"date":"2021-05-31T10:20:09","date_gmt":"2021-05-31T08:20:09","guid":{"rendered":"http:\/\/sftarticles.wpenginepowered.com\/en\/?p=168611"},"modified":"2025-07-01T21:05:24","modified_gmt":"2025-07-02T04:05:24","slug":"how-to-use-microsoft-excel-formulas-in-3-simple-steps","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/en\/how-to-use-microsoft-excel-formulas-in-3-simple-steps\/","title":{"rendered":"How to Use Microsoft Excel Formulas in 3 Simple Steps"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Have you started working in Microsoft Excel? If you have, then formulas might still seem a little intimidating to you, but they are actually very useful and if you keep a few simple things in mind, can even be easy to use. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Excel is very useful for storing, manipulating, and presenting various forms of data on your <a href=\"https:\/\/microsoft-excel.en.softonic.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Windows<\/a> or <a href=\"https:\/\/microsoft-excel-2011.en.softonic.com\/mac\" target=\"_blank\" rel=\"noreferrer noopener\">Mac <\/a>computer. Excel has a useful formula wizard that can assist you in using various functions.<\/p>\n\n\n<div class=\"howto_container schema-howto-acf-block\"><ol><li><div class=\"howto_item\"><h2>Access the Formula Wizard<\/h2><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2021\/05\/How-to-Use-Microsoft-Excel-Formulas-1.jpg\" alt=\"How to Use Microsoft Excel Formulas\" width=\"228\" height=\"79\"><p><span style=\"font-weight: 400;\">When you are in your spreadsheet, click on the <\/span><span style=\"font-weight: 400;\">cell<\/span><span style=\"font-weight: 400;\"> you want to enter the <\/span><span style=\"font-weight: 400;\">formula<\/span><span style=\"font-weight: 400;\"> into and type =. <\/span><span style=\"font-weight: 400;\">Formulas<\/span><span style=\"font-weight: 400;\"> always start with a =. Next click on the <\/span><span style=\"font-weight: 400;\">formula<\/span><span style=\"font-weight: 400;\"> icon in the top bar represented by the <\/span><i><span style=\"font-weight: 400;\">fx<\/span><\/i><span style=\"font-weight: 400;\"> symbol.<\/span><\/p>\n<\/div><\/li><li><div class=\"howto_item\"><h2>Choose the Formula<\/h2><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2021\/05\/How-to-Use-Microsoft-Excel-Formulas-2.jpg\" alt=\"How to Use Microsoft Excel Formulas\" width=\"427\" height=\"374\"><p><span style=\"font-weight: 400;\">The next window will show the available <\/span><span style=\"font-weight: 400;\">functions<\/span><span style=\"font-weight: 400;\">. You can choose your <\/span><span style=\"font-weight: 400;\">formula<\/span><span style=\"font-weight: 400;\"> from the list if you already know what it is, or you can type the description into the box and see which <\/span><span style=\"font-weight: 400;\">formula<\/span> <span style=\"font-weight: 400;\">Excel<\/span><span style=\"font-weight: 400;\"> recommends.<\/span><\/p>\n<\/div><\/li><li><div class=\"howto_item\"><h2>Insert Function Arguments<\/h2><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2021\/05\/How-to-Use-Microsoft-Excel-Formulas-3.jpg\" alt=\"How to Use Microsoft Excel Formulas\" width=\"512\" height=\"271\"><p><span style=\"font-weight: 400;\">You will be taken to a new window, sometimes called the <\/span><span style=\"font-weight: 400;\">formula<\/span><span style=\"font-weight: 400;\"> palette, where you have to input the data from your spreadsheet. The wizard tells you what information needs to be inserted.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">&#8211; Next to the argument click on the grid icon with the red arrow to be taken to your spreadsheet.<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Select the data from the <\/span><span style=\"font-weight: 400;\">cells<\/span><span style=\"font-weight: 400;\"> in your spreadsheet.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">The formula palette will show you a description of the <\/span><span style=\"font-weight: 400;\">formula<\/span><span style=\"font-weight: 400;\"> in the window, as well as an <\/span><span style=\"font-weight: 400;\">example<\/span><span style=\"font-weight: 400;\"> of the formula and the result at the bottom so that you can check your information easily.<\/span><\/p>\n<\/div><\/li><\/ol><\/div><style type=\"text\/css\">\n\t.howto_container {\n\t  margin: 0 auto;\n\t}\n\t.howto_container img {\n\t\theight: 100%;\n\t\tmargin-bottom: 30px;\n\t}\n\t\n\t\t  .howto_container h2 {\n\t\t\t  clear: none !important;\n\t\t  }\n\t\t  .howto_container ol {\n\t\t\t  list-style: none !important;\n\t\t  }\t\n\t.howto_container ol li::before {\n\t\tcolor: #ffffff !important;\n\t\tbackground:#0073aa !important;\n\t}\n<\/style>\n\n\t\t\n\n\n<h2 class=\"wp-block-heading\"><strong>Use Formulas Confidently<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">By using the formula wizard in Excel you can learn to use formulas right from the start with a good helping hand. Soon you\u2019ll be using the formulas without even needing the wizard.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you started working in Microsoft Excel? If you have, then formulas might still seem a little intimidating to you, but they are actually very useful and if you keep a few simple things in mind, can even be easy to use. Excel is very useful for storing, manipulating, and presenting various forms of data &hellip; <a href=\"https:\/\/cms-articles.softonic.io\/en\/how-to-use-microsoft-excel-formulas-in-3-simple-steps\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;How to Use Microsoft Excel Formulas in 3 Simple Steps&#8221;<\/span><\/a><\/p>\n","protected":false},"author":9205,"featured_media":181480,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","wpcf-pageviews":0},"categories":[2441],"tags":[2523],"usertag":[],"vertical":[],"content-category":[],"class_list":["post-168611","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to","tag-app-subdomain-redirectionmicrosoft-excel"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/168611","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/users\/9205"}],"replies":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/comments?post=168611"}],"version-history":[{"count":1,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/168611\/revisions"}],"predecessor-version":[{"id":324761,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/168611\/revisions\/324761"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media\/181480"}],"wp:attachment":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media?parent=168611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/categories?post=168611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/tags?post=168611"},{"taxonomy":"usertag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/usertag?post=168611"},{"taxonomy":"vertical","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/vertical?post=168611"},{"taxonomy":"content-category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/content-category?post=168611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}