{"id":6463,"date":"2017-06-08T12:37:51","date_gmt":"2017-06-08T10:37:51","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6463"},"modified":"2024-02-06T15:59:09","modified_gmt":"2024-02-06T14:59:09","slug":"5-1-reasons-you-should-use-excels-quick-analysis-option","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/5-1-reasons-you-should-use-excels-quick-analysis-option\/","title":{"rendered":"5 + 1 Reasons You Should Use Excel\u2019s Quick Analysis Option"},"content":{"rendered":"<p>In Excel (2013 or above version), whenever you select some data from a range of cells you get a small icon on the bottom right hand corner, as you can see below:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/2017-06-08_12-19-35.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 + 1 Reasons You Should Use Excel\u2019s Quick Analysis Option\" class=\"alignnone size-full wp-image-6465\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/2017-06-08_12-19-35.png\" alt=\"5 + 1 Reasons You Should Use Excel\u2019s Quick Analysis Option\" width=\"285\" height=\"198\" \/><\/a><\/p>\n<p>And, I\u2019m sure you have noticed this so many times.<\/p>\n<p>It was first introduced by Microsoft in 2013 version of Excel\u00a0and it is called: <b>QUICK ANALYSIS<\/b><\/p>\n<p>But, the thing I want to ask is how many times you have used it in your daily work? If you are one of those excel users who use it, please say \u201cYes\u201d in the comments section below the post.<\/p>\n<p>So today, I want to inspire you to use this tool, and for this, I have listed <b>5+1 amazing things which you can do with the quick analysis option<\/b>\u00a0and which will save your a lot of time!<\/p>\n<p>But before we get into it, let me share with you what others are saying about this option.<\/p>\n<blockquote>\n<p style=\"text-align: center\">According to Make Use of:<\/p>\n<h3 style=\"text-align: center\"><em>&#8220;Quick Analysis is one of the best excel features which you should use.&#8221;<\/em><\/h3>\n<p style=\"text-align: center\">And, Tech Republic says:<\/p>\n<h3 style=\"text-align: center\"><em>&#8220;You can instantly analyze your data with Quick Analysis.&#8221;<\/em><\/h3>\n<\/blockquote>\n<p>&nbsp;<\/p>\n<p>If you are not able to see the Quick Analysis option,\u00a0then you <strong>need to activate it<\/strong> and here are the steps.<\/p>\n<ul>\n<li>Go to <strong>File Tab -&gt; Options<\/strong><\/li>\n<li>In Excel Options, go to <strong>General<\/strong><\/li>\n<li>And, under user interface options, <strong>tick mark \u201cQuick Analysis options on selection\u201d<\/strong><\/li>\n<\/ul>\n<p>&lt;!&#8211;<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12058\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/activate-quick-analysis-from-excel-options.png\" alt=\"activate quick analysis from excel options\" width=\"383\" height=\"135\" title=\"\">&#8211;&gt;<\/p>\n<ul>\n<li>Click <strong>OK<\/strong><\/li>\n<\/ul>\n<p>So now, let\u2019s get started with the\u00a05 + 1 Reasons You Should Use Excel\u2019s Quick Analysis Option!<\/p>\n<p>&nbsp;<\/p>\n<p><b>Table of Contents:<\/b><\/p>\n<p>1. Add Running Total<\/p>\n<p>2. Create a <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a><\/p>\n<p>3. Insert a Line Chart<\/p>\n<p>4. Percentage Share<\/p>\n<p>5. Insert a Sparkline<\/p>\n<p>6. Highlight Greater than values<\/p>\n<h2 style=\"text-align: center\"><\/h2>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"button small\" href=\"https:\/\/excelchamps.com\/files\/quick-analysis.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\" data-leadbox=\"http:\/\/files.excelchamps.com\/quick-analysis-options\/\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"> DOWNLOAD OUR FREE &#8220;QUICK ANALYSIS CHEAT&#8221; SHEET <i class=\"fa fa-download\"><\/i><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/5-1-reasons-you-should-use-excels-quick-analysis-option\/#1_Add_Running_Total\" title=\"1. Add Running Total\">1. Add Running Total<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/5-1-reasons-you-should-use-excels-quick-analysis-option\/#2_Insert_a_Pivot_Table\" title=\"2. Insert a Pivot Table\">2. Insert a Pivot Table<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/5-1-reasons-you-should-use-excels-quick-analysis-option\/#3_Recommended_Charts\" title=\"3. Recommended Charts\">3. Recommended Charts<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/5-1-reasons-you-should-use-excels-quick-analysis-option\/#4_Percentage_Share\" title=\"4.\u00a0Percentage Share\">4.\u00a0Percentage Share<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/5-1-reasons-you-should-use-excels-quick-analysis-option\/#5_Insert_a_Sparkline\" title=\"5. Insert a Sparkline\">5. Insert a Sparkline<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/5-1-reasons-you-should-use-excels-quick-analysis-option\/#6_Highlight_Greater_than_values\" title=\"6. Highlight Greater than values\">6. Highlight Greater than values<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/5-1-reasons-you-should-use-excels-quick-analysis-option\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/5-1-reasons-you-should-use-excels-quick-analysis-option\/#About_the_Author\" title=\"About the Author\">About the Author<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Add_Running_Total\"><\/span><span style=\"color: #ff0000\">1. Add Running Total<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Instantly add a running total.<\/b><\/p>\n<p>Running total is <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/show-pivot-table-values-as-a-running-total-in\/\" target=\"_blank\" rel=\"noopener noreferrer\">one of the best ways to analyze data<\/a> and you can use quick analysis option to add it in no time. \u00a0So, please follow these steps:<\/p>\n<ul>\n<li><strong>Select your data<\/strong> and click on the quick analysis icon or you can also use shortcut key Ctrl \u00a0+Q.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12063\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/select-data-to-add-running-total-with-quick-analysis.png\" alt=\"\" width=\"268\" height=\"378\" title=\"\">&#8211;&gt;<\/p>\n<ul>\n<li>Now, in quick analysis option, go to <strong>Totals<\/strong> and scroll to the end of the option.<\/li>\n<li>And, click on <strong>\u201cRunning\u201d<\/strong> <strong>(yellow icon)<\/strong>.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12062\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/running-tot-tal-button-in-quick-analysis.png\" alt=\"\" width=\"433\" height=\"372\" title=\"\">&#8211;&gt;<\/p>\n<ul>\n<li>Once you click on it, it will automatically <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/insert-or-delete-rows-and-columns-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">insert a new column in your table<\/a> with running total <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/excel-subtotal-feature\/\" target=\"_blank\" rel=\"noopener noreferrer\">using the SUBTOTAL function<\/a>.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12061\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/running-total-using-quick-analysis.png\" alt=\"\" width=\"353\" height=\"345\" title=\"\">&#8211;&gt;<\/p>\n<p>In the <strong>Total<\/strong> tab, there are two types of options, one is blue which is for rows and second is yellow which is for columns.<\/p>\n<p>Let\u2019s say if you want to add a running total for a row instead of a\u00a0column, you can use blue option.<\/p>\n<h2><\/h2>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Insert_a_Pivot_Table\"><\/span><span style=\"color: #ff0000\">2. Insert a Pivot Table<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Quickly insert a pivot table. <\/b><\/p>\n<p>Yes, you can <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/quick-analysis-tool\/\" target=\"_blank\" rel=\"noopener\">use the quick analysis tool<\/a> to quickly create a pivot table. Please follow these simple steps.<\/p>\n<ul>\n<li>First of all, <strong>select your entire data.<\/strong><\/li>\n<li>After that, press <strong>Ctrl + Q<\/strong> and select <strong>Tables<\/strong>.<\/li>\n<li>Now click on <strong>&#8220;Blank&#8221;<\/strong>\u00a0in tables.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12070\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/create-a-pivot-table-with-quick-analysis-min.png\" alt=\"create a pivot table with quick analysis\" width=\"417\" height=\"164\" title=\"\">&#8211;&gt;<\/p>\n<ul>\n<li>Once you click on it, it will instantly\u00a0create a pivot table adding a new worksheet.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>The best thing about this method is, it inserts a pivot table without showing you \u201cCreate Pivot Table Window\u201d.<\/p>\n<p>So, whenever you are in hurry just remember: <b>Select your data -&gt; Ctrl + Q &amp; Tables -&gt; Click Blank Button<\/b>.<\/p>\n<h2><\/h2>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Recommended_Charts\"><\/span><span style=\"color: #ff0000\">3. Recommended Charts<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/excel-chart-helper-infographic\/\" target=\"_blank\" rel=\"noopener noreferrer\">Choose right chart for your data<\/a> in a flash.<\/b><\/p>\n<p>Most of the times you have a specific chart in your mind \u00a0to present your data and you insert it without considering that there can be an another type of a chart which you can use.<\/p>\n<p>In Excel, there is an option \u201cRecommended Charts\u201d which you can use to get a <strong>suggestion of charts<\/strong> and you can use that option in the quick analysis as well.<\/p>\n<p>Follow these steps.<\/p>\n<ul>\n<li>First of all, <strong>select your data table<\/strong> and press <strong>Ctrl + Q<\/strong> and then <strong>Charts<\/strong>.<\/li>\n<li>Now, you have a<strong> list of recommended charts<\/strong> from which you can\u00a0hover over with your mouse and it will show you a <strong>live update of the chart<\/strong> based on your data.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12069\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/create-a-chart-with-quick-analysis-min.png\" alt=\"create a chart with quick analysis\" width=\"545\" height=\"571\" title=\"\">&#8211;&gt;<\/p>\n<ul>\n<li><strong>Click on the chart icon<\/strong> that you like and it will instantly insert that chart in your worksheet.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>And, if you want to insert a chart which is not in the list, click on \u201cMore Charts\u201d. \u00a0The best part is that it will always recommend you the best suitable charts.<\/p>\n<h2><\/h2>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_Percentage_Share\"><\/span><span style=\"color: #ff0000\">4.\u00a0Percentage Share<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Insert percentage share with just a\u00a0few clicks.<\/b><\/p>\n<p>Let\u2019s say you have a list of products with their sales quantity\u00a0and you want to calculate the product share. If you want to use the manual method for this, you will need to insert a <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> manually.<\/p>\n<p>But, you can do this automatically\u00a0using the quick analysis option.<\/p>\n<p>Steps:<\/p>\n<ul>\n<li><strong>Select your data<\/strong> and press <strong>Ctrl + Q<\/strong> and then select <strong>Totals<\/strong>.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12072\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/data-to-add-product-share-with-quick-analysis-min.png\" alt=\"data to add product share with quick analysis\" width=\"285\" height=\"163\" title=\"\">&#8211;&gt;<\/p>\n<ul>\n<li>Scroll to <strong>\u201c%Total\u201d (yellow icon)<\/strong> and click on it.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12068\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/click-on-total-in-quick-analysis-min.png\" alt=\"click on total in quick analysis\" width=\"418\" height=\"164\" title=\"\">&#8211;&gt;<\/p>\n<ul>\n<li>Once you click on it, it will instantly insert a new column to your table with product share percentage.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12074\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/product-share-table-with-quick-analysis-min.png\" alt=\"product share table with quick analysis\" width=\"343\" height=\"125\" title=\"\">&#8211;&gt;<\/p>\n<p>It uses a combination of <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/sumifs-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">SUM function<\/a> and SUBTOTAL function for this.<\/p>\n<h2><\/h2>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"5_Insert_a_Sparkline\"><\/span><span style=\"color: #ff0000\">5. Insert a Sparkline<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Insert a small trend line with sparklines.<\/b><\/p>\n<p>You can also add a sparkline with the quick analysis tool. \u00a0The benefit of using sparklines is that you can <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/in-cell-bar-charts-with-the-excel-rept-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">create in-cell charts<\/a>\u00a0with it, which don\u2019t take much space. And, you can easily <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/ultimate-dashboard-tools-for-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">use them in your dashboards<\/a>.<\/p>\n<p>Steps:<\/p>\n<ul>\n<li>First of all, select the entire range of data like below and press <strong>Ctrl + Q<\/strong> and then select <strong>Sparklines<\/strong>.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12071\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/data-for-sparklines-with-quick-analysis-min.png\" alt=\"data for sparklines with quick analysis\" width=\"725\" height=\"72\" title=\"\">&#8211;&gt;<\/p>\n<ul>\n<li>After that, <strong>click on the type of sparkline<\/strong> you want to add.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12075\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/select-column-sparkline-from-quick-analysis-min.png\" alt=\"select column sparkline from quick analysis\" width=\"418\" height=\"164\" title=\"\">&#8211;&gt;<\/p>\n<ul>\n<li>Once you click on it, it will insert a Sparkline in the cell after the last cell.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12077\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/table-with-sparkline-with-quick-analysis-min.png\" alt=\"table with sparkline with quick analysis\" width=\"723\" height=\"69\" title=\"\">&#8211;&gt;<\/p>\n<p>After inserting a sparkling and you decide you want to change its type, then just select your data and follow the same steps.<\/p>\n<h2><\/h2>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"6_Highlight_Greater_than_values\"><\/span><span style=\"color: #ff0000\">6.<\/span> <span style=\"color: #ff0000\">Highlight Greater than values<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/conditional-format-a-cells-value\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Quickly apply conditional formatting on your data<\/strong><\/a>.<\/p>\n<p>If you ever wanted to highlight all the values which are greater than a certain value, you can do this with the quick analysis option.<\/p>\n<ul>\n<li>First of all, <strong>select your values<\/strong> on which you want to apply conditional formatting.<\/li>\n<li>Press shortcut key <strong>Ctrl + Q<\/strong> and click on the <strong>Greater<\/strong> icon.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12073\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/data-to-highlight-greater-than-values-with-quick-analysis-min.png\" alt=\"data to highlight greater than values with quick analysis\" width=\"418\" height=\"164\" title=\"\">&#8211;&gt;<\/p>\n<ul>\n<li>Once you click on it, it will show you a pop-up window. \u00a0<strong>Enter the greater than value<\/strong> and <strong>select a\u00a0color<\/strong> to use for highlighting the cells.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12067\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/add-greate-than-value-with-quick-analysis-min.png\" alt=\"add greater than value with quick analysis\" width=\"471\" height=\"133\" title=\"\">&#8211;&gt;<\/p>\n<ul>\n<li>In the end, click <strong>OK<\/strong>.<\/li>\n<\/ul>\n<p>&lt;!&#8211;<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12076\" src=\"http:\/\/excelchamps.com\/blog\/wp-content\/uploads\/2017\/04\/table-with-heighligted-values-with-quick-analysis-min.png\" alt=\"table with heighligted values with quick analysis\" width=\"265\" height=\"282\" title=\"\">&#8211;&gt;<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><span style=\"color: #ff0000\">Conclusion<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel&#8217;s Quick Analysis is all about quick stuff. \u00a0You can access most useful stuff in a flash. \u00a0Apart from the stuff I have mentioned above, there are more than 24 options which you can use.<\/p>\n<p>The only flaw which I have seen is you can\u2019t add or delete your favourite features\u00a0into Quick Analysis but it\u2019s still can be a time saver for you.<\/p>\n<p>What do you think?<\/p>\n<p>I want you to share your views in the comment section with me below. \u00a0I would love to hear from you.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"About_the_Author\"><\/span><span style=\"color: #ff0000\">About the Author<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This guest post is contributed by <strong>Puneet Gogia<\/strong> from Excel Champs<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Excel (2013 or above version), whenever you select some data from a range of cells you get a small icon on the bottom right hand corner, as you can see below: And, I\u2019m sure you have noticed this so many times. It was first introduced by Microsoft in 2013 version of Excel\u00a0and it is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6469,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"5 + 1 Reasons You Should Use Excel\u2019s Quick Analysis Option","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,41],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6463"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=6463"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6463\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/6469"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}