{"id":9944,"date":"2020-10-06T16:12:49","date_gmt":"2020-10-06T14:12:49","guid":{"rendered":"https:\/\/adconia.de\/en\/?p=9944"},"modified":"2020-10-06T16:12:49","modified_gmt":"2020-10-06T14:12:49","slug":"excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3","status":"publish","type":"post","link":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/","title":{"rendered":"Excel tricks from the daily life of a buyer \u2013 part 2 of 3"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_full-25347b0a799d5b9f7058434b2a9c3182\">\n.flex_column.av-av_one_full-25347b0a799d5b9f7058434b2a9c3182{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_one_full-25347b0a799d5b9f7058434b2a9c3182 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-kfxrrssx-4dffe3f4d640fefb3a2a5698a6c7f592\">\n.avia-image-container.av-kfxrrssx-4dffe3f4d640fefb3a2a5698a6c7f592 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kfxrrssx-4dffe3f4d640fefb3a2a5698a6c7f592 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kfxrrssx-4dffe3f4d640fefb3a2a5698a6c7f592 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-9945 avia-img-lazy-loading-not-9945 avia_image ' src=\"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks.jpg\" alt='Excel-Tricks' title='Excel-Tricks'  height=\"1124\" width=\"2000\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks.jpg 2000w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks-300x169.jpg 300w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks-768x432.jpg 768w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks-1030x579.jpg 1030w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks-1500x843.jpg 1500w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks-705x396.jpg 705w, https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks-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-av_one_fifth-25347b0a799d5b9f7058434b2a9c3182\">\n.flex_column.av-av_one_fifth-25347b0a799d5b9f7058434b2a9c3182{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_one_fifth-25347b0a799d5b9f7058434b2a9c3182 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-av_two_third-f7c1061df29de8cca6b42fcf455fe4a0\">\n.flex_column.av-av_two_third-f7c1061df29de8cca6b42fcf455fe4a0{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_two_third-f7c1061df29de8cca6b42fcf455fe4a0 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-kfxrqvx0-698afe4d296a48c9e11e0e849b4d5108\">\n#top .av-special-heading.av-kfxrqvx0-698afe4d296a48c9e11e0e849b4d5108{\npadding-bottom:10px;\nfont-size:24px;\n}\nbody .av-special-heading.av-kfxrqvx0-698afe4d296a48c9e11e0e849b4d5108 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n#top #wrap_all .av-special-heading.av-kfxrqvx0-698afe4d296a48c9e11e0e849b4d5108 .av-special-heading-tag{\nfont-size:24px;\n}\n.av-special-heading.av-kfxrqvx0-698afe4d296a48c9e11e0e849b4d5108 .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-kfxrqvx0-698afe4d296a48c9e11e0e849b4d5108 .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-kfxrqvx0-698afe4d296a48c9e11e0e849b4d5108 .av-special-heading-tag{\nfont-size:0.8em;\n}\n}\n<\/style>\n<div  class='av-special-heading av-kfxrqvx0-698afe4d296a48c9e11e0e849b4d5108 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 2 of 3<\/h2><div class='av-subheading av-subheading_below'><p>Status bar, Monitoring window, Recording macros<\/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-kfxrub6w-c1811d29f5cf4c4d661dcc1d25272b5f '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>In the first blog post of this series Excel tricks we have already introduced you to our most popular shortcuts when working with Excel and gave you a tip on the topic of automatic saving in Microsoft Office. Today we would like to continue the series with the topics status bar, monitoring window and the recording of simple macros for taking over recurring commands.<\/p>\n<h2><strong>Status bar<\/strong><\/h2>\n<p>You can find the status bar at the bottom of the program window. It shows you the result of frequently used formulas without using formulas in the spreadsheet itself. For example, if you have selected a range of cells, you can see the amount, sum and average value of these selected cells (with contents) in the status bar at a glance.<\/p>\n<p>You can also customize the status bar display by right-clicking on it and selecting the desired options from the context menu.<\/p>\n<h2><strong>Monitoring window<\/strong><\/h2>\n<p>When editing a worksheet, input in one area usually affects another. Now, it can happen that the work area is so large that you cannot see the changing area during input because it is at the end of a long table or even on another worksheet. Scrolling back and forth or changing worksheets to control the effects, however, leads to losses in the performance of the processing.<\/p>\n<p>In this case, you have the option of setting up a monitoring window that hovers over the editing area. This gives you direct insight into the monitored area and the effects of your changes. To set up a monitoring window, select the &#8222;Monitoring Window&#8220; function in the ribbon &#8222;Function&#8220;. The window can be resized and moved. It is also possible to monitor multiple cells simultaneously by setting up multiple monitors within the window.<\/p>\n<h2><strong>Recording macros<\/strong><\/h2>\n<p>You have not yet dealt with the function macros in Excel, because you think that these are complicated programs, keyword Visual Basic Applications (VBA)? Can, but does not have to. By using macros, recurring steps can be automated and can thus relieve you of work in daily life. Excel offers the possibility to record a sequence of defined commands, which later, when using a defined key combination, can be executed by the software independently as often as you like, without you having to make any clicks. Although the commands are synchronized in the background into VBA, no programming knowledge is required for the simple use of the recordings. A classic example is the uniform formatting of a new worksheet: Font, font size, margins, headers and footers and so on. The corresponding function in Excel for recording macros can be found in the ribbon &#8222;View&#8220;, &#8222;Macros&#8220;, &#8222;Record Macros&#8220;.<\/p>\n<p>Please note the following remarks regarding the use of macro recordings:<\/p>\n<ul>\n<li>The use of recorded macros is only suitable for simple linear processes and cannot reproduce repetitions \/ branches in the process &#8211; this would require VBA knowledge.<\/li>\n<li>Especially at the beginning, it is recommended to create several smaller macro recordings than a long (and therefore possibly more error-prone) process.<\/li>\n<li>It is possible to choose whether a recorded macro should be available only in a certain workbook or in all Excel files.<\/li>\n<li>When selecting the key combination, make sure that it is not already being used by Excel, otherwise it will be overwritten. It is advisable to choose capital letters.<\/li>\n<li>Executed macros cannot be undone. When testing newly recorded macros, it is therefore recommended to save them in advance and, if errors occur in the macro, to close the workbook without saving again in order to undo the errors.<\/li>\n<\/ul>\n<p>We would like to motivate you to test the use of Excel macros to make your daily work easier. In addition to the option already mentioned above to format workbooks automatically according to a certain pattern, there are a number of other possibilities: The automated transfer of data from one place to another, the insertion of buttons to jump between single worksheets, the setting or abandoning of sheet or cell protection, which can be labor-intensive, especially for files with many worksheets, and much more.<\/p>\n<p><strong>Read next time from our Excel tricks:<\/strong><\/p>\n<p>SUBTOTAL: The solution for formulas in filterable tables<\/p>\n<p>XLOOKUP: Have VLOOKUP, HLOOKUP and INDEX\/MATCH become obsolete?<\/p>\n<p>Power Pivot: How to merge and compress large amounts of data<\/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":9945,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_improvement_type_select":"improve_an_existing","_thumb_yes_seoaic":false,"_frame_yes_seoaic":false,"seoaic_generate_description":"","seoaic_improve_instructions_prompt":"","seoaic_rollback_content_improvement":"","seoaic_idea_thumbnail_generator":"","thumbnail_generated":false,"thumbnail_generate_prompt":"","seoaic_article_description":"","seoaic_article_subtitles":[],"footnotes":""},"categories":[1,48],"tags":[115,116,121,122,113,117,120,118,114,123],"class_list":["post-9944","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-allgemein","category-en","tag-excel","tag-excel-hacks","tag-excel-tricks","tag-key-combinations","tag-macros","tag-microsoft-office","tag-power-pivot","tag-shortcuts","tag-vba","tag-xlookup"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel tricks from the daily life of a buyer \u2013 part 2 of 3<\/title>\n<meta name=\"description\" content=\"Excel tricks from the daily life of a buyer \u2013 part 2 of 3. We would like to motivate you to test the use of Excel macros to make your daily work easier.\" \/>\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\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-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 2 of 3\" \/>\n<meta property=\"og:description\" content=\"Excel tricks from the daily life of a buyer \u2013 part 2 of 3. We would like to motivate you to test the use of Excel macros to make your daily work easier.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/\" \/>\n<meta property=\"og:site_name\" content=\"ADCONIA\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-06T14:12:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks.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\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-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 2 of 3\",\"datePublished\":\"2020-10-06T14:12:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\\\/\"},\"wordCount\":1073,\"image\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/adconia.de\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2020\\\/10\\\/Excel-Tricks.jpg\",\"keywords\":[\"Excel\",\"Excel hacks\",\"Excel tricks\",\"key combinations\",\"Macros\",\"Microsoft Office\",\"Power Pivot\",\"Shortcuts\",\"VBA\",\"XLOOKUP\"],\"articleSection\":{\"1\":\"EN\"},\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\\\/\",\"url\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\\\/\",\"name\":\"Excel tricks from the daily life of a buyer \u2013 part 2 of 3\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/adconia.de\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2020\\\/10\\\/Excel-Tricks.jpg\",\"datePublished\":\"2020-10-06T14:12:49+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/#\\\/schema\\\/person\\\/5d183a7f0bf320d30a67ec30d3e28281\"},\"description\":\"Excel tricks from the daily life of a buyer \u2013 part 2 of 3. We would like to motivate you to test the use of Excel macros to make your daily work easier.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\\\/#primaryimage\",\"url\":\"https:\\\/\\\/adconia.de\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2020\\\/10\\\/Excel-Tricks.jpg\",\"contentUrl\":\"https:\\\/\\\/adconia.de\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2020\\\/10\\\/Excel-Tricks.jpg\",\"width\":2000,\"height\":1124,\"caption\":\"Excel-Tricks\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/adconia.de\\\/en\\\/blog\\\/2020\\\/10\\\/06\\\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-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 2 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 2 of 3","description":"Excel tricks from the daily life of a buyer \u2013 part 2 of 3. We would like to motivate you to test the use of Excel macros to make your daily work easier.","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\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/","og_locale":"de_DE","og_type":"article","og_title":"Excel tricks from the daily life of a buyer \u2013 part 2 of 3","og_description":"Excel tricks from the daily life of a buyer \u2013 part 2 of 3. We would like to motivate you to test the use of Excel macros to make your daily work easier.","og_url":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/","og_site_name":"ADCONIA","article_published_time":"2020-10-06T14:12:49+00:00","og_image":[{"width":2000,"height":1124,"url":"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks.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\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/#article","isPartOf":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-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 2 of 3","datePublished":"2020-10-06T14:12:49+00:00","mainEntityOfPage":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/"},"wordCount":1073,"image":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/#primaryimage"},"thumbnailUrl":"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks.jpg","keywords":["Excel","Excel hacks","Excel tricks","key combinations","Macros","Microsoft Office","Power Pivot","Shortcuts","VBA","XLOOKUP"],"articleSection":{"1":"EN"},"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/","url":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/","name":"Excel tricks from the daily life of a buyer \u2013 part 2 of 3","isPartOf":{"@id":"https:\/\/adconia.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/#primaryimage"},"image":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/#primaryimage"},"thumbnailUrl":"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks.jpg","datePublished":"2020-10-06T14:12:49+00:00","author":{"@id":"https:\/\/adconia.de\/en\/#\/schema\/person\/5d183a7f0bf320d30a67ec30d3e28281"},"description":"Excel tricks from the daily life of a buyer \u2013 part 2 of 3. We would like to motivate you to test the use of Excel macros to make your daily work easier.","breadcrumb":{"@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-of-3\/#primaryimage","url":"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks.jpg","contentUrl":"https:\/\/adconia.de\/en\/wp-content\/uploads\/sites\/5\/2020\/10\/Excel-Tricks.jpg","width":2000,"height":1124,"caption":"Excel-Tricks"},{"@type":"BreadcrumbList","@id":"https:\/\/adconia.de\/en\/blog\/2020\/10\/06\/excel-tricks-from-the-daily-life-of-a-buyer-part-2-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 2 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\/9944","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=9944"}],"version-history":[{"count":2,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/posts\/9944\/revisions"}],"predecessor-version":[{"id":9947,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/posts\/9944\/revisions\/9947"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/media\/9945"}],"wp:attachment":[{"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/media?parent=9944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/categories?post=9944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adconia.de\/en\/wp-json\/wp\/v2\/tags?post=9944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}