{"id":505,"date":"2026-01-23T12:05:19","date_gmt":"2026-01-23T12:05:19","guid":{"rendered":"https:\/\/bliv-klogere.dk\/?page_id=505"},"modified":"2026-02-23T17:12:01","modified_gmt":"2026-02-23T17:12:01","slug":"7-videre-med-excel","status":"publish","type":"page","link":"https:\/\/bliv-klogere.dk\/index.php\/7-videre-med-excel\/","title":{"rendered":"7. Videre med Excel"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Indholdsfortegnelse<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/bliv-klogere.dk\/index.php\/7-videre-med-excel\/#1_Yderligere_emner_i_Excel\" >1. Yderligere emner i Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/bliv-klogere.dk\/index.php\/7-videre-med-excel\/#2_Kodning_i_Excel\" >2. Kodning i Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/bliv-klogere.dk\/index.php\/7-videre-med-excel\/#3Saet_navnet_pa_arket_ind_et_Excel_ark\" >3.S\u00e6t navnet p\u00e5 arket ind et Excel ark<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Yderligere_emner_i_Excel\"><\/span>1. Yderligere emner i Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Du kan f.eks. fordybe dig i:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Frysning: S\u00e5 man hele tiden ser den\/de \u00f8verste linje(-r) eller s\u00f8jle(-r), selv n\u00e5r man skroller<\/li>\n\n\n\n<li>Flere formler\n<ul class=\"wp-block-list\">\n<li>Formler, der arbejder med tekst<\/li>\n\n\n\n<li>Rentesregning (finansielle formler). S\u00e5 kan du regne renter og afdrag ud p\u00e5 f.eks. boligl\u00e5n eller se, hvor lidt du tjener ved at s\u00e6tte kr. 100.000 I banken.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Layouts\n<ul class=\"wp-block-list\">\n<li>V\u00e6r sikker p\u00e5, at alting er inden for margen, n\u00e5r du printer<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Grafik\n<ul class=\"wp-block-list\">\n<li>Grafer<\/li>\n\n\n\n<li>Betinget formatering (man farvel\u00e6gger celler efter v\u00e6rdi)<\/li>\n\n\n\n<li>Mini-diagrammer<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Scenarier, sammenligne forskellige mulige scenarier<\/li>\n\n\n\n<li>M\u00e5ls\u00f8gning: Hvis jeg skal tjene kr. 5.000 mere, hvor meget skal jeg s\u00e5 arbejde<\/li>\n\n\n\n<li>Pivot: Pivot er en m\u00e5de at analysere data p\u00e5. Man l\u00e6gger filtre p\u00e5 kryds og tv\u00e6rs I tabellen og kommer p\u00e5 den m\u00e5de frem til analyser. Det er nemmere og sjovere, end du tror \ud83d\ude42<\/li>\n\n\n\n<li>Makroer: Optag dine egne funktioner<\/li>\n\n\n\n<li>PowerBI: Grafisk visning af tal<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Kodning_i_Excel\"><\/span>2. Kodning i Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Bagved Excel ligger vba script, og f.eks. skrives makroer i vba script. ChatGBT er meget hj\u00e6lpsom mht. kodning i Excel. Bl.a. skal du have en ellers skjult fane frem, der hedder kodning.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3Saet_navnet_pa_arket_ind_et_Excel_ark\"><\/span>3.S\u00e6t navnet p\u00e5 arket ind et Excel ark<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Start med at oprette et Excelark, hvis du ikke allerede har et Excel ark i forvejen. Det her vil ikke virke, hvis ikke Excelarket er gemt.<\/li>\n\n\n\n<li>Jeg har her oprettet et Excel ark og kaldt fanebladet F\u00f8rste fane (1)<\/li>\n\n\n\n<li>I den \u00f8nskede celle her celle A1 indtaster jeg formlen. Du f\u00e5r den b\u00e5de i den danske og den engelske version (2)<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>Formel dansk version: =MIDT(CELLE(\"filnavn\";A1);FIND(\"]\";CELLE(\"filnavn\";A1))+1;255)   \n\nFormel engelsk version:\n=MID(CELL(\"filename\";A1);FIND(\"]\";CELL(\"filename\";A1))+1;255)<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Formlen returnerer arkets navn (3)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"452\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/02\/image-86.png\" alt=\"\" class=\"wp-image-1897\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/02\/image-86.png 811w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/02\/image-86-300x167.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/02\/image-86-768x428.png 768w\" sizes=\"auto, (max-width: 811px) 100vw, 811px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>1. Yderligere emner i Excel Du kan f.eks. fordybe dig i: 2. Kodning i Excel Bagved Excel ligger vba script, og f.eks. skrives makroer i vba script. ChatGBT er meget hj\u00e6lpsom mht. kodning i Excel. Bl.a. skal du have en ellers skjult fane frem, der hedder kodning. 3.S\u00e6t navnet p\u00e5 arket ind et Excel ark<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-505","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/comments?post=505"}],"version-history":[{"count":3,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/505\/revisions"}],"predecessor-version":[{"id":1911,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/505\/revisions\/1911"}],"wp:attachment":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/media?parent=505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}