{"id":9948,"date":"2020-10-13T12:47:18","date_gmt":"2020-10-13T10:47:18","guid":{"rendered":"https:\/\/adconia.de\/en\/?p=9948"},"modified":"2020-10-13T14:14:56","modified_gmt":"2020-10-13T12:14:56","slug":"excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3","status":"publish","type":"post","link":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/","title":{"rendered":"Excel tricks from the daily life of a buyer \u2013 part 3 of 3"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-7omuh8-3061830a9acd9c74f993ee0981fb65aa\">\n.flex_column.av-7omuh8-3061830a9acd9c74f993ee0981fb65aa{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-7omuh8-3061830a9acd9c74f993ee0981fb65aa av_one_full  avia-builder-el-0  el_before_av_one_fifth  avia-builder-el-first  first flex_column_div av-zero-column-padding  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-5ulnrw-0bdad0a88a9eb5a0f224857f2d8f5641\">\n.avia-image-container.av-5ulnrw-0bdad0a88a9eb5a0f224857f2d8f5641 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-5ulnrw-0bdad0a88a9eb5a0f224857f2d8f5641 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-5ulnrw-0bdad0a88a9eb5a0f224857f2d8f5641 av-styling- avia-align-center  avia-builder-el-1  avia-builder-el-no-sibling '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" fetchpriority=\"high\" class='wp-image-9951 avia-img-lazy-loading-not-9951 avia_image ' src=\"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_.jpg\" alt='Excel' title='Excel _'  height=\"1124\" width=\"2000\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_.jpg 2000w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_-300x169.jpg 300w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_-768x432.jpg 768w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_-1030x579.jpg 1030w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_-1500x843.jpg 1500w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_-705x396.jpg 705w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_-450x253.jpg 450w\" sizes=\"(max-width: 2000px) 100vw, 2000px\" \/><\/div><\/div><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-49f6u4-76eb65735450af78d1876bf374c80db6\">\n.flex_column.av-49f6u4-76eb65735450af78d1876bf374c80db6{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-49f6u4-76eb65735450af78d1876bf374c80db6 av_one_fifth  avia-builder-el-2  el_after_av_one_full  el_before_av_two_third  first flex_column_div av-zero-column-padding  column-top-margin'     ><\/div><\/p>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-2tebzw-063960b61d3232033211f980e0dacb63\">\n.flex_column.av-2tebzw-063960b61d3232033211f980e0dacb63{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-2tebzw-063960b61d3232033211f980e0dacb63 av_two_third  avia-builder-el-3  el_after_av_one_fifth  avia-builder-el-last  flex_column_div av-zero-column-padding  column-top-margin'     ><p>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kg6dt8xu-1e3e5a170f9ce112fb4893678020c1f8\">\n#top .av-special-heading.av-kg6dt8xu-1e3e5a170f9ce112fb4893678020c1f8{\npadding-bottom:10px;\nfont-size:24px;\n}\nbody .av-special-heading.av-kg6dt8xu-1e3e5a170f9ce112fb4893678020c1f8 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n#top #wrap_all .av-special-heading.av-kg6dt8xu-1e3e5a170f9ce112fb4893678020c1f8 .av-special-heading-tag{\nfont-size:24px;\n}\n.av-special-heading.av-kg6dt8xu-1e3e5a170f9ce112fb4893678020c1f8 .av-subheading{\nfont-size:15px;\n}\n\n@media only screen and (min-width: 480px) and (max-width: 767px){ \n#top #wrap_all .av-special-heading.av-kg6dt8xu-1e3e5a170f9ce112fb4893678020c1f8 .av-special-heading-tag{\nfont-size:0.8em;\n}\n}\n\n@media only screen and (max-width: 479px){ \n#top #wrap_all .av-special-heading.av-kg6dt8xu-1e3e5a170f9ce112fb4893678020c1f8 .av-special-heading-tag{\nfont-size:0.8em;\n}\n}\n<\/style>\n<div  class='av-special-heading av-kg6dt8xu-1e3e5a170f9ce112fb4893678020c1f8 av-special-heading-h2 blockquote modern-quote  avia-builder-el-4  el_before_av_textblock  avia-builder-el-first  av-inherit-size'><h2 class='av-special-heading-tag '  itemprop=\"headline\"  >Excel tricks from the daily life of a buyer \u2013 part 3 of 3<\/h2><div class='av-subheading av-subheading_below'><p>Subtotal, XLOOKUP, Power Pivot<\/p>\n<\/div><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div><br \/>\n<section  class='av_textblock_section av-kg6dscg1-95edb1defb10f7f1433aa18c42c6e23e '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>After we&#8217;ve already covered topics like shortcuts, monitoring windows and macros in previous blogs, this is now the last part of our blog series about Excel.<\/p>\n<h2><strong>Subtotal<\/strong><\/h2>\n<p><strong>\u00a0<\/strong>Do you know this? You have created a table and formed a formula (COUNTA, SUM or so) over all the rows. Now you filter the table by a criterion. Result: The formula does not adapt and still includes all rows in the calculation, regardless of whether they are shown or hidden due to the filtering.<\/p>\n<p>The solution at this point is subtotal: =SUBTOTAL(function_num;ref_1). The function of the subtotal, i.e. the formula on which the partial result is based, is determined by means of a number, whereby among other things 2 stands for COUNTA, 9 for SUM &#8211; Excel shows you the possible selection when creating the formula. Now the calculation automatically adapts to the filtered values when filtering the table.<\/p>\n<h2><strong>XLOOKUP<\/strong><\/h2>\n<p>The VLOOKUP function is always used when you want to compare or merge several Excel tables. The V stands for vertical, so that the search or comparison is performed on a column basis. The counterpart on a row basis is the HLOOKUP for the search \/ adjustment on row level.<\/p>\n<p>New and currently in rollout for Office 365 is XLOOKUP, which has the potential to replace VLOOKUP, HLOOKUP and INDEX\/MATCH functions in the future. It offers several advantages compared to the old formulas:<\/p>\n<ul>\n<li>Vertical and horizontal searches can be combined with only one formula.<\/li>\n<li>You can search both right and left (or both up and down).<\/li>\n<li>There is no need to count the output range.<\/li>\n<\/ul>\n<p>At this point we only want to introduce the basic formula in brief. Online you will find many detailed tutorials with examples for various applications.<\/p>\n<p>=XLOOKUP (search criterion;search matrix;return matrix;[if-not-found];[compare modus];<br \/>\n[search modus])<\/p>\n<p>Search criterion:\u00a0\u00a0\u00a0\u00a0 Which value should be searched for?<\/p>\n<p>Search matrix:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Column\/row in which to search for the value<\/p>\n<p>Return matrix:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Column\/row from which the return value is to be used<\/p>\n<p>If_not_found:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (optional) Which value should be displayed if the search criterion is not found (instead of an error)<\/p>\n<p>Compare modus:\u00a0\u00a0 (optional) Selection &#8222;exact match&#8220;, &#8222;exact match or next higher\/lower value&#8220;, &#8222;wildcard character match\u201d<\/p>\n<p>Search modus:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (optional) Selection of search direction (from first to last or vice versa with or without consideration of a sorting)<\/p>\n<p>Disadvantage: According to the current status, XLOOKUP will initially only be usable for Office 365 and will not be rolled out in Office 2019 (or older versions). Unfortunately, it is also not backwards compatible, so that problems can occur when files are to be shared between organizations with and without a 365-subscription using the formula.<\/p>\n<h2><strong>Power Pivot<\/strong><\/h2>\n<p>Do you already work with pivot tables in Excel? This is a special type of table with the ability to display and evaluate data according to different breakdowns and viewing angles without having to make changes to the original data. In this way, large amounts of data can be condensed into manageable views. If you have not worked with pivots before, you should take a closer look at this topic to get a better overview of your data.<\/p>\n<p>But do you know Power Pivot, either? This is a function in Excel that was initially available as an add-in since version 2010 and has been installed automatically since version 2013. Basically, Power Pivot includes the same features as a &#8222;normal&#8220; pivot table, but offers additional functions and advantages:<\/p>\n<ul>\n<li>Merge multiple data sources (of different data types) into a linked data model<\/li>\n<li>No limitation of the number of records<\/li>\n<li>High speed of evaluations<\/li>\n<li>Creation of individually calculated fields<\/li>\n<li>Use of hierarchies<\/li>\n<\/ul>\n<p>One of our favorite functions: A normal pivot table uses the value field function &#8222;COUNT&#8220; to determine the number of records with contents but is not able to name the number of different contents. This is easily done by Power Pivot using the world field function &#8222;Discrete Count&#8220;.<\/p>\n<p>We hope that you enjoyed our small Excel blog series and that we were perhaps able to show you the one or other trick in using the software.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>Jessica Murawski<\/strong><\/p>\n<p>Consultant, ADCONIA GmbH<\/p>\n<\/div><\/section><\/p><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":9951,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[1,48],"tags":[],"class_list":["post-9948","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-allgemein","category-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel tricks from the daily life of a buyer \u2013 part 3 of 3<\/title>\n<meta name=\"description\" content=\"Excel tricks from the daily life of a buyer \u2013 part 3 of 3. This is now the last part of our blog series about Excel. Hope, you`ll enjoy it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel tricks from the daily life of a buyer \u2013 part 3 of 3\" \/>\n<meta property=\"og:description\" content=\"Excel tricks from the daily life of a buyer \u2013 part 3 of 3. This is now the last part of our blog series about Excel. Hope, you`ll enjoy it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/\" \/>\n<meta property=\"og:site_name\" content=\"ADCONIA\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-13T10:47:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-13T12:14:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"1124\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"feyen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"feyen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"6\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/\"},\"author\":{\"name\":\"feyen\",\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/#\\\/schema\\\/person\\\/5d183a7f0bf320d30a67ec30d3e28281\"},\"headline\":\"Excel tricks from the daily life of a buyer \u2013 part 3 of 3\",\"datePublished\":\"2020-10-13T10:47:18+00:00\",\"dateModified\":\"2020-10-13T12:14:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/\"},\"wordCount\":1054,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/adconia.de\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2020\\\/10\\\/Excel-_.jpg\",\"articleSection\":{\"1\":\"EN\"},\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/\",\"url\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/\",\"name\":\"Excel tricks from the daily life of a buyer \u2013 part 3 of 3\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/adconia.de\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2020\\\/10\\\/Excel-_.jpg\",\"datePublished\":\"2020-10-13T10:47:18+00:00\",\"dateModified\":\"2020-10-13T12:14:56+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/#\\\/schema\\\/person\\\/5d183a7f0bf320d30a67ec30d3e28281\"},\"description\":\"Excel tricks from the daily life of a buyer \u2013 part 3 of 3. This is now the last part of our blog series about Excel. Hope, you`ll enjoy it.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/#primaryimage\",\"url\":\"https:\\\/\\\/adconia.de\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2020\\\/10\\\/Excel-_.jpg\",\"contentUrl\":\"https:\\\/\\\/adconia.de\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2020\\\/10\\\/Excel-_.jpg\",\"width\":2000,\"height\":1124,\"caption\":\"Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/13\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/adconia.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel tricks from the daily life of a buyer \u2013 part 3 of 3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/adconia.de\\\/en\\\/\",\"name\":\"ADCONIA\",\"description\":\"Einkauf 4.0\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/adconia.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/#\\\/schema\\\/person\\\/5d183a7f0bf320d30a67ec30d3e28281\",\"name\":\"feyen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9ef28318eda1e76f5c877cdc6714aedd484e39f1d44d18e942e163aaf2a29f47?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9ef28318eda1e76f5c877cdc6714aedd484e39f1d44d18e942e163aaf2a29f47?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9ef28318eda1e76f5c877cdc6714aedd484e39f1d44d18e942e163aaf2a29f47?s=96&d=mm&r=g\",\"caption\":\"feyen\"},\"url\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/author\\\/feyen\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel tricks from the daily life of a buyer \u2013 part 3 of 3","description":"Excel tricks from the daily life of a buyer \u2013 part 3 of 3. This is now the last part of our blog series about Excel. Hope, you`ll enjoy it.","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:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/","og_locale":"de_DE","og_type":"article","og_title":"Excel tricks from the daily life of a buyer \u2013 part 3 of 3","og_description":"Excel tricks from the daily life of a buyer \u2013 part 3 of 3. This is now the last part of our blog series about Excel. Hope, you`ll enjoy it.","og_url":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/","og_site_name":"ADCONIA","article_published_time":"2020-10-13T10:47:18+00:00","article_modified_time":"2020-10-13T12:14:56+00:00","og_image":[{"width":2000,"height":1124,"url":"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_.jpg","type":"image\/jpeg"}],"author":"feyen","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"feyen","Gesch\u00e4tzte Lesezeit":"6\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/#article","isPartOf":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/"},"author":{"name":"feyen","@id":"https:\/\/adconia.de\/en\/#\/schema\/person\/5d183a7f0bf320d30a67ec30d3e28281"},"headline":"Excel tricks from the daily life of a buyer \u2013 part 3 of 3","datePublished":"2020-10-13T10:47:18+00:00","dateModified":"2020-10-13T12:14:56+00:00","mainEntityOfPage":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/"},"wordCount":1054,"commentCount":0,"image":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/#primaryimage"},"thumbnailUrl":"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_.jpg","articleSection":{"1":"EN"},"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/","url":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/","name":"Excel tricks from the daily life of a buyer \u2013 part 3 of 3","isPartOf":{"@id":"https:\/\/adconia.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/#primaryimage"},"image":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/#primaryimage"},"thumbnailUrl":"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_.jpg","datePublished":"2020-10-13T10:47:18+00:00","dateModified":"2020-10-13T12:14:56+00:00","author":{"@id":"https:\/\/adconia.de\/en\/#\/schema\/person\/5d183a7f0bf320d30a67ec30d3e28281"},"description":"Excel tricks from the daily life of a buyer \u2013 part 3 of 3. This is now the last part of our blog series about Excel. Hope, you`ll enjoy it.","breadcrumb":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/#primaryimage","url":"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_.jpg","contentUrl":"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-_.jpg","width":2000,"height":1124,"caption":"Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/13\/excel-tricks-from-the-daily-life-of-a-buyer-part-3-of-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/adconia.de\/en\/"},{"@type":"ListItem","position":2,"name":"Excel tricks from the daily life of a buyer \u2013 part 3 of 3"}]},{"@type":"WebSite","@id":"https:\/\/adconia.de\/en\/#website","url":"https:\/\/adconia.de\/en\/","name":"ADCONIA","description":"Einkauf 4.0","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/adconia.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Person","@id":"https:\/\/adconia.de\/en\/#\/schema\/person\/5d183a7f0bf320d30a67ec30d3e28281","name":"feyen","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/9ef28318eda1e76f5c877cdc6714aedd484e39f1d44d18e942e163aaf2a29f47?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/9ef28318eda1e76f5c877cdc6714aedd484e39f1d44d18e942e163aaf2a29f47?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9ef28318eda1e76f5c877cdc6714aedd484e39f1d44d18e942e163aaf2a29f47?s=96&d=mm&r=g","caption":"feyen"},"url":"https:\/\/adconia.de\/en\/blog\/author\/feyen\/"}]}},"_links":{"self":[{"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/posts\/9948","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/comments?post=9948"}],"version-history":[{"count":3,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/posts\/9948\/revisions"}],"predecessor-version":[{"id":9954,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/posts\/9948\/revisions\/9954"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/media\/9951"}],"wp:attachment":[{"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/media?parent=9948"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/categories?post=9948"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/tags?post=9948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}