{"id":9856,"date":"2025-01-07T17:35:37","date_gmt":"2025-01-07T20:35:37","guid":{"rendered":"https:\/\/www.red-handed.com.ar\/?page_id=9856"},"modified":"2026-04-22T07:47:55","modified_gmt":"2026-04-22T10:47:55","slug":"excel-curso-practico-en-video-2","status":"publish","type":"page","link":"https:\/\/www.red-handed.com.ar\/index.php\/excel-curso-practico-en-video-2\/","title":{"rendered":"EXCEL \u2013 CURSO PR\u00c1CTICO EN VIDEO"},"content":{"rendered":"\n

POR LEONEL IV\u00c1N SAAFIGUEROA<\/p>\n\n\n\n

\n\n\n\n
\n
\n
\n

CLASE 01<\/strong>
Introducci\u00f3n:<\/strong> Presentaci\u00f3n de la planilla (columnas<\/strong>, filas<\/strong>, celdas<\/strong>, puntero<\/strong> e ingreso de datos<\/strong>, f\u00f3rmulas<\/strong> y tips<\/strong>).
Creaci\u00f3n de nuestra primera Planilla (Gastos del mes).
Utilizamos la funci\u00f3n: SUMA() + Rangos<\/strong>. <\/p>\n\n\n\n

C\u00f3mo insertar y suprimir Columnas y Filas.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n
\n\n\n\n
\n
\n
\n

CLASE 02<\/strong><\/p>\n\n\n\n

Creaci\u00f3n de una Lista de Alumnos<\/strong>.
C\u00f3mo usar el auto relleno<\/strong>.
Ordenar Alfab\u00e9ticamente<\/strong>.
Insertar registros<\/strong>.
C\u00f3mo mejorar aspecto <\/strong>de la planilla (alinear textos<\/strong> en columnas<\/strong>, tipo de Fuente<\/strong>, Color<\/strong>, Tama\u00f1o<\/strong>, Bordes<\/strong>).
Creaci\u00f3n y duplicaci\u00f3n de Hojas<\/strong>.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n
\n\n\n\n
\n
\n
\n

CLASE 03<\/strong><\/p>\n\n\n\n

Creaci\u00f3n de una encuesta<\/strong>.
Utilizamos la funci\u00f3n: CONTAR.SI()<\/strong> para poder contar los totales en distintos rangos<\/strong>.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n
\n\n\n\n
\n
\n
\n

CLASE 04<\/strong><\/p>\n\n\n\n

C\u00f3mo calcular promedios<\/strong>. Creaci\u00f3n de un Bolet\u00edn de notas digital.
Utilizamos la funci\u00f3n: PROMEDIO()<\/strong>.
Formato de celdas y posiciones decimales<\/strong>.
C\u00f3mo combinar y centrar celdas<\/strong>.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n
\n\n\n\n
\n
\n
\n

CLASE 05<\/strong><\/p>\n\n\n\n

\u00bfAprobado o desaprobado? Tomando decisiones.<\/strong>
Funci\u00f3n condicional: SI()<\/strong> (Prueba L\u00f3gica)
Repaso funci\u00f3n: CONTAR.SI()<\/strong>.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n
\n\n\n\n
\n
\n
\n

CLASE 06<\/strong><\/p>\n\n\n\n

Generaci\u00f3n de Gr\u00e1ficos.<\/strong>
Repaso de auto relleno<\/strong> con los meses del a\u00f1o y d\u00edas de la semana.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n
\n\n\n\n
\n
\n
\n

CLASE 07<\/strong><\/p>\n\n\n\n

C\u00f3mo unir el contenido de dos celdas en una.<\/strong>
Funci\u00f3n: CONCATENAR().<\/strong>
TIP:<\/strong> Copiar (y pegar como valores).<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n
\n\n\n\n
\n
\n
\n

CLASE 08<\/strong><\/p>\n\n\n\n

C\u00f3mo dividir el contenido de una celda en dos celdas.<\/strong>
Funci\u00f3nes: IZQUIERDA()<\/strong>, DERECHA()<\/strong>, HALLAR()<\/strong> y LARGO()<\/strong>.
Repaso TIP:<\/strong> Copiar (y pegar como valores).<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n
\n\n\n\n
\n
\n
\n

CLASE 09<\/strong><\/p>\n\n\n\n

Fechas din\u00e1micas y autom\u00e1ticas.<\/strong>
Funciones: HOY()<\/strong>, AHORA()<\/strong>, DIA()<\/strong>,MES()<\/strong>, A\u00d1O()<\/strong> y FECHA()<\/strong>.<\/p>\n\n\n\n

Calcular d\u00edas laborales.<\/strong><\/p>\n\n\n\n

Funci\u00f3n: DIAS.LAB()<\/strong><\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n
\n\n\n\n
\n
\n
\n

CLASE 10<\/strong><\/p>\n\n\n\n

C\u00f3mo utilizar FILTROS<\/strong>.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n
\n\n\n\n

\ud83e\udc83 Pulse para volver a la biblioteca de contenidos.<\/strong> \ud83e\udc83<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\n","protected":false},"excerpt":{"rendered":"

POR LEONEL IV\u00c1N SAAFIGUEROA \ud83e\udc83 Pulse para volver a la biblioteca de contenidos. \ud83e\udc83<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-9856","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.red-handed.com.ar\/index.php\/wp-json\/wp\/v2\/pages\/9856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-handed.com.ar\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.red-handed.com.ar\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-handed.com.ar\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-handed.com.ar\/index.php\/wp-json\/wp\/v2\/comments?post=9856"}],"version-history":[{"count":19,"href":"https:\/\/www.red-handed.com.ar\/index.php\/wp-json\/wp\/v2\/pages\/9856\/revisions"}],"predecessor-version":[{"id":11169,"href":"https:\/\/www.red-handed.com.ar\/index.php\/wp-json\/wp\/v2\/pages\/9856\/revisions\/11169"}],"wp:attachment":[{"href":"https:\/\/www.red-handed.com.ar\/index.php\/wp-json\/wp\/v2\/media?parent=9856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}