{"id":3896,"date":"2019-12-04T08:52:39","date_gmt":"2019-12-03T20:52:39","guid":{"rendered":"https:\/\/kinetics.co.nz\/?p=3896"},"modified":"2019-12-04T08:52:39","modified_gmt":"2019-12-03T20:52:39","slug":"excels-best-ideas","status":"publish","type":"post","link":"https:\/\/new.kinetics.co.nz\/?p=3896","title":{"rendered":"Excel\u2019s Best Ideas"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.22″][et_pb_row admin_label=”row” _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Text” _builder_version=”4.9.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ sticky_enabled=”0″]<\/p>\n

Have you noticed the \u2018IDEAS\u2019 icon in Excel?<\/h2>\n

(It used to be called \u2018Insights\u2019 ). It\u2019s Excel\u2019s attempt to make you look smarter and more thoughtful.<\/p>\n

\"\"<\/p>\n

Simply start with a table (not a pivot table) of data, and hit the idea\u2019s button and see what comes.<\/strong><\/p>\n

Based on my experimentation, it gets a little confused with formatting and \u2018total\u2019 lines in data, so you may need to cut-and-paste your data to a sheet, or just highlight the data you want to analyse without the total lines or blank formatting lines.<\/p>\n

The function will then suggest charts and identify trends<\/strong> or stand-out numbers for you.<\/p>\n

Nothing beats a human assessment of data, but this is a useful additional tool to help you make sure you didn\u2019t miss anything obvious!<\/p>\n

 <\/p>\n

If you hit the \u2018Which fields interest you the most\u2019, you can instruct Excel to focus down just on that data<\/strong> and it will present some graphs and pivot options that help get you straight to the data you are interested in.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Have you noticed the \u2018IDEAS\u2019 icon in Excel? (It used to be called \u2018Insights\u2019 ). It\u2019s Excel\u2019s attempt to make you look smarter and more thoughtful. Simply start with a table (not a pivot table) of data, and hit the idea\u2019s button and see what comes. Based on my experimentation, it gets a little confused […]<\/p>\n","protected":false},"author":5,"featured_media":3898,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"[header2 text=\"Have you noticed the \u2018IDEAS\u2019 icon in Excel?\" align=\"left\" color=\"#336A40\" margintop=\"\"]\n\n(It used to be called \u2018Insights\u2019 ). It\u2019s Excel\u2019s attempt to make you look smarter and more thoughtful.\n\n[wow_spacing size=\"10px\"]\"\"\n\nSimply start with a table (not a pivot table) of data, and hit the idea\u2019s button and see what comes.<\/strong>\n\nBased on my experimentation, it gets a little confused with formatting and \u2018total\u2019 lines in data, so you may need to cut-and-paste your data to a sheet, or just highlight the data you want to analyse without the total lines or blank formatting lines.\n\nThe function will then suggest charts and identify trends<\/strong> or stand-out numbers for you.\n\nNothing beats a human assessment of data, but this is a useful additional tool to help you make sure you didn\u2019t miss anything obvious!\n\n \n\nIf you hit the \u2018Which fields interest you the most\u2019, you can instruct Excel to focus down just on that data<\/strong> and it will present some graphs and pivot options that help get you straight to the data you are interested in.","_et_gb_content_width":"","footnotes":""},"categories":[4,2],"tags":[],"class_list":["post-3896","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news","category-tips-tricks-and-hints"],"_links":{"self":[{"href":"https:\/\/new.kinetics.co.nz\/index.php?rest_route=\/wp\/v2\/posts\/3896","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/new.kinetics.co.nz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/new.kinetics.co.nz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/new.kinetics.co.nz\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/new.kinetics.co.nz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3896"}],"version-history":[{"count":0,"href":"https:\/\/new.kinetics.co.nz\/index.php?rest_route=\/wp\/v2\/posts\/3896\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/new.kinetics.co.nz\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"https:\/\/new.kinetics.co.nz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/new.kinetics.co.nz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/new.kinetics.co.nz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}