{"id":116,"date":"2024-05-02T16:12:38","date_gmt":"2024-05-02T16:12:38","guid":{"rendered":"https:\/\/myallcodes.in\/?p=116"},"modified":"2025-03-04T07:26:13","modified_gmt":"2025-03-04T07:26:13","slug":"microsoft-excel","status":"publish","type":"post","link":"https:\/\/myallcodes.in\/index.php\/2024\/05\/02\/microsoft-excel\/","title":{"rendered":"Learn Advance Microsoft Excel"},"content":{"rendered":"\n<p>What is Microsoft Excel :<\/p>\n\n\n\n<p>Excel is a powerful tool to store our data and get the desired information using its inbuilt formula\u2019s.<\/p>\n\n\n\n<p>Let\u2019s start the work on Excel as a beginner and will finish it by an advance excel user.<\/p>\n\n\n\n<p>Best of Luck..<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>First we need to install the Microsoft office from the official Microsoft website &#8211; <a href=\"https:\/\/www.microsoft.com\/en-in\/download\/office.aspx\">https:\/\/www.microsoft.com\/en-in\/download\/office.aspx<\/a><\/li>\n\n\n\n<li>These days Microsoft office is called Microsoft 365 which facilitates us with cloud solution also.<\/li>\n\n\n\n<li>After sign up we can use the cloud version of Microsoft 365 and can download the offline setup also.<\/li>\n\n\n\n<li>After installation of Office setup we can use the Excel.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Let\u2019s start with basic Formulas \u2013<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Sum<\/strong>&nbsp;\u2013 &nbsp;We can sum multiple values in Microsoft Excel, Let\u2019s take an example to understand it :<\/li>\n<\/ul>\n\n\n\n<p>If i want to sum my all sales values during the dates 1-1-2024 to 10-1-2024 then we can use this formula :<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>=SUM(B2:B11)<\/p>\n\n\n\n<p>Here in this example i am putting dates in \u201cA\u201d Column and Sales value in \u201cB\u201d Column<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"448\" height=\"361\" src=\"https:\/\/myallcodes.in\/wp-content\/uploads\/2024\/05\/sum-forumula-1-1.jpg\" alt=\"\" class=\"wp-image-127\" srcset=\"https:\/\/myallcodes.in\/wp-content\/uploads\/2024\/05\/sum-forumula-1-1.jpg 448w, https:\/\/myallcodes.in\/wp-content\/uploads\/2024\/05\/sum-forumula-1-1-300x242.jpg 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/figure>\n<\/blockquote>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li> <strong>Just like &#8220;Sum&#8221; formula we can use some more basic formula&#8217;s in Excel such as Average, Max, Min.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"171\" height=\"197\" src=\"https:\/\/myallcodes.in\/wp-content\/uploads\/2024\/05\/all-basic-forumula-1-1.jpg\" alt=\"\" class=\"wp-image-135\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"># Now we should go ahead and learn about the most importent and valuable tool of Microsoft Excel &#8211; Sort &amp; Filter<\/h2>\n\n\n\n<p>We can use this tool when we need to works on raw and huge data because it helps to save our time and efforts. Let&#8217;s take an example and understand that how it works :<br>If we are having huge amount of data i.e. so many fruits name and we want to work on specific data then we can use this both options Sort and Filter, If we are having fruits name in column &#8220;P&#8221; and i want to work on only Apple or Papaya then i can use the &#8220;<strong>Filter<\/strong>&#8221; Option and if want to sort out the fruits from low to high cost then i can use the &#8220;<strong>Sort<\/strong>&#8221; Option. Now let&#8217;s think that i&#8217;ll work manually on this data to do this without these tools then how much time will it take ? <\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"835\" height=\"552\" data-id=\"143\" src=\"https:\/\/myallcodes.in\/wp-content\/uploads\/2024\/05\/Sort-and-filter.gif\" alt=\"\" class=\"wp-image-143\"\/><\/figure>\n<\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"># Now we will learn about &#8211; Find and Select<\/h2>\n\n\n\n<p>If we are working on huge data and need to find any specific word then we can use these options to find that word quickly, Let&#8217;s suppose we need to find out &#8220;Orange&#8221; and &#8220;Papaya&#8221; then we will select the option &#8220;Find&#8221; and type the word &#8220;Apple&#8221; and then &#8220;Papaya&#8221; <br>If we need to replace any specific word then we can use &#8220;Replace&#8221; option, For example if i need to replace the word &#8220;Papaya&#8221; to &#8220;Papaya 1&#8221; and &#8220;Orange&#8221; to &#8220;Papaya&#8221; then instead of doing one by one i can replace all in one click or can select the cells in which i want to replace the word.<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"596\" data-id=\"189\" src=\"https:\/\/myallcodes.in\/wp-content\/uploads\/2024\/06\/Find-and-select-6.gif\" alt=\"\" class=\"wp-image-189\"\/><\/figure>\n<\/figure>\n","protected":false},"excerpt":{"rendered":"<p>What is Microsoft Excel : Excel is a powerful tool to store our data and get the desired information using its inbuilt formula\u2019s. Let\u2019s start the work on Excel as a beginner and will finish it by an advance excel user. Best of Luck.. Let\u2019s start with basic Formulas \u2013 If i want to sum\u2026 <span class=\"read-more\"><a href=\"https:\/\/myallcodes.in\/index.php\/2024\/05\/02\/microsoft-excel\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[25],"tags":[],"class_list":["post-116","post","type-post","status-publish","format-standard","hentry","category-miscellaneous"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/posts\/116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/comments?post=116"}],"version-history":[{"count":11,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/posts\/116\/revisions"}],"predecessor-version":[{"id":191,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/posts\/116\/revisions\/191"}],"wp:attachment":[{"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/media?parent=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/categories?post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/tags?post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}