{"id":918,"date":"2012-10-24T13:09:36","date_gmt":"2012-10-24T13:09:36","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=918"},"modified":"2023-12-30T23:12:48","modified_gmt":"2023-12-30T23:12:48","slug":"use-autosum-to-speed-up-data-analysis-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/use-autosum-to-speed-up-data-analysis-in-excel\/","title":{"rendered":"Use Autosum to speed up data analysis In Excel"},"content":{"rendered":"<p>You can learn how to get more out of your data with Excel 2010 training courses London. For example, Autosum offers you so much more than just, well, auto-summing. It belongs in the Formulas tab, but you&#8217;ll also find it tucked away on the Home tab.<\/p>\n<blockquote><p>Tip: \u00a0I use Autosum so much I like to add it to my quick access toolbar. \u00a0To do this, right click on the Autosum icon, and select &#8220;Add to Quick Access Toolbar&#8221;.<\/p><\/blockquote>\n<p>The Autosum button offers you a quick way to access common calculations such including:<\/p>\n<ul>\n<li>Sum<\/li>\n<li>Average<\/li>\n<li>Count numbers<\/li>\n<li>Maximum<\/li>\n<li>Minimum<\/li>\n<\/ul>\n<p>This is a really quick way to get the results to these common questions, so when you are asked to give an answer in a few seconds, you can do it.<\/p>\n<p>Here is my list of fictitious students. \u00a0I want to know the average score from their exam. \u00a0I select the exam results \u00a0and then go to the Autosum icon, on the Formulas tab.<\/p>\n<figure id=\"attachment_919\" aria-describedby=\"caption-attachment-919\" style=\"width: 145px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/autosum-options-excel-2010-training-london.png\"><img decoding=\"async\" class=\"size-full wp-image-919\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/autosum-options-excel-2010-training-london.png\" alt=\"autosum-options-excel-2010-training-london\" width=\"145\" height=\"198\" \/><\/a><figcaption id=\"caption-attachment-919\" class=\"wp-caption-text\">Autosum options&#8230;so easy to access&#8230;<\/figcaption><\/figure>\n<p>I choose Average, and Excel will give me the result below the selected results. \u00a0I can use the same method to find out the minimum result, maximum result, count up the number of students&#8230;.etc etc.<\/p>\n<figure id=\"attachment_920\" aria-describedby=\"caption-attachment-920\" style=\"width: 211px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/Average-results-excel-2010-training-london.png\"><img decoding=\"async\" class=\"size-medium wp-image-920\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/Average-results-excel-2010-training-london-211x300.png\" alt=\"Average-results-excel-2010-training-london\" width=\"211\" height=\"300\" \/><\/a><figcaption id=\"caption-attachment-920\" class=\"wp-caption-text\">Ta da! The results are in.<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>You can learn how to get more out of your data with Excel 2010 training courses London. For example, Autosum offers you so much more than just, well, auto-summing. It belongs in the Formulas tab, but you&#8217;ll also find it tucked away on the Home tab. Tip: \u00a0I use Autosum so much I like to [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[70,177],"class_list":["post-918","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-autosum","tag-excel-2010-training-london"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/918","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=918"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/918\/revisions"}],"predecessor-version":[{"id":6744,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/918\/revisions\/6744"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}