{"id":3420,"date":"2023-10-27T22:57:31","date_gmt":"2023-10-27T22:57:31","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/skriptlabor\/"},"modified":"2023-12-03T13:05:09","modified_gmt":"2023-12-03T13:05:09","slug":"skriptlabor","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/skriptlabor\/","title":{"rendered":"Wie verwende ich script lab in excel?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1719288496\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Mit Script Lab k\u00f6nnen Sie die Office-JavaScript-API verwenden. Um das \u201eScript Lab\u201c zu erhalten, m\u00fcssen Sie das Script Lab-Add-In \u00fcber die Registerkarte \u201eEinf\u00fcgen\u201c \u21e2 Add-Ins abrufen \u21e2 Script Lab installieren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88977\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"Skriptlabor in Excel\" width=\"686\" height=\"393\"><\/figure><\/div><p> Als N\u00e4chstes m\u00fcssen Sie die Registerkarte \u201eScript Lab\u201c zum Men\u00fcband hinzuf\u00fcgen. Gehen Sie dazu zur Registerkarte Datei \u21e2 Optionen \u21e2 Multifunktionsleiste anpassen \u21e2 H\u00e4kchen \u21e2 Skriptlabor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88978\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-ajouter-un-laboratoire-de-script-sur-le-ruban.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-script-lab-on-ribbon\" width=\"692\" height=\"334\"><\/figure><\/div><p> Kehren Sie zu Ihrer Tabelle zur\u00fcck und klicken Sie auf der Registerkarte \u201eScript Lab\u201c auf die Schaltfl\u00e4che \u201eCode\u201c. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88979\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-clics-sur-le-code-de-longlet-du-laboratoire-de-script.png\" sizes=\"auto, \" srcset=\"\" alt=\"clic-code-from-script-lab-tab\" width=\"710\" height=\"161\"><\/figure><\/div><p> Wenn Sie auf die Codeschaltfl\u00e4che klicken, wird auf der rechten Seite des Excel-Fensters ein Bereich angezeigt. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88980\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-volet-sur-le-cote-droit.png\" sizes=\"auto, \" srcset=\"\" alt=\"Verschluss auf der rechten Seite\" width=\"355\" height=\"433\"><\/figure><\/div><p> Mit Script Lab k\u00f6nnen Sie JavaScript verwenden, um Codes zu schreiben und eine benutzerdefinierte Funktion in Excel zu erstellen. Klicken Sie nun auf die Men\u00fcschaltfl\u00e4che und dann auf die Schaltfl\u00e4che Neu. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88981\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-avec-script-lab-utiliser-javascript-pour-ecrire-des-codes.png\" sizes=\"auto, \" srcset=\"\" alt=\"with-script-lab-use-javascript-to-write-codes\" width=\"369\" height=\"121\"><\/figure><\/div><p> Als n\u00e4chstes l\u00f6schen Sie den Code, der bereits in den drei Registerkarten Skript, HTML und CSS vorhanden ist. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88982\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-supprimer-les-codes-deja-presents.png\" sizes=\"auto, \" srcset=\"\" alt=\"l\u00f6sche-die-codes-bereits-da\" width=\"644\" height=\"232\"><\/figure><\/div><p> Wenn Sie den Code einf\u00fcgen, verschwindet die Registerkarte \u201eHTML und CSS\u201c, da dieser Code eine Funktion erstellt. Und diese Funktion hilft Ihnen, das QUADRAT EINER ZAHL zu berechnen.<\/p><pre class=\"wp-block-code\"> <code class=\"language-typescript\" lang=\"typescript\">\/** * calculates the square root of the number. * @customfunction *\/ function getsquare(num) { return Math.pow(num, 2); }<\/code><\/pre><p> Von hier aus m\u00fcssen Sie diese Funktion in Ihrer Excel-Anwendung speichern. Klicken Sie zun\u00e4chst auf die Schaltfl\u00e4che \u201eRegistrieren\u201c. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88983\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-7-registres-avec-application-Excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"Speicherfunktion mit Excel-Anwendung\" width=\"578\" height=\"379\"><\/figure><\/div><p> Wenn Sie auf die Schaltfl\u00e4che \u201eSpeichern\u201c klicken, wird \u201eDie folgenden Funktionen wurden erfolgreich gespeichert\u201c angezeigt. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88984\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-montre-les-fonctions-enregistrees-avec-succes.png\" sizes=\"auto, \" srcset=\"\" alt=\"watch-functions-successfully registriert\" width=\"646\" height=\"294\"><\/figure><\/div><p> Gehen Sie nun zur\u00fcck zur Tabelle und geben Sie eine Zahl in eine Zelle ein. Geben Sie beispielsweise \u201e=ScriptLab\u201c in eine andere Zelle ein und w\u00e4hlen Sie die Funktion GETSQUARE aus. Beziehen Sie sich auf die Zelle mit der Nummer. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88985\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-entrez-un-nombre-dans-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"Geben Sie eine Zahl in die Zelle ein\" width=\"540\" height=\"334\"><\/figure><\/div><p> Dr\u00fccken Sie am Ende die Eingabetaste, um das Ergebnis zu erhalten. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88986\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-appuyez-sur-Entree-pour-obtenir-le-resultat.png\" sizes=\"auto, \" srcset=\"\" alt=\"Dr\u00fccken Sie die Eingabetaste, um das Ergebnis zu erhalten\" width=\"569\" height=\"370\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/de\/excel-fortschritt\/\">Erweiterte Excel-Tutorials<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Verwandte Tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/excel-standardmassig-auf-dem-mac\/\">Machen Sie Excel auf dem Mac zum Standard<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/excel-sicherheitsmodus\/\">\u00d6ffnen Sie Excel im abgesicherten Modus<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/leeren-sie-den-cache\/\">Cache in Excel leeren<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/autokorrektur\/\">Verwenden Sie AutoKorrektur in Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-3420","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Wie verwende ich Script Lab in Excel?<\/title>\n<meta name=\"description\" content=\"Dies ist ein kurzes Tutorial f\u00fcr den Einstieg in die Verwendung des Script Lab in Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/de\/skriptlabor\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie verwende ich Script Lab in Excel?\" \/>\n<meta property=\"og:description\" content=\"Dies ist ein kurzes Tutorial f\u00fcr den Einstieg in die Verwendung des Script Lab in Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/skriptlabor\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:05:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/skriptlabor\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/skriptlabor\/\",\"name\":\"Wie verwende ich Script Lab in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/skriptlabor\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/skriptlabor\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png\",\"datePublished\":\"2023-10-27T22:57:31+00:00\",\"dateModified\":\"2023-12-03T13:05:09+00:00\",\"description\":\"Dies ist ein kurzes Tutorial f\u00fcr den Einstieg in die Verwendung des Script Lab in Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/skriptlabor\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/skriptlabor\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/skriptlabor\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/skriptlabor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie verwende ich script lab in excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie verwende ich Script Lab in Excel?","description":"Dies ist ein kurzes Tutorial f\u00fcr den Einstieg in die Verwendung des Script Lab in Excel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/de\/skriptlabor\/","og_locale":"de_DE","og_type":"article","og_title":"Wie verwende ich Script Lab in Excel?","og_description":"Dies ist ein kurzes Tutorial f\u00fcr den Einstieg in die Verwendung des Script Lab in Excel.","og_url":"https:\/\/exceladvisor.org\/de\/skriptlabor\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:05:09+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/skriptlabor\/","url":"https:\/\/exceladvisor.org\/de\/skriptlabor\/","name":"Wie verwende ich Script Lab in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/skriptlabor\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/skriptlabor\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png","datePublished":"2023-10-27T22:57:31+00:00","dateModified":"2023-12-03T13:05:09+00:00","description":"Dies ist ein kurzes Tutorial f\u00fcr den Einstieg in die Verwendung des Script Lab in Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/skriptlabor\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/skriptlabor\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/skriptlabor\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/skriptlabor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie verwende ich script lab in excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3420"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3420\/revisions"}],"predecessor-version":[{"id":4377,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3420\/revisions\/4377"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}