Elep

Envelope-to: rvasquez@ifprc.com.pe
Delivery-date: Thu, 22 Oct 2020 02:27:47 -0300
Message-ID: <CD2C6D3EBE7B4C919AE9821CAC10E69C@hawk408>
Reply-To: "Talleres por Zoom 2x1" <cursos2020@acqla.com>
From: "Talleres por Zoom 2x1" <noreply@javaspictures.com>
To: =?iso-8859-1?B?TWFpbGluZyBQZXL6?= <clientes@javaspictures.com>
Subject: =?iso-8859-1?B?RXhjZWwgRmluYW5jaWVybyAvIEV4Y2VsIEF2YW56YWRv?=
Date: Thu, 22 Oct 2020 00:26:32 -0500
Organization: acq2
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_1223_01D6A809.FDE0ABA0"

This is a multi-part message in MIME format.

------=_NextPart_000_1223_01D6A809.FDE0ABA0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

ENTRENAMIENTO VIA ZOOM =20
EXCEL PARA FINANZAS=20

03, 04, 05 Y 06 DE NOVIEMBRE=20
Horario de 06:30 pm a 10:30pmENTRENAMIENTO VIA ZOOM

EXCEL AVANZADO PARA EMPRESAS Y PARTICULARES

29 Y 30 DE OCTUBRE DE 6:30PM A 9:30PM=20
Y 31 DE OCTUBRE DE 9:00AM A 12:00PM=20
 =20
QUE APRENDERAS :
Unidad 1: Introducci=F3n a Excel
1) Interfaz Excel
2) Formatos y sus propiedades
3) Trabajo con nombres
4) Dise=F1o de p=E1gina e Imprimir

Unidad 2: Gesti=F3n de datos
5) Ordenar datos y Subtotales
6) Autofiltros y Filtros Avanzados
7) Validaci=F3n de datos

Unidad 3: F=F3rmulas y funciones esenciales
8) Sumar, Sumar.si y BuscarV
9) Promedio, Contar y Si.Error

Unidad 4: Herramientas de Escenarios
10) Herramientas de Escenarios - Buscar
Objetivo
11) Herramientas de Escenarios _ Solver

Unidad 5: Funciones financieras
12) Construcci=F3n de tabla de amortizaci=F3n
13) Valoraci=F3n de proyectos (VPN - TIR)

Unidad 6: Herramientas Business Intelligence
en Excel
14) Tablas din=E1micas en Excel y Gr=E1ficos
din=E1micos
15) Dise=F1o de Dashboard y Segmentaci=F3n de
Datos

Unidad 7: Informes financieros
16) Informe de gesti=F3n empresarial
17) Presupuesto empresarial con minigr=E1ficos

Unidad 8: Macros y su c=F3digo
18) Grabaci=F3n de macro y Examinado del c=F3digo
de la macro

Unidad 9: Novedades en Excel 2019
19) Si Conjunto
20) Max Si Conjunto
21) Cambiar
22) Concat
23) Unircadenas

Unidad 10:=20
24) Las diez funciones de Excel que todos
deber=EDan aprender
QUE APRENDERAS :
Sesi=F3n 01
Funciones L=F3gicas y de B=FAsqueda
Funci=F3n SI.=20
Usar funciones Anidadas.=20
Funci=F3n SUMAR.SI, PROMEDIO.SI, CONTAR.SI=20
Funci=F3n Y, O=20
Uso Avanzado de la Funci=F3n BUSCARV.=20
Usar la Funci=F3n BUSCARV para la B=FAsqueda de Rangos.=20
B=FAsqueda de M=FAltiplos Registros con BUSCARV.=20
Usar la Funci=F3n BUSCARV para evitar el uso de la Funci=F3n SI anidados.=
=20

Sesi=F3n 02
Funciones de Fecha.
Funci=F3n Hoy, Ahora, Dia, Mes A=F1o.=20
C=E1lculo de D=EDas a trav=E9s de fechas.=20
Calculo a=F1os a trav=E9s de Fechas.=20
=B7         Formatos para Fechas
Validaci=F3n de Datos
=B7         Creaci=F3n de listas desplegables
=B7         Validaci=F3n de Datos
Sesi=F3n 03
Introducci=F3n a Macros
=B7         Concepto y aplicaciones de Macros. Introducci=F3n al VBA
=B7         Formas de crear una Macro.
=B7         Uso de la Grabadora de Macros
=B7         Creaci=F3n y ejecuci=F3n de Macros sencillas.
APLICAR MACROS A BOTOSNES
=B7         Uso del Editor de VBA.
=B7         Anexar macros a Botones.
=B7         Correcciones del C=F3digo de VBA.
APLICACI=D3N DE CONTROLES DE FORMULARIO SOBRE LA HOJA DE CALCULO
=B7         Uso de controles de formulario.
=B7         Aplicar Propiedades y C=F3digo para Controles
----------------------------------------------------------------------
C O N S U L T A S :=20
Celular: + 51 936 615 264 / + 51 936623496=20
MARQUE ESTE ENLACE PARA RECIBIR MAYOR INFORMACI=D3N=20
--------------------------------------------------------------------- ---=
-----------------------------------------------------------------------=20
C O N S U L T A S :
Celular: + 51 936 615 264 / + 51 936 623 496=20
MARQUE ESTE ENLACE PARA RECIBIR MAYOR INFORMACION=20
------------------------------------------------------------------------
  =20

Para retirarlo responder NO ENVIAR=20

------=_NextPart_000_1223_01D6A809.FDE0ABA0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>T A L L E R=A0=A0 -=A0 O N L I N E</TITLE>
<META content=3Des-pe http-equiv=3DContent-Language>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Ty=
pe>
<STYLE>P {
	FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; MARGIN-LEFT: 0c=
m; MARGIN-RIGHT: 0cm
}
P.MsoNormal {
	FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; MARGIN: 0cm 0cm=
 0pt; mso-style-parent: ""
}
TABLE.MsoNormalTable {
	FONT-SIZE: 11pt; FONT-FAMILY: "Calibri","sans-serif"; LINE-HEIGHT: 107%;=
 mso-style-parent: ""
}
P.xmsonormal {
	FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; MARGIN-LEFT: 0c=
m; MARGIN-RIGHT: 0cm
}
P.MsoListParagraph {
	FONT-SIZE: 11pt; FONT-FAMILY: "Calibri","sans-serif"; MARGIN: 0cm 0cm 10=
pt 36pt; LINE-HEIGHT: 115%
}
P.MsoListParagraphCxSpFirst {
	FONT-SIZE: 11pt; FONT-FAMILY: "Calibri","sans-serif"; MARGIN: 0cm 0cm 0p=
t 36pt; LINE-HEIGHT: 115%
}
P.MsoListParagraphCxSpLast {
	FONT-SIZE: 11pt; FONT-FAMILY: "Calibri","sans-serif"; MARGIN: 0cm 0cm 10=
pt 36pt; LINE-HEIGHT: 115%
}
P.MsoListParagraphCxSpMiddle {
	FONT-SIZE: 11pt; FONT-FAMILY: "Calibri","sans-serif"; MARGIN: 0cm 0cm 0p=
t 36pt; LINE-HEIGHT: 115%
}
</STYLE>

<META name=3DGENERATOR content=3D"-[OUTLOOK_VER]-">
<BODY>
<A name=3D_MailOriginal><SPAN=20
style=3D"FONT-FAMILY: Calibri,sans-serif; COLOR: black"></A>&nbsp;=

<DIV align=3Dcenter>
<TABLE class=3DMsoNormalTable style=3D"WIDTH: 615pt; BORDER-COLLAPSE: col=
lapse"=20
cellSpacing=3D0 cellPadding=3D0 width=3D820 border=3D0>
 <TBODY>
 <TR>
 <TD=20
 style=3D"WIDTH: 300pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt; P=
ADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt"=20
 vAlign=3Dtop width=3D400>
 <S=
PAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">ENTRENAMIENTO VIA=20
 ZOOM<SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">&nbsp;=20
 
 <B=
><SPAN=20
 style=3D"FONT-SIZE: 18pt; FONT-FAMILY: Arial,sans-serif; COLOR: #00=
00a0">EXCEL=20
 PARA FINANZAS 
 <B=
><SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif; COLOR: black">&n=
bsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif; COLOR: black">03, 04, 05 Y =
06 DE=20
 NOVIEMBRE Horario de 06:30 pm a 10:30pm</TD>
 <TD=20
 style=3D"WIDTH: 15pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt; PA=
DDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt"=20
 width=3D20 colSpan=3D2>
 &nbsp;=
</TD>
 <TD=20
 style=3D"WIDTH: 300pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt; P=
ADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt"=20
 vAlign=3Dtop width=3D400>
 <F=
ONT=20
 size=3D2>ENTRENAMI=
ENTO VIA=20
 ZOOM
 &n=
bsp;
 <B=
><SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif; COLOR: #0000a0">EXCEL=20
 AVANZADO PARA EMPRESAS Y PARTICULARES
 <B=
><SPAN=20
 style=3D"FONT-SIZE: 16pt; FONT-FAMILY: Arial,sans-serif; COLOR: #00=
00a0">&nbsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif; COLOR: black">29 Y 30 DE OC=
TUBRE DE=20
 6:30PM A 9:30PM 
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif; COLOR: black">Y 31 DE OCTUB=
RE DE=20
 9:00AM A 12:00PM </TD></TR>
 <TR>
 <TD=20
 style=3D"WIDTH: 300pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt; P=
ADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt"=20
 width=3D400>
 <SPAN=20
 style=3D"COLOR: black">&nbsp;</TD>
 <TD=20
 style=3D"WIDTH: 15pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt; PA=
DDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt"=20
 width=3D20 colSpan=3D2>
 &nbsp;=
</TD>
 <TD=20
 style=3D"WIDTH: 300pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt; P=
ADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt"=20
 width=3D400>
 <SPAN=20
 style=3D"COLOR: black">&nbsp;</TD></TR>
 <TR>
 <TD=20
 style=3D"WIDTH: 307.5pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt;=
 PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt"=20
 width=3D410 colSpan=3D2>
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">QUE APRENDERAS :=

 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Unidad 1: Introducci=F3n a=20
 Excel
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">1)=20
 Interfaz Excel
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">2)=20
 Formatos y sus propiedades
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">3)=20
 Trabajo con nombres
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">4)=20
 Dise=F1o de p=E1gina e Imprimir
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">&nbsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Unidad 2: Gesti=F3n de=20
 datos
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">5)=20
 Ordenar datos y Subtotales
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">6)=20
 Autofiltros y Filtros Avanzados
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">7)=20
 Validaci=F3n de datos
 <SPAN=20
 style=3D"FONT-SIZE: 14pt; FONT-FAMILY: T3Font_1,sans-serif; COLOR: =
#363636">&nbsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Unidad 3: F=F3rmulas y func=
iones=20
 esenciales
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">8)=20
 Sumar, Sumar.si y BuscarV
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">9)=20
 Promedio, Contar y Si.Error
 <SPAN=20
 style=3D"FONT-SIZE: 14pt; FONT-FAMILY: T3Font_1,sans-serif; COLOR: =
#363636">&nbsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Unidad 4: Herramientas de=20
 Escenarios
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">10)=20
 Herramientas de Escenarios - Buscar
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">Objetivo
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">11)=20
 Herramientas de Escenarios _ Solver
 <SPAN=20
 style=3D"FONT-SIZE: 14pt; FONT-FAMILY: T3Font_1,sans-serif; COLOR: =
#363636">&nbsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Unidad 5: Funciones=20
 financieras
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">12)=20
 Construcci=F3n de tabla de amortizaci=F3n
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">13)=20
 Valoraci=F3n de proyectos (VPN - TIR)
 <SPAN=20
 style=3D"FONT-SIZE: 14pt; FONT-FAMILY: T3Font_1,sans-serif; COLOR: =
#363636">&nbsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Unidad 6: Herramientas Busi=
ness=20
 Intelligence
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">en Excel
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">14)=20
 Tablas din=E1micas en Excel y Gr=E1ficos
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">din=E1micos
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">15)=20
 Dise=F1o de Dashboard y Segmentaci=F3n de
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">Datos
 <SPAN=20
 style=3D"FONT-SIZE: 14pt; FONT-FAMILY: T3Font_1,sans-serif; COLOR: =
#363636">&nbsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Unidad 7: Informes=20
 financieros
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">16)=20
 Informe de gesti=F3n empresarial
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">17)=20
 Presupuesto empresarial con minigr=E1ficos
 <SPAN=20
 style=3D"FONT-SIZE: 14pt; FONT-FAMILY: T3Font_1,sans-serif; COLOR: =
#363636">&nbsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Unidad 8: Macros y su=20
 c=F3digo
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">18)=20
 Grabaci=F3n de macro y Examinado del c=F3digo
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">de la=20
 macro
 <SPAN=20
 style=3D"FONT-SIZE: 14pt; FONT-FAMILY: T3Font_1,sans-serif; COLOR: =
#363636">&nbsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Unidad 9: Novedades en Exce=
l=20
 2019
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">19)=20
 Si Conjunto
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">20)=20
 Max Si Conjunto
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">21)=20
 Cambiar
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">22)=20
 Concat
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">23)=20
 Unircadenas
 <SPAN=20
 style=3D"FONT-SIZE: 14pt; FONT-FAMILY: T3Font_1,sans-serif; COLOR: =
#363636">&nbsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Unidad 10: 
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">24)=20
 Las diez funciones de Excel que todos
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck">deber=EDan=20
 aprender</TD>
 <TD=20
 style=3D"WIDTH: 307.5pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt;=
 PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt"=20
 width=3D410 colSpan=3D2>
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif"> QUE APRENDERAS :=

 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Sesi=F3n 01
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Funciones L=F3gicas y de=20
 B=FAsqueda
 <UL style=3D"MARGIN-BOTTOM: 0cm; MARGIN-TOP: 0cm" type=3Dsquare>
 <LI class=3DMsoNormalCxSpMiddle=20
 style=3D"MARGIN-BOTTOM: 8pt; COLOR: black; LINE-HEIGHT: 107%"><SP=
AN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; LINE-HEI=
GHT: 107%">Funci=F3n=20
 SI.=20
 <LI class=3DMsoNormalCxSpMiddle=20
 style=3D"MARGIN-BOTTOM: 8pt; COLOR: black; LINE-HEIGHT: 107%"><SP=
AN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; LINE-HEI=
GHT: 107%">Usar=20
 funciones Anidadas.=20
 <LI class=3DMsoNormalCxSpMiddle=20
 style=3D"MARGIN-BOTTOM: 8pt; COLOR: black; LINE-HEIGHT: 107%"><SP=
AN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; LINE-HEI=
GHT: 107%">Funci=F3n=20
 SUMAR.SI, PROMEDIO.SI, CONTAR.SI=20
 <LI class=3DMsoNormalCxSpMiddle=20
 style=3D"MARGIN-BOTTOM: 8pt; COLOR: black; LINE-HEIGHT: 107%"><SP=
AN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; LINE-HEI=
GHT: 107%">Funci=F3n=20
 Y, O=20
 <LI class=3DMsoNormalCxSpMiddle=20
 style=3D"MARGIN-BOTTOM: 8pt; COLOR: black; LINE-HEIGHT: 107%"><SP=
AN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; LINE-HEI=
GHT: 107%">Uso=20
 Avanzado de la Funci=F3n BUSCARV.=20
 <LI class=3DMsoNormalCxSpMiddle=20
 style=3D"MARGIN-BOTTOM: 8pt; COLOR: black; LINE-HEIGHT: 107%"><SP=
AN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; LINE-HEI=
GHT: 107%">Usar=20
 la Funci=F3n BUSCARV para la B=FAsqueda de Rangos.=20
 <LI class=3DMsoNormalCxSpMiddle=20
 style=3D"MARGIN-BOTTOM: 8pt; COLOR: black; LINE-HEIGHT: 107%"><SP=
AN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; LINE-HEI=
GHT: 107%">B=FAsqueda=20
 de M=FAltiplos Registros con BUSCARV.=20
 <LI class=3DMsoNormalCxSpMiddle=20
 style=3D"MARGIN-BOTTOM: 8pt; COLOR: black; LINE-HEIGHT: 107%"><SP=
AN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; LINE-HEI=
GHT: 107%">Usar=20
 la Funci=F3n BUSCARV para evitar el uso de la Funci=F3n=
 SI=20
 anidados. </LI></UL>
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">&nbsp;
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Sesi=F3n 02
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Funciones de Fecha.<=
/B>
 <UL style=3D"MARGIN-BOTTOM: 0cm; MARGIN-TOP: 0cm" type=3Dsquare>
 <LI class=3DMsoNormalCxSpMiddle=20
 style=3D"MARGIN-BOTTOM: 8pt; COLOR: black"><SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif">Funci=F3=
n Hoy,=20
 Ahora, Dia, Mes A=F1o.=20
 <LI class=3DMsoNormalCxSpMiddle=20
 style=3D"MARGIN-BOTTOM: 8pt; COLOR: black"><SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif">C=E1lcul=
o de D=EDas a=20
 trav=E9s de fechas.=20
 <LI class=3DMsoNormalCxSpLast=20
 style=3D"MARGIN-BOTTOM: 8pt; COLOR: black"><SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif">Calculo =
a=F1os a=20
 trav=E9s de Fechas. </LI></UL>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Formatos=20
 para Fechas
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Validaci=F3n de Datos</SPAN=
>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Creaci=F3n=20
 de listas desplegables
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Validaci=F3n=20
 de Datos
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Sesi=F3n 03
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">Introducci=F3n a Macros</SP=
AN>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Concepto=20
 y aplicaciones de Macros. Introducci=F3n al VBA
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Formas=20
 de crear una Macro.
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Uso=20
 de la Grabadora de Macros
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Creaci=F3n=20
 y ejecuci=F3n de Macros sencillas.
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">APLICAR MACROS A=20
 BOTOSNES
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Uso=20
 del Editor de VBA.
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Anexar=20
 macros a Botones.
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Correcciones=20
 del C=F3digo de VBA.
 <SPAN=20
 style=3D"FONT-FAMILY: Arial,sans-serif">APLICACI=D3N DE CONTROLES D=
E=20
 FORMULARIO SOBRE LA HOJA DE CALCULO
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Uso=20
 de controles de formulario.
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Symbol; COLOR: black; LINE-H=
EIGHT: 115%">=B7<SPAN=20
 style=3D"FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; FONT-VARIANT=
: normal; FONT-WEIGHT: normal; FONT-STYLE: normal">&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial,sans-serif; COLOR: bla=
ck; LINE-HEIGHT: 115%">Aplicar=20
 Propiedades y C=F3digo para Controles</TD></TR>
 <TR>
 <TD=20
 style=3D"WIDTH: 300pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt; P=
ADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt"=20
 vAlign=3Dtop width=3D400>
 <SPAN=20
 style=3D"COLOR: #0000a0">------------------------------------------=
---------------------------- C=20
 O N S U L T A S : Celular: + 51 936 615 264 / + 51 936623496=20
 <A=20
 style=3D"TEXT-DECORATION: underline; COLOR: blue; text-underline: s=
ingle"=20
 href=3D"https://api.whatsapp.com/send?phone=3D51936280230&text=3DRe=
quiero_informacion_del_taller_online_excel_para_finanzas_CA"><SPAN=20
 style=3D"FONT-FAMILY: Calibri,sans-serif; BACKGROUND: yellow; COLOR=
: red">MARQUE=20
 ESTE ENLACE PARA RECIBIR MAYOR INFORMACI=D3N </A><SPAN=20
 style=3D"COLOR: #0000a0"> --------------------------------------=
-------------------------------<SPAN=20
 style=3D"FONT-SIZE: 11pt; FONT-FAMILY: Arial,sans-serif; COLOR: #00=
00a0">=20
 </TD>
 <TD=20
 style=3D"WIDTH: 15pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt; PA=
DDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt"=20
 width=3D20 colSpan=3D2>
 &nbsp;=
</TD>
 <TD=20
 style=3D"WIDTH: 300pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt; P=
ADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt"=20
 vAlign=3Dtop width=3D400><SPAN=20
 style=3D"FONT-FAMILY: Calibri,sans-serif; COLOR: #0000a0">---------=
-----------------------------------------------------------------=20
 C O N S U L T A S : Celular: + 51 936 615 264 / + 51 936 623=
 496=20
 <A=20
 style=3D"TEXT-DECORATION: underline; COLOR: blue; text-underline: s=
ingle"=20
 href=3D"https://api.whatsapp.com/send?phone=3D51936280230&text=3DRe=
quiero_informacion_del_taller_excel_avanzado_CA"><SPAN=20
 style=3D"FONT-FAMILY: Calibri,sans-serif; BACKGROUND: yellow; COLOR=
: red">MARQUE=20
 ESTE ENLACE PARA RECIBIR MAYOR INFORMACION </A><SPAN=20
 style=3D"FONT-FAMILY: Calibri,sans-serif; COLOR: #0000a0"> -----=
-------------------------------------------------------------------</SPAN=
></TD></TR>
 <TR>
 <TD=20
 style=3D"BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-B=
OTTOM: medium none; BORDER-LEFT: medium none"=20
 width=3D389>&nbsp;</TD>
 <TD=20
 style=3D"BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-B=
OTTOM: medium none; BORDER-LEFT: medium none"=20
 width=3D4>&nbsp;</TD>
 <TD=20
 style=3D"BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-B=
OTTOM: medium none; BORDER-LEFT: medium none"=20
 width=3D2></TD>
 <TD=20
 style=3D"BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-B=
OTTOM: medium none; BORDER-LEFT: medium none"=20
 width=3D470>&nbsp;</TD></TR></TBODY></TABLE></DIV>
Para retirarlo responder NO ENVIAR </BODY></HTML=
>

------=_NextPart_000_1223_01D6A809.FDE0ABA0--