PM01-0405. Funciones en Excel

Macros

Excel te permite integrar funciones para automatizar tareas más complejas y realizar cálculos avanzados.

[{"selector":"#anim-a25a117e-3667-435f-bc1d-df7a833b73ce","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f07def95-b56d-497e-98eb-c0794b96af4a","keyframes":{"transform":["translate3d(0px, 503.94590%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

1. Ingresa al entorno de programación con la opción “Visual Basic” (VBA). 2. Selecciona la opción INSERTAR NUEVO MÓDULO en la opción de PROYECTO.

[{"selector":"#anim-036ff049-7be3-46fe-8846-54a783dea201","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9aabd629-d15d-4485-a6d2-3b315908d1e5","keyframes":{"transform":["translate3d(0px, 244.18118%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-49c97462-7a87-4423-aa81-cbacb5c5b2dd","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-38e808de-16d0-4fa9-b7a5-48fe67b1d492","keyframes":{"transform":["translate3d(-114.8265%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

3. Construye la función colocando: a) el inicio de sintaxis “function”, b) el nombre la función, c) las variables a utilizar, d) las operaciones que quieres realizar, y el cierre de la sintaxis.

[{"selector":"#anim-1c8484a9-02d4-4671-963a-29c8235b84de","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-25292049-008d-4e6b-81b9-f7deff684861","keyframes":{"transform":["translate3d(0px, 247.43264%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c7074094-2b3b-4927-b0c2-6801048a35e4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0912f88a-9df1-4a0f-9c6b-afdc24f8f8b2","keyframes":{"transform":["translate3d(0px, 231.15334%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a571a62b-9c05-472a-9752-c6552a1bc7ab","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-98325e5c-1e61-4a9b-a82a-01f93828f684","keyframes":{"transform":["translate3d(0px, 326.83450%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Observa un ejemplo práctico:

[{"selector":"#anim-61476c3d-e407-405a-88e9-89cd9ce08c38","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4e33e426-db1a-4832-b919-f7bbdc67a1e5","keyframes":{"transform":["translate3d(-114.51104%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c5865cfd-0561-455f-aba4-7d051c35d834","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-dcebfe50-85c9-4e2b-b20e-351bfbe22db4","keyframes":{"transform":["translate3d(-386.51686%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e61c6981-6b9a-476c-a9f6-9eeee693e22a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eb7a315b-db47-4f55-88d4-271d2ffae46a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5379534e-60aa-4d5c-b35d-0f4cc4dcb111","keyframes":{"transform":["translate3d(100.00000%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Aplica Burst with Arrow

[{"selector":"#anim-b9c300bb-85b6-46c2-9b34-8065d2d59363","keyframes":[{"offset":0,"transform":"translate3d(0, -166.2263%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -46.74283556%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -15.89123428%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -5.967524170000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.59313028%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1400,"fill":"both"}]

Macros

Excel te permite integrar funciones para automatizar tareas más complejas y realizar cálculos avanzados.

1. Ingresa al entorno de programación con la opción “Visual Basic” (VBA). 2. Selecciona la opción INSERTAR NUEVO MÓDULO en la opción de PROYECTO.

¿Cómo hacerlo?

3. Construye la función colocando: a) el inicio de sintaxis “function”, b) el nombre la función, c) las variables a utilizar, d) las operaciones que quieres realizar, y el cierre de la sintaxis.

SINTAXIS: Function etiqueta (nombre, variable 1, variable 2) Operaciones a realizar End Function

4. Cierra la ventana y prueba tu nueva función.

Observa un ejemplo práctico: