{"id":5335,"date":"2021-10-19T01:00:43","date_gmt":"2021-10-19T07:00:43","guid":{"rendered":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/?p=5335"},"modified":"2021-09-28T16:11:27","modified_gmt":"2021-09-28T22:11:27","slug":"harness-the-power-of-excel-formulas","status":"publish","type":"post","link":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/harness-the-power-of-excel-formulas\/","title":{"rendered":"Harness the Power of Excel Formulas"},"content":{"rendered":"\r\n<p>Few spreadsheets use the power of Excel formulas, which is like using a Ferrari as a push cart. Excel formulas are power tools for improvement. Here&#8217;s how to access them in QI Macros.<\/p>\r\n\r\n\r\n\r\n<p><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/611801658?title=0&amp;byline=0&amp;portrait=0\" width=\"720\" height=\"405\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\r\n\r\n\r\n\r\n<p>&#8220;A few years back, I went to an <a href=\"http:\/\/www.excelapalooza.com\/about\/\">Excelapalooza conference<\/a> (yes there is such a thing), and the keynote speaker was kind of the head developer for Excel, and she was talking about how Microsoft keeps track of what people do. I was stunned to recognize that only 5% (that&#8217;s five out of a hundred) Excel spreadsheets have <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/overview-of-formulas-in-excel-ecfdc708-9162-49e8-b993-c311f47ca173\">any sort of formula<\/a> in them, even division or multiplication or something simple like that.<\/p>\r\n<p>&#8220;The other thing that stung me was that over half of them use Merge and Center for headings. What does that mean? That means you&#8217;re using Excel to create reports and spreadsheets that nobody wants to read. It&#8217;s not a chart, it can&#8217;t be interpreted easily, and the more columns and rows you get the more complex and unreadable it becomes. Guess what? This is like having a Ferrari and you <a href=\"https:\/\/www.carscoops.com\/2010\/12\/push-and-pull-ferrari-f430-spider-on\/\">push it around the neighborhood or pull it around the neighborhood<\/a> rather than get in it, fire it up and take it for a ride.<\/p>\r\n<p>&#8220;Excel can do some amazingly powerful things, so I would suggest that one of the things you might do is go out and learn something about Excel formulas. <a href=\"https:\/\/www.qimacros.com\/free-excel-tips\/excel-formulas\/\">There&#8217;s some training resources on our website that will take you and teach you a little bit about formulas.<\/a> In the QI Macros there&#8217;s actually a <a href=\"https:\/\/www.qimacros.com\/qi-macros\/excel-formulas-template\/\">whole worksheet that&#8217;s designed to help you with formulas<\/a> for turning time into numbers or turning text into something or splitting text, so there&#8217;s a whole bunch of formulas built in there that I use because I can&#8217;t always remember all these things, right? So I use my Excel formulas in the QI Macros and take those and then start to do analysis and calculations and compute things that that are a little bit more complicated.<\/p>\r\n<p>&#8220;That&#8217;s my Improvement Insight for this week: Learn how to use Excel formulas. It&#8217;ll make your life so much easier. Let&#8217;s create a hassle-free America, hassle-free healthcare. Let&#8217;s go out and improve something this week.&#8221;<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Few spreadsheets use the power of Excel formulas, which is like using a Ferrari as a push cart. Excel formulas are power tools for improvement. Here&rsquo;s how to access them in QI Macros. &#65279; &ldquo;A few years back, I went to an Excelapalooza conference (yes there is such a thing), and the keynote speaker was [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":5370,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[175,290,5],"tags":[421,168],"class_list":["post-5335","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-improvement-insights","category-qi-macros","tag-excel-formulas","tag-qi-macros"],"_links":{"self":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/5335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/comments?post=5335"}],"version-history":[{"count":9,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/5335\/revisions"}],"predecessor-version":[{"id":5382,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/5335\/revisions\/5382"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/media\/5370"}],"wp:attachment":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/media?parent=5335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/categories?post=5335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/tags?post=5335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}