{"id":4706,"date":"2015-04-08T13:53:57","date_gmt":"2015-04-08T11:53:57","guid":{"rendered":"http:\/\/www.chartisan.com\/sales-dashboard-mit-excel-2\/"},"modified":"2018-08-21T17:03:11","modified_gmt":"2018-08-21T15:03:11","slug":"sales-dashboard-mit-excel","status":"publish","type":"post","link":"https:\/\/www.chartisan.com\/en\/sales-dashboard-mit-excel\/","title":{"rendered":"Sales Dashboard mit Excel"},"content":{"rendered":"<div  class='avia-video av-oyom-a8603dd74ff282edf54d374b0ef3ab44 avia-video-4-3 av-no-preview-image avia-video-load-always av-lazyload-immediate av-lazyload-video-embed'  itemprop=\"video\" itemtype=\"https:\/\/schema.org\/VideoObject\"  data-original_url='https:\/\/vimeo.com\/124404392\/'><script type='text\/html' class='av-video-tmpl'><div class='avia-iframe-wrap'><iframe src=\"https:\/\/player.vimeo.com\/video\/124404392?autoplay=0&loop=0&controls=1&muted=0\" width=\"960\" height=\"720\" frameborder=\"0\" title=\"Sales Dashboard Excel\" webkitallowfullscreen mozallowfullscreen allowfullscreen><\/iframe><\/div><\/script><div class='av-click-to-play-overlay'><div class=\"avia_playpause_icon\"><\/div><\/div><\/div>\n<p>Ein kleiner Projekt-Einblick in ein \u00fcbersichtlich aufgebautes Sales Dashboard. Durch die Realisierung in Excel, ohne etwaige Plugins oder VBA-Programmierung, l\u00e4sst es sich komplikationslos von jedem Office-Anwender nutzen und verteilen. Die Datenaufbereitung basiert in diesem Beispiel auf Pivot-Tabellen. Eine Datenbank-Anbindung ist problemlos m\u00f6glich.<\/p>\n<blockquote><p>Das ist keine Zauberei oder ewige T\u00fcftelei. Versprochen!<\/p><\/blockquote>\n<p>Wenn Sie unsere L\u00f6sung interessiert, k\u00f6nnen Sie uns nach einer individuellen L\u00f6sung f\u00fcr Ihren Anwendungsfall fragen oder Sie besuchen ein Seminar zum Thema \u00a0<a title=\"Neues Seminar: Dashboards mit Excel realisieren\" href=\"http:\/\/www.chartisan.com\/neues-seminarangebot-dashboards-mit-excel-realisieren\/\">&gt;siehe Blogbeitrag hier&lt;<\/a>\u00a0oder <a href=\"http:\/\/www.vereon.ch\/shop\/USER_ARTIKEL_HANDLING_AUFRUF.php?darstellen=1&amp;Kategorie_ID=179&amp;Ziel_ID=5307&amp;anzeigen_ab=0&amp;sort=&amp;order=&amp;PEPPERSESS=764de9ff62b7cb1b245733b6ac971abc\" target=\"_blank\" rel=\"noopener\">&gt;direkt zum Seminar&lt;<\/a>\u00a0 und erlernen es selbst.<\/p>\n<p>&nbsp;<\/p>\n<div class=\"shariff\"><ul class=\"shariff-buttons theme-default orientation-horizontal buttonsize-medium\"><li class=\"shariff-button twitter shariff-nocustomcolor\" style=\"background-color:#595959\"><a href=\"https:\/\/twitter.com\/share?url=https%3A%2F%2Fwww.chartisan.com%2Fen%2Fsales-dashboard-mit-excel%2F&text=Sales%20Dashboard%20mit%20Excel\" title=\"Share on X\" aria-label=\"Share on X\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\"; background-color:#000; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\"><path fill=\"#000\" d=\"M14.258 10.152L23.176 0h-2.113l-7.747 8.813L7.133 0H0l9.352 13.328L0 23.973h2.113l8.176-9.309 6.531 9.309h7.133zm-2.895 3.293l-.949-1.328L2.875 1.56h3.246l6.086 8.523.945 1.328 7.91 11.078h-3.246zm0 0\"\/><\/svg><\/span><span class=\"shariff-text\">share<\/span>&nbsp;<\/a><\/li><li class=\"shariff-button facebook shariff-nocustomcolor\" style=\"background-color:#4273c8\"><a href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Fwww.chartisan.com%2Fen%2Fsales-dashboard-mit-excel%2F\" title=\"Share on Facebook\" aria-label=\"Share on Facebook\" role=\"button\" rel=\"nofollow\" class=\"shariff-link\" style=\"; background-color:#3b5998; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 18 32\"><path fill=\"#3b5998\" d=\"M17.1 0.2v4.7h-2.8q-1.5 0-2.1 0.6t-0.5 1.9v3.4h5.2l-0.7 5.3h-4.5v13.6h-5.5v-13.6h-4.5v-5.3h4.5v-3.9q0-3.3 1.9-5.2t5-1.8q2.6 0 4.1 0.2z\"\/><\/svg><\/span><span class=\"shariff-text\">share<\/span>&nbsp;<\/a><\/li><li class=\"shariff-button linkedin shariff-nocustomcolor\" style=\"background-color:#1488bf\"><a href=\"https:\/\/www.linkedin.com\/sharing\/share-offsite\/?url=https%3A%2F%2Fwww.chartisan.com%2Fen%2Fsales-dashboard-mit-excel%2F\" title=\"Share on LinkedIn\" aria-label=\"Share on LinkedIn\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\"; background-color:#0077b5; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 27 32\"><path fill=\"#0077b5\" d=\"M6.2 11.2v17.7h-5.9v-17.7h5.9zM6.6 5.7q0 1.3-0.9 2.2t-2.4 0.9h0q-1.5 0-2.4-0.9t-0.9-2.2 0.9-2.2 2.4-0.9 2.4 0.9 0.9 2.2zM27.4 18.7v10.1h-5.9v-9.5q0-1.9-0.7-2.9t-2.3-1.1q-1.1 0-1.9 0.6t-1.2 1.5q-0.2 0.5-0.2 1.4v9.9h-5.9q0-7.1 0-11.6t0-5.3l0-0.9h5.9v2.6h0q0.4-0.6 0.7-1t1-0.9 1.6-0.8 2-0.3q3 0 4.9 2t1.9 6z\"\/><\/svg><\/span><span class=\"shariff-text\">share<\/span>&nbsp;<\/a><\/li><li class=\"shariff-button xing shariff-nocustomcolor\" style=\"background-color:#29888a\"><a href=\"https:\/\/www.xing.com\/spi\/shares\/new?url=https%3A%2F%2Fwww.chartisan.com%2Fen%2Fsales-dashboard-mit-excel%2F\" title=\"Share on XING\" aria-label=\"Share on XING\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\"; background-color:#126567; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 25 32\"><path fill=\"#126567\" d=\"M10.7 11.9q-0.2 0.3-4.6 8.2-0.5 0.8-1.2 0.8h-4.3q-0.4 0-0.5-0.3t0-0.6l4.5-8q0 0 0 0l-2.9-5q-0.2-0.4 0-0.7 0.2-0.3 0.5-0.3h4.3q0.7 0 1.2 0.8zM25.1 0.4q0.2 0.3 0 0.7l-9.4 16.7 6 11q0.2 0.4 0 0.6-0.2 0.3-0.6 0.3h-4.3q-0.7 0-1.2-0.8l-6-11.1q0.3-0.6 9.5-16.8 0.4-0.8 1.2-0.8h4.3q0.4 0 0.5 0.3z\"\/><\/svg><\/span><span class=\"shariff-text\">share<\/span>&nbsp;<\/a><\/li><\/ul><\/div>","protected":false},"excerpt":{"rendered":"<p>Ein kleiner Projekt-Einblick in ein \u00fcbersichtlich aufgebautes Sales Dashboard. Durch die Realisierung in Excel, ohne etwaige Plugins oder VBA-Programmierung, l\u00e4sst es sich komplikationslos von jedem Office-Anwender nutzen und verteilen. Die Datenaufbereitung basiert in diesem Beispiel auf Pivot-Tabellen. Eine Datenbank-Anbindung ist problemlos m\u00f6glich. Das ist keine Zauberei oder ewige T\u00fcftelei. Versprochen! Wenn Sie unsere L\u00f6sung interessiert, [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":8606,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"video","meta":{"footnotes":""},"categories":[142,143,144],"tags":[1851,148,184],"yst_prominent_words":[1136,1951],"class_list":["post-4706","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-innovations-2","category-inside-2","category-projects-2","tag-best-practice-en-2","tag-dashboard-en","tag-excel-en","post_format-post-format-video"],"_links":{"self":[{"href":"https:\/\/www.chartisan.com\/en\/wp-json\/wp\/v2\/posts\/4706","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chartisan.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chartisan.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chartisan.com\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chartisan.com\/en\/wp-json\/wp\/v2\/comments?post=4706"}],"version-history":[{"count":0,"href":"https:\/\/www.chartisan.com\/en\/wp-json\/wp\/v2\/posts\/4706\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.chartisan.com\/en\/wp-json\/wp\/v2\/media\/8606"}],"wp:attachment":[{"href":"https:\/\/www.chartisan.com\/en\/wp-json\/wp\/v2\/media?parent=4706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chartisan.com\/en\/wp-json\/wp\/v2\/categories?post=4706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chartisan.com\/en\/wp-json\/wp\/v2\/tags?post=4706"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.chartisan.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=4706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}