{"id":3067,"date":"2023-03-06T12:45:56","date_gmt":"2023-03-06T17:45:56","guid":{"rendered":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/?post_type=cursos&p=3067"},"modified":"2023-03-07T13:49:07","modified_gmt":"2023-03-07T18:49:07","slug":"excel-financiero","status":"publish","type":"cursos","link":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/","title":{"rendered":"Excel Financiero"},"content":{"rendered":"\n

Temario del curso de Excel Financiero:<\/h2>\n\n\n\n

<\/p>\n\n\n\n

1. Ecuaciones de valor del dinero en el tiempo en Exce<\/strong>l<\/p>\n\n\n\n

1.1.       Inter\u00e9s simple<\/p>\n\n\n\n

1.1.1      Ecuaci\u00f3n de valor futuro F dado un valor presente P<\/p>\n\n\n\n

1.1.2      Ecuaci\u00f3n de valor Presente P dado un valor Futuro F<\/p>\n\n\n\n

1.1.3      Ecuaci\u00f3n para el c\u00e1lculo de la tasa de inter\u00e9s i dado un n\u00famero de per\u00edodos<\/p>\n\n\n\n

1.1.4      Ecuaci\u00f3n para el c\u00e1lculo del n\u00famero de per\u00edodos n dada una tasa de inter\u00e9s<\/p>\n\n\n\n

1.2. Inter\u00e9s compuesto<\/strong><\/p>\n\n\n\n

1.2.1      Ecuaciones de pago \u00fanico<\/p>\n\n\n\n

1.2.2      Ecuaciones de series de cuotas uniformes<\/p>\n\n\n\n

1.2.3      Ecuaciones de series gradientes uniformes<\/p>\n\n\n\n

1.2.4      Ecuaciones de series gradientes geom\u00e9tricas<\/p>\n\n\n\n

2. Tasas de inter\u00e9s<\/strong><\/p>\n\n\n\n

2.1          Tasa de inter\u00e9s nominal (r)<\/p>\n\n\n\n

2.2          Tasa de inter\u00e9s efectiva (ie<\/sub>)<\/p>\n\n\n\n

2.3          Expresiones de las tasas de inter\u00e9s<\/p>\n\n\n\n

3. Valor Neto Actual y Tasa Interna de Retorno<\/strong><\/p>\n\n\n\n

3.1           Valor Neto Actual<\/p>\n\n\n\n

3.2          Tasa Interna de Retorno<\/p>\n\n\n\n

3.3          Valor Neto Actual con plazos no peri\u00f3dicos<\/p>\n\n\n\n

3.4          Tasa Interna de Retorno con plazos no peri\u00f3dicos<\/p>\n\n\n\n

4. Sistemas de Cr\u00e9dito<\/strong><\/p>\n\n\n\n

4.1           Ordinario<\/p>\n\n\n\n

4.1.1         Cuota Fija<\/p>\n\n\n\n

4.1.2        Amortizaci\u00f3n Fija<\/p>\n\n\n\n

4.2          Moneda extranjera<\/p>\n\n\n\n

4.3          Leasing habitacional<\/p>\n\n\n\n

4.4          Unidades de Valor Relativo<\/p>\n\n\n\n

5. Herramientas<\/strong><\/p>\n\n\n\n

5.1          Buscar objetivo<\/p>\n\n\n\n

5.2          Tabla de datos<\/p>\n\n\n\n

5.3          Solver<\/p>\n","protected":false},"excerpt":{"rendered":"

Domina Excel para realizar c\u00e1lculos y pron\u00f3sticos con los datos financieros de una empresa y as\u00ed tomar mejores decisiones.<\/p>\n","protected":false},"featured_media":2689,"template":"","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false},"class_list":["post-3067","cursos","type-cursos","status-publish","has-post-thumbnail","hentry"],"yoast_head":"\nExcel Financiero - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Financiero - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\" \/>\n<meta property=\"og:description\" content=\"Domina Excel para realizar c\u00e1lculos y pron\u00f3sticos con los datos financieros de una empresa y as\u00ed tomar mejores decisiones.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/\" \/>\n<meta property=\"og:site_name\" content=\"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-07T18:49:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-financiero.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/\",\"url\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/\",\"name\":\"Excel Financiero - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\",\"isPartOf\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-financiero.jpg\",\"datePublished\":\"2023-03-06T17:45:56+00:00\",\"dateModified\":\"2023-03-07T18:49:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/#primaryimage\",\"url\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-financiero.jpg\",\"contentUrl\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-financiero.jpg\",\"width\":600,\"height\":300,\"caption\":\"Curso de Excel financiero\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"cursos\",\"item\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Financiero\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#website\",\"url\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/\",\"name\":\"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\",\"description\":\"Instituci\u00f3n de educaci\u00f3n superior\",\"publisher\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#organization\",\"name\":\"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\",\"url\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2021\/09\/logo-politecnico-santafe-bogota.png\",\"contentUrl\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2021\/09\/logo-politecnico-santafe-bogota.png\",\"width\":57,\"height\":73,\"caption\":\"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\"},\"image\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Financiero - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/","og_locale":"es_ES","og_type":"article","og_title":"Excel Financiero - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","og_description":"Domina Excel para realizar c\u00e1lculos y pron\u00f3sticos con los datos financieros de una empresa y as\u00ed tomar mejores decisiones.","og_url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/","og_site_name":"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","article_modified_time":"2023-03-07T18:49:07+00:00","og_image":[{"width":600,"height":300,"url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-financiero.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/","url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/","name":"Excel Financiero - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","isPartOf":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/#primaryimage"},"image":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/#primaryimage"},"thumbnailUrl":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-financiero.jpg","datePublished":"2023-03-06T17:45:56+00:00","dateModified":"2023-03-07T18:49:07+00:00","breadcrumb":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/#primaryimage","url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-financiero.jpg","contentUrl":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-financiero.jpg","width":600,"height":300,"caption":"Curso de Excel financiero"},{"@type":"BreadcrumbList","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/excel-financiero\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/"},{"@type":"ListItem","position":2,"name":"cursos","item":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/"},{"@type":"ListItem","position":3,"name":"Excel Financiero"}]},{"@type":"WebSite","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#website","url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/","name":"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","description":"Instituci\u00f3n de educaci\u00f3n superior","publisher":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#organization","name":"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#\/schema\/logo\/image\/","url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2021\/09\/logo-politecnico-santafe-bogota.png","contentUrl":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2021\/09\/logo-politecnico-santafe-bogota.png","width":57,"height":73,"caption":"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1"},"image":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-json\/wp\/v2\/cursos\/3067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-json\/wp\/v2\/cursos"}],"about":[{"href":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-json\/wp\/v2\/types\/cursos"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-json\/wp\/v2\/media\/2689"}],"wp:attachment":[{"href":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-json\/wp\/v2\/media?parent=3067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}