﻿{"id":14686,"date":"2022-11-16T12:00:19","date_gmt":"2022-11-16T18:00:19","guid":{"rendered":"https:\/\/www.uv.mx\/edu-cont\/?p=14686"},"modified":"2022-11-16T12:04:15","modified_gmt":"2022-11-16T18:04:15","slug":"formulas-y-funciones-de-la-hoja-de-calculo-4","status":"publish","type":"post","link":"https:\/\/www.uv.mx\/edu-cont\/general\/formulas-y-funciones-de-la-hoja-de-calculo-4\/","title":{"rendered":"F\u00f3rmulas y Funciones de la Hoja de C\u00e1lculo"},"content":{"rendered":"<table width=\"0\">\n<tbody>\n<tr>\n<td style=\"background-color: #28ad56;width: 589px\" colspan=\"2\" width=\"589\"><span style=\"color: #ffffff\"><strong>En l\u00ednea\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 T\u00e9cnica<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>\u00a0<\/strong><\/td>\n<td width=\"410\"><strong>F\u00d3RMULAS Y FUNCIONES DE LA HOJA DE C\u00c1LCULO<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><\/td>\n<td width=\"410\"><strong>Objetivo: <\/strong>Conocer y dominar las f\u00f3rmulas y funciones m\u00e1s importantes de la hoja de c\u00e1lculo, mejorando los conocimientos sobre c\u00f3mo utilizar las funciones para conseguir c\u00e1lculos eficientes y eficaces.<\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>Dirigido a:<\/strong><\/td>\n<td width=\"410\">Estudiantes, Profesionales y P\u00fablico en General<\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>Temario:<\/strong><\/td>\n<td width=\"410\">\n<p>1.\u00a0\u00a0\u00a0 Uso de las f\u00f3rmulas.<\/p>\n<p>2.\u00a0\u00a0\u00a0 Prelaci\u00f3n de operadores.<\/p>\n<p>3.\u00a0\u00a0\u00a0 Funciones: Estad\u00edsticas de texto, fecha y hora, financieras, matem\u00e1ticas, de referencia, de b\u00fasqueda, de error y condicionales.<\/p>\n<p>4.\u00a0\u00a0\u00a0 Creaci\u00f3n y administraci\u00f3n de nombres.<\/p>\n<p>5.\u00a0\u00a0\u00a0 Manejo de esquemas y subtotales.<\/p>\n<p>6.\u00a0\u00a0\u00a0 Validaci\u00f3n de datos.<\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>Duraci\u00f3n:<\/strong><\/td>\n<td width=\"410\">20 horas<\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>Fecha:<\/strong><\/td>\n<td width=\"410\">5 al 16 de diciembre de 2022<\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>Horario:<\/strong><\/td>\n<td width=\"410\">17:00 a 19:00 horas (lunes a viernes).<\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Plataforma:<\/strong><\/td>\n<td width=\"410\">Microsoft Teams<\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>Coordinador:<\/strong><\/td>\n<td width=\"410\">Mtra. Deysi Carmina Pe\u00f1a Ortiz<\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>Correo electr\u00f3nico:<\/strong><\/td>\n<td width=\"410\"><a href=\"mailto:dpena@uv.mx\">dpena@uv.mx<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>Instructor(es):<\/strong><\/td>\n<td width=\"410\">Mtro. El\u00edas Guillermo Linderman Ger\u00f3nimo<\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>Cuota de recuperaci\u00f3n:<\/strong><\/td>\n<td width=\"410\">\n<p>$338.00 estudiantes UV y externos<\/p>\n<p>$588.00 profesores UV (personal UV) y externos<\/p>\n<p>$838.00 profesionales y p\u00fablico en general<\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>Cupo m\u00ednimo:<\/strong><\/td>\n<td width=\"410\">10 asistentes<\/td>\n<\/tr>\n<tr>\n<td width=\"179\"><strong>Sede:<\/strong><\/td>\n<td width=\"410\">\n<p>Centro de Investigaci\u00f3n en Recursos Energ\u00e9ticos y Sustentables<\/p>\n<p>Av. Universidad km. 7.5, col. Santa Isabel, Coatzacoalcos,<\/p>\n<p>CP 96538<\/p>\n<p>Coatzacoalcos, Ver.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>En l\u00ednea\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 [&hellip;]<\/p>\n","protected":false},"author":2073,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ventana_nueva":"","tipo_url":"","url":"","extracto":"","imagen_halign":"","imagen_valign":"","bg_size":"","text_hide":"","media_url":"","tipo_media":"","video_url":"","video_pos":"","video_youtube":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-14686","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/www.uv.mx\/edu-cont\/wp-json\/wp\/v2\/posts\/14686","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.uv.mx\/edu-cont\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.uv.mx\/edu-cont\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.uv.mx\/edu-cont\/wp-json\/wp\/v2\/users\/2073"}],"replies":[{"embeddable":true,"href":"https:\/\/www.uv.mx\/edu-cont\/wp-json\/wp\/v2\/comments?post=14686"}],"version-history":[{"count":1,"href":"https:\/\/www.uv.mx\/edu-cont\/wp-json\/wp\/v2\/posts\/14686\/revisions"}],"predecessor-version":[{"id":14689,"href":"https:\/\/www.uv.mx\/edu-cont\/wp-json\/wp\/v2\/posts\/14686\/revisions\/14689"}],"wp:attachment":[{"href":"https:\/\/www.uv.mx\/edu-cont\/wp-json\/wp\/v2\/media?parent=14686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.uv.mx\/edu-cont\/wp-json\/wp\/v2\/categories?post=14686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.uv.mx\/edu-cont\/wp-json\/wp\/v2\/tags?post=14686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}