{"id":100745,"date":"2021-10-13T10:19:01","date_gmt":"2021-10-13T08:19:01","guid":{"rendered":"https:\/\/learnesy.com\/?p=100745"},"modified":"2021-10-22T11:42:09","modified_gmt":"2021-10-22T09:42:09","slug":"se-lektionen-om-funktionen-lambda","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/se-lektionen-om-funktionen-lambda\/","title":{"rendered":"Se lektionen om funktionen LAMBDA"},"content":{"rendered":"<p><strong>Hank hos oss l\u00e4r ut funktionen LAMBDA.<\/strong><\/p>\n<p><strong>Om du har en s\u00e4rskild ber\u00e4kning som du g\u00f6r v\u00e4ldigt ofta, men som det inte finns en funktion f\u00f6r, \u00e4r LAMBDA perfekt f\u00f6r dig!<\/strong><\/p>\n<p>LAMBDA \u00e4r en otroligt kraftfull funktion som till\u00e5ter oss att skapa v\u00e5ra egna anpassade funktioner.<br \/>\nAnv\u00e4nder du Excels inbyggda namnhanterare f\u00f6r att ge dessa anpassade funktioner sina egna unika namn kan du enkelt kalla fram funktionerna p\u00e5 andra platser i dokumentet.<br \/>\nFunktionen tar in en eller flera inmatningsvariabler som kommer att ers\u00e4ttas av de v\u00e4rden vi vill ska anv\u00e4ndas i v\u00e5ra ber\u00e4kningar, precis som i ett programmeringsspr\u00e5k!<br \/>\nAlla funktioner vi skapar sparas tillsammans med det Exceldokument vi jobbar med, vilket betyder att oavsett vilken dator som anv\u00e4nds f\u00f6r att bearbeta dokumentet kan funktionerna kallas.<br \/>\nFunktionerna vi skapar kan ocks\u00e5 anv\u00e4nda hela cellomr\u00e5den som argument och g\u00f6ra samma ber\u00e4kning p\u00e5 alla v\u00e4rdena p\u00e5 en g\u00e5ng.<br \/>\nDetta anv\u00e4nder n\u00e5got som heter SPILL-beteendet f\u00f6r att fylla in flera celler samtidigt!<br \/>\nDet \u00e4r \u00e4ntligen m\u00f6jligt att skapa ett urval olika unika funktioner som \u00e4r skr\u00e4ddarsydda till exakt det som du sj\u00e4lv beh\u00f6ver, allt tack vare LAMBDA-funktionen!<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/635552354?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media\"><\/iframe><\/div>\n<p>&nbsp;<\/p>\n<p><strong>LAMBDA-funktionen \u00e4r f\u00f6r tillf\u00e4llet tillg\u00e4ngligt endast i Office Insider.<\/strong><\/p>\n<p>G\u00e5 med i Office insider:<\/p>\n<ol>\n<li>Verifiera din Excelversion. Office Insider \u00e4r tillg\u00e4ngligt endast i Office 365.<\/li>\n<li>G\u00e5 till <strong>Fil<\/strong> &gt; <strong>Konto<\/strong> &gt; <strong><strong>Office Insider<\/strong><\/strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-101507\" src=\"\/wp-content\/uploads\/2021\/10\/Office-insider-300x272.png\" alt=\"\" width=\"300\" height=\"272\" srcset=\"\/wp-content\/uploads\/2021\/10\/Office-insider-300x272.png 300w, \/wp-content\/uploads\/2021\/10\/Office-insider-331x300.png 331w, \/wp-content\/uploads\/2021\/10\/Office-insider.png 745w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/>\n<p>&nbsp;<\/li>\n<li>Klicka i &#8221;Registrera mig f\u00f6r tidig \u00e5tkomst till nya versioner av Office&#8221;.<\/li>\n<li class=\"\">V\u00e4lj vilken Insider-kanal som du vill anv\u00e4nda. V\u00e4lj <strong>Beta<\/strong> f\u00f6r att f\u00e5 tillg\u00e5ng LAMBDA.<\/li>\n<li>Godk\u00e4nn villkoren och klicka <strong><strong>OK.<\/strong><\/strong><\/li>\n<li>Starta om Excel.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h5>Lektionen \u00e4r fr\u00e5n kommande kurs <strong>Avancerad Excel f\u00f6r ekonomer<\/strong>.<br \/>\nOm du beh\u00f6ver baskunskaper innan du kan ge dig p\u00e5 avancerad Excel s\u00e5 har vi kursen f\u00f6r dig &#8211; <a href=\"https:\/\/learnesy.com\/sv\/courses\/excelkurs-bas\/\">Excel Bas<\/a>.<\/h5>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hank hos oss l\u00e4r ut funktionen LAMBDA. Om du har en s\u00e4rskild ber\u00e4kning som du g\u00f6r v\u00e4ldigt ofta, men som det inte finns en funktion f\u00f6r, \u00e4r LAMBDA perfekt f\u00f6r dig! LAMBDA \u00e4r en otroligt [&hellip;]<\/p>\n","protected":false},"author":41201,"featured_media":101224,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[74,65,211,73],"class_list":["post-100745","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-excel-3","tag-excelkurs","tag-lambda","tag-onlinekurs-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/100745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/users\/41201"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=100745"}],"version-history":[{"count":15,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/100745\/revisions"}],"predecessor-version":[{"id":101513,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/100745\/revisions\/101513"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/101224"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=100745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=100745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=100745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}