{"id":492449,"date":"2025-10-24T13:43:45","date_gmt":"2025-10-24T12:43:45","guid":{"rendered":"https:\/\/learnesy.com\/?p=492449"},"modified":"2025-10-24T13:43:45","modified_gmt":"2025-10-24T12:43:45","slug":"en-guide-till-excelfunktioner-och-formelskrivning","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/en-guide-till-excelfunktioner-och-formelskrivning\/","title":{"rendered":"En guide till Excelfunktioner och formelskrivning"},"content":{"rendered":"<p data-start=\"123\" data-end=\"457\">Att beh\u00e4rska Excelfunktioner \u00e4r nyckeln till att arbeta smartare i Excel. Den h\u00e4r guiden \u00e4r f\u00f6r dig som vill f\u00f6rst\u00e5 hur funktioner fungerar, hur man skriver formler korrekt och vilka vanliga misstag du ska undvika. Du l\u00e4r dig grunderna i Excelformler, exempel p\u00e5 anv\u00e4ndbara funktioner \u2013 och hur du snabbt blir trygg i formelskrivning.<\/p>\n<hr data-start=\"459\" data-end=\"462\" \/>\n<span id=\"heading-kortfattat-svar-sa-fungerar-excelfunktioner\"><h2 data-start=\"464\" data-end=\"515\">Kortfattat svar \u2013 s\u00e5 fungerar Excelfunktioner<\/h2><\/span>\n<p data-start=\"517\" data-end=\"633\">Excelfunktioner anv\u00e4nds f\u00f6r att automatisera ber\u00e4kningar och hantera data effektivt.<br data-start=\"601\" data-end=\"604\" \/>H\u00e4r \u00e4r grunderna i punktform:<\/p>\n<ul data-start=\"635\" data-end=\"940\">\n<li data-start=\"635\" data-end=\"696\">\n<p data-start=\"637\" data-end=\"696\"><strong data-start=\"637\" data-end=\"670\">En formel (eller en funktion) b\u00f6rjar alltid med =<\/strong> (t.ex. <code data-start=\"678\" data-end=\"693\">=SUMMA(A1:A5)<\/code>)<\/p>\n<\/li>\n<li data-start=\"697\" data-end=\"773\">\n<p data-start=\"699\" data-end=\"773\"><strong data-start=\"699\" data-end=\"713\">Funktioner<\/strong> \u00e4r inbyggda kommandon som SUMMA, MEDEL, OM, LETARAD m.fl.<\/p>\n<\/li>\n<li data-start=\"774\" data-end=\"841\">\n<p data-start=\"776\" data-end=\"841\"><strong data-start=\"776\" data-end=\"788\">Argument<\/strong> \u00e4r v\u00e4rdena eller cellerna som funktionen anv\u00e4nder.<\/p>\n<\/li>\n<li data-start=\"842\" data-end=\"940\">\n<p data-start=\"844\" data-end=\"940\">Du kan <strong data-start=\"851\" data-end=\"875\">kombinera funktioner<\/strong> f\u00f6r mer avancerade ber\u00e4kningar (t.ex. <code data-start=\"914\" data-end=\"937\">=OM(A1&gt;10;\"Ja\";\"Nej\")<\/code>)<\/p>\n<\/li>\n<\/ul>\n<hr data-start=\"942\" data-end=\"945\" \/>\n<span id=\"heading-vad-ar-en-excelfunktion\"><h2 data-start=\"947\" data-end=\"974\">Vad \u00e4r en Excelfunktion?<\/h2><\/span>\n<p data-start=\"976\" data-end=\"1146\">En Excelfunktion \u00e4r ett f\u00f6rdefinierat verktyg som hj\u00e4lper dig att ber\u00e4kna, j\u00e4mf\u00f6ra eller bearbeta data utan att beh\u00f6va skriva egna formler fr\u00e5n grunden.<br data-start=\"1128\" data-end=\"1131\" \/>Till exempel:<\/p>\n<p data-start=\"1148\" data-end=\"1207\"><code data-start=\"1148\" data-end=\"1164\">=SUMMA(A1:A10)<\/code><br data-start=\"1164\" data-end=\"1167\" \/>Summerar v\u00e4rdena i cellerna A1 till A10.<\/p>\n<blockquote data-start=\"1209\" data-end=\"1317\">\n<p data-start=\"1211\" data-end=\"1317\">\ud83d\udca1 <strong data-start=\"1214\" data-end=\"1223\">Tips:<\/strong> T\u00e4nk p\u00e5 funktioner som sm\u00e5 &#8221;program&#8221; inuti Excel \u2013 du matar in data, Excel g\u00f6r jobbet \u00e5t dig.<\/p>\n<\/blockquote>\n<hr data-start=\"1483\" data-end=\"1486\" \/>\n<span id=\"heading-de-vanligaste-excelfunktionerna-for-nyborjare\"><h2 data-start=\"1488\" data-end=\"1536\">De vanligaste Excelfunktionerna f\u00f6r nyb\u00f6rjare<\/h2><\/span>\n<span id=\"heading-1-summa-summera-snabbt\"><h3 data-start=\"1538\" data-end=\"1567\">1. SUMMA \u2013 summera snabbt<\/h3><\/span>\n<p data-start=\"1568\" data-end=\"1714\">Formel: <code data-start=\"1576\" data-end=\"1592\">=SUMMA(B7:B16)<\/code><br data-start=\"1592\" data-end=\"1595\" \/>Anv\u00e4nds f\u00f6r att l\u00e4gga ihop ett antal celler automatiskt.<br data-start=\"1651\" data-end=\"1654\" \/>Perfekt f\u00f6r att summera f\u00f6rs\u00e4ljning, kostnader eller timmar.<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/178789258?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\"><\/iframe><\/div>\n<hr data-start=\"1866\" data-end=\"1869\" \/>\n<span id=\"heading-2-medel-rakna-ut-genomsnitt\"><h3 data-start=\"1871\" data-end=\"1905\">2. MEDEL \u2013 r\u00e4kna ut genomsnitt<\/h3><\/span>\n<p data-start=\"1906\" data-end=\"2031\">Formel: <code data-start=\"1914\" data-end=\"1929\">=MEDEL(B2:B8)<\/code><br data-start=\"1929\" data-end=\"1932\" \/>Anv\u00e4nds f\u00f6r att ber\u00e4kna medelv\u00e4rdet av flera tal, t.ex. snittbetyg eller genomsnittlig f\u00f6rs\u00e4ljning.<\/p>\n<figure id=\"attachment_493755\" aria-describedby=\"caption-attachment-493755\" style=\"width: 893px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-493755 size-full\" src=\"\/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-medel.png\" alt=\"learnesy-excelfunktioner-medel\" width=\"893\" height=\"608\" srcset=\"\/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-medel.png 893w, \/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-medel-300x204.png 300w, \/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-medel-768x523.png 768w\" sizes=\"auto, (max-width: 893px) 100vw, 893px\" \/><figcaption id=\"caption-attachment-493755\" class=\"wp-caption-text\"><em>MEDEL() anv\u00e4nds f\u00f6r att r\u00e4kna ut det aritmetiska medelv\u00e4rdet i Excel.<\/em><\/figcaption><\/figure>\n<hr data-start=\"2134\" data-end=\"2137\" \/>\n<span id=\"heading-3-om-skapa-logik-i-kalkyler\"><h3 data-start=\"2139\" data-end=\"2173\">3. OM \u2013 skapa logik i kalkyler<\/h3><\/span>\n<p data-start=\"2174\" data-end=\"2373\">Formel: <code data-start=\"2182\" data-end=\"2222\">=OM(C2&gt;100;\"\u00d6ver m\u00e5let\";\"Under m\u00e5let\")<\/code><br data-start=\"2222\" data-end=\"2225\" \/>Med OM-funktionen kan du skapa automatiska beslut i dina formler.<br data-start=\"2290\" data-end=\"2293\" \/><strong>Exempel:<\/strong> Om po\u00e4ngen \u00e4r st\u00f6rre \u00e4n 80; visa &#8221;Godk\u00e4nt&#8221;; annars &#8221;Underk\u00e4nt&#8221;.<\/p>\n<figure id=\"attachment_492583\" aria-describedby=\"caption-attachment-492583\" style=\"width: 640px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-492583 size-large\" src=\"\/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-om-1024x611.png\" alt=\"learnesy-excelfunktioner-om\" width=\"640\" height=\"382\" srcset=\"\/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-om-1024x611.png 1024w, \/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-om-300x179.png 300w, \/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-om-768x458.png 768w, \/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-om-1536x916.png 1536w, \/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-om-2048x1222.png 2048w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption id=\"caption-attachment-492583\" class=\"wp-caption-text\"><em>OM-funktionen anv\u00e4nds s\u00e5h\u00e4r: om villkoret i f\u00f6rsta argumentet \u00e4r sant; g\u00f6r det h\u00e4r; annars, g\u00f6r det h\u00e4r.<\/em><\/figcaption><\/figure>\n<hr data-start=\"2529\" data-end=\"2532\" \/>\n<span id=\"heading-4-letarad-eller-xletaupp-sok-varden-i-tabeller\"><h3 data-start=\"2534\" data-end=\"2589\">4. LETARAD (eller XLETAUPP) \u2013 s\u00f6k v\u00e4rden i tabeller<\/h3><\/span>\n<p data-start=\"2590\" data-end=\"2761\">Formel:<br data-start=\"2597\" data-end=\"2600\" \/><code data-start=\"2600\" data-end=\"2630\">=XLETAUPP(F2;C2:C9;A2:B9;0;1;1)<\/code><br data-start=\"2630\" data-end=\"2633\" \/>H\u00e4mtar ett v\u00e4rde fr\u00e5n en annan tabell baserat p\u00e5 en nyckel.<br data-start=\"2692\" data-end=\"2695\" \/>Exempel: H\u00e4mtar inkomst utifr\u00e5n en nyckel, i det h\u00e4r fallet inkomst, f\u00f6r att returnera r\u00e4tt skattesats och grupp.<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/450762563?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\"><\/iframe><\/div>\n<hr data-start=\"2911\" data-end=\"2914\" \/>\n<span id=\"heading-5-samman-eller-textjoin-kombinera-text\"><h3 data-start=\"2916\" data-end=\"2967\">5. SAMMAN (eller TEXTJOIN) \u2013 kombinera text<\/h3><\/span>\n<p data-start=\"2968\" data-end=\"3133\">Formel: <code data-start=\"2976\" data-end=\"3000\">=SAMMAN(B2;\" \";C2)<\/code><br data-start=\"3000\" data-end=\"3003\" \/>Anv\u00e4nds f\u00f6r att sl\u00e5 ihop flera celler till en textstr\u00e4ng.<br data-start=\"3060\" data-end=\"3063\" \/>Exempel: F\u00f6r- och efternamn i separata kolumner blir \u201cAnna Andersson\u201d.<\/p>\n<figure id=\"attachment_493760\" aria-describedby=\"caption-attachment-493760\" style=\"width: 908px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-493760 size-full\" src=\"\/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-samman.png\" alt=\"learnesy-excelfunktioner-samman\" width=\"908\" height=\"609\" srcset=\"\/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-samman.png 908w, \/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-samman-300x201.png 300w, \/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-samman-768x515.png 768w\" sizes=\"auto, (max-width: 908px) 100vw, 908px\" \/><figcaption id=\"caption-attachment-493760\" class=\"wp-caption-text\"><em>Med SAMMAN() eller TEXTJOIN() kan man sammanfoga textstr\u00e4ngar. Motsvarande resultat kan \u00e5terf\u00e5s med =TEXTJOIN(&#8221; &#8221;;SANT;B2;C2) som i exemplet ovan.<\/em><\/figcaption><\/figure>\n<hr data-start=\"3229\" data-end=\"3232\" \/>\n<span id=\"heading-sa-skriver-du-formler-ratt-steg-for-steg\"><h2 data-start=\"3234\" data-end=\"3279\">S\u00e5 skriver du formler r\u00e4tt \u2013 steg f\u00f6r steg<\/h2><\/span>\n<p data-start=\"3281\" data-end=\"3346\">Att skriva korrekta formler handlar om struktur. F\u00f6lj dessa steg:<\/p>\n<ol data-start=\"3348\" data-end=\"3726\">\n<li data-start=\"3348\" data-end=\"3427\">\n<p data-start=\"3351\" data-end=\"3427\"><strong data-start=\"3351\" data-end=\"3373\">B\u00f6rja alltid med =<\/strong><br data-start=\"3373\" data-end=\"3376\" \/>Excel f\u00f6rst\u00e5r d\u00e5 att du vill skriva en formel.<\/p>\n<\/li>\n<li data-start=\"3428\" data-end=\"3499\">\n<p data-start=\"3431\" data-end=\"3499\"><strong data-start=\"3431\" data-end=\"3456\">Anv\u00e4nd r\u00e4tt separator<\/strong> (vanligen semikolon <code data-start=\"3477\" data-end=\"3480\">;<\/code> i svensk Excel).<\/p>\n<\/li>\n<li data-start=\"3500\" data-end=\"3561\">\n<p data-start=\"3503\" data-end=\"3561\"><strong data-start=\"3503\" data-end=\"3533\">Dubbelkolla cellreferenser<\/strong> \u2013 s\u00e4rskilt vid kopiering.<\/p>\n<\/li>\n<li data-start=\"3562\" data-end=\"3636\">\n<p data-start=\"3565\" data-end=\"3636\"><strong data-start=\"3565\" data-end=\"3585\">L\u00e5s celler med $<\/strong> n\u00e4r en referens inte ska flyttas (t.ex. <code data-start=\"3626\" data-end=\"3632\">$A$1<\/code>).<\/p>\n<\/li>\n<li data-start=\"3637\" data-end=\"3726\">\n<p data-start=\"3640\" data-end=\"3726\"><strong data-start=\"3640\" data-end=\"3664\">Testa alltid formeln<\/strong> p\u00e5 ett litet dataomr\u00e5de innan du anv\u00e4nder den i stor skala.<\/p>\n<\/li>\n<\/ol>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/185009517?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\"><\/iframe><\/div>\n<hr data-start=\"3884\" data-end=\"3887\" \/>\n<blockquote data-start=\"3889\" data-end=\"3998\">\n<p data-start=\"3891\" data-end=\"3998\">\ud83d\udcac <strong data-start=\"3894\" data-end=\"3913\">Relaterad kurs:<\/strong> <a class=\"decorated-link cursor-pointer\" href=\"https:\/\/learnesy.com\/sv\/courses\/excelkurs-bas\/\" target=\"_new\" rel=\"noopener\" data-start=\"3914\" data-end=\"3998\">Excelkurs Bas \u2013 Se hela kursen h\u00e4r \u279d<\/a><\/p>\n<\/blockquote>\n<hr data-start=\"4000\" data-end=\"4003\" \/>\n<span id=\"heading-kombinera-flera-funktioner-i-samma-formel\"><h2 data-start=\"4005\" data-end=\"4049\">Kombinera flera funktioner i samma formel<\/h2><\/span>\n<p data-start=\"4051\" data-end=\"4151\">N\u00e4r du beh\u00e4rskar grunderna kan du b\u00f6rja kombinera funktioner f\u00f6r att skapa mer avancerade l\u00f6sningar.<\/p>\n<p data-start=\"4153\" data-end=\"4288\">Exempel:<br data-start=\"4161\" data-end=\"4164\" \/><code data-start=\"4164\" data-end=\"4209\">=OM(MEDEL(B2:B6)&gt;80;\"Godk\u00e4nt\";\"Ej godk\u00e4nt\")<\/code><br data-start=\"4209\" data-end=\"4212\" \/>H\u00e4r anv\u00e4nds MEDEL inuti OM-funktionen f\u00f6r att automatiskt bed\u00f6ma resultatet.<\/p>\n<figure id=\"attachment_493766\" aria-describedby=\"caption-attachment-493766\" style=\"width: 640px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-493766 size-large\" src=\"\/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-om-summa-1024x508.png\" alt=\"learnesy-excelfunktioner-om-summa\" width=\"640\" height=\"318\" srcset=\"\/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-om-summa-1024x508.png 1024w, \/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-om-summa-300x149.png 300w, \/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-om-summa-768x381.png 768w, \/wp-content\/uploads\/2025\/10\/learnesy-excelfunktioner-om-summa.png 1054w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption id=\"caption-attachment-493766\" class=\"wp-caption-text\"><em>Funktioner kan kombineras f\u00f6r att bilda l\u00e4ngre formler.<\/em><\/figcaption><\/figure>\n<hr data-start=\"4403\" data-end=\"4406\" \/>\n<span id=\"heading-vanliga-fel-i-excelformler-och-hur-du-loser-dem\"><h2 data-start=\"4408\" data-end=\"4460\">Vanliga fel i Excelformler \u2013 och hur du l\u00f6ser dem<\/h2><\/span>\n<div class=\"_tableContainer_1rjym_1\">\n<div class=\"group _tableWrapper_1rjym_13 flex w-fit flex-col-reverse\" tabindex=\"-1\">\n<table class=\"w-fit min-w-(--thread-content-width)\" data-start=\"4462\" data-end=\"4778\">\n<thead data-start=\"4462\" data-end=\"4490\">\n<tr data-start=\"4462\" data-end=\"4490\">\n<th data-start=\"4462\" data-end=\"4471\" data-col-size=\"sm\">Felkod<\/th>\n<th data-start=\"4471\" data-end=\"4479\" data-col-size=\"sm\">Orsak<\/th>\n<th data-start=\"4479\" data-end=\"4490\" data-col-size=\"md\">L\u00f6sning<\/th>\n<\/tr>\n<\/thead>\n<tbody data-start=\"4522\" data-end=\"4778\">\n<tr data-start=\"4522\" data-end=\"4610\">\n<td data-start=\"4522\" data-end=\"4531\" data-col-size=\"sm\">#NAMN?<\/td>\n<td data-col-size=\"sm\" data-start=\"4531\" data-end=\"4567\">Excel k\u00e4nner inte igen funktionen<\/td>\n<td data-col-size=\"md\" data-start=\"4567\" data-end=\"4610\">Kontrollera stavning eller spr\u00e5kversion<\/td>\n<\/tr>\n<tr data-start=\"4611\" data-end=\"4684\">\n<td data-start=\"4611\" data-end=\"4621\" data-col-size=\"sm\">#DIV\/0!<\/td>\n<td data-col-size=\"sm\" data-start=\"4621\" data-end=\"4640\">Delning med noll<\/td>\n<td data-col-size=\"md\" data-start=\"4640\" data-end=\"4684\">L\u00e4gg till ett OM-fel: <code data-start=\"4664\" data-end=\"4682\">=OMFEL(A1\/B1;\"\")<\/code><\/td>\n<\/tr>\n<tr data-start=\"4685\" data-end=\"4778\">\n<td data-start=\"4685\" data-end=\"4693\" data-col-size=\"sm\">#REF!<\/td>\n<td data-start=\"4693\" data-end=\"4716\" data-col-size=\"sm\">Ogiltig cellreferens<\/td>\n<td data-col-size=\"md\" data-start=\"4716\" data-end=\"4778\">Kontrollera om du tagit bort en cell som anv\u00e4nds i formeln<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p data-start=\"4780\" data-end=\"4867\">F\u00f6r en fullst\u00e4ndig artikel p\u00e5 \u00e4mnet formelfel, <a href=\"https:\/\/learnesy.com\/sv\/hur-atgardar-man-formelfel-i-excel\/\">se den h\u00e4r artikeln \u2192<\/a><\/p>\n<hr data-start=\"4869\" data-end=\"4872\" \/>\n<span id=\"heading-faq-vanliga-fragor-om-excelfunktioner\"><h2 data-start=\"4874\" data-end=\"4916\">FAQ \u2013 Vanliga fr\u00e5gor om Excelfunktioner<\/h2><\/span>\n<p data-start=\"4918\" data-end=\"5068\"><strong data-start=\"4918\" data-end=\"4967\">Vilka Excelfunktioner b\u00f6r man l\u00e4ra sig f\u00f6rst?<\/strong><br data-start=\"4967\" data-end=\"4970\" \/>SUMMA, MEDEL, OM och LETARAD \u00e4r de mest grundl\u00e4ggande och anv\u00e4nds i n\u00e4stan alla typer av kalkyler.<\/p>\n<p data-start=\"5070\" data-end=\"5224\"><strong data-start=\"5070\" data-end=\"5125\">Hur kan jag testa mina kunskaper i Excelfunktioner?<\/strong><br data-start=\"5125\" data-end=\"5128\" \/>Du kan g\u00f6ra Learnesys gratis <a class=\"decorated-link cursor-pointer\" target=\"_new\" rel=\"noopener\" data-start=\"5157\" data-end=\"5203\">Exceltest<\/a> f\u00f6r att se din niv\u00e5.<\/p>\n<p data-start=\"5226\" data-end=\"5406\"><strong data-start=\"5226\" data-end=\"5275\">Vad \u00e4r skillnaden mellan funktion och formel?<\/strong><br data-start=\"5275\" data-end=\"5278\" \/>En <strong data-start=\"5281\" data-end=\"5291\">formel<\/strong> \u00e4r hela uttrycket (t.ex. <code data-start=\"5317\" data-end=\"5325\">=A1+B1<\/code>), medan en <strong data-start=\"5337\" data-end=\"5349\">funktion<\/strong> \u00e4r ett f\u00e4rdigt verktyg i Excel (t.ex. <code data-start=\"5388\" data-end=\"5404\">=SUMMA(A1:A10)<\/code>). En\u00a0<strong>formel\u00a0<\/strong>utm\u00e4rker sig genom att du kan blanda element. Du kan anv\u00e4nda dig av cellreferenser, operatorer (plus, minus etc), konstanter (&#8221;7&#8221;, &#8221;1000&#8221; etc), och Excelfunktioner. T ex, <code data-start=\"5317\" data-end=\"5325\">=(SUMMA(A1:A10)*B1)\/7<\/code>.<\/p>\n<p data-start=\"5408\" data-end=\"5566\"><strong data-start=\"5408\" data-end=\"5463\">Kan man anv\u00e4nda engelska funktioner i svensk Excel?<\/strong><br data-start=\"5463\" data-end=\"5466\" \/>Nej, Excel anv\u00e4nder spr\u00e5kversionens egna funktionsnamn, men Learnesys kurser visar b\u00e5da varianterna.<\/p>\n<hr data-start=\"5568\" data-end=\"5571\" \/>\n<span id=\"heading-sammanfattning-och-nasta-steg\"><h2 data-start=\"5573\" data-end=\"5605\">Sammanfattning och n\u00e4sta steg<\/h2><\/span>\n<p data-start=\"5607\" data-end=\"5827\">Excelfunktioner \u00e4r grunden f\u00f6r allt du g\u00f6r i Excel; fr\u00e5n enklaste summering till avancerad dataanalys. N\u00e4r du f\u00f6rst\u00e5r hur du bygger formler, hanterar cellreferenser och kombinerar funktioner \u00f6ppnas helt nya m\u00f6jligheter.<\/p>\n<p data-start=\"5829\" data-end=\"6035\">Vill du l\u00e4ra dig mer om funktioner och formler, och andra grundl\u00e4ggande delar och funktionalitet i Excel? I <strong data-start=\"5881\" data-end=\"5908\">Learnesys Excelkurs Bas<\/strong> f\u00e5r du tydliga videolektioner, quiz och \u00f6vningar som g\u00f6r dig trygg i formler och funktioner i din egen takt, var du \u00e4n \u00e4r.<\/p>\n<p data-start=\"6037\" data-end=\"6106\"><a class=\"decorated-link cursor-pointer\" href=\"https:\/\/leanresy.com\/sv\/courses\/excelkurs-bas\/\" target=\"_new\" rel=\"noopener\" data-start=\"6037\" data-end=\"6106\">Utforska kursen h\u00e4r \u279d<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vill du f\u00f6rst\u00e5 hur Excelfunktioner och formler egentligen fungerar? I den h\u00e4r guiden l\u00e4r du dig grunderna i formelskrivning, vanliga funktioner som SUMMA, OM och LETARAD och hur du undviker de vanligaste felen. Perfekt f\u00f6r dig som vill jobba smartare i Excel och bygga s\u00e4krare kalkyler.<\/p>\n","protected":false},"author":54291,"featured_media":493802,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[],"class_list":["post-492449","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/492449","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\/54291"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=492449"}],"version-history":[{"count":7,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/492449\/revisions"}],"predecessor-version":[{"id":493805,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/492449\/revisions\/493805"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/493802"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=492449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=492449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=492449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}