Elep

Envelope-to: brodriguez@ifprc.com.pe
Delivery-date: Thu, 09 Feb 2023 07:55:30 -0300
Message-ID: <0c0a266c985c531e3d846dc6322d272da6a17d6c@unitedbmecgroup.com>
Reply-To: =?utf-8?B?w5psdGltYXMgNiBWYWNhbnRlcw==?= <excel@unitedbmecgroup.com>
From: =?utf-8?B?w5psdGltYXMgNiBWYWNhbnRlcw==?= <excel@unitedbmecgroup.com>
To: brodriguez@ifprc.com.pe
Subject: Excel Financiero
Date: Thu, 9 Feb 2023 05:54:38 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="89236ae45692ab0023891b9065093ed636"

--89236ae45692ab0023891b9065093ed636
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

EXCEL FINANCIERO
01, 03, 06, 07 y 08 DE MARZO
HORARIO DE 6:30 PM A 10:30 PM

Unidad 1: Introducci=C3=B3n a Excel

=E2=80=A2 =C2=BFQu=C3=A9 aspectos deben incorporarse en el Reglamento?
=E2=80=A2 =C2=BFQu=C3=A9 aspectos no deben se=C3=B1alarse?
=E2=80=A2 Jornada y horario de trabajo. Tiempo de tolerancia
=E2=80=A2 Normas de control de asistencia al trabajo
=E2=80=A2 Interfaz Excel
=E2=80=A2 Formatos y sus propiedades
=E2=80=A2 Trabajo con nombres
=E2=80=A2 Dise=C3=B1o de p=C3=A1gina
=E2=80=A2 Casos pr=C3=A1cticos

Unidad 2: Gesti=C3=B3n de datos

=E2=80=A2 Ordenar datos y Subtotales
=E2=80=A2 Autofiltros y Filtros Avanzados
=E2=80=A2 Validaci=C3=B3n de datos

Unidad 3: F=C3=B3rmulas y funciones esenciales

=E2=80=A2 Sumar, Sumar. si y Buscar V
=E2=80=A2 Promedio, Contar y S=C3=AD. Error

Unidad 4: Herramientas de Escenarios

=E2=80=A2 Herramientas de Escenarios =E2=80=93 Buscar Objetivo
=E2=80=A2 Herramientas de Escenarios - Solver

Unidad 5: Funciones financieras

=E2=80=A2 Construcci=C3=B3n de tabla de amortizaci=C3=B3n
=E2=80=A2 Valoraci=C3=B3n de proyectos (VPN - TIR)

Unidad 6: Herramientas Business Intelligence en Excel

=E2=80=A2 Tablas din=C3=A1micas en Excel y Gr=C3=A1ficos din=C3=A1micos
=E2=80=A2 Dise=C3=B1o de Dashboard y Segmentaci=C3=B3n de datos
Unidad 7: Informes financieros

=E2=80=A2 Informe de gesti=C3=B3n empresarial
=E2=80=A2 Presupuesto empresarial con mini gr=C3=A1ficos

Unidad 8: Macros y su c=C3=B3digo

=E2=80=A2 Grabaci=C3=B3n de macro y Examinado del c=C3=B3digo de la macro
Unidad 9: Novedades en Excel 2019

=E2=80=A2 Si Conjunto
=E2=80=A2 Max Si Conjunto
=E2=80=A2 Cambiar
=E2=80=A2 Concat
=E2=80=A2 Unircadenas

Unidad 10:

=E2=80=A2 Las 10 funciones de Excel que Todos deber=C3=ADan aprender!

=F0=9F=91=89 Consulta por Whatsapp Click Aqu=C3=AD

--89236ae45692ab0023891b9065093ed636
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dutf-8">
</head>
<body>
<table style=3D"MARGIN: 0px auto" align=3Dcenter>
<tbody>
<tr>
<td style=3D"WIDTH: 8px" width=3D8></td>
<td width=3D622>
<div class=3Dmdv2rw style=3D"BORDER-TOP: #2db200 6px solid; BORDER-RIGHT:=
 #2db200 6px solid; BORDER-BOTTOM: #2db200 6px solid; PADDING-BOTTOM: 30p=
x; PADDING-TOP: 30px; PADDING-LEFT: 35px; BORDER-LEFT: #2db200 6px solid;=
 PADDING-RIGHT: 35px; border-radius: 12px">
<div align=3Dleft>
<p class=3DMsoNormal style=3D'FONT-SIZE: medium; FONT-FAMILY: "Times New =
Roman", serif; WHITE-SPACE: normal; WORD-SPACING: 0px; TEXT-TRANSFORM: no=
ne; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; TEXT-ALIGN: =
center; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACING: normal; TEXT-=
INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -=
webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decor=
ation-color: initial; text-decoration-thickness: initial' align=3Dcenter>=
EXCEL FINANCIERO 01, 03, 06,=
 07 y 08 DE MARZO HORARIO DE 6:30 PM A 10:30 PM=

<p class=3DMsoNormal style=3D'FONT-SIZE: medium; FONT-FAMILY: "Times New =
Roman", serif; WHITE-SPACE: normal; WORD-SPACING: 0px; TEXT-TRANSFORM: no=
ne; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; TEXT-ALIGN: =
center; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACING: normal; TEXT-=
INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -=
webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decor=
ation-color: initial; text-decoration-thickness: initial' align=3Dcenter>=
&nbsp;
<p class=3DMsoNormal style=3D'FONT-SIZE: medium; FONT-FAMILY: "Times New =
Roman", serif; WHITE-SPACE: normal; WORD-SPACING: 0px; TEXT-TRANSFORM: no=
ne; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; TEXT-ALIGN: =
justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACING: normal; TEXT=
-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; =
-webkit-text-stroke-width: 0px; text-decoration-style: initial; text-deco=
ration-color: initial; text-decoration-thickness: initial'>Unidad 1: Introducci=C3=B3n a Excel <=
/p>
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">=E2=80=A2 =C2=BFQu=C3=A9 aspectos deben incorporarse =
en el Reglamento? =E2=80=A2 =C2=BFQu=C3=A9 aspectos no deben se=C3=B1a=
larse? =E2=80=A2 Jornada y horario de trabajo. Tiempo de tolerancia<br=
>=E2=80=A2 Normas de control de asistencia al trabajo =E2=80=A2 Interf=
az Excel =E2=80=A2 Formatos y sus propiedades =E2=80=A2 Trabajo c=
on nombres =E2=80=A2 Dise=C3=B1o de p=C3=A1gina =E2=80=A2 Casos pr=
=C3=A1cticos 
<p class=3DMsoNormal style=3D'FONT-SIZE: medium; FONT-FAMILY: "Times New =
Roman", serif; WHITE-SPACE: normal; WORD-SPACING: 0px; TEXT-TRANSFORM: no=
ne; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; TEXT-ALIGN: =
justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACING: normal; TEXT=
-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; =
-webkit-text-stroke-width: 0px; text-decoration-style: initial; text-deco=
ration-color: initial; text-decoration-thickness: initial'>Unidad 2: Gesti=C3=B3n de datos </=
font>
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">=E2=80=A2 Ordenar datos y=
 Subtotales =E2=80=A2 Autofiltros y Filtros Avanzados =E2=80=A2 Va=
lidaci=C3=B3n de datos
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial"> Unidad 3: F=C3=B3rmulas y funcione=
s esenciales 
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">=E2=80=A2 Sumar, Sumar. s=
i y Buscar V =E2=80=A2 Promedio, Contar y S=C3=AD. Error </fo=
nt>
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">Un=
idad 4: Herramientas de Escenarios 
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">=E2=80=A2 Herramientas de=
 Escenarios =E2=80=93 Buscar Objetivo =E2=80=A2 Herramientas de Escen=
arios - Solver 
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">Un=
idad 5: Funciones financieras 
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">=E2=80=A2 Construcci=C3=B3=
n de tabla de amortizaci=C3=B3n =E2=80=A2 Valoraci=C3=B3n de proyecto=
s (VPN - TIR) 
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial"> Unidad 6: Herramientas Business Intelligence en Excel <=
/b>
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">=E2=80=A2 Tablas din=C3=A1=
micas en Excel y Gr=C3=A1ficos din=C3=A1micos =E2=80=A2 Dise=C3=B1o d=
e Dashboard y Segmentaci=C3=B3n de datos Unidad 7: Informes financieros </font=
>
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">=E2=80=A2 Informe de gest=
i=C3=B3n empresarial =E2=80=A2 Presupuesto empresarial con mini gr=C3=
=A1ficos 
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">&nbsp;
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">Un=
idad 8: Macros y su c=C3=B3digo 
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">=E2=80=A2 Grabaci=C3=B3n =
de macro y Examinado del c=C3=B3digo de la macro Unidad 9: Novedades en Excel 2019 
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">=E2=80=A2 Si Conjunto <br=
>=E2=80=A2 Max Si Conjunto =E2=80=A2 Cambiar =E2=80=A2 Concat <br=
>=E2=80=A2 Unircadenas 
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">Un=
idad 10: 
<p class=3DMsoNormal style=3D"WHITE-SPACE: normal; WORD-SPACING: 0px; TEX=
T-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: norma=
l; TEXT-ALIGN: justify; ORPHANS: 2; WIDOWS: 2; MARGIN: 0cm; LETTER-SPACIN=
G: normal; LINE-HEIGHT: 24px; TEXT-INDENT: 0px; font-variant-ligatures: n=
ormal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-de=
coration-style: initial; text-decoration-color: initial; text-decoration-=
thickness: initial">=E2=80=A2 Las 10 funcione=
s de Excel que Todos deber=C3=ADan aprender! </div>
<div style=3D"FONT-STYLE: oblique; TEXT-ALIGN: center; PADDING-TOP: 8px">=
<a style=3D"FONT-SIZE: 19px; TEXT-DECORATION: none; FONT-FAMILY: Arial; M=
IN-WIDTH: 60px; COLOR: #000; PADDING-BOTTOM: 12px; PADDING-TOP: 12px; PAD=
DING-LEFT: 15px; DISPLAY: inline-block; LINE-HEIGHT: 12px; PADDING-RIGHT:=
 15px; BACKGROUND-COLOR: #ffff00; border-radius: 12px" href=3D"https://ap=
i.whatsapp.com/send?phone=3D51936631677&text=3DDeseo%20informaci%C3%B3n%2=
0del%20Curso%3A%20Excel%20Financiero%20CM." target=3D_blank>=F0=9F=
=91=89 Consulta por Whatsapp Click Aqu=C3=AD </a> </div></div=
></td>
<td style=3D"WIDTH: 8px" width=3D8></td></tr></tbody></table>
&nbsp;</body></html>

--89236ae45692ab0023891b9065093ed636--