{"id":63305,"date":"2026-03-31T12:50:16","date_gmt":"2026-03-31T12:50:16","guid":{"rendered":"https:\/\/www.apen.es\/?post_type=curso-formacion&#038;p=63305"},"modified":"2026-03-31T15:18:25","modified_gmt":"2026-03-31T15:18:25","slug":"google-sheets-level-ii","status":"publish","type":"curso-formacion","link":"https:\/\/www.apen.es\/en\/training-course\/google-sheets-level-ii\/","title":{"rendered":"Google Sheets Level II"},"content":{"rendered":"<h2 class=\"wp-block-heading\"><strong>Who is it aimed at?<\/strong><\/h2>\n\n\n\n<p>The Google Sheets Level II course is designed for professionals who already use spreadsheets and want to expand their knowledge to work with data more efficiently and in a structured way. Participants will learn to use logical, text, and lookup functions; cross-reference information between tables; clean and organize data; and perform basic analysis using advanced filters, slicers, and pivot tables. It is ideal for users who are already familiar with the basic functions of Google Sheets and want to take their data analysis and management to the next level.<br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What will you learn?<\/strong><\/h2>\n\n\n\n<p>Upon completion of the training, the student will be able to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Apply logical and conditional functions for simple decisions.<\/li>\n\n\n\n<li>Clean, transform, and structure data efficiently.<\/li>\n\n\n\n<li>Relate information between different tables using lookup and reference functions.<\/li>\n\n\n\n<li>Analyze datasets using filters, slicers, and pivot tables.<\/li>\n\n\n\n<li>Improve the visual interpretation of information through conditional formatting.<\/li>\n\n\n\n<li>Control data quality through validations and input restrictions<\/li>\n<\/ul>","protected":false},"featured_media":63335,"parent":0,"menu_order":19,"template":"","meta":{"_acf_changed":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"modalidad":[953],"software":[982],"convocatoria":[967],"bonificable":[972],"class_list":["post-63305","curso-formacion","type-curso-formacion","status-publish","has-post-thumbnail","hentry","modalidad-curso","software-google-workspace","convocatoria-proximamente","bonificable-parcial"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Curso Google Sheets Nivel II | Funciones y an\u00e1lisis de datos<\/title>\n<meta name=\"description\" content=\"Aprende a usar funciones, filtros, b\u00fasquedas y tablas din\u00e1micas en Google Sheets para analizar datos con m\u00e1s eficacia.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.apen.es\/en\/training-course\/google-sheets-level-ii\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Curso Google Sheets Nivel II | Funciones y an\u00e1lisis de datos\" \/>\n<meta property=\"og:description\" content=\"Aprende a usar funciones, filtros, b\u00fasquedas y tablas din\u00e1micas en Google Sheets para analizar datos con m\u00e1s eficacia.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.apen.es\/en\/training-course\/google-sheets-level-ii\/\" \/>\n<meta property=\"og:site_name\" content=\"Apen Inform\u00e1tica\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/apensolucions\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-31T15:18:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.apen.es\/wp-content\/uploads\/2026\/03\/imatges-cursos-google-sheets-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"860\" \/>\n\t<meta property=\"og:image:height\" content=\"216\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/google-sheets-nivel-ii\\\/\",\"url\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/google-sheets-nivel-ii\\\/\",\"name\":\"Curso Google Sheets Nivel II | Funciones y an\u00e1lisis de datos\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/google-sheets-nivel-ii\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/google-sheets-nivel-ii\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/imatges-cursos-google-sheets-1.jpg\",\"datePublished\":\"2026-03-31T12:50:16+00:00\",\"dateModified\":\"2026-03-31T15:18:25+00:00\",\"description\":\"Aprende a usar funciones, filtros, b\u00fasquedas y tablas din\u00e1micas en Google Sheets para analizar datos con m\u00e1s eficacia.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/google-sheets-nivel-ii\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/google-sheets-nivel-ii\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/google-sheets-nivel-ii\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/imatges-cursos-google-sheets-1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/imatges-cursos-google-sheets-1.jpg\",\"width\":860,\"height\":216},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/google-sheets-nivel-ii\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/www.apen.es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Sheets Nivel II\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/#website\",\"url\":\"https:\\\/\\\/www.apen.es\\\/\",\"name\":\"Apen Inform\u00e1tica\",\"description\":\"Mantenimiento Inform\u00e1tico , Software de Gesti\u00f3n, Soluciones de impresi\u00f3n\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.apen.es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/#organization\",\"name\":\"Apen: Soluciones inform\u00e1ticas\",\"url\":\"https:\\\/\\\/www.apen.es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/logo-apenok-231x82-1.png\",\"contentUrl\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/logo-apenok-231x82-1.png\",\"width\":231,\"height\":82,\"caption\":\"Apen: Soluciones inform\u00e1ticas\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/apensolucions\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/ApenCentreInformatic\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1021771?trk=tyah&trkInfo=clickedVerticalcompanyclickedEntityId1021771idx2-1-2tarId1464195271196tasapenin\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Sheets Level II Course | Functions and Data Analysis","description":"Learn how to use functions, filters, searches, and pivot tables in Google Sheets to analyze data more effectively.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.apen.es\/en\/training-course\/google-sheets-level-ii\/","og_locale":"en_US","og_type":"article","og_title":"Curso Google Sheets Nivel II | Funciones y an\u00e1lisis de datos","og_description":"Aprende a usar funciones, filtros, b\u00fasquedas y tablas din\u00e1micas en Google Sheets para analizar datos con m\u00e1s eficacia.","og_url":"https:\/\/www.apen.es\/en\/training-course\/google-sheets-level-ii\/","og_site_name":"Apen Inform\u00e1tica","article_publisher":"https:\/\/www.facebook.com\/apensolucions","article_modified_time":"2026-03-31T15:18:25+00:00","og_image":[{"width":860,"height":216,"url":"https:\/\/www.apen.es\/wp-content\/uploads\/2026\/03\/imatges-cursos-google-sheets-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.apen.es\/curso-formacion\/google-sheets-nivel-ii\/","url":"https:\/\/www.apen.es\/curso-formacion\/google-sheets-nivel-ii\/","name":"Google Sheets Level II Course | Functions and Data Analysis","isPartOf":{"@id":"https:\/\/www.apen.es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.apen.es\/curso-formacion\/google-sheets-nivel-ii\/#primaryimage"},"image":{"@id":"https:\/\/www.apen.es\/curso-formacion\/google-sheets-nivel-ii\/#primaryimage"},"thumbnailUrl":"https:\/\/www.apen.es\/wp-content\/uploads\/2026\/03\/imatges-cursos-google-sheets-1.jpg","datePublished":"2026-03-31T12:50:16+00:00","dateModified":"2026-03-31T15:18:25+00:00","description":"Learn how to use functions, filters, searches, and pivot tables in Google Sheets to analyze data more effectively.","breadcrumb":{"@id":"https:\/\/www.apen.es\/curso-formacion\/google-sheets-nivel-ii\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.apen.es\/curso-formacion\/google-sheets-nivel-ii\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.apen.es\/curso-formacion\/google-sheets-nivel-ii\/#primaryimage","url":"https:\/\/www.apen.es\/wp-content\/uploads\/2026\/03\/imatges-cursos-google-sheets-1.jpg","contentUrl":"https:\/\/www.apen.es\/wp-content\/uploads\/2026\/03\/imatges-cursos-google-sheets-1.jpg","width":860,"height":216},{"@type":"BreadcrumbList","@id":"https:\/\/www.apen.es\/curso-formacion\/google-sheets-nivel-ii\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.apen.es\/"},{"@type":"ListItem","position":2,"name":"Google Sheets Nivel II"}]},{"@type":"WebSite","@id":"https:\/\/www.apen.es\/#website","url":"https:\/\/www.apen.es\/","name":"Apen Inform\u00e1tica","description":"IT Maintenance, Management Software, Printing Solutions","publisher":{"@id":"https:\/\/www.apen.es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.apen.es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.apen.es\/#organization","name":"Apen: IT Solutions","url":"https:\/\/www.apen.es\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.apen.es\/#\/schema\/logo\/image\/","url":"https:\/\/www.apen.es\/wp-content\/uploads\/2022\/08\/logo-apenok-231x82-1.png","contentUrl":"https:\/\/www.apen.es\/wp-content\/uploads\/2022\/08\/logo-apenok-231x82-1.png","width":231,"height":82,"caption":"Apen: Soluciones inform\u00e1ticas"},"image":{"@id":"https:\/\/www.apen.es\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/apensolucions","https:\/\/www.youtube.com\/user\/ApenCentreInformatic","https:\/\/www.linkedin.com\/company\/1021771?trk=tyah&trkInfo=clickedVerticalcompanyclickedEntityId1021771idx2-1-2tarId1464195271196tasapenin"]}]}},"taxonomy_info":{"modalidad":[{"value":953,"label":"Curso"}],"software":[{"value":982,"label":"Google Workspace"}],"convocatoria":[{"value":967,"label":"Pr\u00f3ximamente"}],"bonificable":[{"value":972,"label":"Parcial"}]},"featured_image_src_large":["https:\/\/www.apen.es\/wp-content\/uploads\/2026\/03\/imatges-cursos-google-sheets-1.jpg",860,216,false],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/curso-formacion\/63305","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/curso-formacion"}],"about":[{"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/types\/curso-formacion"}],"version-history":[{"count":1,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/curso-formacion\/63305\/revisions"}],"predecessor-version":[{"id":63309,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/curso-formacion\/63305\/revisions\/63309"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/media\/63335"}],"wp:attachment":[{"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/media?parent=63305"}],"wp:term":[{"taxonomy":"modalidad","embeddable":true,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/modalidad?post=63305"},{"taxonomy":"software","embeddable":true,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/software?post=63305"},{"taxonomy":"convocatoria","embeddable":true,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/convocatoria?post=63305"},{"taxonomy":"bonificable","embeddable":true,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/bonificable?post=63305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}