{"id":970,"date":"2023-02-02T14:35:20","date_gmt":"2023-02-02T18:35:20","guid":{"rendered":"https:\/\/www.upr.edu\/shra\/?p=970"},"modified":"2023-10-24T13:13:02","modified_gmt":"2023-10-24T17:13:02","slug":"excel-basico","status":"publish","type":"post","link":"https:\/\/www.upr.edu\/shra\/excel-basico\/","title":{"rendered":"Excel B\u00e1sico"},"content":{"rendered":"<style>.kb-row-layout-id970_b1f52c-3f > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id970_b1f52c-3f > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id970_b1f52c-3f > .kt-row-column-wrap{column-gap:var(--global-kb-gap-md, 2rem);row-gap:var(--global-kb-gap-md, 2rem);padding-top:var(--global-kb-spacing-sm, 1.5rem);padding-bottom:var(--global-kb-spacing-sm, 1.5rem);grid-template-columns:minmax(0, 1fr);}.kb-row-layout-id970_b1f52c-3f > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id970_b1f52c-3f > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id970_b1f52c-3f > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id970_b1f52c-3f alignwide has-theme-palette7-background-color kt-row-has-bg wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-1-columns kt-row-layout-equal kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top\">\n<style>.kadence-column970_5c66c5-f9 > .kt-inside-inner-col,.kadence-column970_5c66c5-f9 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column970_5c66c5-f9 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column970_5c66c5-f9 > .kt-inside-inner-col{flex-direction:column;}.kadence-column970_5c66c5-f9 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column970_5c66c5-f9 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column970_5c66c5-f9{position:relative;}@media all and (max-width: 1024px){.kadence-column970_5c66c5-f9 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column970_5c66c5-f9 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column970_5c66c5-f9 inner-column-1\"><div class=\"kt-inside-inner-col\">\n<p class=\"wp-block-paragraph\"><strong>Descripci\u00f3n del Taller:<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Curso introductorio al programa Microsoft Excel. En este curso se aprender\u00e1n los conceptos y herramientas del programa de hoja de c\u00e1lculo. El estudiante conocer\u00e1 las herramientas que contiene la Cinta de Opciones. Obtendr\u00e1 conocimientos \u00fatiles a la hora de realizar una hoja de c\u00e1lculo.<\/p>\n<\/div><\/div>\n\n<\/div><\/div>\n\n<style>.kb-row-layout-id970_7462a5-0f > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id970_7462a5-0f > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id970_7462a5-0f > .kt-row-column-wrap{column-gap:var(--global-kb-gap-md, 2rem);row-gap:var(--global-kb-gap-md, 2rem);padding-top:var(--global-kb-spacing-sm, 1.5rem);padding-bottom:var(--global-kb-spacing-sm, 1.5rem);grid-template-columns:minmax(0, 1fr);}.kb-row-layout-id970_7462a5-0f > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id970_7462a5-0f > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id970_7462a5-0f > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id970_7462a5-0f alignwide has-theme-palette7-background-color kt-row-has-bg wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-1-columns kt-row-layout-equal kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top\">\n<style>.kadence-column970_9df0e2-ec > .kt-inside-inner-col,.kadence-column970_9df0e2-ec > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column970_9df0e2-ec > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column970_9df0e2-ec > .kt-inside-inner-col{flex-direction:column;}.kadence-column970_9df0e2-ec > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column970_9df0e2-ec > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column970_9df0e2-ec{position:relative;}@media all and (max-width: 1024px){.kadence-column970_9df0e2-ec > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column970_9df0e2-ec > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column970_9df0e2-ec inner-column-1\"><div class=\"kt-inside-inner-col\"><\/div><\/div>\n\n<\/div><\/div>\n\n<style>.kb-row-layout-id970_497878-17 > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id970_497878-17 > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id970_497878-17 > .kt-row-column-wrap{column-gap:var(--global-kb-gap-md, 2rem);row-gap:var(--global-kb-gap-md, 2rem);padding-top:var(--global-kb-spacing-sm, 1.5rem);padding-bottom:var(--global-kb-spacing-sm, 1.5rem);grid-template-columns:minmax(0, 1fr);}.kb-row-layout-id970_497878-17 > .kt-row-layout-overlay{opacity:0.60;background-color:var(--global-palette9, #ffffff);}@media all and (max-width: 1024px){.kb-row-layout-id970_497878-17 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id970_497878-17 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id970_497878-17 alignwide has-theme-palette6-background-color kt-row-has-bg wp-block-kadence-rowlayout\"><div class=\"kt-row-layout-overlay kt-row-overlay-normal\"><\/div><div class=\"kt-row-column-wrap kt-has-1-columns kt-row-layout-equal kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top\">\n<style>.kadence-column970_402716-16 > .kt-inside-inner-col,.kadence-column970_402716-16 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column970_402716-16 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column970_402716-16 > .kt-inside-inner-col{flex-direction:column;}.kadence-column970_402716-16 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column970_402716-16 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column970_402716-16{position:relative;}@media all and (max-width: 1024px){.kadence-column970_402716-16 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column970_402716-16 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column970_402716-16 inner-column-1\"><div class=\"kt-inside-inner-col\">\n<p class=\"wp-block-paragraph\"><strong>Objetivo General<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Definir\u00e1 el concepto de Microsoft Excel.<\/li>\n\n\n\n<li>Conocer\u00e1 los conceptos b\u00e1sicos de Microsoft Excel.<\/li>\n\n\n\n<li>Aprender\u00e1 a abrir y cerrar el programa.<\/li>\n\n\n\n<li>Reconocer\u00e1 la diferencia entre una hoja en blanco y una hoja con dise\u00f1os.<\/li>\n\n\n\n<li>Identificar\u00e1 los componentes de la pantalla.<\/li>\n\n\n\n<li>Conocer\u00e1 los diferentes tipos de punteros en Excel.<\/li>\n\n\n\n<li>Conocer\u00e1 la interfaz de la Cinta de Opciones.<\/li>\n\n\n\n<li>Crear\u00e1 formulas b\u00e1sicas.<\/li>\n<\/ul>\n<\/div><\/div>\n\n<\/div><\/div>\n\n<style>.kb-row-layout-id970_7609f5-bc > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id970_7609f5-bc > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id970_7609f5-bc > .kt-row-column-wrap{column-gap:var(--global-kb-gap-md, 2rem);row-gap:var(--global-kb-gap-md, 2rem);padding-top:var(--global-kb-spacing-sm, 1.5rem);padding-bottom:var(--global-kb-spacing-sm, 1.5rem);grid-template-columns:minmax(0, 1fr);}.kb-row-layout-id970_7609f5-bc > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id970_7609f5-bc > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id970_7609f5-bc > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id970_7609f5-bc alignwide has-theme-palette7-background-color kt-row-has-bg wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-1-columns kt-row-layout-equal kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top\">\n<style>.kadence-column970_b901a9-dc > .kt-inside-inner-col,.kadence-column970_b901a9-dc > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column970_b901a9-dc > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column970_b901a9-dc > .kt-inside-inner-col{flex-direction:column;}.kadence-column970_b901a9-dc > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column970_b901a9-dc > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column970_b901a9-dc{position:relative;}@media all and (max-width: 1024px){.kadence-column970_b901a9-dc > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column970_b901a9-dc > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column970_b901a9-dc inner-column-1\"><div class=\"kt-inside-inner-col\">\n<p class=\"wp-block-paragraph\"><strong>Distribuci\u00f3n de Contenido Tem\u00e1tico<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Introducci\u00f3n a Excel<ul><li>Concepto de hojas de c\u00e1lculo<\/li><\/ul><ul><li>Abrir y cerrar un programa<\/li><\/ul><ul><li>Manejo de ayuda<\/li><\/ul><ul><li>Operaciones b\u00e1sicas con archivos<ul><li>Guardar, abrir y cerrar Libro<\/li><\/ul><\/li><\/ul><ul><li>Utilizaci\u00f3n de Hojas de C\u00e1lculo<ul><li>Hoja en Blanco (Blank Worksheet)<\/li><\/ul><ul><li>Hoja con dise\u00f1os (Template)<\/li><\/ul><\/li><\/ul><ul><li>Punteros en Excel<\/li><\/ul><ul><li>Interfaz de Excel<ul><li>Manejo de la Cinta de Opciones o \u201cRibbon\u201d<ul><li>Personalizaci\u00f3n de la interfaz<ul><li>Personalizaci\u00f3n \u201cribbon\u201d<\/li><\/ul><ul><li>Personalizaci\u00f3n barra acceso r\u00e1pido<\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul><ul><li>Formatos:<ul><li>Formato de celda<ul><li>Fuente, alineaci\u00f3n, n\u00fameros<\/li><\/ul><ul><li>Bordes y sombreados.<\/li><\/ul><ul><li>Copiar formatos<\/li><\/ul><\/li><\/ul><\/li><\/ul>\n<ul class=\"wp-block-list\">\n<li>Formulas b\u00e1sicas<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estrategias Educacionales<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Aprendizaje basado en situaciones<\/li>\n\n\n\n<li>Ense\u00f1anza individualizada<\/li>\n\n\n\n<li>Simulaciones<\/li>\n\n\n\n<li>Integraci\u00f3n de la tecnolog\u00eda<\/li>\n\n\n\n<li>Ejercicios Pr\u00e1cticos utilizando la computadora<\/li>\n\n\n\n<li>Se utilizar\u00e1 una presentaci\u00f3n electr\u00f3nica como gu\u00eda de estudio<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Procedimientos en el Taller<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Se enviar\u00e1n los materiales educacionales, a los participantes, los cuales consta de una presentaci\u00f3n gu\u00eda realizada en PowerPoint y una carpeta con los ejercicios de pr\u00e1cticos, que se discutir\u00e1n durante el taller. Los mismos ser\u00e1n enviados por correo electr\u00f3nico, directamente a los participantes. Antes de comenzar el adiestramiento se enviar\u00e1 un correo electr\u00f3nico con el enlace para acceder al formulario de la pre-prueba y luego se seguir\u00e1 el mismo procedimiento para realizar la post-prueba.<\/p>\n<\/div><\/div>\n\n<\/div><\/div>\n\n<style>.kb-row-layout-id970_e5233a-9c > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id970_e5233a-9c > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id970_e5233a-9c > .kt-row-column-wrap{column-gap:var(--global-kb-gap-md, 2rem);row-gap:var(--global-kb-gap-md, 2rem);padding-top:var(--global-kb-spacing-sm, 1.5rem);padding-bottom:var(--global-kb-spacing-sm, 1.5rem);grid-template-columns:minmax(0, 1fr);}.kb-row-layout-id970_e5233a-9c > .kt-row-layout-overlay{opacity:0.60;background-color:var(--global-palette9, #ffffff);}@media all and (max-width: 1024px){.kb-row-layout-id970_e5233a-9c > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id970_e5233a-9c > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id970_e5233a-9c alignwide has-theme-palette6-background-color kt-row-has-bg wp-block-kadence-rowlayout\"><div class=\"kt-row-layout-overlay kt-row-overlay-normal\"><\/div><div class=\"kt-row-column-wrap kt-has-1-columns kt-row-layout-equal kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top\">\n<style>.kadence-column970_e4d8bf-b6 > .kt-inside-inner-col,.kadence-column970_e4d8bf-b6 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column970_e4d8bf-b6 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column970_e4d8bf-b6 > .kt-inside-inner-col{flex-direction:column;}.kadence-column970_e4d8bf-b6 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column970_e4d8bf-b6 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column970_e4d8bf-b6{position:relative;}@media all and (max-width: 1024px){.kadence-column970_e4d8bf-b6 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column970_e4d8bf-b6 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column970_e4d8bf-b6 inner-column-1\"><div class=\"kt-inside-inner-col\">\n<p class=\"wp-block-paragraph\"><strong>Referencias Bibliogr\u00e1gicas<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Anderson, G., Ferro, D. &amp; Hilton, R. (2016). Connecting with Computer Science. MA: Cengage Learning.<\/li>\n\n\n\n<li>Aulaclic.com. Curso Excel 2016. Disponible en: http:\/\/www.aulaclic.es\/excel-2013\/curso\/Temario.htm<\/li>\n\n\n\n<li>Frye, C. D. (2010). Microsoft Excel 2010 Plain &amp; Simple. NY: Microsoft Press.<\/li>\n<\/ul>\n<\/div><\/div>\n\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Descripci\u00f3n del Taller: Curso introductorio al programa Microsoft Excel. En este curso se aprender\u00e1n los conceptos y herramientas del programa de hoja de c\u00e1lculo. El estudiante conocer\u00e1 las herramientas que contiene la Cinta de Opciones. Obtendr\u00e1 conocimientos \u00fatiles a la hora de realizar una hoja de c\u00e1lculo. Objetivo General Distribuci\u00f3n de Contenido Tem\u00e1tico Estrategias Educacionales&#8230;<\/p>\n","protected":false},"author":237,"featured_media":971,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_themeisle_gutenberg_block_has_review":false,"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"show","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[3,11,12,15],"tags":[],"class_list":["post-970","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cursos","category-sesion-3","category-sesion-4","category-sesion-6"],"featured_image_src":"https:\/\/www.upr.edu\/shra\/wp-content\/uploads\/sites\/129\/2023\/02\/Curso-Excel.jpg","author_info":{"display_name":"Jose A. Mu\u00f1oz","author_link":"https:\/\/www.upr.edu\/shra\/author\/josemunoz17\/"},"_links":{"self":[{"href":"https:\/\/www.upr.edu\/shra\/wp-json\/wp\/v2\/posts\/970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.upr.edu\/shra\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.upr.edu\/shra\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.upr.edu\/shra\/wp-json\/wp\/v2\/users\/237"}],"replies":[{"embeddable":true,"href":"https:\/\/www.upr.edu\/shra\/wp-json\/wp\/v2\/comments?post=970"}],"version-history":[{"count":4,"href":"https:\/\/www.upr.edu\/shra\/wp-json\/wp\/v2\/posts\/970\/revisions"}],"predecessor-version":[{"id":1466,"href":"https:\/\/www.upr.edu\/shra\/wp-json\/wp\/v2\/posts\/970\/revisions\/1466"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.upr.edu\/shra\/wp-json\/wp\/v2\/media\/971"}],"wp:attachment":[{"href":"https:\/\/www.upr.edu\/shra\/wp-json\/wp\/v2\/media?parent=970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.upr.edu\/shra\/wp-json\/wp\/v2\/categories?post=970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.upr.edu\/shra\/wp-json\/wp\/v2\/tags?post=970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}