{"id":1043,"date":"2026-04-17T07:54:32","date_gmt":"2026-04-17T07:54:32","guid":{"rendered":"https:\/\/reverent-almeida.91-213-46-106.plesk.page\/curso\/fulles-de-calcul-basic\/"},"modified":"2026-04-29T07:58:43","modified_gmt":"2026-04-29T07:58:43","slug":"fulles-de-calcul-basic","status":"publish","type":"curso_foment","link":"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/","title":{"rendered":"Fulles de c\u00e0lcul &#8211; B\u00e0sic"},"featured_media":0,"template":"","meta":{"_doceos_id":"17016","_start_date":"2026-01-08T23:00:00.000000Z","_end_date":"2026-01-19T23:00:00.000000Z","_available_seats":"0","_seats":"15","_lang_code":"ca","_tt_days_mask":"1111100","_tt_pm_start":"00:00:00","_tt_pm_end":"00:00:00","_timetable_desc":"Monday, Tuesday, Wednesday, Thursday and Friday from 09:00 to 14:00","_horario_tipo":"Ma\u00f1ana","_presence_hours":"40","_teletraining_hours":"0","_distance_hours":"0","_syllabus":"M\u00f2dul 1 \u00b7 Fonaments d\u2019Excel (ADGG021PO)\n  - Introducci\u00f3: conceptes b\u00e0sics\n  - Introduir dades a les cel\u00b7les\n  - Operacions amb llibres de treball\n  - Treballar amb fulls de c\u00e0lcul\n  - Operacions d\u2019edici\u00f3 sobre cel\u00b7les, files i columnes\n  - Aplicar formats a les cel\u00b7les\n  - Construcci\u00f3 de f\u00f3rmules i \u00fas de funcions\n  - Iniciaci\u00f3 als gr\u00e0fics\n  - Impressi\u00f3 i presentaci\u00f3\n\nM\u00f2dul 2 \u00b7 Excel Avan\u00e7at (ADGG020PO)\n  - Funcions\n  - Bases de dades\n  - Formularis: botons de formularis\n  - Vistes\n  - Estructures de control\n  - An\u00e0lisi de dades\n  - Solver: plantilles\n  - Macros\n  - Obtenci\u00f3 de dades externes\n  - Rangs\n  - Inserci\u00f3 d\u2019objectes","_contingut":"<span style=\"color:#c1002b\">Contingut del curs<\/span>\n\n<span style=\"color:#c1002b\">M\u00f2dul 1 \u00b7 Fonaments d\u2019Excel (ADGG021PO)<\/span>\n<strong>Introducci\u00f3: conceptes b\u00e0sics<\/strong>\n<ul>\n<li>Definici\u00f3 i caracter\u00edstiques de les fulles de c\u00e0lcul.<\/li>\n<\/ul>\n\n<strong>Introduir dades a les cel\u00b7les<\/strong>\n<ul>\n<li>Introduir text, n\u00fameros, dates, hores i f\u00f3rmules.<\/li>\n<li>Modificar el contingut d\u2019una cel\u00b7la.<\/li>\n<li>Despla\u00e7ar-se per una fulla.<\/li>\n<\/ul>\n\n<strong>Operacions amb llibres de treball<\/strong>\n<ul>\n<li>Crear un nou llibre.<\/li>\n<li>Obrir un llibre guardat anteriorment.<\/li>\n<li>Treballar amb diversos llibres alhora.<\/li>\n<li>Desar un llibre.<\/li>\n<li>Tancar un llibre.<\/li>\n<\/ul>\n\n<strong>Treballar amb fulls de c\u00e0lcul<\/strong>\n<ul>\n<li>Activar una fulla.<\/li>\n<li>Seleccionar diverses fulles.<\/li>\n<li>Inserir noves fulles a un llibre.<\/li>\n<li>Canviar el nom d\u2019una fulla.<\/li>\n<li>Eliminar, moure i copiar fulles d\u2019un llibre.<\/li>\n<\/ul>\n\n<strong>Operacions d\u2019edici\u00f3 sobre cel\u00b7les, files i columnes<\/strong>\n<ul>\n<li>Seleccionar cel\u00b7les.<\/li>\n<li>Canviar l\u2019al\u00e7ada de les files i l\u2019amplada de les columnes.<\/li>\n<li>Copiar i moure cel\u00b7les.<\/li>\n<\/ul>\n\n<strong>Aplicar formats a les cel\u00b7les<\/strong>\n<ul>\n<li>Aplicar formats de n\u00famero i de font.<\/li>\n<li>Aplicar vores i ombrejat a les cel\u00b7les.<\/li>\n<li>Alinear i orientar el contingut de les cel\u00b7les.<\/li>\n<li>Esborrar el format de les cel\u00b7les.<\/li>\n<\/ul>\n\n<strong>Construcci\u00f3 de f\u00f3rmules i \u00fas de funcions<\/strong>\n<ul>\n<li>Creaci\u00f3 de f\u00f3rmules.<\/li>\n<li>Refer\u00e8ncies de cel\u00b7la: concepte i tipus.<\/li>\n<li>Valors d\u2019error.<\/li>\n<li>Sintaxi de les funcions.<\/li>\n<li>Tipus de funcions.<\/li>\n<\/ul>\n\n<strong>Iniciaci\u00f3 als gr\u00e0fics<\/strong>\n<ul>\n<li>Elements d\u2019un gr\u00e0fic.<\/li>\n<li>Com inserir un gr\u00e0fic.<\/li>\n<li>Modificar un gr\u00e0fic (mida, posici\u00f3, escala).<\/li>\n<\/ul>\n\n<strong>Impressi\u00f3 i presentaci\u00f3<\/strong>\n<ul>\n<li>Opcions d\u2019impressi\u00f3 i preparaci\u00f3 de la presentaci\u00f3 del full de c\u00e0lcul.<\/li>\n<\/ul>\n\n<span style=\"color:#c1002b\">M\u00f2dul 2 \u00b7 Excel Avan\u00e7at (ADGG020PO)<\/span>\n<strong>Funcions<\/strong>\n<ul>\n<li>Anidar funcions.<\/li>\n<\/ul>\n\n<strong>Bases de dades<\/strong>\n<ul>\n<li>Filtres avan\u00e7ats.<\/li>\n<li>Validaci\u00f3 de dades.<\/li>\n<li>Depurar bases de dades: valors \u00fanics.<\/li>\n<\/ul>\n\n<strong>Formularis: botons de formularis<\/strong>\n<ul>\n<li>\u00das i configuraci\u00f3 de botons de formularis.<\/li>\n<\/ul>\n\n<strong>Vistes<\/strong>\n<ul>\n<li>Agrupar i desagrupar.<\/li>\n<li>Autoesquema.<\/li>\n<\/ul>\n\n<strong>Estructures de control<\/strong>\n<ul>\n<li>Domini de taules din\u00e0miques.<\/li>\n<li>Consolidaci\u00f3 de dades.<\/li>\n<\/ul>\n\n<strong>An\u00e0lisi de dades<\/strong>\n<ul>\n<li>Cerca d\u2019objectiu.<\/li>\n<li>Escenaris.<\/li>\n<li>Taules d\u2019una i dues variables.<\/li>\n<\/ul>\n\n<strong>Solver: plantilles<\/strong>\n<ul>\n<li>\u00das de Solver per a la resoluci\u00f3 de problemes.<\/li>\n<\/ul>\n\n<strong>Macros<\/strong>\n<ul>\n<li>Gravaci\u00f3 de macros. Creaci\u00f3 de macros.<\/li>\n<li>Reproducci\u00f3 de macros.<\/li>\n<li>Eliminaci\u00f3 de macros.<\/li>\n<li>Crear icones i botons que executin macros.<\/li>\n<li>Seguretat de macros.<\/li>\n<\/ul>\n\n<strong>Obtenci\u00f3 de dades externes<\/strong>\n<ul>\n<li>Des d\u2019Access.<\/li>\n<li>Des de text.<\/li>\n<li>Altres possibilitats.<\/li>\n<li>Connexi\u00f3 amb Access: importaci\u00f3, vinculaci\u00f3.<\/li>\n<\/ul>\n\n<strong>Rangs<\/strong>\n<ul>\n<li>Noms de rang.<\/li>\n<li>Modificar rangs.<\/li>\n<li>Treure duplicats.<\/li>\n<\/ul>\n\n<strong>Inserci\u00f3 d\u2019objectes<\/strong>\n<ul>\n<li>Inserir diferents tipus d\u2019objectes dins d\u2019Excel.<\/li>\n<\/ul>\n","_objectius":"L\u2019itinerari <strong>Fulles de c\u00e0lcul - b\u00e0sic<\/strong> \u00e9s un itinerari compost per les especialitats formatives <strong>ADGG021PO Fonaments Excel<\/strong> i <strong>ADGG020PO Excel avan\u00e7at<\/strong>, amb una durada total de 40 hores, on podreu adquirir els coneixements necessaris per treballar amb les operacions b\u00e0siques i funcions habituals de les fulles de c\u00e0lcul Excel que cont\u00e9 l\u2019aplicaci\u00f3 Microsoft Office, aix\u00ed com con\u00e8ixer l\u2019aplicaci\u00f3 i el disseny de funcions avan\u00e7ades d\u2019Excel, el treball amb dades externes i la interconnexi\u00f3 d\u2019Excel amb Access.\n\n<span style=\"color: #c1002b;\">Aquest curs est\u00e0 dirigit a <strong>dones, priorit\u00e0riament aturades<\/strong>, inscrites a les Oficines de Treball del Servei P\u00fablic d\u2019Ocupaci\u00f3 de Catalunya.<\/span>\n\n<span style=\"color:#c1002b\"><strong>Objectiu general<\/strong><\/span>\nAdquirir els coneixements necessaris per treballar amb operacions b\u00e0siques i funcions habituals de les fulles de c\u00e0lcul Excel, aix\u00ed com aplicar i dissenyar funcions avan\u00e7ades, treballar amb dades externes i utilitzar la interconnexi\u00f3 d\u2019Excel amb Access.\n\n<span style=\"color:#c1002b\">Objectius espec\u00edfics<\/span>\n<ul>\n<li>Introduir dades i gestionar el contingut de les cel\u00b7les en un full de c\u00e0lcul.<\/li>\n\n<li>Crear, gestionar i emmagatzemar llibres i fulls de c\u00e0lcul.<\/li>\n\n<li>Aplicar formats i operacions d\u2019edici\u00f3 a cel\u00b7les, files i columnes.<\/li>\n\n<li>Construir f\u00f3rmules, utilitzar funcions i identificar errors habituals.<\/li>\n\n<li>Iniciar-se en la creaci\u00f3, modificaci\u00f3 i presentaci\u00f3 de gr\u00e0fics.<\/li>\n\n<li>Aplicar formats avan\u00e7ats i validar dades en bases de dades d\u2019Excel.<\/li>\n\n<li>Dissenyar i anidar funcions avan\u00e7ades en Excel.<\/li>\n\n<li>Gestionar filtres, formularis i estructures de control com les taules din\u00e0miques.<\/li>\n\n<li>Analitzar dades mitjan\u00e7ant escenaris, taules de variables, cerca d\u2019objectius i Solver.<\/li>\n\n<li>Crear i gestionar macros, aix\u00ed com inserir objectes i connectar Excel amb Access i altres fonts externes.<\/li>\n<\/ul>","_requisits":"<span style=\"color: #c1002b;\">Aquest curs est\u00e0 dirigit a <strong>dones, priorit\u00e0riament aturades<\/strong>, inscrites a les Oficines de Treball del Servei P\u00fablic d\u2019Ocupaci\u00f3 de Catalunya.<\/span>\n\n<span style=\"color:#c1002b\">Requisits dels alumnes<\/span>\n<ul>\n<li><strong>Estudis (Acreditacions\/Titulacions)<\/strong>\n  <ul>\n    <li>No es requereixen titulacions espec\u00edfiques pr\u00e8vies, per\u00f2 es recomana tenir coneixements b\u00e0sics d\u2019inform\u00e0tica.<\/li>\n  <\/ul>\n<\/li>\n\n<li><strong>Experi\u00e8ncia professional<\/strong>\n  <ul>\n    <li>No es requereix experi\u00e8ncia professional pr\u00e8via, per\u00f2 pot ser \u00fatil tenir experi\u00e8ncia en entorns d\u2019oficina o gesti\u00f3 administrativa.<\/li>\n  <\/ul>\n<\/li>\n\n<li><strong>Altres requisits<\/strong>\n  <ul>\n    <li>Disposar d\u2019un ordinador amb connexi\u00f3 a internet i el programari Microsoft Excel instal\u00b7lat.<\/li>\n  <\/ul>\n<\/li>\n<\/ul>","_materials":"Motxilla, bloc, bol\u00edgrag i dossier","_resp_name":"Paqui Fuentes Camara","_resp_email":null,"_certificado":"1","_adaptado":"0","_modality_id":"1","_training_area_id":"1","_custom_code":null,"_group":"1","_closed":"0","_full":"1","_num_sessions":null,"_visible_on_web":"1","_wpml_trid":"1017","_wpml_lang":"ca"},"class_list":["post-1043","curso_foment","type-curso_foment","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Fulles de c\u00e0lcul - B\u00e0sic -<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"ca_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fulles de c\u00e0lcul - B\u00e0sic -\" \/>\n<meta property=\"og:url\" content=\"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-29T07:58:43+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/\",\"url\":\"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/\",\"name\":\"Fulles de c\u00e0lcul - B\u00e0sic -\",\"isPartOf\":{\"@id\":\"https:\/\/foment.teamdesarrollo.com\/ca\/#website\"},\"datePublished\":\"2026-04-17T07:54:32+00:00\",\"dateModified\":\"2026-04-29T07:58:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/#breadcrumb\"},\"inLanguage\":\"ca\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/foment.teamdesarrollo.com\/ca\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cursos\",\"item\":\"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Fulles de c\u00e0lcul &#8211; B\u00e0sic\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/foment.teamdesarrollo.com\/ca\/#website\",\"url\":\"https:\/\/foment.teamdesarrollo.com\/ca\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/foment.teamdesarrollo.com\/ca\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ca\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fulles de c\u00e0lcul - B\u00e0sic -","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"ca_ES","og_type":"article","og_title":"Fulles de c\u00e0lcul - B\u00e0sic -","og_url":"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/","article_modified_time":"2026-04-29T07:58:43+00:00","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/","url":"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/","name":"Fulles de c\u00e0lcul - B\u00e0sic -","isPartOf":{"@id":"https:\/\/foment.teamdesarrollo.com\/ca\/#website"},"datePublished":"2026-04-17T07:54:32+00:00","dateModified":"2026-04-29T07:58:43+00:00","breadcrumb":{"@id":"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/#breadcrumb"},"inLanguage":"ca","potentialAction":[{"@type":"ReadAction","target":["https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/fulles-de-calcul-basic\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/foment.teamdesarrollo.com\/ca\/"},{"@type":"ListItem","position":2,"name":"Cursos","item":"https:\/\/foment.teamdesarrollo.com\/ca\/formacio\/"},{"@type":"ListItem","position":3,"name":"Fulles de c\u00e0lcul &#8211; B\u00e0sic"}]},{"@type":"WebSite","@id":"https:\/\/foment.teamdesarrollo.com\/ca\/#website","url":"https:\/\/foment.teamdesarrollo.com\/ca\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/foment.teamdesarrollo.com\/ca\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ca"}]}},"_links":{"self":[{"href":"https:\/\/foment.teamdesarrollo.com\/ca\/wp-json\/wp\/v2\/curso_foment\/1043","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/foment.teamdesarrollo.com\/ca\/wp-json\/wp\/v2\/curso_foment"}],"about":[{"href":"https:\/\/foment.teamdesarrollo.com\/ca\/wp-json\/wp\/v2\/types\/curso_foment"}],"wp:attachment":[{"href":"https:\/\/foment.teamdesarrollo.com\/ca\/wp-json\/wp\/v2\/media?parent=1043"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}