{"id":13186,"date":"2020-03-27T10:08:43","date_gmt":"2020-03-27T09:08:43","guid":{"rendered":"https:\/\/www.graphomate.com\/plattformen\/microsoft\/microsoft-excel\/"},"modified":"2022-07-18T15:43:09","modified_gmt":"2022-07-18T13:43:09","slug":"microsoft-excel","status":"publish","type":"platform","link":"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/","title":{"rendered":"Microsoft Excel"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<h4 class=\"wp-block-heading\">Available graphomate product for Microsoft Excel<\/h4>\n\n\n\n\t<div id=\"block_5e7e0ce48ebe6\" class=\"wp-block-teaser-extension  \">\n\t\t<div class=\"wp-block-extension-platform__inner-container\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t<div class=\"list list-extension-small list-1\">\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t<div class=\"list-item item-extension\">\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\t\n\t\n\t<article id=\"post-13257\" class=\"post post-type-extension post-view-teaser-small post-scope- status-publish has-post-thumbnail clear article-extension element-article template-article-extension\">\n\t\n\t\t\t\t\t\t\n\t\t<a href=\"https:\/\/www.graphomate.com\/en\/produkte\/graphomate-charts\/\" class=\"teaser\">\n\t\t\t<div class=\"field field-title\">\n\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"256\" height=\"256\" src=\"https:\/\/www.graphomate.com\/wp-content\/uploads\/2020\/06\/icon_ch_256x256.png\" class=\"attachment-full size-full\" alt=\"\" srcset=\"https:\/\/www.graphomate.com\/wp-content\/uploads\/2020\/06\/icon_ch_256x256.png 256w, https:\/\/www.graphomate.com\/wp-content\/uploads\/2020\/06\/icon_ch_256x256-150x150.png 150w\" sizes=\"auto, (max-width: 256px) 100vw, 256px\" \/>\t\t\t\t<h3>graphomate<br \/><span>charts<\/span><\/h3>\n\t\t\t<\/div>\n\t\t<\/a>\n\t\t\n\t<\/article>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<p>In the world of business you will find <strong>Microsoft Excel<\/strong> everywhere. There are a lot of reasons: The program enables <strong>quick <\/strong>and <strong>easy storage<\/strong> of data, their <strong>analysis <\/strong>and the <strong>visualization<\/strong> of results. <\/p>\n\n\n\n<p>As part of the <strong>standard programs<\/strong> of Windows pcs as well as the <strong>flexibilty <\/strong>for countless application scenarios explains the <strong>wide distribution<\/strong> in the business world.<\/p>\n\n\n\n<p>Also working Microsoft Excel is very common within the <strong>SAP system infrastructure<\/strong>. The program <strong>SAP Analysis for Office<\/strong> enables the user to load data from SAP databases directly to the excel sheet and use the familiar Excel features to analyze, process and display the data.<\/p>\n\n\n\n<p>Known functionalities like Power Query, Power Pivot and Power View have been integrated into the &#8216;younger&#8217; reporting tool <a href=\"https:\/\/www.graphomate.com\/en\/platforms\/microsoft\/microsoft-power-bi\/\" data-type=\"platform\" data-id=\"13183\">Microsoft Power BI<\/a>.<\/p>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">The finishing touch: graphomate charts for Excel<\/h2>\n\n\n\n<p>In recent years the topic of a uniform notation in the business communication has become increasingly important &#8211; that&#8217;s good! The International Business Communication Standard<strong> (IBCS)<\/strong> lays the foundation for a uniform appearance of reports and presentations.<\/p>\n\n\n\n<p>With <strong>graphomate charts for Excel<\/strong> you can easily create IBCS compliant charts. Charts can be generated with a few clicks, even by Excel beginners. So don&#8217;t waste valuable time to create IBCS charts with Excel&#8217;s built-in tools. <strong>Use graphomate charts instead<\/strong>.Save your time and use it for analysis and interpretation of your data.<\/p>\n\n\n\n<p>Many of our customers wished to be able to use graphomate charts more universally: not only in SAP Lumira Designer (formerly SAP BusinessObjects Design Studio), but also in Microsoft Excel. Behind this request is a typical use case: You want to be able to use filter states of a graphomate chart in a dashboard in Excel, PowerPoint or Word. The export function of graphomate charts for Excel allows you to edit a dashboard visualization directly in Excel &#8211; data and settings are transferred from the web application.<\/p>\n\n\n\n<p>In addition graphomate charts can be used in connection with SAP Analysis for Office. When updating the database, the adjustment in graphomate chart is done simultaneously.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Microsoft Excel as a BI tool?<\/h2>\n\n\n\n<p>The switch from command line based programs to graphical user interfaces is also the hour of birth of Excel. That was back in 1985 and the range of functions has grown continuously over the past 35 years.<\/p>\n\n\n\n<p>Heavily nested queries, programming using VBA (Visual Basic for Application) and linking to other tools in the Microsoft Office Suite are characteristic features of the flexibility of Excel. As a consequence of its widespread use, data provision from a diverse range of data sources and systems is now often in Excel file format too.<\/p>\n\n\n\n<p>The seamless communication between the programs of the Office Suite (Word, PowerPoint and others) also facilitates the embedding of graphics or tables in the familiar look. This protocol is called Object Linking and Embedding (OLE for short) in the Microsoft environment. For example, if an object is changed, this object is updated in all linked Office files when opened. A very useful function that always shows the current status of the data source.<\/p>\n\n\n\n<p>The numerous possible uses of Excel make it <strong>appear <\/strong>as an all-round carefree package:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Worldwide distribution through integration with Microsoft Office Suite \/ Microsoft 365 subscription<\/li><li>Extensive calculations of the data possible (mathematical, economic and commercial purposes)<\/li><li>Ad-hoc analyses through quick and easy data manipulation<\/li><li>Collaboration with colleagues<\/li><li>Connectivity to various data sources<\/li><\/ul>\n\n\n\n<p><strong>Conclusion<\/strong>: Did you notice that we wrote &#8220;appear&#8221;? In the context of reporting and data analysis, we see the application area of Excel mainly in the area of short-term and manual data evaluation. We see it less as an all-in-one tool for comprehensive reporting and\/or dashboarding. In our opinion, tools such as Power BI, Tableau or SAP Lumira Designer better meet the requirements of a transparent reporting tool.<\/p>\n","protected":false},"excerpt":{"rendered":"The Microsoft Excel is ubiquitous in the business world. The reasons: The program allows for quick and easy storage of data, their analysis and the graphical presentation of results.","protected":false},"featured_media":14084,"parent":13172,"menu_order":2,"template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post post-type-platform post-view- post-scope-","status-publish","has-post-thumbnail","clear"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft Excel - graphomate<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Excel - graphomate\" \/>\n<meta property=\"og:description\" content=\"The Microsoft Excel is ubiquitous in the business world. The reasons: The program allows for quick and easy storage of data, their analysis and the graphical presentation of results.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"graphomate\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-18T13:43:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.graphomate.com\/wp-content\/uploads\/2021\/01\/host_exl.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"100\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@graphomate\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/plattformen\\\/microsoft\\\/microsoft-excel\\\/\",\"url\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/plattformen\\\/microsoft\\\/microsoft-excel\\\/\",\"name\":\"Microsoft Excel - graphomate\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/plattformen\\\/microsoft\\\/microsoft-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/plattformen\\\/microsoft\\\/microsoft-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.graphomate.com\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/host_exl.jpg\",\"datePublished\":\"2020-03-27T09:08:43+00:00\",\"dateModified\":\"2022-07-18T13:43:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/plattformen\\\/microsoft\\\/microsoft-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.graphomate.com\\\/en\\\/plattformen\\\/microsoft\\\/microsoft-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/plattformen\\\/microsoft\\\/microsoft-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.graphomate.com\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/host_exl.jpg\",\"contentUrl\":\"https:\\\/\\\/www.graphomate.com\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/host_exl.jpg\",\"width\":200,\"height\":100},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/plattformen\\\/microsoft\\\/microsoft-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft\",\"item\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/platforms\\\/microsoft\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/\",\"name\":\"graphomate\",\"description\":\"Einfach und einheitlich IBCS Dashboards visualisieren\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/#organization\",\"name\":\"graphomate Gmbh\",\"url\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.graphomate.com\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/graphomate_logo_2014_500px_transparent.png\",\"contentUrl\":\"https:\\\/\\\/www.graphomate.com\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/graphomate_logo_2014_500px_transparent.png\",\"width\":500,\"height\":82,\"caption\":\"graphomate Gmbh\"},\"image\":{\"@id\":\"https:\\\/\\\/www.graphomate.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/graphomate\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/graphomate-gmbh\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCvrjaoVJ-xDFGLCAzKN_11Q\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Excel - graphomate","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Excel - graphomate","og_description":"The Microsoft Excel is ubiquitous in the business world. The reasons: The program allows for quick and easy storage of data, their analysis and the graphical presentation of results.","og_url":"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/","og_site_name":"graphomate","article_modified_time":"2022-07-18T13:43:09+00:00","og_image":[{"width":200,"height":100,"url":"https:\/\/www.graphomate.com\/wp-content\/uploads\/2021\/01\/host_exl.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@graphomate","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/","url":"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/","name":"Microsoft Excel - graphomate","isPartOf":{"@id":"https:\/\/www.graphomate.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.graphomate.com\/wp-content\/uploads\/2021\/01\/host_exl.jpg","datePublished":"2020-03-27T09:08:43+00:00","dateModified":"2022-07-18T13:43:09+00:00","breadcrumb":{"@id":"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/#primaryimage","url":"https:\/\/www.graphomate.com\/wp-content\/uploads\/2021\/01\/host_exl.jpg","contentUrl":"https:\/\/www.graphomate.com\/wp-content\/uploads\/2021\/01\/host_exl.jpg","width":200,"height":100},{"@type":"BreadcrumbList","@id":"https:\/\/www.graphomate.com\/en\/plattformen\/microsoft\/microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.graphomate.com\/en\/"},{"@type":"ListItem","position":2,"name":"Microsoft","item":"https:\/\/www.graphomate.com\/en\/platforms\/microsoft\/"},{"@type":"ListItem","position":3,"name":"Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.graphomate.com\/en\/#website","url":"https:\/\/www.graphomate.com\/en\/","name":"graphomate","description":"Einfach und einheitlich IBCS Dashboards visualisieren","publisher":{"@id":"https:\/\/www.graphomate.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.graphomate.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.graphomate.com\/en\/#organization","name":"graphomate Gmbh","url":"https:\/\/www.graphomate.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.graphomate.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.graphomate.com\/wp-content\/uploads\/2021\/06\/graphomate_logo_2014_500px_transparent.png","contentUrl":"https:\/\/www.graphomate.com\/wp-content\/uploads\/2021\/06\/graphomate_logo_2014_500px_transparent.png","width":500,"height":82,"caption":"graphomate Gmbh"},"image":{"@id":"https:\/\/www.graphomate.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/graphomate","https:\/\/www.linkedin.com\/company\/graphomate-gmbh\/","https:\/\/www.youtube.com\/channel\/UCvrjaoVJ-xDFGLCAzKN_11Q"]}]}},"_links":{"self":[{"href":"https:\/\/www.graphomate.com\/en\/wp-json\/wp\/v2\/platform\/13186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graphomate.com\/en\/wp-json\/wp\/v2\/platform"}],"about":[{"href":"https:\/\/www.graphomate.com\/en\/wp-json\/wp\/v2\/types\/platform"}],"version-history":[{"count":23,"href":"https:\/\/www.graphomate.com\/en\/wp-json\/wp\/v2\/platform\/13186\/revisions"}],"predecessor-version":[{"id":18725,"href":"https:\/\/www.graphomate.com\/en\/wp-json\/wp\/v2\/platform\/13186\/revisions\/18725"}],"up":[{"embeddable":true,"href":"https:\/\/www.graphomate.com\/en\/wp-json\/wp\/v2\/platform\/13172"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.graphomate.com\/en\/wp-json\/wp\/v2\/media\/14084"}],"wp:attachment":[{"href":"https:\/\/www.graphomate.com\/en\/wp-json\/wp\/v2\/media?parent=13186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}