{"id":62294,"date":"2025-10-27T06:41:46","date_gmt":"2025-10-27T05:41:46","guid":{"rendered":"https:\/\/ms-office-training.de\/die-indirekt-funktion-in-excel-meistern\/"},"modified":"2025-11-05T15:30:39","modified_gmt":"2025-11-05T14:30:39","slug":"mastering-the-indirect-function-in-excel","status":"publish","type":"post","link":"https:\/\/ms-office-training.de\/en\/mastering-the-indirect-function-in-excel\/","title":{"rendered":"Mastering the INDIRECT function in Excel"},"content":{"rendered":"<p><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container has-pattern-background has-mask-background nonhundred-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 fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"max-width:104%;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-color-hover:rgba(237,237,237,0);--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-center fusion-content-layout-column\"><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><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-2 fusion-flex-container 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-padding-right:50px;--awb-padding-left:60px;--awb-padding-right-medium:0px;--awb-padding-left-medium:0px;--awb-padding-right-small:0px;--awb-padding-left-small:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-flex-align-self-flex-start 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;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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;\">Mastering the INDIRECT function in Excel: Converting text into dynamic references<\/h1><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-flex-align-self-flex-start fusion-column-no-min-height\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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 0px;\"><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>In the world of Excel, cell references like =A1 or =SUM(B2:B10) are commonplace. These references are direct and static. They always point to the same cell or range. But what if you want your reference to change based on the content of a different cell? That&#8217;s where the INDIRECT function comes in.<\/p>\n<p>INDIRECT is a powerful, though often overlooked, function that takes a text string (plain text) and converts it into a real, working cell reference. It&#8217;s the tool of choice for making your spreadsheets dynamic and flexible.<\/p>\n<\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-3 fusion_builder_column_3_4 3_4 fusion-flex-column fusion-flex-align-self-flex-start fusion-column-no-min-height\" style=\"--awb-bg-size:cover;--awb-width-large:75%;--awb-margin-top-large:0px;--awb-spacing-right-large:3.84%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:2.56%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-image-element \" 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);\"><span class=\" fusion-imageframe imageframe-none imageframe-1 hover-type-none\" style=\"border-radius:3px;\"><img decoding=\"async\" width=\"1000\" height=\"717\" alt=\"indirekt-funktion-excel\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/indirekt-funktion-excel.jpg\" class=\"img-responsive wp-image-62298\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/indirekt-funktion-excel-200x143.jpg 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/indirekt-funktion-excel-400x287.jpg 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/indirekt-funktion-excel-600x430.jpg 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/indirekt-funktion-excel-800x574.jpg 800w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/indirekt-funktion-excel.jpg 1000w\" sizes=\"(max-width: 1024px) 100vw, (max-width: 640px) 100vw, 1000px\" \/><\/span><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-4 fusion_builder_column_1_4 1_4 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:25%;--awb-margin-top-large:0px;--awb-spacing-right-large:7.68%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:3.84%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-5 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-4 fusion-content-widget-area\" style=\"--awb-title-size:21px;--awb-background-color:var(--awb-color1);--awb-title-color:#002baf;--awb-padding:0px 0px 0px 0px;\"><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 id=\"text-76\" class=\"widget widget_text\" style=\"border-style: solid;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><div class=\"accordian fusion-accordian\" style=\"--awb-padding-top:5px;--awb-padding-right:5px;--awb-padding-bottom:5px;--awb-padding-left:5px;--awb-border-size:1px;--awb-icon-size:20px;--awb-content-font-size:21px;--awb-icon-alignment:left;--awb-hover-color:#f4f4f4;--awb-border-color:#00d6fc;--awb-background-color:rgba(255,255,255,0.96);--awb-divider-color:#00d6fc;--awb-divider-hover-color:#00d6fc;--awb-icon-color:#00d6fc;--awb-title-color:#ffffff;--awb-content-color:rgba(0,52,158,0.9);--awb-icon-box-color:#ffffff;--awb-toggle-hover-accent-color:#14b701;--awb-toggle-active-accent-color:#14b701;--awb-title-font-family:&quot;Orbitron&quot;;--awb-title-font-weight:400;--awb-title-font-style:normal;--awb-title-font-size:20px;--awb-content-font-family:&quot;Oxanium&quot;;--awb-content-font-style:normal;--awb-content-font-weight:400;\"><div class=\"panel-group fusion-toggle-icon-boxed\" id=\"accordion--1\"><div class=\"fusion-panel panel-default panel-432fe4d27875bfdf4 fusion-toggle-no-divider fusion-toggle-boxed-mode\" style=\"--awb-title-font-family:&quot;Orbitron&quot;;--awb-title-font-weight:400;--awb-title-font-style:normal;--awb-title-font-size:20px;--awb-title-color:#ffffff;--awb-content-color:rgba(0,52,158,0.9);\"><div class=\"panel-heading\"><h4 class=\"panel-title toggle\" id=\"toggle_432fe4d27875bfdf4\"><a aria-expanded=\"false\" aria-controls=\"432fe4d27875bfdf4\" role=\"button\" data-toggle=\"collapse\" data-parent=\"#accordion--1\" data-target=\"#432fe4d27875bfdf4\" href=\"#432fe4d27875bfdf4\"><span class=\"fusion-toggle-icon-wrapper\" aria-hidden=\"true\"><i class=\"fa-fusion-box active-icon fa-book-open fas\" aria-hidden=\"true\"><\/i><i class=\"fa-fusion-box inactive-icon fa-book fas\" aria-hidden=\"true\"><\/i><\/span><span class=\"fusion-toggle-heading\">Latest Posts<\/span><\/a><\/h4><\/div><div id=\"432fe4d27875bfdf4\" class=\"panel-collapse collapse \" aria-labelledby=\"toggle_432fe4d27875bfdf4\"><div class=\"panel-body toggle-content fusion-clearfix\"><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\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\t\t<span class=\"post-date\">31. December 2025<\/span>\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\t\t<span class=\"post-date\">26. December 2025<\/span>\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\t\t<span class=\"post-date\">26. December 2025<\/span>\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\t\t<span class=\"post-date\">23. December 2025<\/span>\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\t\t<span class=\"post-date\">23. December 2025<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t<\/ul>\n\n\t\t<\/div><\/div>\r\n\r\n<div style=\"text-align:center;\"><a class=\"fusion-button button-flat button-medium button-default fusion-button-default button-1 fusion-button-span-yes fusion-button-default-type\" target=\"_blank\" rel=\"noopener noreferrer\" href=\"https:\/\/ms-office-training.de\/en\/newsblog\/\"><span class=\"fusion-button-icon-divider button-icon-divider-left\"><i class=\"fa-book-reader fas awb-button__icon awb-button__icon--default\" aria-hidden=\"true\"><\/i><\/span><span class=\"fusion-button-text awb-button__text awb-button__text--default fusion-button-text-left\">Show all Posts<\/span><\/a><\/div><\/div><\/div><\/div><\/div><\/div><\/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-6 fusion-content-widget-area\" style=\"--awb-margin-bottom:0px;--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 style=\"text-align:center;\"><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><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-3 fusion-flex-container 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-padding-right:50px;--awb-padding-left:60px;--awb-padding-right-medium:0px;--awb-padding-left-medium:0px;--awb-padding-right-small:0px;--awb-padding-left-small:0px;--awb-margin-top:20px;--awb-margin-top-medium:20px;--awb-margin-top-small:20px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-6 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" 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;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-2 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;\">What does the INDIRECT function do?<\/h2><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-4 fusion-flex-container has-pattern-background has-mask-background hundred-percent-fullwidth non-hundred-percent-height-scrolling\" 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:0px;--awb-padding-left:60px;--awb-padding-top-medium:20px;--awb-padding-right-medium:0px;--awb-padding-left-medium:0px;--awb-padding-top-small:20px;--awb-padding-right-small:0px;--awb-padding-left-small:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><main class=\"fusion-layout-column fusion_builder_column fusion-builder-column-7 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" style=\"--awb-bg-size:cover;--awb-border-color:var(--awb-color3);--awb-border-top:0;--awb-border-right:0;--awb-border-bottom:0;--awb-border-left:0;--awb-border-style:solid;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-text fusion-text-2\"><p>Imagine you have the text &#8220;B1&#8221; in cell A1. If you then enter the formula =A1 in cell C1, the result is simply the text &#8220;B1&#8221;. However, if you enter the formula =INDIRECT(A1) in cell C1 instead, Excel looks at the content of A1 (&#8220;B1&#8221;), converts this text into a reference to cell B1, and returns the value from cell B1.<\/p>\n<p><strong>INDIRECT thus acts as a translator:<\/strong> It reads a text string and tells Excel: <em>&#8220;Hey, this isn&#8217;t normal text, this is an address. Go there and get the value.&#8221;<\/em><\/p>\n<p>The Syntax Broken Down<\/p>\n<p>The syntax of the function is relatively simple:<\/p>\n<p><strong>=INDIRECT(reference text; [A1])<\/strong><\/p>\n<p>Reference Text (Required): This is the text string that Excel should convert into a reference. This can be direct text (e.g., &#8220;C5&#8221;) or, much more commonly, a reference to a cell containing the text (e.g., A1). It can also be a formula that creates a text string (e.g., &#8220;Table&#8221; &amp; A2 &amp; &#8220;!B5&#8221;).<\/p>\n<p>[A1] (Optional): This argument specifies the reference type.<\/p>\n<p><span style=\"color: #339966;\"><strong>TRUE or omitted:<\/strong><\/span> Excel expects the default reference type &#8220;A1&#8221; (e.g., B3, C4:D5).<\/p>\n<p><span style=\"color: #993300;\"><strong>FALSE:<\/strong><\/span> Excel expects the &#8220;R1C1&#8221; reference type (Row 1 Column 1).<\/p>\n<p>\ud83d\udca1<strong>Tip:<\/strong> In 99% of cases, you can simply ignore and omit this argument.<\/p>\n<\/div><\/div><\/main><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-5 fusion-flex-container 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-padding-right:50px;--awb-padding-left:60px;--awb-padding-right-medium:0px;--awb-padding-left-medium:0px;--awb-padding-right-small:0px;--awb-padding-left-small:0px;--awb-margin-top:20px;--awb-margin-top-medium:20px;--awb-margin-top-small:20px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-8 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" 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;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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;\">Practical example: Dynamic data summarization<\/h2><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-6 fusion-flex-container has-pattern-background has-mask-background hundred-percent-fullwidth non-hundred-percent-height-scrolling\" 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:0px;--awb-padding-left:60px;--awb-padding-top-medium:20px;--awb-padding-right-medium:0px;--awb-padding-left-medium:0px;--awb-padding-top-small:20px;--awb-padding-right-small:0px;--awb-padding-left-small:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><main class=\"fusion-layout-column fusion_builder_column fusion-builder-column-9 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-text fusion-text-3\"><p>The best way to understand INDIRECT is through a practical example. Imagine you have a worksheet for each month of the year: &#8220;January,&#8221; &#8220;February,&#8221; &#8220;March,&#8221; and so on.<\/p>\n<p>In each of these monthly sheets, the total sales are in cell E10.<\/p>\n<p>Now you want to create a summary table that lists all the total sales.<\/p>\n<p>The slow, static way: In your summary table, you would manually type:<\/p>\n<p>In B2: =January!D6<\/p>\n<p>In B3: =February!D6<\/p>\n<p>In B4: =March!D6<\/p>\n<p>&#8230;and so on.<\/p>\n<p>This is tedious and prone to errors. What if the cell changes? You would have to adjust all the formulas manually.<\/p>\n<h3><strong>The fast, dynamic way with INDIRECT:<\/strong><\/h3>\n<p>Set up your &#8220;Overview&#8221; table so that the month names (which must be exactly the same as the worksheet names!) are in column A.<\/p>\n<\/div><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=\"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-text fusion-text-4\"><p>Set up your &#8220;Overview&#8221; table so that the month names (which must be exactly the same as the worksheet names!) are in column A.<\/p>\n<p>Go to cell B2 and enter the following formula:<\/p>\n<p>=INDIRECT(A2 &amp; &#8220;!D6&#8221;) [Cell D6 is just an example here. In your table, it must be named after the cell containing the desired value.]<\/p>\n<p>Copy this formula down from B2 to B5.<\/p>\n<p><strong>What&#8217;s happening here?<\/strong><\/p>\n<ul>\n<li>In cell B2:<\/li>\n<li>The formula takes the value from A2 (&#8220;January&#8221;).<\/li>\n<li>It concatenates (&amp;) it with the text string &#8220;!D6&#8221;.<\/li>\n<li>The result of this concatenation is the text: &#8220;January!D6&#8221;.<\/li>\n<li>INDIRECT takes this text and converts it into a real reference: January!D6.<\/li>\n<li>Excel retrieves the value from cell E10 of the &#8220;January&#8221; sheet.<\/li>\n<\/ul>\n<p><strong>In cell B3 (when copying):<\/strong><\/p>\n<ul>\n<li>The reference A2 automatically adjusts to A3.<\/li>\n<li>The formula is now =INDIRECT(A3 &amp; &#8220;!D6&#8221;).<\/li>\n<li>It takes the value from A3 (&#8220;February&#8221;) and creates the text &#8220;February!D6&#8221;.<\/li>\n<li>INDIRECT retrieves the value from cell D6 of the &#8220;February&#8221; sheet.<\/li>\n<\/ul>\n<p>You now have a single, flexible formula that you can use for all 12 months. If you add an &#8220;April&#8221; sheet next year, you simply need to type &#8220;April&#8221; in A5 and drag the formula down.<\/p>\n<\/div><\/div><\/main><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-10 fusion_builder_column_1_2 1_2 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:50%;--awb-margin-top-large:0px;--awb-spacing-right-large:3.84%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:3.84%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-image-element \" 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=\"awb-image-frame awb-image-frame-2 imageframe-liftup imageframe-2\"><span class=\" fusion-imageframe imageframe-none imageframe-2\" style=\"border-radius:5px;\"><a href=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.14.42.135-AM.png\" class=\"fusion-lightbox\" data-rel=\"iLightbox[2e51222af7fe05a365e]\"><img decoding=\"async\" width=\"400\" height=\"338\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.14.42.135-AM-400x338.png\" alt class=\"img-responsive wp-image-62297\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.14.42.135-AM-200x169.png 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.14.42.135-AM-400x338.png 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.14.42.135-AM-600x507.png 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.14.42.135-AM-800x675.png 800w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.14.42.135-AM.png 982w\" sizes=\"(max-width: 1024px) 100vw, (max-width: 640px) 100vw, 400px\" \/><\/a><\/span><\/div><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-11 fusion_builder_column_1_2 1_2 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:50%;--awb-margin-top-large:0px;--awb-spacing-right-large:3.84%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:3.84%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-image-element \" 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=\"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\/2025\/10\/Screen-Shot-2025-10-27-at-06.16.47.499-AM.png\" class=\"fusion-lightbox\" data-rel=\"iLightbox[e7cfe6ce0a291e5af20]\"><img decoding=\"async\" width=\"400\" height=\"533\" src=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.16.47.499-AM-400x533.png\" alt class=\"img-responsive wp-image-62301\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.16.47.499-AM-200x267.png 200w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.16.47.499-AM-400x533.png 400w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.16.47.499-AM-600x800.png 600w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.16.47.499-AM-800x1067.png 800w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/Screen-Shot-2025-10-27-at-06.16.47.499-AM.png 1032w\" sizes=\"(max-width: 1024px) 100vw, (max-width: 640px) 100vw, 400px\" \/><\/a><\/span><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-7 fusion-flex-container 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-padding-right:50px;--awb-padding-left:60px;--awb-padding-right-medium:0px;--awb-padding-left-medium:0px;--awb-padding-right-small:0px;--awb-padding-left-small:0px;--awb-margin-top:20px;--awb-margin-top-medium:20px;--awb-margin-top-small:20px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-12 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" 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;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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;\">Why is the INDIRECT function so useful?<\/h2><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-8 fusion-flex-container has-pattern-background has-mask-background hundred-percent-fullwidth non-hundred-percent-height-scrolling\" 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:0px;--awb-padding-left:60px;--awb-padding-top-medium:20px;--awb-padding-right-medium:0px;--awb-padding-left-medium:0px;--awb-padding-top-small:20px;--awb-padding-right-small:0px;--awb-padding-left-small:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><main class=\"fusion-layout-column fusion_builder_column fusion-builder-column-13 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-text fusion-text-5\"><p>The main advantage of INDIRECT is its flexibility. It &#8220;decouples&#8221; the formula from the actual reference. The reference is instead controlled by another cell&#8217;s content.<\/p>\n<p><strong>Other common use cases include:<\/strong><\/p>\n<ul>\n<li>Dependent drop-down lists: You can create a drop-down list (data validation) whose options change depending on what is selected in another cell.<\/li>\n<li>Dynamic named ranges: You can reference a named range whose name is in a cell.<\/li>\n<li>Creating dashboards: You can control which data is displayed in a chart or table simply by changing a text value in a cell (e.g., &#8220;Week 1&#8221;, &#8220;Week 2&#8221;).<\/li>\n<\/ul>\n<p><strong>Important notes:<\/strong><\/p>\n<p>Despite its power, INDIRECT has two important drawbacks to be aware of:<\/p>\n<ul>\n<li>Volatileness: INDIRECT is a volatile function. This means it is recalculated whenever there is a change in the workbook, not just when its own input values \u200b\u200bchange. In very large files with thousands of INDIRECT formulas, this can noticeably slow down Excel&#8217;s performance.<\/li>\n<li>Error vulnerability with references: If the reference text does not result in a valid reference (e.g., because the worksheet name was written &#8220;Jannuar&#8221; instead of &#8220;January&#8221;), the function returns a #REF! error.<\/li>\n<li>Linked workbooks: If you use INDIRECT to reference another Excel file, that target file must be open for the reference to work.<\/li>\n<\/ul>\n<\/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=\"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><\/main><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-9 fusion-flex-container 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-padding-right:50px;--awb-padding-left:60px;--awb-padding-right-medium:0px;--awb-padding-left-medium:0px;--awb-padding-right-small:0px;--awb-padding-left-small:0px;--awb-margin-top:20px;--awb-margin-top-medium:20px;--awb-margin-top-small:20px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-14 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" 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;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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;\">Conclusion<\/h2><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-10 fusion-flex-container has-pattern-background has-mask-background hundred-percent-fullwidth non-hundred-percent-height-scrolling\" 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:0px;--awb-padding-left:60px;--awb-padding-top-medium:20px;--awb-padding-right-medium:0px;--awb-padding-left-medium:0px;--awb-padding-top-small:20px;--awb-padding-right-small:0px;--awb-padding-left-small:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><main class=\"fusion-layout-column fusion_builder_column fusion-builder-column-15 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-text fusion-text-6\"><p>The INDIRECT function is a powerful tool for advanced Excel users. It may seem complicated at first glance, but the concept is simple: it turns dead text into a living reference. If you ever reach a point where you think, &#8220;I wish my formula could adapt to the text in this cell,&#8221; then INDIRECT is almost always the right answer.<\/p>\n<\/div><\/div><\/main><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-11 fusion-flex-container has-pattern-background has-mask-background hundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-background-position:left top;--awb-border-sizes-top:0px;--awb-border-sizes-bottom:0px;--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-right:50px;--awb-padding-left:60px;--awb-padding-right-medium:0px;--awb-padding-left-medium:0px;--awb-padding-right-small:0px;--awb-padding-left-small:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-16 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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 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-69d28eb8118e1\"><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-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-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><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-17 fusion_builder_column_1_2 1_2 fusion-flex-column fusion-animated\" style=\"--awb-overflow:hidden;--awb-bg-size:cover;--awb-border-color:#00d6fc;--awb-border-color-hover:#00d6fc;--awb-border-style:solid;--awb-border-radius:3px 3px 3px 3px;--awb-width-large:50%;--awb-margin-top-large:0px;--awb-spacing-right-large:3.84%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:3.84%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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=\"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:&#105;n&#102;&#111;&#064;ms&#045;off&#105;ce-t&#114;&#097;&#105;ni&#110;g&#046;&#100;e\" 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-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-106\" class=\"widget_text widget widget_custom_html\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"textwidget custom-html-widget\"><center><a href=\"https:\/\/www.bloggerei.de\/rubrik_15_Computerblogs\" target=\"_blank\" rel=\"nofollow noopener\"><img decoding=\"async\" src=\"https:\/\/www.bloggerei.de\/bgpublicon.jpg\" alt=\"Blogverzeichnis Bloggerei.de - Computerblogs\" ><\/a><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-18 fusion_builder_column_1_2 1_2 fusion-flex-column fusion-animated\" style=\"--awb-bg-size:cover;--awb-width-large:50%;--awb-margin-top-large:0px;--awb-spacing-right-large:3.84%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:3.84%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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=\"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-14 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-15 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 style=\"text-align:center;\"><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><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-19 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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=\"text-52\" class=\"widget widget_text\" style=\"border-style: solid;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><div class=\"awb-news-ticker awb-news-ticker-1 awb-news-ticker-marquee\" role=\"marquee\" style=\"--awb-ticker-font-color:#ffffff;--awb-ticker-background-color:#515151;--awb-border-radius-top-left:2;--awb-border-radius-top-right:2;--awb-border-radius-bottom-right:2;--awb-border-radius-bottom-left:2;--awb-posts-distance:20px;\"><div class=\"awb-news-ticker-bar awb-news-ticker-bar-marquee\"><div class=\"awb-news-ticker-item-list awb-news-ticker-item-list-run\" data-awb-ticker-speed=\"75\"><div class=\"awb-news-ticker-item\"><a class=\"awb-news-ticker-link\" href=\"https:\/\/ms-office-training.de\/tank-apps-im-jahr-2026-warum-sie-trotz-der-neuen-12-uhr-regel-unverzichtbar-bleiben\/\">Tank-Apps im Jahr 2026: Warum sie trotz der neuen 12-Uhr-Regel unverzichtbar bleiben<\/a><\/div><div class=\"awb-news-ticker-item-separator\">+++<\/div><div class=\"awb-news-ticker-item\"><a class=\"awb-news-ticker-link\" href=\"https:\/\/ms-office-training.de\/windows-11-fuehrt-neues-ampel-system-fuer-den-sicherheitsstatus-ein\/\">Windows 11 f\u00fchrt neues Ampel-System f\u00fcr den Sicherheitsstatus ein<\/a><\/div><div class=\"awb-news-ticker-item-separator\">+++<\/div><div class=\"awb-news-ticker-item\"><a class=\"awb-news-ticker-link\" href=\"https:\/\/ms-office-training.de\/das-digitale-wettruesten-betrugspraevention-im-zeitalter-von-ki-und-instant-payments\/\">Das digitale Wettr\u00fcsten: Betrugspr\u00e4vention im Zeitalter von KI und Instant Payments<\/a><\/div><div class=\"awb-news-ticker-item-separator\">+++<\/div><div class=\"awb-news-ticker-item\"><a class=\"awb-news-ticker-link\" href=\"https:\/\/ms-office-training.de\/der-digitale-fuehrerschein-kommt-was-der-neue-bundestagsbeschluss-fuer-autofahrer-bedeutet\/\">Der digitale F\u00fchrerschein kommt: Was der neue Bundestagsbeschluss f\u00fcr Autofahrer bedeutet<\/a><\/div><div class=\"awb-news-ticker-item-separator\">+++<\/div><div class=\"awb-news-ticker-item\"><a class=\"awb-news-ticker-link\" href=\"https:\/\/ms-office-training.de\/atomstrom-fuer-die-ki-revolution-alternativlos\/\">Atomstrom f\u00fcr die KI-Revolution &#8211; Alternativlos?<\/a><\/div><div class=\"awb-news-ticker-item-separator\">+++<\/div><div class=\"awb-news-ticker-item\"><a class=\"awb-news-ticker-link\" href=\"https:\/\/ms-office-training.de\/atomstrom-fuer-ki-synthetische-patienten-claude-4-wochenrueckblick-kw-13-2026\/\">Atomstrom f\u00fcr KI, synthetische Patienten &#038; Claude 4: Der Wochenr\u00fcckblick KW 13\/2026<\/a><\/div><div class=\"awb-news-ticker-item-separator\">+++<\/div><div class=\"awb-news-ticker-item\"><a class=\"awb-news-ticker-link\" href=\"https:\/\/ms-office-training.de\/mikrofon-geht-nicht-in-teams-zoom-oder-meet\/\">Mikrofon geht nicht in Teams, Zoom oder Meet?<\/a><\/div><div class=\"awb-news-ticker-item-separator\">+++<\/div><div class=\"awb-news-ticker-item\"><a class=\"awb-news-ticker-link\" href=\"https:\/\/ms-office-training.de\/so-erkennen-sie-deepfakes-und-ki-bilder\/\">So erkennen Sie Deepfakes und KI-Bilder<\/a><\/div><div class=\"awb-news-ticker-item-separator\">+++<\/div><div class=\"awb-news-ticker-item\"><a class=\"awb-news-ticker-link\" href=\"https:\/\/ms-office-training.de\/paypal-trennt-sich-von-google-wallet-was-sich-jetzt-fuer-nutzer-aendert\/\">PayPal trennt sich von Google Wallet &#8211; Was sich jetzt f\u00fcr Nutzer \u00e4ndert<\/a><\/div><div class=\"awb-news-ticker-item-separator\">+++<\/div><div class=\"awb-news-ticker-item\"><a class=\"awb-news-ticker-link\" href=\"https:\/\/ms-office-training.de\/die-perfekte-e-mail-signatur-erstellen-tutorial\/\">Die perfekte E-Mail-Signatur erstellen &#8211; Tutorial<\/a><\/div><\/div><\/div><\/div><\/div>\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-12 fusion-flex-container has-pattern-background has-mask-background hundred-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-padding-top-medium:20px;--awb-padding-right-medium:0px;--awb-padding-bottom-medium:20px;--awb-padding-left-medium:0px;--awb-padding-top-small:20px;--awb-padding-right-small:0px;--awb-padding-bottom-small:20px;--awb-padding-left-small:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-20 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-flex-align-self-flex-start 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;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-6 fusion-sep-none fusion-title-text fusion-title-size-four\" 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:25px;\"><h4 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:25;line-height:1.2;\">Beliebte Beitr\u00e4ge<\/h4><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-21 fusion_builder_column_3_4 3_4 fusion-flex-column fusion-animated\" style=\"--awb-bg-size:cover;--awb-width-large:75%;--awb-margin-top-large:0px;--awb-spacing-right-large:3.84%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:2.56%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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=\"11\"><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-62594\" class=\"fusion-post-medium-alternate post-62594 post type-post status-publish format-standard has-post-thumbnail hentry category-microsoft-office-en category-microsoft-excel-en category-microsoft-outlook-en category-microsoft-powerpoint-en category-microsoft-teams-en category-microsoft-word-en category-office-365-en category-software-en tag-microsoft-en tag-office-en tag-teams-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">9<\/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\/was-ist-microsoft-loop-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"was-ist-microsoft-loop\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/was-ist-microsoft-loop-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/was-ist-microsoft-loop-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\/microsoft-loop-in-teams-the-revolution-of-your-notes\/\">Microsoft Loop in Teams: The revolution of your notes?<\/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\/microsoft-loop-in-teams-the-revolution-of-your-notes\/\">\n\t\t\t\t\t\tMicrosoft Loop in Teams: The revolution of your notes?\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\/microsoft-loop-in-teams-the-revolution-of-your-notes\/\" aria-label=\"Microsoft Loop in Teams: The revolution of your notes?\"><\/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\/microsoft-loop-in-teams-the-revolution-of-your-notes\/\">Microsoft Loop in Teams: The revolution of your notes?<\/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-09T11:04:33+01:00<\/span><span>November 9th, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <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\/microsoft-office-en\/microsoft-excel-en\/\" rel=\"category tag\">Microsoft Excel<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/microsoft-outlook-en\/\" rel=\"category tag\">Microsoft Outlook<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/microsoft-powerpoint-en\/\" rel=\"category tag\">Microsoft PowerPoint<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/microsoft-teams-en\/\" rel=\"category tag\">Microsoft Teams<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/microsoft-word-en\/\" rel=\"category tag\">Microsoft Word<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/office-365-en\/\" rel=\"category tag\">Office 365<\/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\/microsoft-en\/\" rel=\"tag\">Microsoft<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/office-en\/\" rel=\"tag\">Office<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/teams-en\/\" rel=\"tag\">Teams<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>What exactly are these Loop components in Microsoft Teams? We'll show you how these \"living mini-documents\" can accelerate your teamwork. From dynamic agendas to shared, real-time checklists \u2013 discover practical use cases for your everyday work.<\/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\/microsoft-loop-in-teams-the-revolution-of-your-notes\/\" aria-label=\"More on Microsoft Loop in Teams: The revolution of your notes?\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-1-post-62601\" class=\"fusion-post-medium-alternate post-62601 post type-post status-publish format-standard has-post-thumbnail hentry category-microsoft-office-en category-microsoft-excel-en category-microsoft-outlook-en category-microsoft-powerpoint-en category-microsoft-teams-en category-microsoft-word-en category-office-365-en category-software-en tag-microsoft-en tag-office-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">9<\/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\/Karrierebooster-2026-Diese-Microsoft-Office-Skills-bringen-dich-weiter-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"Karrierebooster 2026 Diese Microsoft Office-Skills bringen dich weiter\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Karrierebooster-2026-Diese-Microsoft-Office-Skills-bringen-dich-weiter-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/11\/Karrierebooster-2026-Diese-Microsoft-Office-Skills-bringen-dich-weiter-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\/career-booster-2026-these-microsoft-office-skills-will-take-you-further\/\">Career booster 2026: These Microsoft Office skills will take you further!<\/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\/career-booster-2026-these-microsoft-office-skills-will-take-you-further\/\">\n\t\t\t\t\t\tCareer booster 2026: These Microsoft Office skills will take you further!\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\/career-booster-2026-these-microsoft-office-skills-will-take-you-further\/\" aria-label=\"Career booster 2026: These Microsoft Office skills will take you further!\"><\/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\/career-booster-2026-these-microsoft-office-skills-will-take-you-further\/\">Career booster 2026: These Microsoft Office skills will take you further!<\/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-09T11:12:01+01:00<\/span><span>November 9th, 2025<\/span><span class=\"fusion-inline-sep\">|<\/span>Categories: <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\/microsoft-office-en\/microsoft-excel-en\/\" rel=\"category tag\">Microsoft Excel<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/microsoft-outlook-en\/\" rel=\"category tag\">Microsoft Outlook<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/microsoft-powerpoint-en\/\" rel=\"category tag\">Microsoft PowerPoint<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/microsoft-teams-en\/\" rel=\"category tag\">Microsoft Teams<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/microsoft-word-en\/\" rel=\"category tag\">Microsoft Word<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/category\/microsoft-office-en\/office-365-en\/\" rel=\"category tag\">Office 365<\/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\/microsoft-en\/\" rel=\"tag\">Microsoft<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/office-en\/\" rel=\"tag\">Office<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>A new year, new career opportunities! But which Office skills will really be in demand in 2026? \"Skilled use\" is no longer enough. We'll show you today's must-haves \u2013 like advanced Excel, using AI in the office, and relevant certifications for your resume.<\/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\/career-booster-2026-these-microsoft-office-skills-will-take-you-further\/\" aria-label=\"More on Career booster 2026: These Microsoft Office skills will take you further!\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-1-post-62276\" class=\"fusion-post-medium-alternate post-62276 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-microsoft-excel-en category-microsoft-office-en category-office-365-en tag-excel-en tag-office-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">29<\/span><span class=\"fusion-month-year\">10, 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\/10\/duplikate-in-excel-entfernen-tutorial-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"duplikate-in-excel-entfernen-tutorial\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/duplikate-in-excel-entfernen-tutorial-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/duplikate-in-excel-entfernen-tutorial-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\/excel-tutorial-how-to-quickly-and-safely-remove-duplicates\/\">Excel Tutorial: How to quickly and safely remove duplicates<\/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\/excel-tutorial-how-to-quickly-and-safely-remove-duplicates\/\">\n\t\t\t\t\t\tExcel Tutorial: How to quickly and safely remove duplicates\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\/excel-tutorial-how-to-quickly-and-safely-remove-duplicates\/\" aria-label=\"Excel Tutorial: How to quickly and safely remove duplicates\"><\/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\/excel-tutorial-how-to-quickly-and-safely-remove-duplicates\/\">Excel Tutorial: How to quickly and safely remove duplicates<\/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-04T16:17:22+01:00<\/span><span>October 29th, 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\/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\/microsoft-office-en\/office-365-en\/\" rel=\"category tag\">Office 365<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/excel-en\/\" rel=\"tag\">Excel<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/office-en\/\" rel=\"tag\">Office<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>Duplicate entries in your Excel lists? This distorts your data. Our tutorial shows you, using a practical example, how to clean up your data in seconds with the \"Remove Duplicates\" function \u2013 whether you want to delete identical rows or just values \u200b\u200bin a column.<\/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\/excel-tutorial-how-to-quickly-and-safely-remove-duplicates\/\" aria-label=\"More on Excel Tutorial: How to quickly and safely remove duplicates\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-1-post-62291\" class=\"fusion-post-medium-alternate post-62291 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-microsoft-excel-en category-microsoft-office-en category-office-365-en tag-excel-en tag-office-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">27<\/span><span class=\"fusion-month-year\">10, 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\/10\/bereich-verschieben-excel-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"bereich-verschieben-excel\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/bereich-verschieben-excel-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/bereich-verschieben-excel-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\/dynamic-ranges-in-excel-offset-function\/\">Dynamic ranges in Excel: OFFSET function<\/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\/dynamic-ranges-in-excel-offset-function\/\">\n\t\t\t\t\t\tDynamic ranges in Excel: OFFSET function\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\/dynamic-ranges-in-excel-offset-function\/\" aria-label=\"Dynamic ranges in Excel: OFFSET function\"><\/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\/dynamic-ranges-in-excel-offset-function\/\">Dynamic ranges in Excel: OFFSET function<\/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-05T15:26:09+01:00<\/span><span>October 27th, 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\/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\/microsoft-office-en\/office-365-en\/\" rel=\"category tag\">Office 365<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/excel-en\/\" rel=\"tag\">Excel<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/office-en\/\" rel=\"tag\">Office<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>The OFFSET function in Excel creates a flexible reference. Instead of fixing =SUM(B5:B7), the function finds the range itself, e.g., for the \"last 3 months\". Ideal for dynamic charts or dashboards that grow automatically.<\/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\/dynamic-ranges-in-excel-offset-function\/\" aria-label=\"More on Dynamic ranges in Excel: OFFSET function\">Read More<\/a><\/div><\/div><\/article>\n<article id=\"blog-1-post-62294\" class=\"fusion-post-medium-alternate post-62294 post type-post status-publish format-standard has-post-thumbnail hentry category-shorts-and-tutorials-en category-microsoft-excel-en category-microsoft-office-en category-office-365-en tag-excel-en tag-office-en\">\n<div class=\"fusion-date-and-formats\"><div class=\"fusion-date-box updated\"><span class=\"fusion-date\">27<\/span><span class=\"fusion-month-year\">10, 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\/10\/indirekt-funktion-excel-320x202.jpg\" class=\"attachment-blog-medium size-blog-medium wp-post-image\" alt=\"indirekt-funktion-excel\" srcset=\"https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/indirekt-funktion-excel-320x202.jpg 320w, https:\/\/ms-office-training.de\/wp-content\/uploads\/2025\/10\/indirekt-funktion-excel-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\/mastering-the-indirect-function-in-excel\/\">Mastering the INDIRECT function in Excel<\/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\/mastering-the-indirect-function-in-excel\/\">\n\t\t\t\t\t\tMastering the INDIRECT function in Excel\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\/mastering-the-indirect-function-in-excel\/\" aria-label=\"Mastering the INDIRECT function in Excel\"><\/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\/mastering-the-indirect-function-in-excel\/\">Mastering the INDIRECT function in Excel<\/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-05T15:30:39+01:00<\/span><span>October 27th, 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\/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\/microsoft-office-en\/office-365-en\/\" rel=\"category tag\">Office 365<\/a><span class=\"fusion-inline-sep\">|<\/span><span class=\"meta-tags\">Tags: <a href=\"https:\/\/ms-office-training.de\/en\/tag\/excel-en\/\" rel=\"tag\">Excel<\/a>, <a href=\"https:\/\/ms-office-training.de\/en\/tag\/office-en\/\" rel=\"tag\">Office<\/a><\/span><span class=\"fusion-inline-sep\">|<\/span><\/p><div class=\"fusion-post-content-container\"><p>The INDIRECT function in Excel converts text into a real reference. Instead of manually typing =January!E10, use =INDIRECT(A2 &amp; \"!E10\"), where A2 contains 'January'. This allows you to easily create dynamic summaries for multiple worksheets.<\/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\/mastering-the-indirect-function-in-excel\/\" aria-label=\"More on Mastering the INDIRECT function in Excel\">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\/62294\/page\/2\/\" class=\"inactive\">2<\/a><a class=\"pagination-next\" rel=\"next\" href=\"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/posts\/62294\/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><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-22 fusion_builder_column_1_4 1_4 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:25%;--awb-margin-top-large:0px;--awb-spacing-right-large:7.68%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:3.84%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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;\"><style type=\"text\/css\" data-id=\"custom_html-52\">@media (max-width: 768px){#custom_html-52{text-align:center !important;}}<\/style><div id=\"custom_html-52\" class=\"widget_text fusion-widget-mobile-align-center fusion-widget-align-center widget widget_custom_html\" style=\"padding: 20px;border-style: solid;text-align: center;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<!-- beliebte beitr\u00e4ge 2026 -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-6975808762565780\"\r\n     data-ad-slot=\"4902693103\"\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; color: #00d6fc;\">Anzeige<\/span><\/div><\/center><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-23 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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 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\/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: 968px) 25vw, (min-width: 2200px) 100vw, (min-width: 717px) 443px, (min-width: 691px) 590px, (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: 968px) 25vw, (min-width: 2200px) 100vw, (min-width: 717px) 443px, (min-width: 691px) 590px, (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: 968px) 25vw, (min-width: 2200px) 100vw, (min-width: 717px) 443px, (min-width: 691px) 590px, (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: 968px) 25vw, (min-width: 2200px) 100vw, (min-width: 717px) 443px, (min-width: 691px) 590px, (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\/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: 968px) 25vw, (min-width: 2200px) 100vw, (min-width: 717px) 443px, (min-width: 691px) 590px, (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\/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: 968px) 25vw, (min-width: 2200px) 100vw, (min-width: 717px) 443px, (min-width: 691px) 590px, (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: 968px) 25vw, (min-width: 2200px) 100vw, (min-width: 717px) 443px, (min-width: 691px) 590px, (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: 968px) 25vw, (min-width: 2200px) 100vw, (min-width: 717px) 443px, (min-width: 691px) 590px, (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: 968px) 25vw, (min-width: 2200px) 100vw, (min-width: 717px) 443px, (min-width: 691px) 590px, (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: 968px) 25vw, (min-width: 2200px) 100vw, (min-width: 717px) 443px, (min-width: 691px) 590px, (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: 968px) 25vw, (min-width: 2200px) 100vw, (min-width: 717px) 443px, (min-width: 691px) 590px, (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><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-24 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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 id=\"text-42\" class=\"widget widget_text\" style=\"border-style: solid;border-color:transparent;border-width:0px;\">\t\t\t<div class=\"textwidget\"><\/div>\n\t\t<\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-25 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-26 fusion_builder_column_1_1 1_1 fusion-flex-column fusion-animated\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-animationType=\"fadeInUp\" data-animationDuration=\"1.0\" data-animationOffset=\"top-into-view\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><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 class=\"fusion-additional-widget-content\"><\/div><\/div><\/div><\/div><\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The INDIRECT function in Excel converts text into a real reference. Instead of manually typing =January!E10, use =INDIRECT(A2 &#038; &#8220;!E10&#8221;), where A2 contains &#8216;January&#8217;. This allows you to easily create dynamic summaries for multiple worksheets.<\/p>\n","protected":false},"author":3,"featured_media":62298,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"footnotes":""},"categories":[2875,211,762,3358],"tags":[3631,3633],"class_list":["post-62294","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-shorts-and-tutorials-en","category-microsoft-excel-en","category-microsoft-office-en","category-office-365-en","tag-excel-en","tag-office-en"],"_links":{"self":[{"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/posts\/62294","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/comments?post=62294"}],"version-history":[{"count":0,"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/posts\/62294\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/media\/62298"}],"wp:attachment":[{"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/media?parent=62294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/categories?post=62294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ms-office-training.de\/en\/wp-json\/wp\/v2\/tags?post=62294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}