{"id":13676,"date":"2026-11-18T16:18:20","date_gmt":"2026-11-18T15:18:20","guid":{"rendered":"https:\/\/global-bits.com\/curso\/excel-avancat"},"modified":"2026-11-18T16:18:20","modified_gmt":"2026-11-18T15:18:20","slug":"excel-avancat","status":"publish","type":"curso","link":"https:\/\/global-bits.com\/ca\/curs\/excel-avancat","title":{"rendered":"Excel nivell avan\u00e7at"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Objectius<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Entendre, comprendre i realitzar operacions per a l&#8217;\u00fas professional de funcionalitats avan\u00e7ades de l&#8217;eina Microsoft Excel, com ara l&#8217;administraci\u00f3 de configuracions i opcions d&#8217;un llibre, les funcions avan\u00e7ades per crear f\u00f3rmules, taules i gr\u00e0fics, i la gesti\u00f3 de configuracions personalitzades.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Continguts<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Administrar configuracions i opcions d&#8217;un llibre<ol class=\"wp-block-list\"><li>Administrar llibres<\/li><li>Administrar la revisi\u00f3 de llibres<\/li><\/ol><\/li><li>Aplicar dissenys i formats de dades personalitzats<ol class=\"wp-block-list\"><li>Aplicar formats de dades personalitzats i validacions<\/li><li>Aplicar filtres i formats condicionals avan\u00e7ats<\/li><li>Crear i modificar elements d&#8217;un llibre personalitzat<\/li><li>Preparar un llibre per a la internacionalitzaci\u00f3<\/li><\/ol><\/li><li>Crear f\u00f3rmules avan\u00e7ades<ol class=\"wp-block-list\"><li>Aplicar funcions en f\u00f3rmules<\/li><li>Cercar dades utilitzant funcions<\/li><li>Aplicar funcions avan\u00e7ades de data i hora<\/li><li>Realitzar an\u00e0lisis de dades i intel\u00b7lig\u00e8ncia empresarial<\/li><li>Resoldre problemes amb les f\u00f3rmules<\/li><li>Definir objectes i rangs amb nom<\/li><\/ol><\/li><li>Crear taules i gr\u00e0fics avan\u00e7ats<ol class=\"wp-block-list\"><li>Crear gr\u00e0fics avan\u00e7ats<\/li><li>Crear i administrar taules din\u00e0miques<\/li><li>Crear i administrar gr\u00e0fics din\u00e0mics<\/li><\/ol><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Excel avan\u00e7at: configuraci\u00f3 de llibres, formats personalitzats, f\u00f3rmules avan\u00e7ades, taules i gr\u00e0fics.<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"_EventAllDay":false,"_EventTimezone":"","_EventStartDate":"","_EventEndDate":"","_EventStartDateUTC":"","_EventEndDateUTC":"","_EventShowMap":false,"_EventShowMapLink":false,"_EventURL":"","_EventCost":"","_EventCostDescription":"","_EventCurrencySymbol":"","_EventCurrencyCode":"","_EventCurrencyPosition":"","_EventDateTimeSeparator":"","_EventTimeRangeSeparator":"","_EventOrganizerID":[],"_EventVenueID":[],"_OrganizerEmail":"","_OrganizerPhone":"","_OrganizerWebsite":"","_VenueAddress":"","_VenueCity":"","_VenueCountry":"","_VenueProvince":"","_VenueState":"","_VenueZip":"","_VenuePhone":"","_VenueURL":"","_VenueStateProvince":"","_VenueLat":"","_VenueLng":"","_VenueShowMap":false,"_VenueShowMapLink":false,"gb_horas":45,"gb_estado":"sin_fecha","gb_fecha_inicio":"","gb_fecha_fin":"","gb_horario":"","gb_modalidad":"presencial","gb_plazas":0,"gb_precio":"","gb_financiador":"","gb_certificado":"","gb_aviso":"","gb_url_antigua":"https:\/\/global-bits.com\/ca\/microsoft-excel-2016-nivell-inicial","footnotes":""},"area":[242],"situacion":[228,227],"class_list":["post-13676","curso","type-curso","status-publish","hentry","area-informatica-i-ofimatica"],"_links":{"self":[{"href":"https:\/\/global-bits.com\/ca\/wp-json\/wp\/v2\/curso\/13676","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/global-bits.com\/ca\/wp-json\/wp\/v2\/curso"}],"about":[{"href":"https:\/\/global-bits.com\/ca\/wp-json\/wp\/v2\/types\/curso"}],"version-history":[{"count":0,"href":"https:\/\/global-bits.com\/ca\/wp-json\/wp\/v2\/curso\/13676\/revisions"}],"wp:attachment":[{"href":"https:\/\/global-bits.com\/ca\/wp-json\/wp\/v2\/media?parent=13676"}],"wp:term":[{"taxonomy":"area","embeddable":true,"href":"https:\/\/global-bits.com\/ca\/wp-json\/wp\/v2\/area?post=13676"},{"taxonomy":"situacion","embeddable":true,"href":"https:\/\/global-bits.com\/ca\/wp-json\/wp\/v2\/situacion?post=13676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}