{"id":101734,"date":"2021-10-26T08:50:53","date_gmt":"2021-10-26T06:50:53","guid":{"rendered":"https:\/\/learnesy.com\/?p=101734"},"modified":"2021-10-26T11:23:39","modified_gmt":"2021-10-26T09:23:39","slug":"se-lektionen-koppla-data-med-pivottabeller","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/se-lektionen-koppla-data-med-pivottabeller\/","title":{"rendered":"Se lektionen: Koppla data med Pivottabeller"},"content":{"rendered":"<span id=\"heading-\"><h3><\/h3><\/span>\n<span id=\"heading-lar-dig-koppla-data-i-pivottabeller-visas-i-denna-veckas-exceltips-skapa-pivottabell-pa-flera-cellomraden\"><h3><strong>L\u00e4r dig koppla data i Pivottabeller visas i denna veckas Exceltips. Skapa Pivottabell p\u00e5 flera cellomr\u00e5den.<\/strong><\/h3><\/span>\n<p>I denna veckas lektion ser vi p\u00e5 hur man kan koppla kolumner i olika tabeller till en och samma Pivottabell.<br \/>\nGenom att hantera relationerna mellan dataunderlag kan vi skapa pivottabeller som tar data fr\u00e5n flera k\u00e4llor och sammanst\u00e4ller allting p\u00e5 en och samma plats.<br \/>\nS\u00e5 l\u00e4nge din data \u00e4r sorterad och dina tabeller har en kolumn som anv\u00e4nder sig av samma datapunkter \u00e4r det m\u00f6jligt att sammans\u00e4tta datan och skapa helt nya analyser. Vilket ger dig m\u00f6jlighet att effektivisera ditt arbete.<\/p>\n<p>&nbsp;<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/638995307?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<span id=\"heading-du-hittar-dagens-lektion-i-kursen-pivottabeller-fordjupning\"><h3>Du hittar dagens lektion i kursen\u00a0 &#8211; <a href=\"https:\/\/learnesy.com\/sv\/courses\/fordjupning-pivottabeller\/\">Pivottabeller F\u00f6rdjupning<\/a><\/h3><\/span>\n<p>&nbsp;<\/p>\n<p><strong>L\u00e4s med om Pivottabeller i g\u00e4stbloggsinl\u00e4ggen:<\/strong><\/p>\n<p><a href=\"https:\/\/learnesy.com\/sv\/hur-du-anvander-pivottabeller-i-excel-nagot-alla-bor-kunna\/\">Hur du anv\u00e4nder Pivottabeller i Excel, n\u00e5got alla b\u00f6r kunna&#8230;<\/a><\/p>\n<p><a href=\"https:\/\/learnesy.com\/sv\/arbeta-med-pivottabeller-och-beraknade-falt-i-excel\/\">Arbeta med Pivottabeller och Ber\u00e4knande f\u00e4lt i Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>L\u00e4r dig koppla data i Pivottabeller visas i denna veckas Exceltips. Skapa Pivottabell p\u00e5 flera cellomr\u00e5den. I denna veckas lektion ser vi p\u00e5 hur man kan koppla kolumner i olika tabeller till en och samma [&hellip;]<\/p>\n","protected":false},"author":41201,"featured_media":101739,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[223,185,74,202,224,222],"class_list":["post-101734","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-analysera-data","tag-dataanalys","tag-excel-3","tag-excelfunktion","tag-koppla-kolumner","tag-pivottabeller"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/101734","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=101734"}],"version-history":[{"count":9,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/101734\/revisions"}],"predecessor-version":[{"id":101831,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/101734\/revisions\/101831"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/101739"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=101734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=101734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=101734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}