{"id":7943,"date":"2019-10-15T15:59:27","date_gmt":"2019-10-15T13:59:27","guid":{"rendered":"https:\/\/icebergng.udg.edu\/?p=7943"},"modified":"2021-01-20T12:19:36","modified_gmt":"2021-01-20T11:19:36","slug":"curs-dexcel-avancat","status":"publish","type":"post","link":"https:\/\/iceberg.udg.edu\/?p=7943","title":{"rendered":"Curs d&#8217;Excel avan\u00e7at (Primera part)"},"content":{"rendered":"\n<p><strong>Presentaci\u00f3:&nbsp;<\/strong>Aquest curs s\u2019adre\u00e7a a persones usu\u00e0ries que ja treballen amb aquest programa i que volen tenir un major coneixement de les funcions avan\u00e7ades que ofereix.<\/p>\n\n\n\n<p><strong>Programa:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Format de cel\u00b7les <\/li><li>Ordenaci\u00f3 de dades <\/li><li>F\u00f2rmules <\/li><li>Validaci\u00f3 <\/li><li>Filtres <\/li><li>Format condicional <\/li><li>Taules din\u00e0miques <\/li><li>Gr\u00e0fics vs gr\u00e0fics din\u00e0mics <\/li><li>Presentaci\u00f3 de p\u00e0gina<\/li><\/ul>\n\n\n\n<p>Est\u00e0 previst complementar aquest curs amb un altre curs durant el segon semestre en el qual es treballaran les macros.<\/p>\n\n\n\n<p><strong>Metodologia: <\/strong><\/p>\n\n\n\n<p>A cada sessi\u00f3 hi ha una part d&#8217;explicaci\u00f3 i una altra de fer exercicis, posant en pr\u00e0ctica el que s&#8217;ha desenvolupat durant la sessi\u00f3. <br>En aquest curs es demana que dueu una base de dades amb la que treballeu habitualment, en format excel (per exemple notes dels estudiants o dades de recerca), i a la part de la sessi\u00f3 pr\u00e0ctica s&#8217;intentar\u00e0 treballar el contingut del curs amb aquesta base de dades vostra.<\/p>\n\n\n\n<p>Est\u00e0 previst complementar aquest curs amb un altre curs el segon semestre en el qual es treballaran les macros.&nbsp;Es pot veure m\u00e9s informaci\u00f3 d\u2019aquest segon curs a la web de l\u2019ICE.&nbsp;\n\n<\/p>\n\n\n\n<p><strong>Calendari i horari: <\/strong> 12, 14, 19, 21 i 26 de novembre de 16:30h a 19:30h<\/p>\n\n\n\n<p><strong>Lloc<\/strong>: Aula d&#8217;inform\u00e0tica AC-037i de l&#8217;aulari com\u00fa (Campus de Montilivi) <\/p>\n\n\n\n<p><strong>Organitza:<\/strong>\u00a0Institut de Ci\u00e8ncies de l&#8217;Educaci\u00f3 Josep Pallach <\/p>\n\n\n\n<p><a href=\"https:\/\/aserv.udg.edu\/MAU\/ice\/Client\/Oferta\/Detall\/5383\">\u201cM\u00e9s informaci\u00f3 i matr\u00edcula\u201d<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\t\t\t\tAquest curs s\u2019adre\u00e7a a persones usu\u00e0ries que ja treballen amb aquest programa i que volen tenir un major coneixement de les funcions avan\u00e7ades que ofereix.  <\/p>\n<p>Entre d&#8217;altres elements es treballaran el format de cel\u00b7les, l&#8217;ordenaci\u00f3 de dades, f\u00f2rmules, filtres, taules din\u00e0miques i gr\u00e0fics.\t\t<\/p>\n","protected":false},"author":2,"featured_media":7947,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,33],"tags":[],"class_list":["post-7943","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-activitats","category-repassat"],"_links":{"self":[{"href":"https:\/\/iceberg.udg.edu\/index.php?rest_route=\/wp\/v2\/posts\/7943","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iceberg.udg.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iceberg.udg.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iceberg.udg.edu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/iceberg.udg.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7943"}],"version-history":[{"count":1,"href":"https:\/\/iceberg.udg.edu\/index.php?rest_route=\/wp\/v2\/posts\/7943\/revisions"}],"predecessor-version":[{"id":12312,"href":"https:\/\/iceberg.udg.edu\/index.php?rest_route=\/wp\/v2\/posts\/7943\/revisions\/12312"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/iceberg.udg.edu\/index.php?rest_route=\/wp\/v2\/media\/7947"}],"wp:attachment":[{"href":"https:\/\/iceberg.udg.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7943"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iceberg.udg.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7943"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iceberg.udg.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7943"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}