{"id":3898,"date":"2015-07-06T13:04:26","date_gmt":"2015-07-06T12:04:26","guid":{"rendered":"http:\/\/www.espai.es\/blog\/?p=3898"},"modified":"2015-07-08T12:09:06","modified_gmt":"2015-07-08T11:09:06","slug":"introduccion-a-microsoft-excel-iii","status":"publish","type":"post","link":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/","title":{"rendered":"Introducci\u00f3n a Microsoft Excel (III)"},"content":{"rendered":"<p>Buenos d\u00edas a todos y bienvenidos a un nuevo art\u00edculo del blog de Espai.<\/p>\n<p>Despu\u00e9s de casi 2 meses sin escribir, se oxida un poco el arte este de juntar letras&#8230; Asi que si encontr\u00e1is algun <em>as\u00edn<\/em>, lo <em>cualo<\/em> o <em>Me se ha ca\u00edo <\/em>en el art\u00edculo&#8230; No lo teng\u00e1is en cuenta! No ser\u00eda tan grave, lo importante es ser feliz y <a href=\"https:\/\/www.youtube.com\/watch?v=DXOjKLja57s\" target=\"_blank\">nadar en la ambulancia<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.youtube.com\/watch?v=DXOjKLja57s\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3970 size-full\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-0.png\" alt=\"Introduccion a excel 2010\" width=\"663\" height=\"320\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-0.png 663w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-0-300x145.png 300w\" sizes=\"auto, (max-width: 663px) 100vw, 663px\" \/><\/a><\/p>\n<p style=\"text-align: center\">El Sr. Pazos, nadando en la ambulancia<\/p>\n<p>&nbsp;<\/p>\n<p>Se acab\u00f3 el rollo, vamos al bollo:<\/p>\n<p>&nbsp;<\/p>\n<h2>\u00cdndice de contenidos: Introducci\u00f3n a Microsoft Excel<\/h2>\n<p>&nbsp;<\/p>\n<ol>\n<li>Organizar la informaci\u00f3n en Tablas<\/li>\n<li>Filtrar datos<\/li>\n<li>Automatizar c\u00e1lculos como sumas y promedios<\/li>\n<\/ol>\n<p>Vamos a basar todo el art\u00edculo en un ejemplo pr\u00e1ctico. Puedes baj\u00e1rtelo <a href=\"http:\/\/www.espailab.com\/blog\/descargas\/articulo_blog.xlsx\" target=\"_blank\">Aqu\u00ed<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h3>Organizar la informaci\u00f3n en Tablas<\/h3>\n<p>&nbsp;<\/p>\n<p>En excel todo son filas, columnas y celdas. La informaci\u00f3n no tiene ninguna relaci\u00f3n entre s\u00ed, y para eso vienen al rescate las tablas. Nos permiten filtrar nuestros datos, ordenarlos y actualizar autom\u00e1ticamente los c\u00e1lculos cuando insertamos o eliminamos informaci\u00f3n.<\/p>\n<div id=\"attachment_3926\" style=\"width: 650px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3926\" class=\"wp-image-3926 size-large\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-1-1024x562.png\" alt=\"espai-escola-informatica-excel-1\" width=\"640\" height=\"351\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-1-1024x562.png 1024w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-1-300x165.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-1.png 1893w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><p id=\"caption-attachment-3926\" class=\"wp-caption-text\">Introducci\u00f3n a Microsoft Excel<\/p><\/div>\n<p style=\"text-align: center\">Pulsamos el boton crear tabla, despues de seleccionar todos los datos que queramos que la formen. Incluye las cabeceras.<\/p>\n<p><a href=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3927 size-large\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-2-1024x604.png\" alt=\"Introducci\u00f3n a Microsoft Excel \" width=\"640\" height=\"378\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-2-1024x604.png 1024w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-2-300x177.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-2.png 1356w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p style=\"text-align: center\">Aceptar<\/p>\n<p><a href=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3928 size-large\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-3-1024x465.png\" alt=\"Introducci\u00f3n a Microsoft Excel \" width=\"640\" height=\"291\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-3-1024x465.png 1024w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-3-300x136.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-3.png 1821w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p style=\"text-align: center\">Ya tenemos creada la tabla, por eso aparecen las flechas.<\/p>\n<p>&nbsp;<\/p>\n<p>Estas flechas nos van a permitir filtrar y ordenar la informaci\u00f3n, una herramienta muy \u00fatil cuando trabajamos con grandes vol\u00famenes de datos. Vamos a ver c\u00f3mo:<\/p>\n<p>&nbsp;<\/p>\n<h3>Filtrar datos<\/h3>\n<p>&nbsp;<\/p>\n<p>En nuestro ejemplo, vamos a mostrar s\u00f3lo los pa\u00edses con m\u00e1s de 500 millones de habitantes. Aparte de Lloret en verano no debe haber muchos m\u00e1s&#8230;<\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3929 size-large\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-4-1024x732.png\" alt=\"Introducci\u00f3n a Microsoft Excel \" width=\"640\" height=\"458\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-4-1024x732.png 1024w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-4-300x214.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-4.png 1062w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\nSelecciona \u00abmayor que\u00bb<\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3930 size-large\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-5-1024x491.png\" alt=\"Introducci\u00f3n a Microsoft Excel \" width=\"640\" height=\"307\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-5-1024x491.png 1024w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-5-300x144.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-5.png 1567w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\nEscribe la cantidad m\u00ednima de poblaci\u00f3n para que se muestre el pa\u00eds. Todos los menores (o iguales) a esa cantidad se ocultar\u00e1n.<\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3931 size-full\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-6.png\" alt=\"Introducci\u00f3n a Microsoft Excel \" width=\"971\" height=\"490\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-6.png 971w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-6-300x151.png 300w\" sizes=\"auto, (max-width: 971px) 100vw, 971px\" \/><\/a><br \/>\nAqu\u00ed tenemos el resultado.<\/p>\n<p>&nbsp;<\/p>\n<p>F\u00edjate que las filas est\u00e1n discontinuas, hay un salto entre el 5, 106 y 114. Tambi\u00e9n sale en azul, asi excel nos indica que hay filas ocultas que no aparecen porque est\u00e1n filtradas.<\/p>\n<p>ya hemos visto c\u00f3mo filtrar resultados, pero ahopra tenemos muy pocos datos para seguir con nuestro ejemplo. Por eso vamos a eliminar el filtro que hemos aplicado, asi:<\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3932 size-large\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-7-1024x707.png\" alt=\"Introducci\u00f3n a Microsoft Excel \" width=\"640\" height=\"442\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-7-1024x707.png 1024w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-7-300x207.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-7.png 1133w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\nBorramos el filtro para que vuelva a aparecer todo.<\/p>\n<p>&nbsp;<\/p>\n<p>Si miras m\u00e1s en detalle, ver\u00e1s que hay otra opci\u00f3n (ordenar) que tambien nos puede ser \u00fatil. Para utilizarla es bien sencillo:<\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3933 size-large\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-8-1024x710.png\" alt=\"Introducci\u00f3n a Microsoft Excel \" width=\"640\" height=\"444\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-8-1024x710.png 1024w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-8-300x208.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-8.png 1140w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\nOrdenaci\u00f3n alfab\u00e9tica.<\/p>\n<p>&nbsp;<\/p>\n<p>F\u00edjate que si haces lo mismo en una columna num\u00e9rica, como la de poblaci\u00f3n, la ordenaci\u00f3n ser\u00e1 de mayor a menor.<\/p>\n<p>Todo esto de por s\u00ed ya es \u00fatil, pero si ademas le a\u00f1adimos c\u00e1lculos automatizados ya es que lo petamos&#8230;<\/p>\n<p>&nbsp;<\/p>\n<h3>Automatizar c\u00e1lculos como sumas y promedios<\/h3>\n<p>&nbsp;<\/p>\n<p>Vamos a a\u00f1adir un total en la columna de poblaci\u00f3n, de esta manera:<\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3934 size-full\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-9.png\" alt=\"Introducci\u00f3n a Microsoft Excel \" width=\"925\" height=\"604\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-9.png 925w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-9-300x196.png 300w\" sizes=\"auto, (max-width: 925px) 100vw, 925px\" \/><\/a><br \/>\nCreamos la f\u00f3rmula de total<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3935 size-full\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-10.png\" alt=\"Introducci\u00f3n a Microsoft Excel \" width=\"915\" height=\"591\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-10.png 915w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-10-300x194.png 300w\" sizes=\"auto, (max-width: 915px) 100vw, 915px\" \/><\/a><br \/>\nAceptamos, aqui el resultado<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3936 size-full\" src=\"http:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-11.png\" alt=\"Introducci\u00f3n a Microsoft Excel \" width=\"886\" height=\"466\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-11.png 886w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-11-300x158.png 300w\" sizes=\"auto, (max-width: 886px) 100vw, 886px\" \/><\/a><br \/>\nResultado tras insertar nuestro nuevo pa\u00eds.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Fijaros en que el total se ha actualizado autom\u00e1ticamente, sin necesidad de modificar la f\u00f3rmula. Tambi\u00e9n ha variado la manera de representar la misma, ya que en lugar de utiliazr el t\u00edpico rango a que estamos acostumbrados:<\/p>\n<p>=suma(E6:E210)<\/p>\n<p>ha variado a<\/p>\n<p>=SUMA(poblacion)<\/p>\n<p>de esta forma es mucho m\u00e1s intuitivo saber qu\u00e9 est\u00e1 calculando esta celda.<br \/>\nTened en cuenta que tambi\u00e9n lo podemos encontrar en la forma<\/p>\n<p>=SUMA(Tabla1[Poblaci\u00f3n])<\/p>\n<p>esta ultima forma es necesaria si hay varias tablas en la hoja.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Y hasta aqu\u00ed el tema de hoy. Espero que os haya sido interesante,<\/p>\n<p>Saludos y hasta la pr\u00f3xima!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Buenos d\u00edas a todos y bienvenidos a un nuevo art\u00edculo del blog de Espai. Despu\u00e9s de casi 2 meses sin escribir, se oxida un poco el arte este de juntar letras&#8230; Asi que si encontr\u00e1is algun as\u00edn, lo cualo o Me se ha ca\u00edo en&#8230;<\/p>\n","protected":false},"author":3,"featured_media":3947,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_ef_editorial_meta_date_first-draft-date":"","_ef_editorial_meta_paragraph_assignment":"","_ef_editorial_meta_checkbox_needs-photo":"","_ef_editorial_meta_number_word-count":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[218,379,1],"tags":[],"class_list":["post-3898","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-escola-espai","category-productividad","category-sin-categoria"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Introducci\u00f3n a Microsoft Excel (III) - Blog Escola Espai<\/title>\n<meta name=\"description\" content=\"Introducci\u00f3n a Microsoft Excel, tablas, filtros, ordenacion de datos y calculos automatizados. Escuela escola Espai Informatica, enten\u00e7a 182. Ofim\u00e1tica 2010\" \/>\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.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducci\u00f3n a Microsoft Excel (III) - Blog Escola Espai\" \/>\n<meta property=\"og:description\" content=\"Introducci\u00f3n a Microsoft Excel, tablas, filtros, ordenacion de datos y calculos automatizados. Escuela escola Espai Informatica, enten\u00e7a 182. Ofim\u00e1tica 2010\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Escola Espai\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-06T12:04:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-07-08T11:09:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-intro1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Escobar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Escobar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/\"},\"author\":{\"name\":\"Escobar\",\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602\"},\"headline\":\"Introducci\u00f3n a Microsoft Excel (III)\",\"datePublished\":\"2015-07-06T12:04:26+00:00\",\"dateModified\":\"2015-07-08T11:09:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/\"},\"wordCount\":638,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-intro1.png\",\"articleSection\":[\"Escola Espai\",\"Productividad\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/\",\"url\":\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/\",\"name\":\"Introducci\u00f3n a Microsoft Excel (III) - Blog Escola Espai\",\"isPartOf\":{\"@id\":\"https:\/\/www.espai.es\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-intro1.png\",\"datePublished\":\"2015-07-06T12:04:26+00:00\",\"dateModified\":\"2015-07-08T11:09:06+00:00\",\"author\":{\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602\"},\"description\":\"Introducci\u00f3n a Microsoft Excel, tablas, filtros, ordenacion de datos y calculos automatizados. Escuela escola Espai Informatica, enten\u00e7a 182. Ofim\u00e1tica 2010\",\"breadcrumb\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#primaryimage\",\"url\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-intro1.png\",\"contentUrl\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-intro1.png\",\"width\":400,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.espai.es\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introducci\u00f3n a Microsoft Excel (III)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.espai.es\/blog\/#website\",\"url\":\"https:\/\/www.espai.es\/blog\/\",\"name\":\"Blog Escola Espai\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.espai.es\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602\",\"name\":\"Escobar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g\",\"caption\":\"Escobar\"},\"sameAs\":[\"http:\/\/www.espai.es\"],\"url\":\"https:\/\/www.espai.es\/blog\/author\/escobar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introducci\u00f3n a Microsoft Excel (III) - Blog Escola Espai","description":"Introducci\u00f3n a Microsoft Excel, tablas, filtros, ordenacion de datos y calculos automatizados. Escuela escola Espai Informatica, enten\u00e7a 182. Ofim\u00e1tica 2010","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.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/","og_locale":"es_ES","og_type":"article","og_title":"Introducci\u00f3n a Microsoft Excel (III) - Blog Escola Espai","og_description":"Introducci\u00f3n a Microsoft Excel, tablas, filtros, ordenacion de datos y calculos automatizados. Escuela escola Espai Informatica, enten\u00e7a 182. Ofim\u00e1tica 2010","og_url":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/","og_site_name":"Blog Escola Espai","article_published_time":"2015-07-06T12:04:26+00:00","article_modified_time":"2015-07-08T11:09:06+00:00","og_image":[{"width":400,"height":300,"url":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-intro1.png","type":"image\/png"}],"author":"Escobar","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Escobar","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#article","isPartOf":{"@id":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/"},"author":{"name":"Escobar","@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602"},"headline":"Introducci\u00f3n a Microsoft Excel (III)","datePublished":"2015-07-06T12:04:26+00:00","dateModified":"2015-07-08T11:09:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/"},"wordCount":638,"commentCount":0,"image":{"@id":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#primaryimage"},"thumbnailUrl":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-intro1.png","articleSection":["Escola Espai","Productividad"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/","url":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/","name":"Introducci\u00f3n a Microsoft Excel (III) - Blog Escola Espai","isPartOf":{"@id":"https:\/\/www.espai.es\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#primaryimage"},"image":{"@id":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#primaryimage"},"thumbnailUrl":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-intro1.png","datePublished":"2015-07-06T12:04:26+00:00","dateModified":"2015-07-08T11:09:06+00:00","author":{"@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602"},"description":"Introducci\u00f3n a Microsoft Excel, tablas, filtros, ordenacion de datos y calculos automatizados. Escuela escola Espai Informatica, enten\u00e7a 182. Ofim\u00e1tica 2010","breadcrumb":{"@id":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#primaryimage","url":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-intro1.png","contentUrl":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-intro1.png","width":400,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/www.espai.es\/blog\/2015\/07\/introduccion-a-microsoft-excel-iii\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.espai.es\/blog\/"},{"@type":"ListItem","position":2,"name":"Introducci\u00f3n a Microsoft Excel (III)"}]},{"@type":"WebSite","@id":"https:\/\/www.espai.es\/blog\/#website","url":"https:\/\/www.espai.es\/blog\/","name":"Blog Escola Espai","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.espai.es\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602","name":"Escobar","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g","caption":"Escobar"},"sameAs":["http:\/\/www.espai.es"],"url":"https:\/\/www.espai.es\/blog\/author\/escobar\/"}]}},"jetpack_featured_media_url":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2015\/07\/espai-escola-informatica-excel-intro1.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts\/3898","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/comments?post=3898"}],"version-history":[{"count":16,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts\/3898\/revisions"}],"predecessor-version":[{"id":3975,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts\/3898\/revisions\/3975"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/media\/3947"}],"wp:attachment":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/media?parent=3898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/categories?post=3898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/tags?post=3898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}