{"id":133,"date":"2018-03-22T15:14:59","date_gmt":"2018-03-22T14:14:59","guid":{"rendered":"https:\/\/wpdemo.resurscentrum.se\/?page_id=133"},"modified":"2025-11-06T11:54:35","modified_gmt":"2025-11-06T10:54:35","slug":"excel-kalkylmodeller","status":"publish","type":"page","link":"https:\/\/www.resurscentrum.se\/?page_id=133","title":{"rendered":"Excel &#8211; steg 3"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-2149\" src=\"http:\/\/www.resurscentrum.se\/wp-content\/uploads\/2025\/08\/excel365-1.png\" alt=\"\" width=\"139\" height=\"126\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Excelutbildningarna bygger p\u00e5 3 steg d\u00e4r varje steg<br \/>\nger dig mer f\u00e4rdigheter och djupare kunskaper.<\/p>\n<h3><\/h3>\n<h3><\/h3>\n<h3><strong>Excel \u2013 steg 3<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Passar dig som<\/strong><br \/>\ndeltagit eller har motsvarande kunskaper i steg 1 och 2 och vill ta n\u00e4sta steg &#8211; g\u00f6ra mer avancerade ber\u00e4kningar, analyser och presentationer. Du l\u00e4r dig sammanst\u00e4lla och analysera listor med pivottabeller, visualisera med villkorsstyrd formatering, egna format och hantera data mellan arbetsb\u00f6cker.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Syfte och m\u00e5l<\/strong><br \/>\nAtt kunna hantera avancerade ber\u00e4kningar och analyser, bygga dynamiska rapporter med pivottabeller och villkorsstyrd formatering samt sammanst\u00e4lla data fr\u00e5n flera olika k\u00e4llor p\u00e5 ett professionellt s\u00e4tt.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Du l\u00e4r dig<\/strong><\/p>\n<ul>\n<li>Hantering av stora datam\u00e4ngder och avancerade format.<\/li>\n<li>Skapa egna format (tex kvm, kW, m3).<\/li>\n<li>Fler datum- och tidsformat.<\/li>\n<li>Villkorsstyrd formatering och f\u00e4rgvisualisering.<\/li>\n<li>Skapa och analysera data med pivottabeller.<\/li>\n<li>Avancerade funktioner; LETARAD, XLETAUPP, OCH,<br \/>\nELLER, SUMMA.OM, DATUM, V\u00c4NSTER\/H\u00d6GER.<\/li>\n<li>Kapslade funktioner (funktioner i funktioner),<\/li>\n<li>Namngivna omr\u00e5den och celler.<\/li>\n<li>L\u00e4nkar mellan arbetsb\u00f6cker och konsolideringsverktyget.<\/li>\n<li>Tips, best practice och vanliga fallgropar.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>F\u00f6rkunskaper<\/strong>\u00a0motsvarande Excel steg 1 och 2.<br \/>\nOm du \u00e4r os\u00e4ker p\u00e5 vilken kurs som passar dina f\u00f6rkunskaper s\u00e5 finns det ett\u00a0<span style=\"color: #993300;\">sj\u00e4lvuppskattningstest<\/span>.<br \/>\nMaila kurs@ircljungby.se s\u00e5 f\u00e5r du tillg\u00e5ng till l\u00e4nken.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Kursl\u00e4ngd<\/strong>\u00a01 dag<\/p>\n<p>&nbsp;<\/p>\n<blockquote><p><span style=\"font-family: Arial;\">Har du fr\u00e5gor kring anm\u00e4lan, kontakta IRC p\u00e5 telefon 0372-78 00 10<br \/>\neller <a href=\"mailto:info@ircljungby.se\">info@ircljungby.se<\/a><\/span><\/p><\/blockquote>\n<h4><strong>\u00a0<\/strong><\/h4>\n<h4>Intresseanm\u00e4lan<\/h4>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f289-o1\" lang=\"sv-SE\" dir=\"ltr\" data-wpcf7-id=\"289\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/index.php?rest_route=%2Fwp%2Fv2%2Fpages%2F133#wpcf7-f289-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Kontaktformul\u00e4r\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"289\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.2\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"sv_SE\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f289-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/>\n<\/fieldset>\n<p><label> Kursnamn<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"text1\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text\" aria-invalid=\"false\" value=\"\" type=\"text\" name=\"text1\" \/><\/span> <\/label>\n<\/p>\n<p><label> Namn<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"your-name2\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text\" aria-invalid=\"false\" value=\"\" type=\"text\" name=\"your-name2\" \/><\/span> <\/label>\n<\/p>\n<p><label> F\u00f6retag<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"text3\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text\" aria-invalid=\"false\" value=\"\" type=\"text\" name=\"text3\" \/><\/span> <\/label>\n<\/p>\n<p><label> Telefon<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"tel6\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-tel wpcf7-text wpcf7-validates-as-tel\" aria-invalid=\"false\" value=\"\" type=\"tel\" name=\"tel6\" \/><\/span> <\/label>\n<\/p>\n<p><label> Din epost<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"your-email7\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-text wpcf7-validates-as-email\" aria-invalid=\"false\" value=\"\" type=\"email\" name=\"your-email7\" \/><\/span> <\/label>\n<\/p>\n<p><label> Eventuellt meddelande<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"your-message8\"><textarea cols=\"40\" rows=\"10\" maxlength=\"2000\" class=\"wpcf7-form-control wpcf7-textarea\" aria-invalid=\"false\" name=\"your-message8\"><\/textarea><\/span> <\/label>\n<\/p>\n<p><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Skicka\" \/>\n<\/p><p style=\"display: none !important;\" class=\"akismet-fields-container\" data-prefix=\"_wpcf7_ak_\"><label>&#916;<textarea name=\"_wpcf7_ak_hp_textarea\" cols=\"45\" rows=\"8\" maxlength=\"100\"><\/textarea><\/label><input type=\"hidden\" id=\"ak_js_1\" name=\"_wpcf7_ak_js\" value=\"175\"\/><script>\ndocument.getElementById( \"ak_js_1\" ).setAttribute( \"value\", ( new Date() ).getTime() );\n<\/script>\n<\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Excelutbildningarna bygger p\u00e5 3 steg d\u00e4r varje steg ger dig mer f\u00e4rdigheter och djupare kunskaper. Excel \u2013 steg 3 &nbsp; &nbsp; Passar dig som deltagit eller har motsvarande kunskaper i steg 1 och 2 och vill ta n\u00e4sta steg &#8211; g\u00f6ra mer avancerade ber\u00e4kningar, analyser och presentationer. Du l\u00e4r dig sammanst\u00e4lla och analysera listor [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":127,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-133","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.resurscentrum.se\/index.php?rest_route=\/wp\/v2\/pages\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.resurscentrum.se\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.resurscentrum.se\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.resurscentrum.se\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.resurscentrum.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=133"}],"version-history":[{"count":13,"href":"https:\/\/www.resurscentrum.se\/index.php?rest_route=\/wp\/v2\/pages\/133\/revisions"}],"predecessor-version":[{"id":2280,"href":"https:\/\/www.resurscentrum.se\/index.php?rest_route=\/wp\/v2\/pages\/133\/revisions\/2280"}],"up":[{"embeddable":true,"href":"https:\/\/www.resurscentrum.se\/index.php?rest_route=\/wp\/v2\/pages\/127"}],"wp:attachment":[{"href":"https:\/\/www.resurscentrum.se\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}