{"id":11655,"date":"2019-12-18T07:08:26","date_gmt":"2019-12-18T06:08:26","guid":{"rendered":"https:\/\/ms-office-training.de\/sverweis-und-wverweis\/"},"modified":"2025-12-07T08:06:06","modified_gmt":"2025-12-07T07:06:06","slug":"apply-vreference-and-wreference-in-excel","status":"publish","type":"post","link":"https:\/\/ms-office-training.de\/en\/apply-vreference-and-wreference-in-excel\/","title":{"rendered":"The Sreference and the Wreference in Excel"},"content":{"rendered":"<p><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 has-pattern-background has-mask-background hundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;--awb-margin-bottom:0px;\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-column-content-centered\"><div class=\"fusion-column-content\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-1 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"custom_html-110\" class=\"widget_text widget widget_custom_html\" style=\"padding: 0px 50px;border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- head-2026 -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"6080043400\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><div <span style=\"font-size: x-small;\"><span style=\"font-size: x-small;\">Anzeige<\/span><\/div><\/center><\/div><\/div><style type=\"text\/css\" data-id=\"text-78\">@media (max-width: 768px){#text-78{text-align:initial !important;}}<\/style><div id=\"text-78\" class=\"fusion-widget-mobile-align-initial fusion-widget-align-center widget widget_text\" style=\"border-style: solid;text-align: center;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><p><span style=\"display: block; color: #747474; font-size: 10px; margin-top: 15px; line-height: 1.2;\"><br \/>\nTransparenz: Um diesen Blog kostenlos anbieten zu k\u00f6nnen, nutzen wir Affiliate-Links. Klickst du darauf und kaufst etwas, bekommen wir eine kleine Verg\u00fctung. Der Preis bleibt f\u00fcr dich gleich. Win-Win!<br \/>\n<\/span><\/p>\n<\/div>\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-2 hundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-small-visibility fusion-no-medium-visibility\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-right:50px;--awb-padding-left:60px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-column-no-min-height\" style=\"--awb-padding-top:8px;--awb-padding-right:8px;--awb-padding-bottom:8px;--awb-padding-left:8px;--awb-bg-color:#00d6fc;--awb-bg-color-hover:#00d6fc;--awb-bg-size:cover;\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-title title fusion-title-1 fusion-sep-none fusion-title-text fusion-title-size-one\" style=\"--awb-text-color:#ffffff;--awb-margin-top-small:0px;--awb-margin-right-small:0px;--awb-margin-bottom-small:5px;--awb-margin-left-small:0px;--awb-font-size:33px;\"><h1 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:33;line-height:1.2;\">The Sreference and the Wreference in Excel<\/h1><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-2 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 50px;\"><div id=\"icl_lang_sel_widget-2\" class=\"widget widget_icl_lang_sel_widget\">\n<div role=\"navigation\" aria-label=\"Language Switcher\" class=\"wpml-ls-sidebars-avada-custom-sidebar-sprachumschalter wpml-ls wpml-ls-legacy-list-horizontal\">\n\t<ul><li class=\"wpml-ls-slot-avada-custom-sidebar-sprachumschalter wpml-ls-item wpml-ls-item-en wpml-ls-current-language wpml-ls-first-item wpml-ls-item-legacy-list-horizontal\">\n\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/\" hreflang=\"en\" lang=\"en\" class=\"wpml-ls-link\" aria-current=\"page\" aria-label=\"Switch to English\" title=\"Switch to English\">\n\t\t\t\t\t                                    <img decoding=\"async\"\n            class=\"wpml-ls-flag\"\n            src=\"https:\/\/ms-office-training.de\/wp-content\/plugins\/sitepress-multilingual-cms\/res\/flags\/en.png\"\n            alt=\"\"\n            loading=\"lazy\"\n            width=18\n            height=12\n    \/><span class=\"wpml-ls-native\">English<\/span><\/a>\n\t\t\t<\/li><li class=\"wpml-ls-slot-avada-custom-sidebar-sprachumschalter wpml-ls-item wpml-ls-item-de wpml-ls-last-item wpml-ls-item-legacy-list-horizontal\">\n\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/\" hreflang=\"de\" lang=\"de\" class=\"wpml-ls-link\" aria-label=\"Switch to German\" title=\"Switch to German\">\n\t\t\t\t\t                                    <img decoding=\"async\"\n            class=\"wpml-ls-flag\"\n            src=\"https:\/\/ms-office-training.de\/wp-content\/plugins\/sitepress-multilingual-cms\/res\/flags\/de.png\"\n            alt=\"\"\n            loading=\"lazy\"\n            width=18\n            height=12\n    \/><span class=\"wpml-ls-display\">German<\/span><\/a>\n\t\t\t<\/li><\/ul>\n<\/div>\n<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-text fusion-text-1\"><p>If you have created a table with many records in Excel, you may eventually come to a point where certain records should be automatically retrieved from this table and pasted into another table for a better overview.<\/p>\n<p>So what do you do?<\/p>\n<\/div><div class=\"fusion-text fusion-text-2\"><p>Of course you have the possibility to create one or more stand-alone tables with the Pivot function, and of course have a great variety of filter options at the same time.<\/p>\n<p>But sometimes it does not work the way you had imagined.<\/p>\n<p>And this is exactly where the S-reference and W-reference functions come into play.<\/p>\n<p>How these two variants work and how to use them I would like to shed some light on in this article.<\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-3 fusion_builder_column_3_4 3_4 fusion-three-fourth fusion-column-first\" style=\"--awb-bg-size:cover;width:75%;width:calc(75% - ( ( 4% ) * 0.75 ) );margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><span class=\" fusion-imageframe imageframe-none imageframe-1 hover-type-none\" style=\"border-radius:5px;\"><a class=\"fusion-no-lightbox\" href=\"https:\/\/ms-office-training.de\/en\/s-reference-w-reference\" target=\"_self\" aria-label=\"Sverweis_Wverweis2\"><img decoding=\"async\" width=\"887\" height=\"585\" alt=\"s-reference and w-reference in excel\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Sverweis_Wverweis2.jpg\" class=\"img-responsive wp-image-11627\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Sverweis_Wverweis2-400x264.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Sverweis_Wverweis2.jpg 887w\" sizes=\"(max-width: 768px) 100vw, 887px\" \/><\/a><\/span><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-4 fusion_builder_column_1_4 1_4 fusion-one-fourth fusion-column-last\" style=\"--awb-bg-size:cover;width:25%;width:calc(25% - ( ( 4% ) * 0.25 ) );\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-3 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"categories-14\" class=\"widget widget_categories\"><div class=\"heading\"><h4 class=\"widget-title\">Topic Overview<\/h4><\/div><form action=\"https:\/\/ms-office-training.de\/en\/\" method=\"get\"><label class=\"screen-reader-text\" for=\"cat\">Topic Overview<\/label><select  name='cat' id='cat' class='postform'>\n\t<option value='-1'>Select Category<\/option>\n\t<option class=\"level-0\" value=\"3508\">Amazon&nbsp;&nbsp;(16)<\/option>\n\t<option class=\"level-0\" value=\"236\">Android \/ iOS&nbsp;&nbsp;(33)<\/option>\n\t<option class=\"level-0\" value=\"3502\">Artificial intelligence&nbsp;&nbsp;(92)<\/option>\n\t<option class=\"level-0\" value=\"3500\">AutoGPT&nbsp;&nbsp;(22)<\/option>\n\t<option class=\"level-0\" value=\"3521\">Career&nbsp;&nbsp;(54)<\/option>\n\t<option class=\"level-0\" value=\"3501\">ChatGPT&nbsp;&nbsp;(35)<\/option>\n\t<option class=\"level-0\" value=\"3648\">Daily AI-News&nbsp;&nbsp;(19)<\/option>\n\t<option class=\"level-0\" value=\"300\">Data Protection&nbsp;&nbsp;(92)<\/option>\n\t<option class=\"level-0\" value=\"214\">Google&nbsp;&nbsp;(69)<\/option>\n\t<option class=\"level-0\" value=\"282\">Guest Article&nbsp;&nbsp;(17)<\/option>\n\t<option class=\"level-0\" value=\"3602\">Hardware&nbsp;&nbsp;(39)<\/option>\n\t<option class=\"level-0\" value=\"3306\">Homeoffice&nbsp;&nbsp;(64)<\/option>\n\t<option class=\"level-0\" value=\"1200\">Internet, Finance &amp; Shopping&nbsp;&nbsp;(94)<\/option>\n\t<option class=\"level-0\" value=\"3647\">Kurioses&nbsp;&nbsp;(3)<\/option>\n\t<option class=\"level-0\" value=\"3506\">LLaMa&nbsp;&nbsp;(24)<\/option>\n\t<option class=\"level-0\" value=\"3544\">Mac OS&nbsp;&nbsp;(8)<\/option>\n\t<option class=\"level-0\" value=\"211\">Microsoft Excel&nbsp;&nbsp;(45)<\/option>\n\t<option class=\"level-0\" value=\"762\">Microsoft Office&nbsp;&nbsp;(106)<\/option>\n\t<option class=\"level-0\" value=\"237\">Microsoft Outlook&nbsp;&nbsp;(30)<\/option>\n\t<option class=\"level-0\" value=\"259\">Microsoft PowerPoint&nbsp;&nbsp;(13)<\/option>\n\t<option class=\"level-0\" value=\"3464\">Microsoft Teams&nbsp;&nbsp;(12)<\/option>\n\t<option class=\"level-0\" value=\"221\">Microsoft Word&nbsp;&nbsp;(29)<\/option>\n\t<option class=\"level-0\" value=\"3358\">Office 365&nbsp;&nbsp;(81)<\/option>\n\t<option class=\"level-0\" value=\"1257\">Product Tests&nbsp;&nbsp;(18)<\/option>\n\t<option class=\"level-0\" value=\"218\">SEO&nbsp;&nbsp;(12)<\/option>\n\t<option class=\"level-0\" value=\"2875\">Shorts &amp; Tutorials&nbsp;&nbsp;(319)<\/option>\n\t<option class=\"level-0\" value=\"3667\">Social Media&nbsp;&nbsp;(7)<\/option>\n\t<option class=\"level-0\" value=\"3601\">Software&nbsp;&nbsp;(41)<\/option>\n\t<option class=\"level-0\" value=\"3655\">Streaming&nbsp;&nbsp;(8)<\/option>\n\t<option class=\"level-0\" value=\"3503\">TruthGPT&nbsp;&nbsp;(24)<\/option>\n\t<option class=\"level-0\" value=\"210\">Uncategorized&nbsp;&nbsp;(105)<\/option>\n\t<option class=\"level-0\" value=\"246\">Windows 10\/11\/12&nbsp;&nbsp;(47)<\/option>\n\t<option class=\"level-0\" value=\"215\">Wordpress&nbsp;&nbsp;(14)<\/option>\n<\/select>\n<\/form><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\n( ( dropdownId ) => {\n\tconst dropdown = document.getElementById( dropdownId );\n\tfunction onSelectChange() {\n\t\tsetTimeout( () => {\n\t\t\tif ( 'escape' === dropdown.dataset.lastkey ) {\n\t\t\t\treturn;\n\t\t\t}\n\t\t\tif ( dropdown.value && parseInt( dropdown.value ) > 0 && dropdown instanceof HTMLSelectElement ) {\n\t\t\t\tdropdown.parentElement.submit();\n\t\t\t}\n\t\t}, 250 );\n\t}\n\tfunction onKeyUp( event ) {\n\t\tif ( 'Escape' === event.key ) {\n\t\t\tdropdown.dataset.lastkey = 'escape';\n\t\t} else {\n\t\t\tdelete dropdown.dataset.lastkey;\n\t\t}\n\t}\n\tfunction onClick() {\n\t\tdelete dropdown.dataset.lastkey;\n\t}\n\tdropdown.addEventListener( 'keyup', onKeyUp );\n\tdropdown.addEventListener( 'click', onClick );\n\tdropdown.addEventListener( 'change', onSelectChange );\n})( \"cat\" );\n\n\/\/# sourceURL=WP_Widget_Categories%3A%3Awidget\n\/* ]]> *\/\n<\/script>\n<\/div><div id=\"custom_html-51\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- inside article -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"5246870081\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\r\n<div <span style=\"font-size: x-small;\"><span style=\"font-size: x-small;\">Anzeige<\/span><\/div><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-5 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget fusion-widget-element fusion-widget-area fusion-content-widget-area wpWidget-1 wp_widget_recent_posts\" style=\"--awb-fusion-border-size:0px;--awb-fusion-border-style:solid;\">\n\t\t<div class=\"widget widget_recent_entries\">\n\t\t<div class=\"heading\"><h4 class=\"widget-title\">Latest Posts<\/h4><\/div>\n\t\t<ul>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/historic-softbank-deal-starting-signal-for-eu-regulation-the-ai-news-on-new-years-eve\/\">Historic SoftBank deal &#038; starting signal for EU regulation: The AI \u200b\u200bnews on New Year&#8217;s Eve<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/when-your-own-voice-becomes-a-weapon-the-rise-of-ai-powered-audio-fraud\/\">When your own voice becomes a weapon: The rise of AI-powered audio fraud<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/december-26-2025-record-workload-during-the-holidays-final-sprint-in-the-mega-deal\/\">December 26, 2025: Record workload during the holidays &#038; final sprint in the mega-deal<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\">Ad-free home network: Install Pi-hole on Windows<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/december-23-2025-900-billion-valuation-in-sight-googles-flash-launch\/\">December 23, 2025: $900 billion valuation in sight &#038; Google&#8217;s Flash launch<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t<\/ul>\n\n\t\t<\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-4 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"text-80\" class=\"widget widget_text\" style=\"border-style: solid;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><h2 style=\"text-align: center; font-size: 25px;\"><strong>JETZT NEU BEI UNS:<\/strong><\/h2>\r\n<p style=\"text-align: center;\">VERSICHERUNGEN &amp; FINANZEN OPTIMIEREN<\/p>\r\n<div class=\"fusion-aligncenter\"><a class=\"fusion-button button-flat button-xlarge button-default fusion-button-default button-1 fusion-button-default-span fusion-button-default-type\" style=\"--button_margin-right:20px;--button_margin-bottom:20px;--button_margin-left:20px;\" target=\"_blank\" rel=\"noopener noreferrer\" href=\"https:\/\/ms-office-training.de\/finanzrechner\/\"><span class=\"fusion-button-text awb-button__text awb-button__text--default fusion-button-text-right\">FINANZ-COCKPIT<\/span><span class=\"fusion-button-icon-divider button-icon-divider-right\"><i class=\"fa-coins fas awb-button__icon awb-button__icon--default\" aria-hidden=\"true\"><\/i><\/span><\/a><\/div>\r\n<p style=\"text-align: center;\"><\/p><\/div>\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-5 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-3 has-pattern-background has-mask-background hundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-large-visibility\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-6 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-column-no-min-height\" style=\"--awb-padding-top:8px;--awb-padding-right:8px;--awb-padding-bottom:8px;--awb-padding-left:8px;--awb-bg-color:#00d6fc;--awb-bg-color-hover:#00d6fc;--awb-bg-size:cover;\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-title title fusion-title-2 fusion-sep-none fusion-title-text fusion-title-size-one\" style=\"--awb-text-color:#ffffff;--awb-margin-top-small:0px;--awb-margin-right-small:0px;--awb-margin-bottom-small:5px;--awb-margin-left-small:0px;--awb-font-size:33px;\"><h1 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:33;line-height:1.2;\">The Sreference and the Wreference in Excel<\/h1><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-7 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-6 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 50px;\"><div id=\"icl_lang_sel_widget-2\" class=\"widget widget_icl_lang_sel_widget\">\n<div role=\"navigation\" aria-label=\"Language Switcher\" class=\"wpml-ls-sidebars-avada-custom-sidebar-sprachumschalter wpml-ls wpml-ls-legacy-list-horizontal\">\n\t<ul><li class=\"wpml-ls-slot-avada-custom-sidebar-sprachumschalter wpml-ls-item wpml-ls-item-en wpml-ls-current-language wpml-ls-first-item wpml-ls-item-legacy-list-horizontal\">\n\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/\" hreflang=\"en\" lang=\"en\" class=\"wpml-ls-link\" aria-current=\"page\" aria-label=\"Switch to English\" title=\"Switch to English\">\n\t\t\t\t\t                                    <img decoding=\"async\"\n            class=\"wpml-ls-flag\"\n            src=\"https:\/\/ms-office-training.de\/wp-content\/plugins\/sitepress-multilingual-cms\/res\/flags\/en.png\"\n            alt=\"\"\n            loading=\"lazy\"\n            width=18\n            height=12\n    \/><span class=\"wpml-ls-native\">English<\/span><\/a>\n\t\t\t<\/li><li class=\"wpml-ls-slot-avada-custom-sidebar-sprachumschalter wpml-ls-item wpml-ls-item-de wpml-ls-last-item wpml-ls-item-legacy-list-horizontal\">\n\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/\" hreflang=\"de\" lang=\"de\" class=\"wpml-ls-link\" aria-label=\"Switch to German\" title=\"Switch to German\">\n\t\t\t\t\t                                    <img decoding=\"async\"\n            class=\"wpml-ls-flag\"\n            src=\"https:\/\/ms-office-training.de\/wp-content\/plugins\/sitepress-multilingual-cms\/res\/flags\/de.png\"\n            alt=\"\"\n            loading=\"lazy\"\n            width=18\n            height=12\n    \/><span class=\"wpml-ls-display\">German<\/span><\/a>\n\t\t\t<\/li><\/ul>\n<\/div>\n<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-text fusion-text-3\"><p>If you have created a table with many records in Excel, you may eventually come to a point where certain records should be automatically retrieved from this table and pasted into another table for a better overview.<\/p>\n<p>So what do you do?<\/p>\n<\/div><div class=\"fusion-text fusion-text-4\"><p>Of course you have the possibility to create one or more stand-alone tables with the Pivot function, and of course have a great variety of filter options at the same time.<\/p>\n<p>But sometimes it does not work the way you had imagined.<\/p>\n<p>And this is exactly where the S-reference and W-reference functions come into play.<\/p>\n<p>How these two variants work and how to use them I would like to shed some light on in this article.<\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-8 fusion_builder_column_3_4 3_4 fusion-three-fourth fusion-column-first\" style=\"--awb-bg-size:cover;width:75%;width:calc(75% - ( ( 4% ) * 0.75 ) );margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><span class=\" fusion-imageframe imageframe-none imageframe-2 hover-type-none\" style=\"border-radius:5px;\"><a class=\"fusion-no-lightbox\" href=\"https:\/\/ms-office-training.de\/en\/s-reference-w-reference\" target=\"_self\" aria-label=\"Sverweis_Wverweis2\"><img decoding=\"async\" width=\"887\" height=\"585\" alt=\"s-reference and w-reference in excel\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Sverweis_Wverweis2.jpg\" class=\"img-responsive wp-image-11627\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Sverweis_Wverweis2-400x264.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Sverweis_Wverweis2.jpg 887w\" sizes=\"(max-width: 768px) 100vw, 887px\" \/><\/a><\/span><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-9 fusion_builder_column_1_4 1_4 fusion-one-fourth fusion-column-last\" style=\"--awb-bg-size:cover;width:25%;width:calc(25% - ( ( 4% ) * 0.25 ) );\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-7 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"categories-14\" class=\"widget widget_categories\"><div class=\"heading\"><h4 class=\"widget-title\">Topic Overview<\/h4><\/div><form action=\"https:\/\/ms-office-training.de\/en\/\" method=\"get\"><label class=\"screen-reader-text\" for=\"categories-dropdown-14\">Topic Overview<\/label><select  name='cat' id='categories-dropdown-14' class='postform'>\n\t<option value='-1'>Select Category<\/option>\n\t<option class=\"level-0\" value=\"3508\">Amazon&nbsp;&nbsp;(16)<\/option>\n\t<option class=\"level-0\" value=\"236\">Android \/ iOS&nbsp;&nbsp;(33)<\/option>\n\t<option class=\"level-0\" value=\"3502\">Artificial intelligence&nbsp;&nbsp;(92)<\/option>\n\t<option class=\"level-0\" value=\"3500\">AutoGPT&nbsp;&nbsp;(22)<\/option>\n\t<option class=\"level-0\" value=\"3521\">Career&nbsp;&nbsp;(54)<\/option>\n\t<option class=\"level-0\" value=\"3501\">ChatGPT&nbsp;&nbsp;(35)<\/option>\n\t<option class=\"level-0\" value=\"3648\">Daily AI-News&nbsp;&nbsp;(19)<\/option>\n\t<option class=\"level-0\" value=\"300\">Data Protection&nbsp;&nbsp;(92)<\/option>\n\t<option class=\"level-0\" value=\"214\">Google&nbsp;&nbsp;(69)<\/option>\n\t<option class=\"level-0\" value=\"282\">Guest Article&nbsp;&nbsp;(17)<\/option>\n\t<option class=\"level-0\" value=\"3602\">Hardware&nbsp;&nbsp;(39)<\/option>\n\t<option class=\"level-0\" value=\"3306\">Homeoffice&nbsp;&nbsp;(64)<\/option>\n\t<option class=\"level-0\" value=\"1200\">Internet, Finance &amp; Shopping&nbsp;&nbsp;(94)<\/option>\n\t<option class=\"level-0\" value=\"3647\">Kurioses&nbsp;&nbsp;(3)<\/option>\n\t<option class=\"level-0\" value=\"3506\">LLaMa&nbsp;&nbsp;(24)<\/option>\n\t<option class=\"level-0\" value=\"3544\">Mac OS&nbsp;&nbsp;(8)<\/option>\n\t<option class=\"level-0\" value=\"211\">Microsoft Excel&nbsp;&nbsp;(45)<\/option>\n\t<option class=\"level-0\" value=\"762\">Microsoft Office&nbsp;&nbsp;(106)<\/option>\n\t<option class=\"level-0\" value=\"237\">Microsoft Outlook&nbsp;&nbsp;(30)<\/option>\n\t<option class=\"level-0\" value=\"259\">Microsoft PowerPoint&nbsp;&nbsp;(13)<\/option>\n\t<option class=\"level-0\" value=\"3464\">Microsoft Teams&nbsp;&nbsp;(12)<\/option>\n\t<option class=\"level-0\" value=\"221\">Microsoft Word&nbsp;&nbsp;(29)<\/option>\n\t<option class=\"level-0\" value=\"3358\">Office 365&nbsp;&nbsp;(81)<\/option>\n\t<option class=\"level-0\" value=\"1257\">Product Tests&nbsp;&nbsp;(18)<\/option>\n\t<option class=\"level-0\" value=\"218\">SEO&nbsp;&nbsp;(12)<\/option>\n\t<option class=\"level-0\" value=\"2875\">Shorts &amp; Tutorials&nbsp;&nbsp;(319)<\/option>\n\t<option class=\"level-0\" value=\"3667\">Social Media&nbsp;&nbsp;(7)<\/option>\n\t<option class=\"level-0\" value=\"3601\">Software&nbsp;&nbsp;(41)<\/option>\n\t<option class=\"level-0\" value=\"3655\">Streaming&nbsp;&nbsp;(8)<\/option>\n\t<option class=\"level-0\" value=\"3503\">TruthGPT&nbsp;&nbsp;(24)<\/option>\n\t<option class=\"level-0\" value=\"210\">Uncategorized&nbsp;&nbsp;(105)<\/option>\n\t<option class=\"level-0\" value=\"246\">Windows 10\/11\/12&nbsp;&nbsp;(47)<\/option>\n\t<option class=\"level-0\" value=\"215\">Wordpress&nbsp;&nbsp;(14)<\/option>\n<\/select>\n<\/form><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\n( ( dropdownId ) => {\n\tconst dropdown = document.getElementById( dropdownId );\n\tfunction onSelectChange() {\n\t\tsetTimeout( () => {\n\t\t\tif ( 'escape' === dropdown.dataset.lastkey ) {\n\t\t\t\treturn;\n\t\t\t}\n\t\t\tif ( dropdown.value && parseInt( dropdown.value ) > 0 && dropdown instanceof HTMLSelectElement ) {\n\t\t\t\tdropdown.parentElement.submit();\n\t\t\t}\n\t\t}, 250 );\n\t}\n\tfunction onKeyUp( event ) {\n\t\tif ( 'Escape' === event.key ) {\n\t\t\tdropdown.dataset.lastkey = 'escape';\n\t\t} else {\n\t\t\tdelete dropdown.dataset.lastkey;\n\t\t}\n\t}\n\tfunction onClick() {\n\t\tdelete dropdown.dataset.lastkey;\n\t}\n\tdropdown.addEventListener( 'keyup', onKeyUp );\n\tdropdown.addEventListener( 'click', onClick );\n\tdropdown.addEventListener( 'change', onSelectChange );\n})( \"categories-dropdown-14\" );\n\n\/\/# sourceURL=WP_Widget_Categories%3A%3Awidget\n\/* ]]> *\/\n<\/script>\n<\/div><div id=\"custom_html-51\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- inside article -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"5246870081\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\r\n<div <span style=\"font-size: x-small;\"><span style=\"font-size: x-small;\">Anzeige<\/span><\/div><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-10 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget fusion-widget-element fusion-widget-area fusion-content-widget-area wpWidget-2 wp_widget_recent_posts\" style=\"--awb-fusion-border-size:0px;--awb-fusion-border-style:solid;\">\n\t\t<div class=\"widget widget_recent_entries\">\n\t\t<div class=\"heading\"><h4 class=\"widget-title\">Latest Posts<\/h4><\/div>\n\t\t<ul>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/historic-softbank-deal-starting-signal-for-eu-regulation-the-ai-news-on-new-years-eve\/\">Historic SoftBank deal &#038; starting signal for EU regulation: The AI \u200b\u200bnews on New Year&#8217;s Eve<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/when-your-own-voice-becomes-a-weapon-the-rise-of-ai-powered-audio-fraud\/\">When your own voice becomes a weapon: The rise of AI-powered audio fraud<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/december-26-2025-record-workload-during-the-holidays-final-sprint-in-the-mega-deal\/\">December 26, 2025: Record workload during the holidays &#038; final sprint in the mega-deal<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\">Ad-free home network: Install Pi-hole on Windows<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/december-23-2025-900-billion-valuation-in-sight-googles-flash-launch\/\">December 23, 2025: $900 billion valuation in sight &#038; Google&#8217;s Flash launch<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t<\/ul>\n\n\t\t<\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-8 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"text-80\" class=\"widget widget_text\" style=\"border-style: solid;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><h2 style=\"text-align: center; font-size: 25px;\"><strong>JETZT NEU BEI UNS:<\/strong><\/h2>\r\n<p style=\"text-align: center;\">VERSICHERUNGEN &amp; FINANZEN OPTIMIEREN<\/p>\r\n<div class=\"fusion-aligncenter\"><a class=\"fusion-button button-flat button-xlarge button-default fusion-button-default button-2 fusion-button-default-span fusion-button-default-type\" style=\"--button_margin-right:20px;--button_margin-bottom:20px;--button_margin-left:20px;\" target=\"_blank\" rel=\"noopener noreferrer\" href=\"https:\/\/ms-office-training.de\/finanzrechner\/\"><span class=\"fusion-button-text awb-button__text awb-button__text--default fusion-button-text-right\">FINANZ-COCKPIT<\/span><span class=\"fusion-button-icon-divider button-icon-divider-right\"><i class=\"fa-coins fas awb-button__icon awb-button__icon--default\" aria-hidden=\"true\"><\/i><\/span><\/a><\/div>\r\n<p style=\"text-align: center;\"><\/p><\/div>\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-9 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-4 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-small-visibility fusion-no-medium-visibility\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-right:50px;--awb-padding-left:60px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-11 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-padding-top:8px;--awb-padding-right:8px;--awb-padding-bottom:8px;--awb-padding-left:8px;--awb-bg-color:#00d6fc;--awb-bg-color-hover:#00d6fc;--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-title title fusion-title-3 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"--awb-margin-top-small:0px;--awb-margin-right-small:0px;--awb-margin-bottom-small:5px;--awb-margin-left-small:0px;--awb-font-size:30px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:30;line-height:1.2;\"><div class=\"fusion-menu-anchor\" id=\"Mark1\"><\/div>1. Definition S-reference and W-reference<\/p><\/h2><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-5 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-large-visibility\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-right:10px;--awb-padding-left:10px;--awb-margin-top:20px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-12 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-padding-top:8px;--awb-padding-right:8px;--awb-padding-bottom:8px;--awb-padding-left:8px;--awb-bg-color:#00d6fc;--awb-bg-color-hover:#00d6fc;--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-title title fusion-title-4 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"--awb-margin-top-small:0px;--awb-margin-right-small:0px;--awb-margin-bottom-small:5px;--awb-margin-left-small:0px;--awb-font-size:30px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:30;line-height:1.2;\"><div class=\"fusion-menu-anchor\" id=\"Mark1\"><\/div>1. Definition S-reference and W-reference<\/p><\/h2><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-6 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-small-visibility fusion-no-medium-visibility\" style=\"--awb-background-position:left top;--awb-border-sizes-top:1px;--awb-border-sizes-bottom:1px;--awb-border-sizes-left:0px;--awb-border-sizes-right:0px;--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:20px;--awb-padding-right:50px;--awb-padding-bottom:20px;--awb-padding-left:60px;--awb-margin-bottom:60px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-13 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-5\"><p>In general we first clarify the definition of the S-reference and W-reference.<\/p>\n<p><strong>The S-reference:<\/strong><\/p>\n<p>The <em>&#8220;S&#8221;<\/em> stands for &#8220;vertical&#8221; and describes the search direction in which Excel searches for a specific term.<br \/>\nWhat does this mean in columns for a term is searched, and if this is found is searched in the appropriate line to determine the coordinate.<\/p>\n<p>see picture: <em>(click to enlarge)<\/em><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-14 fusion_builder_column_3_4 3_4 fusion-three-fourth fusion-column-first\" style=\"--awb-bg-size:cover;width:74%; margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><div class=\"awb-image-frame awb-image-frame-3 imageframe-liftup imageframe-3\"><span class=\" fusion-imageframe imageframe-none imageframe-3\" style=\"border-radius:5px;\"><a href=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Senkrechte-Suchrichtung-1024x470.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[b8343171840336417f0]\" data-title=\"Senkrechte Suchrichtung\" title=\"Senkrechte Suchrichtung\"><img decoding=\"async\" width=\"1176\" height=\"540\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Senkrechte-Suchrichtung.jpg\" alt class=\"img-responsive wp-image-11634\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Senkrechte-Suchrichtung-400x184.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Senkrechte-Suchrichtung.jpg 1176w\" sizes=\"(max-width: 768px) 100vw, 1176px\" \/><\/a><\/span><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-15 fusion_builder_column_1_4 1_4 fusion-one-fourth fusion-column-last\" style=\"--awb-bg-size:cover;width:22%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-10 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"custom_html-62\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- inside article -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"5246870081\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><div <span style=\" font-size: x-small;\"><span style=\"font-size: x-small;\">Advertisement<\/span><\/div><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-16 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-6\"><p><strong>The W reference:<\/strong><\/p>\n<p>The &#8220;W&#8221; stands for &#8220;horizontal&#8221; and also describes the search direction in which Excel searches for a specific term.<br \/>\nOnly here is not determined first in columns but in lines for a specific term to determine the coordinate.<\/p>\n<p>see picture: <em>(click to enlarge)<\/em><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-17 fusion_builder_column_3_4 3_4 fusion-three-fourth fusion-column-first\" style=\"--awb-bg-size:cover;width:75%;width:calc(75% - ( ( 4% ) * 0.75 ) );margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><div class=\"awb-image-frame awb-image-frame-4 imageframe-liftup imageframe-4\"><span class=\" fusion-imageframe imageframe-none imageframe-4\" style=\"border-radius:5px;\"><a href=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Waagerechte-Suchrichtung.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[571e0c5b733497d0e90]\" data-title=\"Waagerechte Suchrichtung\" title=\"Waagerechte Suchrichtung\"><img decoding=\"async\" width=\"1119\" height=\"524\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Waagerechte-Suchrichtung.jpg\" alt class=\"img-responsive wp-image-11636\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Waagerechte-Suchrichtung-400x187.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Waagerechte-Suchrichtung.jpg 1119w\" sizes=\"(max-width: 768px) 100vw, 1119px\" \/><\/a><\/span><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-18 fusion_builder_column_1_4 1_4 fusion-one-fourth fusion-column-last\" style=\"--awb-bg-size:cover;width:25%;width:calc(25% - ( ( 4% ) * 0.25 ) );\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-11 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"custom_html-63\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><!-- START ADVERTISER: WebHosting UK Com Ltd. from awin.com --><a rel=\"sponsored nofollow noopener\" href=\"https:\/\/www.awin1.com\/cread.php?s=3112048&amp;v=27692&amp;q=434591&amp;r=1354483\" target=\"_blank\"><img decoding=\"async\" src=\"https:\/\/www.awin1.com\/cshow.php?s=3112048&v=27692&q=434591&r=1354483\" border=\"0\">\r\n<\/a><!-- END ADVERTISER: WebHosting UK Com Ltd. from awin.com -->\r\n<div <span style=\"font-size: x-small;\"><span style=\"font-size: x-small; color: #00d6fc;\">Ads<\/span><\/div><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-7 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-large-visibility\" style=\"--awb-background-position:left top;--awb-border-sizes-top:1px;--awb-border-sizes-bottom:1px;--awb-border-sizes-left:0px;--awb-border-sizes-right:0px;--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:20px;--awb-padding-right:10px;--awb-padding-bottom:20px;--awb-padding-left:10px;--awb-margin-bottom:60px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-19 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-7\"><p>In general we first clarify the definition of the S-reference and W-reference.<\/p>\n<p><strong>The S-reference:<\/strong><\/p>\n<p>The <em>&#8220;S&#8221;<\/em> stands for &#8220;vertical&#8221; and describes the search direction in which Excel searches for a specific term.<br \/>\nWhat does this mean in columns for a term is searched, and if this is found is searched in the appropriate line to determine the coordinate.<\/p>\n<p>see picture: <em>(click to enlarge)<\/em><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-20 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-first\" style=\"--awb-bg-size:cover;width:48%; margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><div class=\"awb-image-frame awb-image-frame-5 imageframe-liftup imageframe-5\"><span class=\" fusion-imageframe imageframe-none imageframe-5\" style=\"border-radius:5px;\"><img decoding=\"async\" width=\"1176\" height=\"540\" title=\"Senkrechte Suchrichtung\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Senkrechte-Suchrichtung.jpg\" alt class=\"img-responsive wp-image-11634\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Senkrechte-Suchrichtung-400x184.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Senkrechte-Suchrichtung.jpg 1176w\" sizes=\"(max-width: 768px) 100vw, 1176px\" \/><\/span><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-21 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-last\" style=\"--awb-bg-size:cover;width:48%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-12 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"custom_html-62\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- inside article -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"5246870081\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><div <span style=\" font-size: x-small;\"><span style=\"font-size: x-small;\">Advertisement<\/span><\/div><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-22 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-8\"><p><strong>The W reference:<\/strong><\/p>\n<p>The &#8220;W&#8221; stands for &#8220;horizontal&#8221; and also describes the search direction in which Excel searches for a specific term.<br \/>\nOnly here is not determined first in columns but in lines for a specific term to determine the coordinate.<\/p>\n<p>see picture: <em>(click to enlarge)<\/em><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-23 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-first\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><div class=\"awb-image-frame awb-image-frame-6 imageframe-liftup imageframe-6\"><span class=\" fusion-imageframe imageframe-none imageframe-6\" style=\"border-radius:5px;\"><img decoding=\"async\" width=\"1119\" height=\"524\" title=\"Waagerechte Suchrichtung\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Waagerechte-Suchrichtung.jpg\" alt class=\"img-responsive wp-image-11636\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Waagerechte-Suchrichtung-400x187.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Waagerechte-Suchrichtung.jpg 1119w\" sizes=\"(max-width: 768px) 100vw, 1119px\" \/><\/span><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-24 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-last\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-13 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"custom_html-63\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><!-- START ADVERTISER: WebHosting UK Com Ltd. from awin.com --><a rel=\"sponsored nofollow noopener\" href=\"https:\/\/www.awin1.com\/cread.php?s=3112048&amp;v=27692&amp;q=434591&amp;r=1354483\" target=\"_blank\"><img decoding=\"async\" src=\"https:\/\/www.awin1.com\/cshow.php?s=3112048&v=27692&q=434591&r=1354483\" border=\"0\">\r\n<\/a><!-- END ADVERTISER: WebHosting UK Com Ltd. from awin.com -->\r\n<div <span style=\"font-size: x-small;\"><span style=\"font-size: x-small; color: #00d6fc;\">Ads<\/span><\/div><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-8 hundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-small-visibility fusion-no-medium-visibility\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-right:50px;--awb-padding-left:60px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-25 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-padding-top:8px;--awb-padding-right:8px;--awb-padding-bottom:8px;--awb-padding-left:8px;--awb-bg-color:#00d6fc;--awb-bg-color-hover:#00d6fc;--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-title title fusion-title-5 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"--awb-margin-top-small:0px;--awb-margin-right-small:0px;--awb-margin-bottom-small:5px;--awb-margin-left-small:0px;--awb-font-size:30px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:30;line-height:1.2;\"><div class=\"fusion-menu-anchor\" id=\"Mark2\"><\/div>2. Procedure S-reference<\/p><\/h2><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-9 hundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-large-visibility\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-right:10px;--awb-padding-left:10px;--awb-margin-top:20px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-26 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-padding-top:8px;--awb-padding-right:8px;--awb-padding-bottom:8px;--awb-padding-left:8px;--awb-bg-color:#00d6fc;--awb-bg-color-hover:#00d6fc;--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-title title fusion-title-6 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"--awb-margin-top-small:0px;--awb-margin-right-small:0px;--awb-margin-bottom-small:5px;--awb-margin-left-small:0px;--awb-font-size:30px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:30;line-height:1.2;\"><div class=\"fusion-menu-anchor\" id=\"Mark2\"><\/div>2. Procedure S-reference<\/p><\/h2><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-10 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-small-visibility fusion-no-medium-visibility\" style=\"--awb-background-position:left top;--awb-border-sizes-top:1px;--awb-border-sizes-bottom:1px;--awb-border-sizes-left:0px;--awb-border-sizes-right:0px;--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:20px;--awb-padding-right:50px;--awb-padding-bottom:40px;--awb-padding-left:60px;--awb-margin-bottom:60px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-27 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-9\"><p>In order to make the whole thing a bit more plastic let&#8217;s assume that we want to build a bill template in Excel, but do not want to have to enter all the recipient data (name, street, city) every time.<\/p>\n<p>Then we should begin by creating a suitable table of customer master data that will later serve as the data source for our S reference. Next, of course, we need the destination (our invoice template).<\/p>\n<p>In the invoice, the recipient address is to be filled in automatically after entering the customer number.<\/p>\n<p>see picture: <em>(click to enlarge)<\/em><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-28 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element in-legacy-container\" style=\"--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"awb-image-frame awb-image-frame-7 imageframe-liftup imageframe-7\"><span class=\" fusion-imageframe imageframe-none imageframe-7\" style=\"border-radius:5px;\"><a href=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Beispiel-S-Verweis-1024x427.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[635172d082ae36c92b8]\" data-title=\"Beispiel S-Verweis\" title=\"Beispiel S-Verweis\"><img decoding=\"async\" width=\"2197\" height=\"917\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Beispiel-S-Verweis.jpg\" alt class=\"img-responsive wp-image-11638\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Beispiel-S-Verweis-400x167.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Beispiel-S-Verweis.jpg 2197w\" sizes=\"(max-width: 768px) 100vw, 2197px\" \/><\/a><\/span><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-29 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-10\"><p>For the automated filling of the receiver head to work, we now need to build several S references that all use the same source but need different coordinates to output the correct data set.<\/p>\n<p>The first entry: <strong>first name<\/strong><\/p>\n<p>We click in the cell <em>&#8220;First name&#8221;<\/em> and start by entering the formula as follows:<\/p>\n<p>= LOOKUP (<\/p>\n<ul>\n<li>After this input, Excel will already tell us which information is needed first. This is the search criteria.<\/li>\n<li>Here we have to click on the cell in which we will enter our customer number later.<\/li>\n<\/ul>\n<p>What does Excel do after exactly what is entered there will look in the data source.<\/p>\n<p>see picture: <em>(click to enlarge)<\/em><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-30 fusion_builder_column_3_4 3_4 fusion-three-fourth fusion-column-first\" style=\"--awb-bg-size:cover;width:75%;width:calc(75% - ( ( 4% ) * 0.75 ) );margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><div class=\"awb-image-frame awb-image-frame-8 imageframe-liftup imageframe-8\"><span class=\" fusion-imageframe imageframe-none imageframe-8\" style=\"border-radius:5px;\"><a href=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[67fd3469beede18c646]\" data-title=\"Suchkriterium festlegen\" title=\"Suchkriterium festlegen\"><img decoding=\"async\" width=\"800\" height=\"294\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-800x294.jpg\" alt class=\"img-responsive wp-image-11640\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-200x74.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-400x147.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-600x221.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-800x294.jpg 800w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-1200x441.jpg 1200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen.jpg 1920w\" sizes=\"(max-width: 768px) 100vw, 800px\" \/><\/a><\/span><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-31 fusion_builder_column_1_4 1_4 fusion-one-fourth fusion-column-last\" style=\"--awb-bg-size:cover;width:25%;width:calc(25% - ( ( 4% ) * 0.25 ) );\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-14 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"custom_html-64\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><!-- START ADVERTISER: TTfone from awin.com --><a rel=\"sponsored nofollow noopener\" href=\"https:\/\/www.awin1.com\/cread.php?s=3315153&amp;v=28737&amp;q=438939&amp;r=1354483\" target=\"_blank\"><img decoding=\"async\" src=\"https:\/\/www.awin1.com\/cshow.php?s=3315153&v=28737&q=438939&r=1354483\" border=\"0\">\r\n<\/a><!-- END ADVERTISER: TTfone from awin.com --><div <span style=\"font-size: x-small;\"><span style=\"font-size: x-small; color: #00d6fc;\">Ads<\/span><\/div><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-32 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-11\"><p>Next, Excel asks for the matrix which is nothing but the table area in which to search for the search criterion (our customer number).<\/p>\n<p>In our example, we can easily mark the entire table with our customer master data.<\/p>\n<p>see picture: <em>(click to enlarge)<\/em><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-33 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element in-legacy-container\" style=\"--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"awb-image-frame awb-image-frame-9 imageframe-liftup imageframe-9\"><span class=\" fusion-imageframe imageframe-none imageframe-9\" style=\"border-radius:5px;\"><a href=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[b00ff44a66c36aac65b]\" data-title=\"Matrix festlegen\" title=\"Matrix festlegen\"><img decoding=\"async\" width=\"800\" height=\"311\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-800x311.jpg\" alt class=\"img-responsive wp-image-11642\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-200x78.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-400x155.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-600x233.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-800x311.jpg 800w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-1200x466.jpg 1200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen.jpg 1920w\" sizes=\"(max-width: 768px) 100vw, 800px\" \/><\/a><\/span><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-34 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-12\"><p>Be sure to remember all the arguments in the formula are each with a semicolon; to separate.<\/p>\n<p>The next step asks for the column index.<br \/>\nHere is simply counted. And in the wievielt column of the previously marked table (not the entire worksheet!) Is to be searched for the entry in the field &#8220;first name&#8221; should.<\/p>\n<p>In our example, it is the third column (in which the first names are). Thus, we simply enter a 3 here.<\/p>\n<p>The last part of our S-reference is not entirely unimportant, because it asks for true = 1 or false = 0.<\/p>\n<p>This is a bit confusing at first, but ultimately means nothing else if Excel should search for exactly the search criterion (as it was entered), or whether it may be similar.<\/p>\n<p>For our example, of course, we are looking for exactly the name entered, and not one of the similar.<br \/>\nSo we enter a &#8220;0&#8221;.<\/p>\n<p>Our finished S-reference for the first field &#8220;first name&#8221; should look like this.<\/p>\n<p>see picture:<em> (click to enlarge)<\/em><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-35 fusion_builder_column_3_4 3_4 fusion-three-fourth fusion-column-first\" style=\"--awb-bg-size:cover;width:75%;width:calc(75% - ( ( 4% ) * 0.75 ) );margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><div class=\"awb-image-frame awb-image-frame-10 imageframe-liftup imageframe-10\"><span class=\" fusion-imageframe imageframe-none imageframe-10\" style=\"border-radius:5px;\"><a href=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[2a5d2e8bc035cb5dabf]\" data-title=\"S-Verweis fertige Formel\" title=\"S-Verweis fertige Formel\"><img decoding=\"async\" width=\"800\" height=\"340\" alt=\"S-Verweis fertige Formel\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-800x340.jpg\" class=\"img-responsive wp-image-11647\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-200x85.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-400x170.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-600x255.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-800x340.jpg 800w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-1200x510.jpg 1200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel.jpg 1920w\" sizes=\"(max-width: 768px) 100vw, 800px\" \/><\/a><\/span><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-36 fusion_builder_column_1_4 1_4 fusion-one-fourth fusion-column-last\" style=\"--awb-bg-size:cover;width:25%;width:calc(25% - ( ( 4% ) * 0.25 ) );\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-15 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"custom_html-100\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- 300x250 EN -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"4647180078\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-11 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-large-visibility\" style=\"--awb-background-position:left top;--awb-border-sizes-top:1px;--awb-border-sizes-bottom:1px;--awb-border-sizes-left:0px;--awb-border-sizes-right:0px;--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:20px;--awb-padding-right:10px;--awb-padding-bottom:40px;--awb-padding-left:10px;--awb-margin-bottom:60px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-37 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-13\"><p>In order to make the whole thing a bit more plastic let&#8217;s assume that we want to build a bill template in Excel, but do not want to have to enter all the recipient data (name, street, city) every time.<\/p>\n<p>Then we should begin by creating a suitable table of customer master data that will later serve as the data source for our S reference. Next, of course, we need the destination (our invoice template).<\/p>\n<p>In the invoice, the recipient address is to be filled in automatically after entering the customer number.<\/p>\n<p>see picture:<\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-38 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element in-legacy-container\" style=\"--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"awb-image-frame awb-image-frame-11 imageframe-liftup imageframe-11\"><span class=\" fusion-imageframe imageframe-none imageframe-11\" style=\"border-radius:5px;\"><img decoding=\"async\" width=\"2197\" height=\"917\" title=\"Beispiel S-Verweis\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Beispiel-S-Verweis.jpg\" alt class=\"img-responsive wp-image-11638\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Beispiel-S-Verweis-400x167.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Beispiel-S-Verweis.jpg 2197w\" sizes=\"(max-width: 768px) 100vw, 2197px\" \/><\/span><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-39 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-14\"><p>For the automated filling of the receiver head to work, we now need to build several S references that all use the same source but need different coordinates to output the correct data set.<\/p>\n<p>The first entry: <strong>first name<\/strong><\/p>\n<p>We click in the cell <em>&#8220;First name&#8221;<\/em> and start by entering the formula as follows:<\/p>\n<p>= LOOKUP (<\/p>\n<ul>\n<li>After this input, Excel will already tell us which information is needed first. This is the search criteria.<\/li>\n<li>Here we have to click on the cell in which we will enter our customer number later.<\/li>\n<\/ul>\n<p>What does Excel do after exactly what is entered there will look in the data source.<\/p>\n<p>see picture:<\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-40 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-first\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><div class=\"awb-image-frame awb-image-frame-12 imageframe-liftup imageframe-12\"><span class=\" fusion-imageframe imageframe-none imageframe-12\" style=\"border-radius:5px;\"><img decoding=\"async\" width=\"800\" height=\"294\" title=\"Suchkriterium festlegen\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-800x294.jpg\" alt class=\"img-responsive wp-image-11640\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-200x74.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-400x147.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-600x221.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-800x294.jpg 800w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen-1200x441.jpg 1200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Suchkriterium-festlegen.jpg 1920w\" sizes=\"(max-width: 768px) 100vw, 1200px\" \/><\/span><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-41 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-last\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-16 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"custom_html-64\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><!-- START ADVERTISER: TTfone from awin.com --><a rel=\"sponsored nofollow noopener\" href=\"https:\/\/www.awin1.com\/cread.php?s=3315153&amp;v=28737&amp;q=438939&amp;r=1354483\" target=\"_blank\"><img decoding=\"async\" src=\"https:\/\/www.awin1.com\/cshow.php?s=3315153&v=28737&q=438939&r=1354483\" border=\"0\">\r\n<\/a><!-- END ADVERTISER: TTfone from awin.com --><div <span style=\"font-size: x-small;\"><span style=\"font-size: x-small; color: #00d6fc;\">Ads<\/span><\/div><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-42 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-15\"><p>Next, Excel asks for the matrix which is nothing but the table area in which to search for the search criterion (our customer number).<\/p>\n<p>In our example, we can easily mark the entire table with our customer master data.<\/p>\n<p>see picture:<\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-43 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element in-legacy-container\" style=\"--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"awb-image-frame awb-image-frame-13 imageframe-liftup imageframe-13\"><span class=\" fusion-imageframe imageframe-none imageframe-13\" style=\"border-radius:5px;\"><img decoding=\"async\" width=\"800\" height=\"311\" title=\"Matrix festlegen\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-800x311.jpg\" alt class=\"img-responsive wp-image-11642\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-200x78.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-400x155.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-600x233.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-800x311.jpg 800w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen-1200x466.jpg 1200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/Matrix-festlegen.jpg 1920w\" sizes=\"(max-width: 768px) 100vw, 800px\" \/><\/span><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-44 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-16\"><p>Be sure to remember all the arguments in the formula are each with a semicolon; to separate.<\/p>\n<p>The next step asks for the column index.<br \/>\nHere is simply counted. And in the wievielt column of the previously marked table (not the entire worksheet!) Is to be searched for the entry in the field &#8220;first name&#8221; should.<\/p>\n<p>In our example, it is the third column (in which the first names are). Thus, we simply enter a 3 here.<\/p>\n<p>The last part of our S-reference is not entirely unimportant, because it asks for true = 1 or false = 0.<\/p>\n<p>This is a bit confusing at first, but ultimately means nothing else if Excel should search for exactly the search criterion (as it was entered), or whether it may be similar.<\/p>\n<p>For our example, of course, we are looking for exactly the name entered, and not one of the similar.<br \/>\nSo we enter a &#8220;0&#8221;.<\/p>\n<p>Our finished S-reference for the first field &#8220;first name&#8221; should look like this.<\/p>\n<p>see picture:<em><br \/>\n<\/em><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-45 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-first\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><div class=\"awb-image-frame awb-image-frame-14 imageframe-liftup imageframe-14\"><span class=\" fusion-imageframe imageframe-none imageframe-14\" style=\"border-radius:5px;\"><a href=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[2a5d2e8bc035cb5dabf]\" data-title=\"S-Verweis fertige Formel\" title=\"S-Verweis fertige Formel\"><img decoding=\"async\" width=\"800\" height=\"340\" alt=\"S-Verweis fertige Formel\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-800x340.jpg\" class=\"img-responsive wp-image-11647\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-200x85.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-400x170.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-600x255.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-800x340.jpg 800w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel-1200x510.jpg 1200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/S-Verweis-fertige-Formel.jpg 1920w\" sizes=\"(max-width: 768px) 100vw, 1200px\" \/><\/a><\/span><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-46 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-last\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-17 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"custom_html-100\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- 300x250 EN -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"4647180078\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-12 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-small-visibility fusion-no-medium-visibility\" style=\"--awb-background-repeat:repeat-x;--awb-border-sizes-top:1px;--awb-border-sizes-bottom:1px;--awb-border-sizes-left:0px;--awb-border-sizes-right:0px;--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:50px;--awb-padding-bottom:50px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-47 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;--awb-margin-bottom:0px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-18 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-13 hundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-small-visibility fusion-no-medium-visibility\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-right:50px;--awb-padding-left:60px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-48 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-padding-top:8px;--awb-padding-right:8px;--awb-padding-bottom:8px;--awb-padding-left:8px;--awb-bg-color:#00d6fc;--awb-bg-color-hover:#00d6fc;--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-title title fusion-title-7 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"--awb-margin-top-small:0px;--awb-margin-right-small:0px;--awb-margin-bottom-small:5px;--awb-margin-left-small:0px;--awb-font-size:30px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:30;line-height:1.2;\"><div class=\"fusion-menu-anchor\" id=\"Mark3\"><\/div>3. Procedure W-reference<\/p><\/h2><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-14 hundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-large-visibility\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-right:10px;--awb-padding-left:10px;--awb-margin-top:20px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-49 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-padding-top:8px;--awb-padding-right:8px;--awb-padding-bottom:8px;--awb-padding-left:8px;--awb-bg-color:#00d6fc;--awb-bg-color-hover:#00d6fc;--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-title title fusion-title-8 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"--awb-margin-top-small:0px;--awb-margin-right-small:0px;--awb-margin-bottom-small:5px;--awb-margin-left-small:0px;--awb-font-size:30px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:30;line-height:1.2;\"><div class=\"fusion-menu-anchor\" id=\"Mark3\"><\/div>3. Procedure W-reference<\/p><\/h2><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-15 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-small-visibility fusion-no-medium-visibility\" style=\"--awb-background-position:left top;--awb-border-sizes-top:1px;--awb-border-sizes-bottom:1px;--awb-border-sizes-left:0px;--awb-border-sizes-right:0px;--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:20px;--awb-padding-right:50px;--awb-padding-bottom:20px;--awb-padding-left:60px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-50 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-17\"><p>The W reference is relatively similar to the S reference.<\/p>\n<p>The main difference lies in the search direction.<br \/>\nIt is not searched vertically but horizontally. To stay with our calculation example, I simply transposed the table with the data source (lines and columns reversed) to represent the W reference.<\/p>\n<p>The function with which we come to our &#8220;first name&#8221; in the bill is therefore:<\/p>\n<p>= HLOOKUP (<\/p>\n<p>Then again specify the cell with the search criterion (the one with the customer number)<\/p>\n<p>next the matrix area (the whole table with the master data)<\/p>\n<p>and now, instead of a column index, just get a row index.<br \/>\nAgain, we just count by again. And in which line should be searched for the first name.<\/p>\n<p>This is the third line in our example. So we enter the 3 at the line index.<br \/>\nAnd finally, we enter the &#8220;0&#8221; for &#8220;False&#8221; to search for an exact match.<\/p>\n<p>Our complete function should look like this.<\/p>\n<p>see picture: <em>(click to enlarge)<\/em><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-51 fusion_builder_column_3_4 3_4 fusion-three-fourth fusion-column-first\" style=\"--awb-bg-size:cover;width:75%;width:calc(75% - ( ( 4% ) * 0.75 ) );margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><div class=\"awb-image-frame awb-image-frame-15 imageframe-liftup imageframe-15\"><span class=\" fusion-imageframe imageframe-none imageframe-15\" style=\"border-radius:5px;\"><a href=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[451ea7e79333bb0c49d]\" data-title=\"W-Verweis fertige Formel\" title=\"W-Verweis fertige Formel\"><img decoding=\"async\" width=\"800\" height=\"309\" alt=\"W-Verweis fertige Formel\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-800x309.jpg\" class=\"img-responsive wp-image-11649\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-200x77.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-400x155.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-600x232.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-800x309.jpg 800w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-1200x464.jpg 1200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel.jpg 1920w\" sizes=\"(max-width: 768px) 100vw, 800px\" \/><\/a><\/span><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-52 fusion_builder_column_1_4 1_4 fusion-one-fourth fusion-column-last\" style=\"--awb-bg-size:cover;width:25%;width:calc(25% - ( ( 4% ) * 0.25 ) );\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-19 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-53 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-18\"><p>Both the S-reference and the W-reference can be used in such a variety of ways, and lead depending on the starting position of the data source to one and the same result.<\/p>\n<p>Of course, you can extend the whole range of functions considerably, and nest them with other functions as well (for example with an if-then function), but already in the basic version, some of the work can be done well with these rather simple functions.<\/p>\n<\/div><a href=\"https:\/\/www.bloggerei.de\/\" target=\"_blank\" rel=\"nofollow noopener\"><img decoding=\"async\" src=\"https:\/\/www.bloggerei.de\/bgpublicon.jpg\" width=\"80\" height=\"15\" border=\"0\" alt=\"Blogverzeichnis Bloggerei.de\" \/><\/a><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-16 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-large-visibility\" style=\"--awb-background-position:left top;--awb-border-sizes-top:1px;--awb-border-sizes-bottom:1px;--awb-border-sizes-left:0px;--awb-border-sizes-right:0px;--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:20px;--awb-padding-right:10px;--awb-padding-bottom:20px;--awb-padding-left:10px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-54 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-19\"><p>The W reference is relatively similar to the S reference.<\/p>\n<p>The main difference lies in the search direction.<br \/>\nIt is not searched vertically but horizontally. To stay with our calculation example, I simply transposed the table with the data source (lines and columns reversed) to represent the W reference.<\/p>\n<p>The function with which we come to our &#8220;first name&#8221; in the bill is therefore:<\/p>\n<p>= HLOOKUP (<\/p>\n<p>Then again specify the cell with the search criterion (the one with the customer number)<\/p>\n<p>next the matrix area (the whole table with the master data)<\/p>\n<p>and now, instead of a column index, just get a row index.<br \/>\nAgain, we just count by again. And in which line should be searched for the first name.<\/p>\n<p>This is the third line in our example. So we enter the 3 at the line index.<br \/>\nAnd finally, we enter the &#8220;0&#8221; for &#8220;False&#8221; to search for an exact match.<\/p>\n<p>Our complete function should look like this.<\/p>\n<p>see picture: <em>(click to enlarge)<\/em><\/p>\n<\/div><div class=\"fusion-text fusion-text-20\"><p>Der W-Verweis ist dem S-Verweis relativ gleich.<\/p>\n<p>Der Hauptunterschied liegt hierbei in der Suchrichtung. Es wird hier also nicht senkrecht sondern waagerecht gesucht. Um bei unserem Rechnungsbeispiel zu bleiben, habe ich die Tabelle mit der Datenquelle einfach mal transponiert (Zeilen und Spalten vertauscht) um den W-Verweis darzustellen.<\/p>\n<p>Die Funktion mit der wir zu unserem &#8220;<strong>Vornamen<\/strong>&#8221; in der Rechnung kommen lautet demnach: =WVERWEIS(<\/p>\n<p>Dann erneut die Zelle mit dem <strong>Suchkriterium<\/strong> festlegen (Die mit der Kundennummer) als n\u00e4chstes den <strong>Matrixbereich<\/strong> (Die gesamte Tabelle mit den Stammdaten) und nun kommt statt einem <strong>Spaltenindex<\/strong> einfach ein <strong>Zeilenindex.<\/strong><\/p>\n<p>Auch hier z\u00e4hlen wir einfach wieder durch. Und zwar in welcher Zeile soll nach dem Vornamen gesucht werden.<\/p>\n<p>Dies ist in unserem Beispiel die dritte Zeile. Also geben wir beim Zeilenindex die <strong>3<\/strong> ein. Und zum Schluss geben wir noch die &#8220;<strong>0<\/strong>&#8221; f\u00fcr &#8220;<strong>Falsch<\/strong>&#8221; ein, damit nach einer genauen \u00dcbereinstimmung gesucht wird.<\/p>\n<p>Unsere komplette Funktion sollte dann wie folgt aussehen.<\/p>\n<p><em>siehe Abb.:<\/em><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-55 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-first\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-liftup-border-radius:5px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><div class=\"awb-image-frame awb-image-frame-16 imageframe-liftup imageframe-16\"><span class=\" fusion-imageframe imageframe-none imageframe-16\" style=\"border-radius:5px;\"><img decoding=\"async\" width=\"600\" height=\"232\" title=\"W-Verweis fertige Formel\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-600x232.jpg\" alt class=\"img-responsive wp-image-11649\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-200x77.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-400x155.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-600x232.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-800x309.jpg 800w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel-1200x464.jpg 1200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2017\/12\/W-Verweis-fertige-Formel.jpg 1920w\" sizes=\"(max-width: 768px) 100vw, 1200px\" \/><\/span><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-56 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-last\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-20 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-57 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-21\"><p>Both the S-reference and the W-reference can be used in such a variety of ways, and lead depending on the starting position of the data source to one and the same result.<\/p>\n<p>Of course, you can extend the whole range of functions considerably, and nest them with other functions as well (for example with an if-then function), but already in the basic version, some of the work can be done well with these rather simple functions.<\/p>\n<\/div><a href=\"https:\/\/www.bloggerei.de\/\" target=\"_blank\" rel=\"nofollow noopener\"><img decoding=\"async\" src=\"https:\/\/www.bloggerei.de\/bgpublicon.jpg\" width=\"80\" height=\"15\" border=\"0\" alt=\"Blogverzeichnis Bloggerei.de\" \/><\/a><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-17 hundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-small-visibility fusion-no-medium-visibility\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:20px;--awb-padding-right:50px;--awb-padding-bottom:30px;--awb-padding-left:60px;--awb-margin-bottom:30px;--awb-background-color:rgba(255,255,255,0);--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-58 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;--awb-margin-bottom:0px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-21 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"text-71\" class=\"widget widget_text\" style=\"border-style: solid;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><div class=\"give-embed-form-wrapper\" id=\"give-69da439f07f8c\"><iframe\n\t\t\t\tname=\"give-embed-form\"\n\t\t\t\tsrc=\"https:\/\/ms-office-training.de\/en\/give\/donation-form\/?giveDonationFormInIframe=1\"\n\t\t\t\t\n\t\t\t\tdata-autoScroll=\"0\"\n\t\t\t\tonload=\"if( 'undefined' !== typeof Give ) { Give.initializeIframeResize(this) }\"\n\t\t\t\tstyle=\"border: 0;visibility: hidden;min-height: 598px;\"><\/iframe><div class=\"iframe-loader\">\n<div style=\"\n\t\theight: calc(100% - 28px);\n\t\twidth: calc(100% - 20px);\n\t\tmax-width: 552px;\n\t\tmargin: 10px auto 10px auto;\n\t\tbackground: transparent;\n\t\tborder-radius: 6px;\n\t\tdisplay: flex;\n\t\talign-items: center;\n\t\tjustify-content: center;\n\t\">\n    <div style=\"\n        pointer-events: none;\n        height: 90px;\n        width: 90px;\n        background-image: url(&quot;data:image\/svg+xml;charset=utf8,%3C?xml version='1.0' encoding='utf-8'?%3E%3C!-- Generator: Adobe Illustrator 24.1.0, SVG Export Plug-In . SVG Version: 6.00 Build 0) --%3E%3Csvg version='1.1' id='Layer_1' xmlns='http:\/\/www.w3.org\/2000\/svg' xmlns:xlink='http:\/\/www.w3.org\/1999\/xlink' x='0px' y='0px' viewBox='0 0 349 348' style='enable-background:new 0 0 349 348;' xml:space='preserve'%3E%3Cstyle type='text\/css'%3E .st0{fill:%2322bf5e;} %3C\/style%3E%3Cpath class='st0' d='M25.1,204.57c-13.38,0-24.47-10.6-24.97-24.08C0.04,178.09,0,175.97,0,174C0,77.78,78.28-0.5,174.5-0.5 c13.81,0,25,11.19,25,25s-11.19,25-25,25C105.85,49.5,50,105.35,50,174c0,1.37,0.03,2.85,0.1,4.65c0.51,13.8-10.27,25.39-24.07,25.9 C25.72,204.56,25.41,204.57,25.1,204.57z'\/%3E%3Cpath class='st0' d='M174.5,348.5c-13.81,0-25-11.19-25-25c0-13.81,11.19-25,25-25c68.65,0,124.5-55.85,124.5-124.5 c0-1.38-0.03-2.85-0.1-4.65c-0.51-13.8,10.26-25.4,24.06-25.91c13.83-0.53,25.4,10.26,25.91,24.06c0.09,2.39,0.13,4.51,0.13,6.49 C349,270.22,270.72,348.5,174.5,348.5z'\/%3E%3C\/svg%3E&quot;);\n        animation: spin 0.6s linear infinite;\n        \"><\/div>\n<\/div>\n<\/div><\/div><\/div>\n\t\t<\/div><div id=\"custom_html-83\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"heading\"><h4 class=\"widget-title\">Search for:<\/h4><\/div><div class=\"textwidget custom-html-widget\"><script async src=\"https:\/\/cse.google.com\/cse.js?cx=27faa65a283ada601\">\r\n<\/script>\r\n<div class=\"gcse-search\"><\/div><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-59 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-first fusion-animated\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );margin-right: 4%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-22 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"text-46\" class=\"widget widget_text\" style=\"border-radius: 2px;overflow:hidden;border-style: solid;border-color: #cccccc;border-width:0px;\"><div class=\"heading\"><h4 class=\"widget-title\">About the Author:<\/h4><\/div>\t\t\t<div class=\"textwidget\"><div class=\"fusion-person person fusion-person-center fusion-person-1 fusion-person-icon-top\" style=\"--awb-pic-style-color:#000000;--awb-pic-borderradius:0px;--awb-margin-top:0px;--awb-margin-right:0px;--awb-margin-bottom:0px;--awb-margin-left:0px;--awb-social-box-border-top:0px;--awb-social-box-border-right:0px;--awb-social-box-border-bottom:0px;--awb-social-box-border-left:0px;--awb-social-box-border-color:var(--awb-color3);--awb-social-box-border-color-hover:var(--awb-color4);--awb-social-box-colors-hover:rgba(244,244,244,0.8);--awb-social-icon-boxed-colors:#f4f4f4;--awb-social-icon-colors:#040082;--awb-social-icon-colors-hover:rgba(4,0,130,0.8);\"><div class=\"person-desc\"><div class=\"person-author\"><div class=\"person-author-wrapper\"><span class=\"person-name\">Michael W. Suhr<\/span><span class=\"person-title\">Dipl. Betriebswirt | Webdesign- und Beratung | Office Training<\/span><\/div><div class=\"fusion-social-networks boxed-icons\"><div class=\"fusion-social-networks-wrapper\"><a class=\"fusion-social-network-icon fusion-tooltip fusion-facebook awb-icon-facebook custom\" aria-label=\"fusion-facebook\" href=\"https:\/\/www.facebook.com\/webdesignms\" target=\"_blank\" rel=\"noopener noreferrer nofollow\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Facebook\" title=\"Facebook\" data-toggle=\"tooltip\"><\/a><a class=\"fusion-social-network-icon fusion-tooltip fusion-twitter awb-icon-twitter custom\" aria-label=\"fusion-twitter\" href=\"https:\/\/twitter.com\/webdesign_ms\" target=\"_blank\" rel=\"noopener noreferrer nofollow\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Twitter\" title=\"Twitter\" data-toggle=\"tooltip\"><\/a><a class=\"fusion-social-network-icon fusion-tooltip fusion-xing awb-icon-xing custom\" aria-label=\"fusion-xing\" href=\"https:\/\/www.xing.com\/profile\/MichaelW_Suhr\/portfolio\" target=\"_blank\" rel=\"noopener noreferrer nofollow\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Xing\" title=\"Xing\" data-toggle=\"tooltip\"><\/a><a class=\"fusion-social-network-icon fusion-tooltip fusion-mail awb-icon-mail custom\" aria-label=\"fusion-mail\" href=\"mailto:i&#110;&#102;o&#064;m&#115;&#045;&#111;ff&#105;&#099;e-&#116;ra&#105;n&#105;&#110;g&#046;&#100;&#101;\" target=\"_self\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Mail\" title=\"Mail\" data-toggle=\"tooltip\"><\/a><a class=\"fusion-social-network-icon fusion-tooltip fusion-paypal awb-icon-paypal custom\" aria-label=\"fusion-paypal\" href=\" https:\/\/www.paypal.com\/paypalme\/msofficetr74\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Paypal\" title=\"Paypal\" data-toggle=\"tooltip\"><\/a><a class=\"fusion-social-network-icon fusion-tooltip fusion-phone awb-icon-phone custom\" aria-label=\"fusion-phone\" href=\"tel:04181360254\" target=\"_self\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Phone\" title=\"Phone\" data-toggle=\"tooltip\"><\/a><\/div><\/div><\/div><div class=\"person-content fusion-clearfix\">After 20 years in logistics, I turned my hobby, which has accompanied me since the mid-1980s, into a profession, and have been working as a freelancer in web design, web consulting and Microsoft Office since the beginning of 2015. On the side, I write articles for more digital competence in my blog as far as time allows.<\/div><\/div><\/div><\/div>\n\t\t<\/div><div id=\"text-77\" class=\"widget widget_text\" style=\"border-style: solid;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><span style=\"display: block; color: #747474; font-size: 10px; margin-top: 15px; line-height: 1.2;\">\r\nTransparenz: Um diesen Blog kostenlos anbieten zu k\u00f6nnen, nutzen wir Affiliate-Links. Klickst du darauf und kaufst etwas, bekommen wir eine kleine Verg\u00fctung. Der Preis bleibt f\u00fcr dich gleich. Win-Win!\r\n<\/span><\/div>\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-60 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-23 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#040082;--awb-padding:0px 0px 0px 0px;\"><div id=\"categories-8\" class=\"widget widget_categories\"><div class=\"heading\"><h4 class=\"widget-title\">Search by category:<\/h4><\/div><form action=\"https:\/\/ms-office-training.de\/en\/\" method=\"get\"><label class=\"screen-reader-text\" for=\"categories-dropdown-8\">Search by category:<\/label><select  name='cat' id='categories-dropdown-8' class='postform'>\n\t<option value='-1'>Select Category<\/option>\n\t<option class=\"level-0\" value=\"3508\">Amazon<\/option>\n\t<option class=\"level-0\" value=\"236\">Android \/ iOS<\/option>\n\t<option class=\"level-0\" value=\"3502\">Artificial intelligence<\/option>\n\t<option class=\"level-0\" value=\"3500\">AutoGPT<\/option>\n\t<option class=\"level-0\" value=\"3521\">Career<\/option>\n\t<option class=\"level-0\" value=\"3501\">ChatGPT<\/option>\n\t<option class=\"level-0\" value=\"3648\">Daily AI-News<\/option>\n\t<option class=\"level-0\" value=\"300\">Data Protection<\/option>\n\t<option class=\"level-0\" value=\"214\">Google<\/option>\n\t<option class=\"level-0\" value=\"282\">Guest Article<\/option>\n\t<option class=\"level-0\" value=\"3602\">Hardware<\/option>\n\t<option class=\"level-0\" value=\"3306\">Homeoffice<\/option>\n\t<option class=\"level-0\" value=\"1200\">Internet, Finance &amp; Shopping<\/option>\n\t<option class=\"level-0\" value=\"3647\">Kurioses<\/option>\n\t<option class=\"level-0\" value=\"3506\">LLaMa<\/option>\n\t<option class=\"level-0\" value=\"3544\">Mac OS<\/option>\n\t<option class=\"level-0\" value=\"211\">Microsoft Excel<\/option>\n\t<option class=\"level-0\" value=\"762\">Microsoft Office<\/option>\n\t<option class=\"level-0\" value=\"237\">Microsoft Outlook<\/option>\n\t<option class=\"level-0\" value=\"259\">Microsoft PowerPoint<\/option>\n\t<option class=\"level-0\" value=\"3464\">Microsoft Teams<\/option>\n\t<option class=\"level-0\" value=\"221\">Microsoft Word<\/option>\n\t<option class=\"level-0\" value=\"3358\">Office 365<\/option>\n\t<option class=\"level-0\" value=\"1257\">Product Tests<\/option>\n\t<option class=\"level-0\" value=\"218\">SEO<\/option>\n\t<option class=\"level-0\" value=\"2875\">Shorts &amp; Tutorials<\/option>\n\t<option class=\"level-0\" value=\"3667\">Social Media<\/option>\n\t<option class=\"level-0\" value=\"3601\">Software<\/option>\n\t<option class=\"level-0\" value=\"3655\">Streaming<\/option>\n\t<option class=\"level-0\" value=\"3503\">TruthGPT<\/option>\n\t<option class=\"level-0\" value=\"210\">Uncategorized<\/option>\n\t<option class=\"level-0\" value=\"246\">Windows 10\/11\/12<\/option>\n\t<option class=\"level-0\" value=\"215\">Wordpress<\/option>\n<\/select>\n<\/form><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\n( ( dropdownId ) => {\n\tconst dropdown = document.getElementById( dropdownId );\n\tfunction onSelectChange() {\n\t\tsetTimeout( () => {\n\t\t\tif ( 'escape' === dropdown.dataset.lastkey ) {\n\t\t\t\treturn;\n\t\t\t}\n\t\t\tif ( dropdown.value && parseInt( dropdown.value ) > 0 && dropdown instanceof HTMLSelectElement ) {\n\t\t\t\tdropdown.parentElement.submit();\n\t\t\t}\n\t\t}, 250 );\n\t}\n\tfunction onKeyUp( event ) {\n\t\tif ( 'Escape' === event.key ) {\n\t\t\tdropdown.dataset.lastkey = 'escape';\n\t\t} else {\n\t\t\tdelete dropdown.dataset.lastkey;\n\t\t}\n\t}\n\tfunction onClick() {\n\t\tdelete dropdown.dataset.lastkey;\n\t}\n\tdropdown.addEventListener( 'keyup', onKeyUp );\n\tdropdown.addEventListener( 'click', onClick );\n\tdropdown.addEventListener( 'change', onSelectChange );\n})( \"categories-dropdown-8\" );\n\n\/\/# sourceURL=WP_Widget_Categories%3A%3Awidget\n\/* ]]> *\/\n<\/script>\n<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-24 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"search-4\" class=\"widget widget_search\"><div class=\"heading\"><h4 class=\"widget-title\">Search by keyword:<\/h4><\/div>\t\t<form role=\"search\" class=\"searchform fusion-search-form  fusion-live-search fusion-search-form-classic\" method=\"get\" action=\"https:\/\/ms-office-training.de\/en\/\">\n\t\t\t<div class=\"fusion-search-form-content\">\n\n\t\t\t\t\n\t\t\t\t<div class=\"fusion-search-field search-field\">\n\t\t\t\t\t<label><span class=\"screen-reader-text\">Search for:<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<input type=\"search\" class=\"s fusion-live-search-input\" name=\"s\" id=\"fusion-live-search-input-0\" autocomplete=\"off\" placeholder=\"Search...\" required aria-required=\"true\" aria-label=\"Search...\"\/>\n\t\t\t\t\t\t\t\t\t\t\t<\/label>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"fusion-search-button search-button\">\n\t\t\t\t\t<input type=\"submit\" class=\"fusion-search-submit searchsubmit\" aria-label=\"Search\" value=\"&#xf002;\" \/>\n\t\t\t\t\t\t\t\t\t\t<div class=\"fusion-slider-loading\"><\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\n\t\t\t<\/div>\n\n\n\t\t\t\t\t\t\t<div class=\"fusion-search-results-wrapper\"><div class=\"fusion-search-results\"><\/div><\/div>\n\t\t\t\n\t\t<\/form>\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-25 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"text-59\" class=\"widget widget_text\" style=\"background-color: rgba(255,255,255,0);border-style: solid;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><div class=\"fusion-align-block\"><a class=\"fusion-button button-flat button-xlarge button-custom fusion-button-default button-3 fusion-button-span-yes fusion-button-default-type\" style=\"--button_accent_color:#ffffff;--button_accent_hover_color:#ffffff;--button_border_hover_color:#ffffff;--button_gradient_top_color:#2fad01;--button_gradient_bottom_color:#2fad01;--button_gradient_top_color_hover:#34c200;--button_gradient_bottom_color_hover:#34c200;\" target=\"_blank\" rel=\"noopener noreferrer\" data-hover=\"text_slide_up\" href=\"#\" data-toggle=\"modal\" data-target=\".fusion-modal.donation-support\"><span class=\"fusion-button-icon-divider button-icon-divider-left\"><i class=\"fa-hands-helping fas awb-button__icon awb-button__icon--default\" aria-hidden=\"true\"><\/i><\/span><div class=\"awb-button-text-transition \"><span class=\"fusion-button-text awb-button__text awb-button__text--default fusion-button-text-left\">Buy them a coffee<\/span><span class=\"fusion-button-text awb-button__text awb-button__text--default fusion-button-text-left\">Buy them a coffee<\/span><\/div><\/a><\/div><\/div>\n\t\t<\/div><div id=\"custom_html-7\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-layout-key=\"-h9-3+2u-6v+44\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"5613816303\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-61 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-26 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"custom_html-60\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"heading\"><h4 class=\"widget-title\">You might also be interested in:<\/h4><\/div><div class=\"textwidget custom-html-widget\"><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-format=\"autorelaxed\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"1827375650\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/div><\/div><div id=\"custom_html-89\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-layout-key=\"-h9-3+2u-6v+44\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"5613816303\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/center><\/div><\/div>\n\t\t<div id=\"recent-posts-12\" class=\"widget widget_recent_entries\" style=\"border-style: solid;border-color:transparent;border-width:0px;\">\n\t\t<div class=\"heading\"><h4 class=\"widget-title\">Latest Posts:<\/h4><\/div>\n\t\t<ul>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/historic-softbank-deal-starting-signal-for-eu-regulation-the-ai-news-on-new-years-eve\/\">Historic SoftBank deal &#038; starting signal for EU regulation: The AI \u200b\u200bnews on New Year&#8217;s Eve<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/when-your-own-voice-becomes-a-weapon-the-rise-of-ai-powered-audio-fraud\/\">When your own voice becomes a weapon: The rise of AI-powered audio fraud<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/december-26-2025-record-workload-during-the-holidays-final-sprint-in-the-mega-deal\/\">December 26, 2025: Record workload during the holidays &#038; final sprint in the mega-deal<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\">Ad-free home network: Install Pi-hole on Windows<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/december-23-2025-900-billion-valuation-in-sight-googles-flash-launch\/\">December 23, 2025: $900 billion valuation in sight &#038; Google&#8217;s Flash launch<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\">How to tune your FRITZ!Box into a professional call server<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t<\/ul>\n\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-27 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-18 hundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-large-visibility\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:20px;--awb-padding-bottom:30px;--awb-margin-bottom:30px;--awb-background-color:rgba(255,255,255,0);--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-62 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;--awb-margin-bottom:0px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-28 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"text-71\" class=\"widget widget_text\" style=\"border-style: solid;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><div class=\"give-embed-form-wrapper\" id=\"give-69da439f0ee35\"><iframe\n\t\t\t\tname=\"give-embed-form\"\n\t\t\t\tsrc=\"https:\/\/ms-office-training.de\/en\/give\/donation-form\/?giveDonationFormInIframe=1\"\n\t\t\t\t\n\t\t\t\tdata-autoScroll=\"0\"\n\t\t\t\tonload=\"if( 'undefined' !== typeof Give ) { Give.initializeIframeResize(this) }\"\n\t\t\t\tstyle=\"border: 0;visibility: hidden;min-height: 598px;\"><\/iframe><div class=\"iframe-loader\">\n<div style=\"\n\t\theight: calc(100% - 28px);\n\t\twidth: calc(100% - 20px);\n\t\tmax-width: 552px;\n\t\tmargin: 10px auto 10px auto;\n\t\tbackground: transparent;\n\t\tborder-radius: 6px;\n\t\tdisplay: flex;\n\t\talign-items: center;\n\t\tjustify-content: center;\n\t\">\n    <div style=\"\n        pointer-events: none;\n        height: 90px;\n        width: 90px;\n        background-image: url(&quot;data:image\/svg+xml;charset=utf8,%3C?xml version='1.0' encoding='utf-8'?%3E%3C!-- Generator: Adobe Illustrator 24.1.0, SVG Export Plug-In . SVG Version: 6.00 Build 0) --%3E%3Csvg version='1.1' id='Layer_1' xmlns='http:\/\/www.w3.org\/2000\/svg' xmlns:xlink='http:\/\/www.w3.org\/1999\/xlink' x='0px' y='0px' viewBox='0 0 349 348' style='enable-background:new 0 0 349 348;' xml:space='preserve'%3E%3Cstyle type='text\/css'%3E .st0{fill:%2322bf5e;} %3C\/style%3E%3Cpath class='st0' d='M25.1,204.57c-13.38,0-24.47-10.6-24.97-24.08C0.04,178.09,0,175.97,0,174C0,77.78,78.28-0.5,174.5-0.5 c13.81,0,25,11.19,25,25s-11.19,25-25,25C105.85,49.5,50,105.35,50,174c0,1.37,0.03,2.85,0.1,4.65c0.51,13.8-10.27,25.39-24.07,25.9 C25.72,204.56,25.41,204.57,25.1,204.57z'\/%3E%3Cpath class='st0' d='M174.5,348.5c-13.81,0-25-11.19-25-25c0-13.81,11.19-25,25-25c68.65,0,124.5-55.85,124.5-124.5 c0-1.38-0.03-2.85-0.1-4.65c-0.51-13.8,10.26-25.4,24.06-25.91c13.83-0.53,25.4,10.26,25.91,24.06c0.09,2.39,0.13,4.51,0.13,6.49 C349,270.22,270.72,348.5,174.5,348.5z'\/%3E%3C\/svg%3E&quot;);\n        animation: spin 0.6s linear infinite;\n        \"><\/div>\n<\/div>\n<\/div><\/div><\/div>\n\t\t<\/div><div id=\"custom_html-83\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"heading\"><h4 class=\"widget-title\">Search for:<\/h4><\/div><div class=\"textwidget custom-html-widget\"><script async src=\"https:\/\/cse.google.com\/cse.js?cx=27faa65a283ada601\">\r\n<\/script>\r\n<div class=\"gcse-search\"><\/div><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-63 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-first fusion-animated\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );margin-right: 4%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-29 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"text-46\" class=\"widget widget_text\" style=\"border-radius: 2px;overflow:hidden;border-style: solid;border-color: #cccccc;border-width:0px;\"><div class=\"heading\"><h4 class=\"widget-title\">About the Author:<\/h4><\/div>\t\t\t<div class=\"textwidget\"><div class=\"fusion-person person fusion-person-center fusion-person-2 fusion-person-icon-top\" style=\"--awb-pic-style-color:#000000;--awb-pic-borderradius:0px;--awb-margin-top:0px;--awb-margin-right:0px;--awb-margin-bottom:0px;--awb-margin-left:0px;--awb-social-box-border-top:0px;--awb-social-box-border-right:0px;--awb-social-box-border-bottom:0px;--awb-social-box-border-left:0px;--awb-social-box-border-color:var(--awb-color3);--awb-social-box-border-color-hover:var(--awb-color4);--awb-social-box-colors-hover:rgba(244,244,244,0.8);--awb-social-icon-boxed-colors:#f4f4f4;--awb-social-icon-colors:#040082;--awb-social-icon-colors-hover:rgba(4,0,130,0.8);\"><div class=\"person-desc\"><div class=\"person-author\"><div class=\"person-author-wrapper\"><span class=\"person-name\">Michael W. Suhr<\/span><span class=\"person-title\">Dipl. Betriebswirt | Webdesign- und Beratung | Office Training<\/span><\/div><div class=\"fusion-social-networks boxed-icons\"><div class=\"fusion-social-networks-wrapper\"><a class=\"fusion-social-network-icon fusion-tooltip fusion-facebook awb-icon-facebook custom\" aria-label=\"fusion-facebook\" href=\"https:\/\/www.facebook.com\/webdesignms\" target=\"_blank\" rel=\"noopener noreferrer nofollow\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Facebook\" title=\"Facebook\" data-toggle=\"tooltip\"><\/a><a class=\"fusion-social-network-icon fusion-tooltip fusion-twitter awb-icon-twitter custom\" aria-label=\"fusion-twitter\" href=\"https:\/\/twitter.com\/webdesign_ms\" target=\"_blank\" rel=\"noopener noreferrer nofollow\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Twitter\" title=\"Twitter\" data-toggle=\"tooltip\"><\/a><a class=\"fusion-social-network-icon fusion-tooltip fusion-xing awb-icon-xing custom\" aria-label=\"fusion-xing\" href=\"https:\/\/www.xing.com\/profile\/MichaelW_Suhr\/portfolio\" target=\"_blank\" rel=\"noopener noreferrer nofollow\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Xing\" title=\"Xing\" data-toggle=\"tooltip\"><\/a><a class=\"fusion-social-network-icon fusion-tooltip fusion-mail awb-icon-mail custom\" aria-label=\"fusion-mail\" href=\"mailto:&#105;n&#102;o&#064;ms-of&#102;&#105;c&#101;&#045;&#116;r&#097;&#105;&#110;&#105;&#110;&#103;.&#100;&#101;\" target=\"_self\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Mail\" title=\"Mail\" data-toggle=\"tooltip\"><\/a><a class=\"fusion-social-network-icon fusion-tooltip fusion-paypal awb-icon-paypal custom\" aria-label=\"fusion-paypal\" href=\" https:\/\/www.paypal.com\/paypalme\/msofficetr74\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Paypal\" title=\"Paypal\" data-toggle=\"tooltip\"><\/a><a class=\"fusion-social-network-icon fusion-tooltip fusion-phone awb-icon-phone custom\" aria-label=\"fusion-phone\" href=\"tel:04181360254\" target=\"_self\" style=\"color:#040082;background-color:#f4f4f4;border-color:var(--awb-color3);border-radius:8px;font-size:21px;padding:8px;\" data-placement=\"top\" data-title=\"Phone\" title=\"Phone\" data-toggle=\"tooltip\"><\/a><\/div><\/div><\/div><div class=\"person-content fusion-clearfix\">After 20 years in logistics, I turned my hobby, which has accompanied me since the mid-1980s, into a profession, and have been working as a freelancer in web design, web consulting and Microsoft Office since the beginning of 2015. On the side, I write articles for more digital competence in my blog as far as time allows.<\/div><\/div><\/div><\/div>\n\t\t<\/div><div id=\"text-77\" class=\"widget widget_text\" style=\"border-style: solid;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><span style=\"display: block; color: #747474; font-size: 10px; margin-top: 15px; line-height: 1.2;\">\r\nTransparenz: Um diesen Blog kostenlos anbieten zu k\u00f6nnen, nutzen wir Affiliate-Links. Klickst du darauf und kaufst etwas, bekommen wir eine kleine Verg\u00fctung. Der Preis bleibt f\u00fcr dich gleich. Win-Win!\r\n<\/span><\/div>\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-64 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-30 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#040082;--awb-padding:0px 0px 0px 0px;\"><div id=\"categories-8\" class=\"widget widget_categories\"><div class=\"heading\"><h4 class=\"widget-title\">Search by category:<\/h4><\/div><form action=\"https:\/\/ms-office-training.de\/en\/\" method=\"get\"><label class=\"screen-reader-text\" for=\"categories-dropdown-8\">Search by category:<\/label><select  name='cat' id='categories-dropdown-8' class='postform'>\n\t<option value='-1'>Select Category<\/option>\n\t<option class=\"level-0\" value=\"3508\">Amazon<\/option>\n\t<option class=\"level-0\" value=\"236\">Android \/ iOS<\/option>\n\t<option class=\"level-0\" value=\"3502\">Artificial intelligence<\/option>\n\t<option class=\"level-0\" value=\"3500\">AutoGPT<\/option>\n\t<option class=\"level-0\" value=\"3521\">Career<\/option>\n\t<option class=\"level-0\" value=\"3501\">ChatGPT<\/option>\n\t<option class=\"level-0\" value=\"3648\">Daily AI-News<\/option>\n\t<option class=\"level-0\" value=\"300\">Data Protection<\/option>\n\t<option class=\"level-0\" value=\"214\">Google<\/option>\n\t<option class=\"level-0\" value=\"282\">Guest Article<\/option>\n\t<option class=\"level-0\" value=\"3602\">Hardware<\/option>\n\t<option class=\"level-0\" value=\"3306\">Homeoffice<\/option>\n\t<option class=\"level-0\" value=\"1200\">Internet, Finance &amp; Shopping<\/option>\n\t<option class=\"level-0\" value=\"3647\">Kurioses<\/option>\n\t<option class=\"level-0\" value=\"3506\">LLaMa<\/option>\n\t<option class=\"level-0\" value=\"3544\">Mac OS<\/option>\n\t<option class=\"level-0\" value=\"211\">Microsoft Excel<\/option>\n\t<option class=\"level-0\" value=\"762\">Microsoft Office<\/option>\n\t<option class=\"level-0\" value=\"237\">Microsoft Outlook<\/option>\n\t<option class=\"level-0\" value=\"259\">Microsoft PowerPoint<\/option>\n\t<option class=\"level-0\" value=\"3464\">Microsoft Teams<\/option>\n\t<option class=\"level-0\" value=\"221\">Microsoft Word<\/option>\n\t<option class=\"level-0\" value=\"3358\">Office 365<\/option>\n\t<option class=\"level-0\" value=\"1257\">Product Tests<\/option>\n\t<option class=\"level-0\" value=\"218\">SEO<\/option>\n\t<option class=\"level-0\" value=\"2875\">Shorts &amp; Tutorials<\/option>\n\t<option class=\"level-0\" value=\"3667\">Social Media<\/option>\n\t<option class=\"level-0\" value=\"3601\">Software<\/option>\n\t<option class=\"level-0\" value=\"3655\">Streaming<\/option>\n\t<option class=\"level-0\" value=\"3503\">TruthGPT<\/option>\n\t<option class=\"level-0\" value=\"210\">Uncategorized<\/option>\n\t<option class=\"level-0\" value=\"246\">Windows 10\/11\/12<\/option>\n\t<option class=\"level-0\" value=\"215\">Wordpress<\/option>\n<\/select>\n<\/form><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\n( ( dropdownId ) => {\n\tconst dropdown = document.getElementById( dropdownId );\n\tfunction onSelectChange() {\n\t\tsetTimeout( () => {\n\t\t\tif ( 'escape' === dropdown.dataset.lastkey ) {\n\t\t\t\treturn;\n\t\t\t}\n\t\t\tif ( dropdown.value && parseInt( dropdown.value ) > 0 && dropdown instanceof HTMLSelectElement ) {\n\t\t\t\tdropdown.parentElement.submit();\n\t\t\t}\n\t\t}, 250 );\n\t}\n\tfunction onKeyUp( event ) {\n\t\tif ( 'Escape' === event.key ) {\n\t\t\tdropdown.dataset.lastkey = 'escape';\n\t\t} else {\n\t\t\tdelete dropdown.dataset.lastkey;\n\t\t}\n\t}\n\tfunction onClick() {\n\t\tdelete dropdown.dataset.lastkey;\n\t}\n\tdropdown.addEventListener( 'keyup', onKeyUp );\n\tdropdown.addEventListener( 'click', onClick );\n\tdropdown.addEventListener( 'change', onSelectChange );\n})( \"categories-dropdown-8\" );\n\n\/\/# sourceURL=WP_Widget_Categories%3A%3Awidget\n\/* ]]> *\/\n<\/script>\n<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-31 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"search-4\" class=\"widget widget_search\"><div class=\"heading\"><h4 class=\"widget-title\">Search by keyword:<\/h4><\/div>\t\t<form role=\"search\" class=\"searchform fusion-search-form  fusion-live-search fusion-search-form-classic\" method=\"get\" action=\"https:\/\/ms-office-training.de\/en\/\">\n\t\t\t<div class=\"fusion-search-form-content\">\n\n\t\t\t\t\n\t\t\t\t<div class=\"fusion-search-field search-field\">\n\t\t\t\t\t<label><span class=\"screen-reader-text\">Search for:<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<input type=\"search\" class=\"s fusion-live-search-input\" name=\"s\" id=\"fusion-live-search-input-1\" autocomplete=\"off\" placeholder=\"Search...\" required aria-required=\"true\" aria-label=\"Search...\"\/>\n\t\t\t\t\t\t\t\t\t\t\t<\/label>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"fusion-search-button search-button\">\n\t\t\t\t\t<input type=\"submit\" class=\"fusion-search-submit searchsubmit\" aria-label=\"Search\" value=\"&#xf002;\" \/>\n\t\t\t\t\t\t\t\t\t\t<div class=\"fusion-slider-loading\"><\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\n\t\t\t<\/div>\n\n\n\t\t\t\t\t\t\t<div class=\"fusion-search-results-wrapper\"><div class=\"fusion-search-results\"><\/div><\/div>\n\t\t\t\n\t\t<\/form>\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-32 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"text-59\" class=\"widget widget_text\" style=\"background-color: rgba(255,255,255,0);border-style: solid;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><div class=\"fusion-align-block\"><a class=\"fusion-button button-flat button-xlarge button-custom fusion-button-default button-4 fusion-button-span-yes fusion-button-default-type\" style=\"--button_accent_color:#ffffff;--button_accent_hover_color:#ffffff;--button_border_hover_color:#ffffff;--button_gradient_top_color:#2fad01;--button_gradient_bottom_color:#2fad01;--button_gradient_top_color_hover:#34c200;--button_gradient_bottom_color_hover:#34c200;\" target=\"_blank\" rel=\"noopener noreferrer\" data-hover=\"text_slide_up\" href=\"#\" data-toggle=\"modal\" data-target=\".fusion-modal.donation-support\"><span class=\"fusion-button-icon-divider button-icon-divider-left\"><i class=\"fa-hands-helping fas awb-button__icon awb-button__icon--default\" aria-hidden=\"true\"><\/i><\/span><div class=\"awb-button-text-transition \"><span class=\"fusion-button-text awb-button__text awb-button__text--default fusion-button-text-left\">Buy them a coffee<\/span><span class=\"fusion-button-text awb-button__text awb-button__text--default fusion-button-text-left\">Buy them a coffee<\/span><\/div><\/a><\/div><\/div>\n\t\t<\/div><div id=\"custom_html-7\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-layout-key=\"-h9-3+2u-6v+44\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"5613816303\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-65 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-33 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"custom_html-60\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"heading\"><h4 class=\"widget-title\">You might also be interested in:<\/h4><\/div><div class=\"textwidget custom-html-widget\"><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-format=\"autorelaxed\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"1827375650\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/div><\/div><div id=\"custom_html-89\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6975808762565780\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-layout-key=\"-h9-3+2u-6v+44\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"5613816303\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/center><\/div><\/div>\n\t\t<div id=\"recent-posts-12\" class=\"widget widget_recent_entries\" style=\"border-style: solid;border-color:transparent;border-width:0px;\">\n\t\t<div class=\"heading\"><h4 class=\"widget-title\">Latest Posts:<\/h4><\/div>\n\t\t<ul>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/historic-softbank-deal-starting-signal-for-eu-regulation-the-ai-news-on-new-years-eve\/\">Historic SoftBank deal &#038; starting signal for EU regulation: The AI \u200b\u200bnews on New Year&#8217;s Eve<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/when-your-own-voice-becomes-a-weapon-the-rise-of-ai-powered-audio-fraud\/\">When your own voice becomes a weapon: The rise of AI-powered audio fraud<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/december-26-2025-record-workload-during-the-holidays-final-sprint-in-the-mega-deal\/\">December 26, 2025: Record workload during the holidays &#038; final sprint in the mega-deal<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\">Ad-free home network: Install Pi-hole on Windows<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/december-23-2025-900-billion-valuation-in-sight-googles-flash-launch\/\">December 23, 2025: $900 billion valuation in sight &#038; Google&#8217;s Flash launch<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\">How to tune your FRITZ!Box into a professional call server<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t<\/ul>\n\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-34 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-19 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-small-visibility fusion-no-medium-visibility\" style=\"--awb-background-position:left top;--awb-border-sizes-top:1px;--awb-border-sizes-bottom:1px;--awb-border-sizes-left:0px;--awb-border-sizes-right:0px;--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:20px;--awb-padding-right:50px;--awb-padding-bottom:20px;--awb-padding-left:50px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-66 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-title title fusion-title-9 sep-underline sep-solid fusion-title-text fusion-title-size-two\" style=\"--awb-margin-top-small:0px;--awb-margin-right-small:0px;--awb-margin-bottom-small:5px;--awb-margin-left-small:0px;--awb-font-size:25px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:25;line-height:1.2;\">Popular Posts:<\/h2><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-67 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-blog-shortcode fusion-blog-shortcode-1 fusion-blog-archive fusion-blog-layout-medium-alternate fusion-blog-infinite\"><div class=\"fusion-posts-container fusion-posts-container-infinite fusion-posts-container-load-more fusion-blog-rollover\" data-pages=\"20\"><article id=\"blog-1-post-64073\" class=\"fusion-post-medium-alternate post-64073 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-homeoffice-en category-microsoft-windows-en tag-homeoffice-en tag-windows-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">23<\/span><span class=\"fusion-month-year\">12, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Werbefrei-im-Heimnetz-mit-Pi-Hole-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"Werbefrei im Heimnetz mit Pi-Hole\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Werbefrei-im-Heimnetz-mit-Pi-Hole-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Werbefrei-im-Heimnetz-mit-Pi-Hole-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\">Ad-free home network: Install Pi-hole on Windows<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\">\n\t\t\t\t\t\tAd-free home network: Install Pi-hole on Windows\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\" aria-label=\"Ad-free home network: Install Pi-hole on Windows\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\">Ad-free home network: Install Pi-hole on Windows<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-12-27T07:20:04+01:00<\/span><span>December 23rd, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/homeoffice-en\/\" rel=\"category tag\">Homeoffice<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/uncategorized\/microsoft-windows-en\/\" rel=\"category tag\">Windows 10\/11\/12<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/homeoffice-en\/\" rel=\"tag\">Homeoffice<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/windows-en\/\" rel=\"tag\">Windows<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>Say goodbye to ads on smart TVs and in apps: Pi-hole software turns your Windows laptop into a network filter. This article explains step-by-step how to install it via Docker and configure the necessary DNS settings in your FRITZ!Box.<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\" aria-label=\"More on Ad-free home network: Install Pi-hole on Windows\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-1-post-64104\" class=\"fusion-post-medium-alternate post-64104 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-homeoffice-en category-microsoft-windows-en tag-career tag-homeoffice-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">22<\/span><span class=\"fusion-month-year\">12, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/fritzbox-mit-laptop-verbinden-telefonzentrale-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"fritzbox-mit-laptop-verbinden-telefonzentrale\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/fritzbox-mit-laptop-verbinden-telefonzentrale-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/fritzbox-mit-laptop-verbinden-telefonzentrale-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\">How to tune your FRITZ!Box into a professional call server<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\">\n\t\t\t\t\t\tHow to tune your FRITZ!Box into a professional call server\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\" aria-label=\"How to tune your FRITZ!Box into a professional call server\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\">How to tune your FRITZ!Box into a professional call server<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-12-27T09:39:27+01:00<\/span><span>December 22nd, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/homeoffice-en\/\" rel=\"category tag\">Homeoffice<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/uncategorized\/microsoft-windows-en\/\" rel=\"category tag\">Windows 10\/11\/12<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/career\/\" rel=\"tag\">Career<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/homeoffice-en\/\" rel=\"tag\">Homeoffice<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>A professional telephone system can be built using a FRITZ!Box and a laptop. This article shows step by step how to use the free software \"Phoner\" to schedule announcements and record calls \u2013 including important legal information (\u00a7 201 StGB).<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\" aria-label=\"More on How to tune your FRITZ!Box into a professional call server\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-1-post-64113\" class=\"fusion-post-medium-alternate post-64113 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-career category-homeoffice-en tag-career tag-homeoffice-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">21<\/span><span class=\"fusion-month-year\">12, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/to-do-list-vs-timeboxing-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"to-do-list-vs-timeboxing\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/to-do-list-vs-timeboxing-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/to-do-list-vs-timeboxing-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/why-to-do-lists-are-a-waste-of-time\/\">Why to-do lists are a waste of time<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/why-to-do-lists-are-a-waste-of-time\/\">\n\t\t\t\t\t\tWhy to-do lists are a waste of time\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/why-to-do-lists-are-a-waste-of-time\/\" aria-label=\"Why to-do lists are a waste of time\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/why-to-do-lists-are-a-waste-of-time\/\">Why to-do lists are a waste of time<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-12-27T09:50:09+01:00<\/span><span>December 21st, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/career\/\" rel=\"category tag\">Career<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/homeoffice-en\/\" rel=\"category tag\">Homeoffice<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/career\/\" rel=\"tag\">Career<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/homeoffice-en\/\" rel=\"tag\">Homeoffice<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>Do you feel unproductive at the end of the day, even though you've worked hard? Your to-do list is to blame. It tempts you to focus on easy tasks and ignores your limited time. This article explains why lists are \"self-deception\" and why professionals use a calendar instead.<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/why-to-do-lists-are-a-waste-of-time\/\" aria-label=\"More on Why to-do lists are a waste of time\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-1-post-64157\" class=\"fusion-post-medium-alternate post-64157 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-data-protection category-hardware-en category-homeoffice-en category-software-en tag-data-protection tag-hardware-en tag-software-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">18<\/span><span class=\"fusion-month-year\">12, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Smartphone-WLAN-Sicherheit-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"Smartphone-WLAN-Sicherheit\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Smartphone-WLAN-Sicherheit-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Smartphone-WLAN-Sicherheit-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/smartphone-wi-fi-security-public-hotspots-vs-home-network\/\">Smartphone Wi-Fi security: Public hotspots vs. home network<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/smartphone-wi-fi-security-public-hotspots-vs-home-network\/\">\n\t\t\t\t\t\tSmartphone Wi-Fi security: Public hotspots vs. home network\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/smartphone-wi-fi-security-public-hotspots-vs-home-network\/\" aria-label=\"Smartphone Wi-Fi security: Public hotspots vs. home network\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/smartphone-wi-fi-security-public-hotspots-vs-home-network\/\">Smartphone Wi-Fi security: Public hotspots vs. home network<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-12-31T18:49:55+01:00<\/span><span>December 18th, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/data-protection\/\" rel=\"category tag\">Data Protection<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/hardware-en\/\" rel=\"category tag\">Hardware<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/homeoffice-en\/\" rel=\"category tag\">Homeoffice<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/software-en\/\" rel=\"category tag\">Software<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/data-protection\/\" rel=\"tag\">Data Protection<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/hardware-en\/\" rel=\"tag\">Hardware<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/software-en\/\" rel=\"tag\">Software<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>Is smartphone Wi-Fi a security risk? This article analyzes in detail threats such as evil twin attacks and explains protective measures for when you're on the go. We also clarify why home Wi-Fi is usually secure and how you can effectively separate your smart home from sensitive data using a guest network.<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/smartphone-wi-fi-security-public-hotspots-vs-home-network\/\" aria-label=\"More on Smartphone Wi-Fi security: Public hotspots vs. home network\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-1-post-63519\" class=\"fusion-post-medium-alternate post-63519 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-artificial-intelligence-en category-microsoft-excel-en category-microsoft-office-en category-software-en tag-artificial-intelligence tag-excel-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">24<\/span><span class=\"fusion-month-year\">11, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Warum-dein-Excel-Kurs-Zeitverschwendung-ist-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"Warum dein Excel-Kurs Zeitverschwendung ist\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Warum-dein-Excel-Kurs-Zeitverschwendung-ist-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Warum-dein-Excel-Kurs-Zeitverschwendung-ist-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/warum-dein-excel-kurs-zeitverschwendung-ist\/\">Warum dein Excel-Kurs Zeitverschwendung ist &#8211; was du wirklich lernen solltest!<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/warum-dein-excel-kurs-zeitverschwendung-ist\/\">\n\t\t\t\t\t\tWarum dein Excel-Kurs Zeitverschwendung ist &#8211; was du wirklich lernen solltest!\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/warum-dein-excel-kurs-zeitverschwendung-ist\/\" aria-label=\"Warum dein Excel-Kurs Zeitverschwendung ist &#8211; was du wirklich lernen solltest!\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/warum-dein-excel-kurs-zeitverschwendung-ist\/\">Warum dein Excel-Kurs Zeitverschwendung ist &#8211; was du wirklich lernen solltest!<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-11-26T06:12:46+01:00<\/span><span>November 24th, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/artificial-intelligence-en\/\" rel=\"category tag\">Artificial intelligence<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/microsoft-excel-en\/\" rel=\"category tag\">Microsoft Excel<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/\" rel=\"category tag\">Microsoft Office<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/software-en\/\" rel=\"category tag\">Software<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/artificial-intelligence\/\" rel=\"tag\">AI<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/excel-en\/\" rel=\"tag\">Excel<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>Hand aufs Herz: Wann hast du zuletzt eine komplexe Excel-Formel ohne Googeln getippt? Eben. KI schreibt heute den Code f\u00fcr dich. Erfahre, warum klassische Excel-Trainings veraltet sind und welche 3 modernen Skills deinen Marktwert im B\u00fcro jetzt massiv steigern.<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/warum-dein-excel-kurs-zeitverschwendung-ist\/\" aria-label=\"More on Warum dein Excel-Kurs Zeitverschwendung ist &#8211; was du wirklich lernen solltest!\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-1-post-63071\" class=\"fusion-post-medium-alternate post-63071 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-data-protection category-homeoffice-en tag-data-protection tag-homeoffice-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">16<\/span><span class=\"fusion-month-year\">11, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Cybersicherheit-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"Cybersicherheit\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Cybersicherheit-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Cybersicherheit-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/cybersicherheit-die-3-groessten-fehler-die-90-prozent-aller-mitarbeiter-machen\/\">Cybersicherheit: Die 3 gr\u00f6\u00dften Fehler, die 90% aller Mitarbeiter machen<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/cybersicherheit-die-3-groessten-fehler-die-90-prozent-aller-mitarbeiter-machen\/\">\n\t\t\t\t\t\tCybersicherheit: Die 3 gr\u00f6\u00dften Fehler, die 90% aller Mitarbeiter machen\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/cybersicherheit-die-3-groessten-fehler-die-90-prozent-aller-mitarbeiter-machen\/\" aria-label=\"Cybersicherheit: Die 3 gr\u00f6\u00dften Fehler, die 90% aller Mitarbeiter machen\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/cybersicherheit-die-3-groessten-fehler-die-90-prozent-aller-mitarbeiter-machen\/\">Cybersicherheit: Die 3 gr\u00f6\u00dften Fehler, die 90% aller Mitarbeiter machen<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-11-16T17:42:53+01:00<\/span><span>November 16th, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/data-protection\/\" rel=\"category tag\">Data Protection<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/homeoffice-en\/\" rel=\"category tag\">Homeoffice<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/data-protection\/\" rel=\"tag\">Data Protection<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/homeoffice-en\/\" rel=\"tag\">Homeoffice<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>Hacker brauchen keine Codes, sie brauchen nur einen unaufmerksamen Mitarbeiter. Von Passwort-Recycling bis zum gef\u00e4hrlichen Klick: Wir zeigen die drei h\u00e4ufigsten Fehler im B\u00fcroalltag und geben praktische Tipps, wie Sie zur menschlichen Firewall werden.<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/cybersicherheit-die-3-groessten-fehler-die-90-prozent-aller-mitarbeiter-machen\/\" aria-label=\"More on Cybersicherheit: Die 3 gr\u00f6\u00dften Fehler, die 90% aller Mitarbeiter machen\">Read More<\/a><\/div><\/div><\/article>\n<\/div><div class=\"fusion-infinite-scroll-trigger\"><\/div><div class=\"pagination infinite-scroll clearfix\" style=\"display:none;\"><span class=\"current\">1<\/span><a href=\"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/posts\/11655\/page\/2\/\" class=\"inactive\">2<\/a><a class=\"pagination-next\" rel=\"next\" href=\"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/posts\/11655\/page\/2\/\"><span class=\"page-text\">Next<\/span><span class=\"page-next\"><\/span><\/a><\/div><div class=\"fusion-clearfix\"><\/div><button class=\"fusion-load-more-button fusion-blog-button fusion-clearfix\">Load More Posts<\/button><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-68 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-35 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"text-43\" class=\"widget widget_text\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"heading\"><h4 class=\"widget-title\">Offers 2024: Word &#038; Excel Templates<\/h4><\/div>\t\t\t<div class=\"textwidget\"><div class=\"fusion-image-carousel fusion-image-carousel-auto fusion-image-carousel-1 fusion-carousel-border\"><div class=\"awb-carousel awb-swiper awb-swiper-carousel awb-carousel--carousel awb-swiper-dots-position-bottom\" data-layout=\"carousel\" data-autoplay=\"no\" data-autoplayspeed=\"3000\" data-autoplaypause=\"no\" data-columns=\"4\" data-columnsmedium=\"1\" data-columnssmall=\"1\" data-itemmargin=\"13\" data-itemwidth=\"180\" data-touchscroll=\"no\" data-freemode=\"no\" data-imagesize=\"auto\" data-scrollitems=\"0\" data-centeredslides=\"no\" data-rotationangle=\"50\" data-depth=\"100\" data-speed=\"500\" data-shadow=\"no\" data-pagination=\"bullets\" style=\"--awb-columns:4;--awb-border-width:1px;--awb-border-color:#e9eaee;\"><div class=\"swiper-wrapper awb-image-carousel-wrapper fusion-flex-align-items-center\"><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/kleinunternehmer-business-bundle-download\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KU-Business-Bundle-2024.jpg\" class=\"attachment-full size-full\" alt=\"Kleinunternehmer - Business Bundle 2024\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KU-Business-Bundle-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KU-Business-Bundle-2024-400x472.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KU-Business-Bundle-2024-600x709.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KU-Business-Bundle-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-rechnungsvorlage-mit-mehrwertsteuer-und-stammdaten\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RV_DE-2024.jpg\" class=\"attachment-full size-full\" alt=\"Excel Rechnungsvorlage mit Steuer und Stammdaten\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RV_DE-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RV_DE-2024-400x472.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RV_DE-2024-600x709.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RV_DE-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-rechnungsvorlage2024-kleinunternehmer-stammdaten\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KURV-2024.jpg\" class=\"attachment-full size-full\" alt=\"Excel Rechnungsvorlage Kleinunternehmer 2024\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KURV-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KURV-2024-400x472.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KURV-2024-600x709.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KURV-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/word-geschaeftsbriefvorlage-din5008-verschiedene-designs\/\" target=\"_self\"><img decoding=\"async\" width=\"735\" height=\"866\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessletter-2024.jpg\" class=\"attachment-full size-full\" alt=\"Geschaeftsbriefvorlage 2024 - International - DIN 5008\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessletter-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessletter-2024-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessletter-2024-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessletter-2024.jpg 735w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/download-briefvorlage-word-din5008-mit-formularfeldern\/\" target=\"_self\"><img decoding=\"async\" width=\"736\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Briefvorlage-2024.jpg\" class=\"attachment-full size-full\" alt=\"Word Briefvorlage 2024 - DIN 5008\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Briefvorlage-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Briefvorlage-2024-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Briefvorlage-2024-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Briefvorlage-2024.jpg 736w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/serienbriefvorlage-word-din5008-download\/\" target=\"_self\"><img decoding=\"async\" width=\"736\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Serienbriefvorlage-2024.jpg\" class=\"attachment-full size-full\" alt=\"Word Serienbrief Vorlage - DIN 5008\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Serienbriefvorlage-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Serienbriefvorlage-2024-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Serienbriefvorlage-2024-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Serienbriefvorlage-2024.jpg 736w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-rechnungsvorlage-schweiz-download\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVCHF-2024.jpg\" class=\"attachment-full size-full\" alt=\"Excel Rechnungsvorlage Schweiz 2024 - mit Stammdaten\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVCHF-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVCHF-2024-400x472.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVCHF-2024-600x709.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVCHF-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-urlaubsplaner-2024-download\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"865\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Urlaubsplaner-2024.jpg\" class=\"attachment-full size-full\" alt=\"Excel Urlaubsplaner 2024 \" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Urlaubsplaner-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Urlaubsplaner-2024-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Urlaubsplaner-2024-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Urlaubsplaner-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-haushaltsbuch-mit-dashboard-und-boersenindizes\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"865\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2023\/05\/Produktbild-Haushaltsbuch-1.jpg\" class=\"attachment-full size-full\" alt=\"Excel Haushaltsbuch 2024\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2023\/05\/Produktbild-Haushaltsbuch-1-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2023\/05\/Produktbild-Haushaltsbuch-1-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2023\/05\/Produktbild-Haushaltsbuch-1-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2023\/05\/Produktbild-Haushaltsbuch-1.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-rechnungsvorlage-oesterreich-download\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVAUT-2024.jpg\" class=\"attachment-full size-full\" alt=\"Excel Rechnungsvorlage Oesterreich 2024 - mit Stammdaten\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVAUT-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVAUT-2024-400x472.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVAUT-2024-600x709.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVAUT-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/personalplaner-2024-excel-download\/\" target=\"_self\"><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/unternehmer-business-bundle-download\/\" target=\"_self\"><img decoding=\"async\" width=\"736\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessbundle-2024-1.jpg\" class=\"attachment-full size-full\" alt=\"Business Bundle 2024\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessbundle-2024-1-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessbundle-2024-1-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessbundle-2024-1-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessbundle-2024-1.jpg 736w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><\/div><div class=\"awb-swiper-button awb-swiper-button-prev\"><i class=\"awb-icon-angle-left\" aria-hidden=\"true\"><\/i><\/div><div class=\"awb-swiper-button awb-swiper-button-next\"><i class=\"awb-icon-angle-right\" aria-hidden=\"true\"><\/i><\/div><\/div><\/div><\/div>\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-69 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-36 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-70 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-37 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-71 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-alert alert custom alert-custom fusion-alert-left awb-alert-native-link-color\" style=\"--awb-background-color:#ffffff;--awb-accent-color:#040082;--awb-border-size:0px;--awb-border-top-left-radius:0px;--awb-border-top-right-radius:0px;--awb-border-bottom-left-radius:0px;--awb-border-bottom-right-radius:0px;\" role=\"alert\"><div class=\"fusion-alert-content-wrapper\"><span class=\"alert-icon\"><i class=\"fa-twitter fab\" aria-hidden=\"true\"><\/i><\/span><span class=\"fusion-alert-content\"><a href=\"https:\/\/twitter.com\/webdesign_ms?lang=de\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><span style=\"color: #0000ff;\">Follow us on Twitter<\/span><\/a><\/span><\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-38 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-20 has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling fusion-no-large-visibility\" style=\"--awb-background-position:left top;--awb-border-sizes-top:1px;--awb-border-sizes-bottom:1px;--awb-border-sizes-left:0px;--awb-border-sizes-right:0px;--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:20px;--awb-padding-bottom:20px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-72 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-title title fusion-title-10 sep-underline sep-solid fusion-title-text fusion-title-size-two\" style=\"--awb-margin-top-small:0px;--awb-margin-right-small:0px;--awb-margin-bottom-small:5px;--awb-margin-left-small:0px;--awb-font-size:25px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:25;line-height:1.2;\">Popular Posts:<\/h2><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-73 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-blog-shortcode fusion-blog-shortcode-2 fusion-blog-archive fusion-blog-layout-medium-alternate fusion-blog-infinite\"><div class=\"fusion-posts-container fusion-posts-container-infinite fusion-posts-container-load-more fusion-blog-rollover\" data-pages=\"20\"><article id=\"blog-2-post-64073\" class=\"fusion-post-medium-alternate post-64073 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-homeoffice-en category-microsoft-windows-en tag-homeoffice-en tag-windows-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">23<\/span><span class=\"fusion-month-year\">12, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Werbefrei-im-Heimnetz-mit-Pi-Hole-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"Werbefrei im Heimnetz mit Pi-Hole\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Werbefrei-im-Heimnetz-mit-Pi-Hole-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Werbefrei-im-Heimnetz-mit-Pi-Hole-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\">Ad-free home network: Install Pi-hole on Windows<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\">\n\t\t\t\t\t\tAd-free home network: Install Pi-hole on Windows\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\" aria-label=\"Ad-free home network: Install Pi-hole on Windows\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\">Ad-free home network: Install Pi-hole on Windows<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-12-27T07:20:04+01:00<\/span><span>December 23rd, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/homeoffice-en\/\" rel=\"category tag\">Homeoffice<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/uncategorized\/microsoft-windows-en\/\" rel=\"category tag\">Windows 10\/11\/12<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/homeoffice-en\/\" rel=\"tag\">Homeoffice<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/windows-en\/\" rel=\"tag\">Windows<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>Say goodbye to ads on smart TVs and in apps: Pi-hole software turns your Windows laptop into a network filter. This article explains step-by-step how to install it via Docker and configure the necessary DNS settings in your FRITZ!Box.<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/ad-free-home-network-install-pi-hole-on-windows\/\" aria-label=\"More on Ad-free home network: Install Pi-hole on Windows\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-2-post-64104\" class=\"fusion-post-medium-alternate post-64104 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-homeoffice-en category-microsoft-windows-en tag-career tag-homeoffice-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">22<\/span><span class=\"fusion-month-year\">12, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/fritzbox-mit-laptop-verbinden-telefonzentrale-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"fritzbox-mit-laptop-verbinden-telefonzentrale\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/fritzbox-mit-laptop-verbinden-telefonzentrale-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/fritzbox-mit-laptop-verbinden-telefonzentrale-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\">How to tune your FRITZ!Box into a professional call server<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\">\n\t\t\t\t\t\tHow to tune your FRITZ!Box into a professional call server\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\" aria-label=\"How to tune your FRITZ!Box into a professional call server\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\">How to tune your FRITZ!Box into a professional call server<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-12-27T09:39:27+01:00<\/span><span>December 22nd, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/homeoffice-en\/\" rel=\"category tag\">Homeoffice<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/uncategorized\/microsoft-windows-en\/\" rel=\"category tag\">Windows 10\/11\/12<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/career\/\" rel=\"tag\">Career<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/homeoffice-en\/\" rel=\"tag\">Homeoffice<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>A professional telephone system can be built using a FRITZ!Box and a laptop. This article shows step by step how to use the free software \"Phoner\" to schedule announcements and record calls \u2013 including important legal information (\u00a7 201 StGB).<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/how-to-tune-your-fritzbox-into-a-professional-call-server\/\" aria-label=\"More on How to tune your FRITZ!Box into a professional call server\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-2-post-64113\" class=\"fusion-post-medium-alternate post-64113 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-career category-homeoffice-en tag-career tag-homeoffice-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">21<\/span><span class=\"fusion-month-year\">12, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/to-do-list-vs-timeboxing-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"to-do-list-vs-timeboxing\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/to-do-list-vs-timeboxing-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/to-do-list-vs-timeboxing-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/why-to-do-lists-are-a-waste-of-time\/\">Why to-do lists are a waste of time<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/why-to-do-lists-are-a-waste-of-time\/\">\n\t\t\t\t\t\tWhy to-do lists are a waste of time\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/why-to-do-lists-are-a-waste-of-time\/\" aria-label=\"Why to-do lists are a waste of time\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/why-to-do-lists-are-a-waste-of-time\/\">Why to-do lists are a waste of time<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-12-27T09:50:09+01:00<\/span><span>December 21st, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/career\/\" rel=\"category tag\">Career<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/homeoffice-en\/\" rel=\"category tag\">Homeoffice<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/career\/\" rel=\"tag\">Career<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/homeoffice-en\/\" rel=\"tag\">Homeoffice<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>Do you feel unproductive at the end of the day, even though you've worked hard? Your to-do list is to blame. It tempts you to focus on easy tasks and ignores your limited time. This article explains why lists are \"self-deception\" and why professionals use a calendar instead.<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/why-to-do-lists-are-a-waste-of-time\/\" aria-label=\"More on Why to-do lists are a waste of time\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-2-post-64157\" class=\"fusion-post-medium-alternate post-64157 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-data-protection category-hardware-en category-homeoffice-en category-software-en tag-data-protection tag-hardware-en tag-software-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">18<\/span><span class=\"fusion-month-year\">12, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Smartphone-WLAN-Sicherheit-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"Smartphone-WLAN-Sicherheit\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Smartphone-WLAN-Sicherheit-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/12\/Smartphone-WLAN-Sicherheit-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/smartphone-wi-fi-security-public-hotspots-vs-home-network\/\">Smartphone Wi-Fi security: Public hotspots vs. home network<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/smartphone-wi-fi-security-public-hotspots-vs-home-network\/\">\n\t\t\t\t\t\tSmartphone Wi-Fi security: Public hotspots vs. home network\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/smartphone-wi-fi-security-public-hotspots-vs-home-network\/\" aria-label=\"Smartphone Wi-Fi security: Public hotspots vs. home network\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/smartphone-wi-fi-security-public-hotspots-vs-home-network\/\">Smartphone Wi-Fi security: Public hotspots vs. home network<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-12-31T18:49:55+01:00<\/span><span>December 18th, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/data-protection\/\" rel=\"category tag\">Data Protection<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/hardware-en\/\" rel=\"category tag\">Hardware<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/homeoffice-en\/\" rel=\"category tag\">Homeoffice<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/software-en\/\" rel=\"category tag\">Software<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/data-protection\/\" rel=\"tag\">Data Protection<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/hardware-en\/\" rel=\"tag\">Hardware<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/software-en\/\" rel=\"tag\">Software<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>Is smartphone Wi-Fi a security risk? This article analyzes in detail threats such as evil twin attacks and explains protective measures for when you're on the go. We also clarify why home Wi-Fi is usually secure and how you can effectively separate your smart home from sensitive data using a guest network.<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/smartphone-wi-fi-security-public-hotspots-vs-home-network\/\" aria-label=\"More on Smartphone Wi-Fi security: Public hotspots vs. home network\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-2-post-63519\" class=\"fusion-post-medium-alternate post-63519 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-artificial-intelligence-en category-microsoft-excel-en category-microsoft-office-en category-software-en tag-artificial-intelligence tag-excel-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">24<\/span><span class=\"fusion-month-year\">11, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Warum-dein-Excel-Kurs-Zeitverschwendung-ist-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"Warum dein Excel-Kurs Zeitverschwendung ist\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Warum-dein-Excel-Kurs-Zeitverschwendung-ist-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Warum-dein-Excel-Kurs-Zeitverschwendung-ist-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/warum-dein-excel-kurs-zeitverschwendung-ist\/\">Warum dein Excel-Kurs Zeitverschwendung ist &#8211; was du wirklich lernen solltest!<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/warum-dein-excel-kurs-zeitverschwendung-ist\/\">\n\t\t\t\t\t\tWarum dein Excel-Kurs Zeitverschwendung ist &#8211; was du wirklich lernen solltest!\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/warum-dein-excel-kurs-zeitverschwendung-ist\/\" aria-label=\"Warum dein Excel-Kurs Zeitverschwendung ist &#8211; was du wirklich lernen solltest!\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/warum-dein-excel-kurs-zeitverschwendung-ist\/\">Warum dein Excel-Kurs Zeitverschwendung ist &#8211; was du wirklich lernen solltest!<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-11-26T06:12:46+01:00<\/span><span>November 24th, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/artificial-intelligence-en\/\" rel=\"category tag\">Artificial intelligence<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/microsoft-excel-en\/\" rel=\"category tag\">Microsoft Excel<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/\" rel=\"category tag\">Microsoft Office<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/software-en\/\" rel=\"category tag\">Software<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/artificial-intelligence\/\" rel=\"tag\">AI<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/excel-en\/\" rel=\"tag\">Excel<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>Hand aufs Herz: Wann hast du zuletzt eine komplexe Excel-Formel ohne Googeln getippt? Eben. KI schreibt heute den Code f\u00fcr dich. Erfahre, warum klassische Excel-Trainings veraltet sind und welche 3 modernen Skills deinen Marktwert im B\u00fcro jetzt massiv steigern.<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/warum-dein-excel-kurs-zeitverschwendung-ist\/\" aria-label=\"More on Warum dein Excel-Kurs Zeitverschwendung ist &#8211; was du wirklich lernen solltest!\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-2-post-63071\" class=\"fusion-post-medium-alternate post-63071 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-data-protection category-homeoffice-en tag-data-protection tag-homeoffice-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">16<\/span><span class=\"fusion-month-year\">11, 2025<\/span><\/div><div class=\"fusion-format-box\"><i class=\"awb-icon-pen\" aria-hidden=\"true\"><\/i><\/div><\/div>\t<style type=\"text\/css\">\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t<\/style>\n\n\n\t\t\t<div class=\"fusion-flexslider flexslider fusion-flexslider-loading fusion-post-slideshow\" style=\"\">\n\t\t<ul class=\"slides\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li><div  class=\"fusion-image-wrapper fusion-image-size-fixed\" aria-haspopup=\"true\">\n\t\t\t\t<img decoding=\"async\" width=\"320\" height=\"202\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Cybersicherheit-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"Cybersicherheit\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Cybersicherheit-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Cybersicherheit-700x441.jpg 700w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><div class=\"fusion-rollover\">\n\t<div class=\"fusion-rollover-content\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"fusion-rollover-link\" href=\"https:\/\/ms-office-training.de\/en\/cybersicherheit-die-3-groessten-fehler-die-90-prozent-aller-mitarbeiter-machen\/\">Cybersicherheit: Die 3 gr\u00f6\u00dften Fehler, die 90% aller Mitarbeiter machen<\/a>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"fusion-rollover-title\">\n\t\t\t\t\t<a class=\"fusion-rollover-title-link\" href=\"https:\/\/ms-office-training.de\/en\/cybersicherheit-die-3-groessten-fehler-die-90-prozent-aller-mitarbeiter-machen\/\">\n\t\t\t\t\t\tCybersicherheit: Die 3 gr\u00f6\u00dften Fehler, die 90% aller Mitarbeiter machen\t\t\t\t\t<\/a>\n\t\t\t\t<\/h4>\n\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\n\t\t\t\t\t\t<a class=\"fusion-link-wrapper\" href=\"https:\/\/ms-office-training.de\/en\/cybersicherheit-die-3-groessten-fehler-die-90-prozent-aller-mitarbeiter-machen\/\" aria-label=\"Cybersicherheit: Die 3 gr\u00f6\u00dften Fehler, die 90% aller Mitarbeiter machen\"><\/a>\n\t<\/div>\n<\/div>\n<\/div>\n<\/li>\n\t\t\t\n\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\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t<\/div>\n\t<div class=\"fusion-post-content post-content\"><h2 class=\"blog-shortcode-post-title entry-title\"><a href=\"https:\/\/ms-office-training.de\/en\/cybersicherheit-die-3-groessten-fehler-die-90-prozent-aller-mitarbeiter-machen\/\">Cybersicherheit: Die 3 gr\u00f6\u00dften Fehler, die 90% aller Mitarbeiter machen<\/a><\/h2><p class=\"fusion-single-line-meta\"><span class=\"vcard\" style=\"display: none;\"><span class=\"fn\"><a href=\"https:\/\/ms-office-training.de\/en\/author\/msuhr\/\" title=\"Posts by Michael\" rel=\"author\">Michael<\/a><\/span><\/span><span class=\"updated\" style=\"display:none;\">2025-11-16T17:42:53+01:00<\/span><span>November 16th, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <a href=\"https:\/\/ms-office-training.de\/en\/category\/shorts-and-tutorials-en\/\" rel=\"category tag\">Shorts &amp; Tutorials<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/data-protection\/\" rel=\"category tag\">Data Protection<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/homeoffice-en\/\" rel=\"category tag\">Homeoffice<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/data-protection\/\" rel=\"tag\">Data Protection<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/homeoffice-en\/\" rel=\"tag\">Homeoffice<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>Hacker brauchen keine Codes, sie brauchen nur einen unaufmerksamen Mitarbeiter. Von Passwort-Recycling bis zum gef\u00e4hrlichen Klick: Wir zeigen die drei h\u00e4ufigsten Fehler im B\u00fcroalltag und geben praktische Tipps, wie Sie zur menschlichen Firewall werden.<\/p><\/div><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"fusion-meta-info\"><div class=\"fusion-alignright\"><a class=\"fusion-read-more\" href=\"https:\/\/ms-office-training.de\/en\/cybersicherheit-die-3-groessten-fehler-die-90-prozent-aller-mitarbeiter-machen\/\" aria-label=\"More on Cybersicherheit: Die 3 gr\u00f6\u00dften Fehler, die 90% aller Mitarbeiter machen\">Read More<\/a><\/div><\/div><\/article>\n<\/div><div class=\"fusion-infinite-scroll-trigger\"><\/div><div class=\"pagination infinite-scroll clearfix\" style=\"display:none;\"><span class=\"current\">1<\/span><a href=\"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/posts\/11655\/page\/2\/\" class=\"inactive\">2<\/a><a class=\"pagination-next\" rel=\"next\" href=\"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/posts\/11655\/page\/2\/\"><span class=\"page-text\">Next<\/span><span class=\"page-next\"><\/span><\/a><\/div><div class=\"fusion-clearfix\"><\/div><button class=\"fusion-load-more-button fusion-blog-button fusion-clearfix\">Load More Posts<\/button><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-74 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-39 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div id=\"text-43\" class=\"widget widget_text\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"heading\"><h4 class=\"widget-title\">Offers 2024: Word &#038; Excel Templates<\/h4><\/div>\t\t\t<div class=\"textwidget\"><div class=\"fusion-image-carousel fusion-image-carousel-auto fusion-image-carousel-2 fusion-carousel-border\"><div class=\"awb-carousel awb-swiper awb-swiper-carousel awb-carousel--carousel awb-swiper-dots-position-bottom\" data-layout=\"carousel\" data-autoplay=\"no\" data-autoplayspeed=\"3000\" data-autoplaypause=\"no\" data-columns=\"4\" data-columnsmedium=\"1\" data-columnssmall=\"1\" data-itemmargin=\"13\" data-itemwidth=\"180\" data-touchscroll=\"no\" data-freemode=\"no\" data-imagesize=\"auto\" data-scrollitems=\"0\" data-centeredslides=\"no\" data-rotationangle=\"50\" data-depth=\"100\" data-speed=\"500\" data-shadow=\"no\" data-pagination=\"bullets\" style=\"--awb-columns:4;--awb-border-width:1px;--awb-border-color:#e9eaee;\"><div class=\"swiper-wrapper awb-image-carousel-wrapper fusion-flex-align-items-center\"><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/download-briefvorlage-word-din5008-mit-formularfeldern\/\" target=\"_self\"><img decoding=\"async\" width=\"736\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Briefvorlage-2024.jpg\" class=\"attachment-full size-full\" alt=\"Word Briefvorlage 2024 - DIN 5008\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Briefvorlage-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Briefvorlage-2024-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Briefvorlage-2024-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Briefvorlage-2024.jpg 736w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-rechnungsvorlage-schweiz-download\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVCHF-2024.jpg\" class=\"attachment-full size-full\" alt=\"Excel Rechnungsvorlage Schweiz 2024 - mit Stammdaten\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVCHF-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVCHF-2024-400x472.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVCHF-2024-600x709.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVCHF-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/personalplaner-2024-excel-download\/\" target=\"_self\"><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/unternehmer-business-bundle-download\/\" target=\"_self\"><img decoding=\"async\" width=\"736\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessbundle-2024-1.jpg\" class=\"attachment-full size-full\" alt=\"Business Bundle 2024\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessbundle-2024-1-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessbundle-2024-1-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessbundle-2024-1-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessbundle-2024-1.jpg 736w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-rechnungsvorlage-mit-mehrwertsteuer-und-stammdaten\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RV_DE-2024.jpg\" class=\"attachment-full size-full\" alt=\"Excel Rechnungsvorlage mit Steuer und Stammdaten\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RV_DE-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RV_DE-2024-400x472.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RV_DE-2024-600x709.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RV_DE-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/word-geschaeftsbriefvorlage-din5008-verschiedene-designs\/\" target=\"_self\"><img decoding=\"async\" width=\"735\" height=\"866\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessletter-2024.jpg\" class=\"attachment-full size-full\" alt=\"Geschaeftsbriefvorlage 2024 - International - DIN 5008\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessletter-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessletter-2024-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessletter-2024-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Businessletter-2024.jpg 735w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/serienbriefvorlage-word-din5008-download\/\" target=\"_self\"><img decoding=\"async\" width=\"736\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Serienbriefvorlage-2024.jpg\" class=\"attachment-full size-full\" alt=\"Word Serienbrief Vorlage - DIN 5008\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Serienbriefvorlage-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Serienbriefvorlage-2024-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Serienbriefvorlage-2024-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Serienbriefvorlage-2024.jpg 736w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-urlaubsplaner-2024-download\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"865\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Urlaubsplaner-2024.jpg\" class=\"attachment-full size-full\" alt=\"Excel Urlaubsplaner 2024 \" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Urlaubsplaner-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Urlaubsplaner-2024-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Urlaubsplaner-2024-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-Urlaubsplaner-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/kleinunternehmer-business-bundle-download\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KU-Business-Bundle-2024.jpg\" class=\"attachment-full size-full\" alt=\"Kleinunternehmer - Business Bundle 2024\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KU-Business-Bundle-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KU-Business-Bundle-2024-400x472.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KU-Business-Bundle-2024-600x709.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KU-Business-Bundle-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-rechnungsvorlage2024-kleinunternehmer-stammdaten\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KURV-2024.jpg\" class=\"attachment-full size-full\" alt=\"Excel Rechnungsvorlage Kleinunternehmer 2024\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KURV-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KURV-2024-400x472.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KURV-2024-600x709.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-KURV-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-rechnungsvorlage-oesterreich-download\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"867\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVAUT-2024.jpg\" class=\"attachment-full size-full\" alt=\"Excel Rechnungsvorlage Oesterreich 2024 - mit Stammdaten\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVAUT-2024-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVAUT-2024-400x472.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVAUT-2024-600x709.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2022\/08\/Produktbild-RVAUT-2024.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-liftup\"><a href=\"https:\/\/ms-office-training.de\/shop\/excel-haushaltsbuch-mit-dashboard-und-boersenindizes\/\" target=\"_self\"><img decoding=\"async\" width=\"734\" height=\"865\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2023\/05\/Produktbild-Haushaltsbuch-1.jpg\" class=\"attachment-full size-full\" alt=\"Excel Haushaltsbuch 2024\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2023\/05\/Produktbild-Haushaltsbuch-1-200x236.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2023\/05\/Produktbild-Haushaltsbuch-1-400x471.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2023\/05\/Produktbild-Haushaltsbuch-1-600x707.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2023\/05\/Produktbild-Haushaltsbuch-1.jpg 734w\" sizes=\"(min-width: 2200px) 100vw, (min-width: 717px) 470px, (min-width: 691px) 627px, (min-width: 666px) 691px, (min-width: 640px) 666px, \" \/><\/a><\/div><\/div><\/div><\/div><div class=\"awb-swiper-button awb-swiper-button-prev\"><i class=\"awb-icon-angle-left\" aria-hidden=\"true\"><\/i><\/div><div class=\"awb-swiper-button awb-swiper-button-next\"><i class=\"awb-icon-angle-right\" aria-hidden=\"true\"><\/i><\/div><\/div><\/div><\/div>\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-75 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-40 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-76 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-41 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-77 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-animated\" style=\"--awb-bg-size:cover;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-alert alert custom alert-custom fusion-alert-left awb-alert-native-link-color\" style=\"--awb-background-color:#ffffff;--awb-accent-color:#040082;--awb-border-size:0px;--awb-border-top-left-radius:0px;--awb-border-top-right-radius:0px;--awb-border-bottom-left-radius:0px;--awb-border-bottom-right-radius:0px;\" role=\"alert\"><div class=\"fusion-alert-content-wrapper\"><span class=\"alert-icon\"><i class=\"fa-twitter fab\" aria-hidden=\"true\"><\/i><\/span><span class=\"fusion-alert-content\"><a href=\"https:\/\/twitter.com\/webdesign_ms?lang=de\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><span style=\"color: #0000ff;\">Follow us on Twitter<\/span><\/a><\/span><\/div><\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-42 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><div class=\"fusion-additional-widget-content\"><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel: How to get S-reference and W-reference purposefully data out of a source.<\/p>\n","protected":false},"author":4,"featured_media":11627,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"footnotes":""},"categories":[211,762,3358,2875],"tags":[3631,3586],"class_list":["post-11655","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel-en","category-microsoft-office-en","category-office-365-en","category-shorts-and-tutorials-en","tag-excel-en","tag-excel-tables"],"_links":{"self":[{"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/posts\/11655","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/comments?post=11655"}],"version-history":[{"count":0,"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/posts\/11655\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/media\/11627"}],"wp:attachment":[{"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/media?parent=11655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/categories?post=11655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/tags?post=11655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}