{"id":43247,"date":"2020-04-14T16:39:22","date_gmt":"2020-04-14T21:39:22","guid":{"rendered":"https:\/\/www.unisinucartagena.edu.co\/?page_id=43247"},"modified":"2021-02-16T09:45:39","modified_gmt":"2021-02-16T14:45:39","slug":"curso-excel-avanzado-virtual","status":"publish","type":"page","link":"https:\/\/unisinucartagena.edu.co\/en\/curso-excel-avanzado-virtual\/","title":{"rendered":"Course \u2013 Advanced Excel \u2013 VIRTUAL"},"content":{"rendered":"<div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<h1 class=\"heading__primary\" style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Course \u2013 Advanced Excel\u00a0<\/span><\/strong><\/h1>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_left\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img data-recalc-dims=\"1\" fetchpriority=\"high\" decoding=\"async\" class=\"vc_single_image-img\" src=\"https:\/\/i0.wp.com\/unisinucartagena.edu.co\/wp-content\/uploads\/2020\/04\/Excel-Avanzado_Mesa-de-trabajo-1.png?resize=640%2C124&#038;ssl=1\" width=\"640\" height=\"124\" alt=\"Excel Avanzado_Mesa de trabajo 1\" title=\"Excel Advanced_Artboard 1\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n<div class=\"vc_empty_space\"   style=\"height: 15px\"><span class=\"vc_empty_space_inner\"><\/span><\/div><\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-8\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"vc_tta-container\" data-vc-action=\"collapse\"><div class=\"vc_general vc_tta vc_tta-accordion vc_tta-color-grey vc_tta-style-classic vc_tta-shape-rounded vc_tta-spacing-15 vc_tta-gap-20 vc_tta-controls-align-left\"><div class=\"vc_tta-panels-container\"><div class=\"vc_tta-panels\"><div class=\"vc_tta-panel\" id=\"1586388071970-9c842761-440e\" data-vc-content=\".vc_tta-panel-body\"><div class=\"vc_tta-panel-heading\"><h4 class=\"vc_tta-panel-title vc_tta-controls-icon-position-left\"><a href=\"#1586388071970-9c842761-440e\" data-vc-accordion data-vc-container=\".vc_tta-container\"><span class=\"vc_tta-title-text\">Goal<\/span><i class=\"vc_tta-controls-icon vc_tta-controls-icon-plus\"><\/i><\/a><\/h4><\/div><div class=\"vc_tta-panel-body\">\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<ul>\n<li style=\"text-align: justify;\">Develop skills in the processing of information in an efficient and timely manner, in such a way that the participant can organize, manipulate, process, present data and contents in a totalized way through the use of Excel tools (tables, formulas, graphs<\/li>\n<li style=\"text-align: justify;\">Quickly carry out both simple and larger operations, with statistical, financial and accounting formulas, as well as create tables and din graphs that will give the works a better appearance.<\/li>\n<\/ul>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><div class=\"vc_tta-panel\" id=\"1586388072011-b10b7d73-a153\" data-vc-content=\".vc_tta-panel-body\"><div class=\"vc_tta-panel-heading\"><h4 class=\"vc_tta-panel-title vc_tta-controls-icon-position-left\"><a href=\"#1586388072011-b10b7d73-a153\" data-vc-accordion data-vc-container=\".vc_tta-container\"><span class=\"vc_tta-title-text\">Introduction<\/span><i class=\"vc_tta-controls-icon vc_tta-controls-icon-plus\"><\/i><\/a><\/h4><\/div><div class=\"vc_tta-panel-body\">\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<p style=\"text-align: justify;\">Excel is a Spreadsheet-type program that allows you to perform operations with numbers organized in a grid. It is useful to perform from simple sums to mortgage loan calculations. If you have never worked with Excel on this basic topic, you can see in more detail what a Basic spreadsheet is and what it is for.<\/p>\n<p style=\"text-align: justify;\">Now we are going to see what are the basic elements of Excel 2016, the screen, the bars, etc., to know how to differentiate between each one of them. You will learn what they are called, where they are and what they are for. Also how to get help, in case at some point you don&#039;t know how to continue working. When you know all this you will be ready to start creating spreadsheets in the next topic.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><div class=\"vc_tta-panel\" id=\"1586388208605-671588b6-e2bf\" data-vc-content=\".vc_tta-panel-body\"><div class=\"vc_tta-panel-heading\"><h4 class=\"vc_tta-panel-title vc_tta-controls-icon-position-left\"><a href=\"#1586388208605-671588b6-e2bf\" data-vc-accordion data-vc-container=\".vc_tta-container\"><span class=\"vc_tta-title-text\">Justification<\/span><i class=\"vc_tta-controls-icon vc_tta-controls-icon-plus\"><\/i><\/a><\/h4><\/div><div class=\"vc_tta-panel-body\">\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<p style=\"text-align: justify;\">We must develop the potential of the tools and functions found in excel, which allow the generation of a number of applications at the service of automation and analysis of processes within the labor and academic field, achieving capacities in the participant to be able to organize , manipulate, process and present data and content in an effective way, managing to add value to the different processes to which they are applied, whether academic or work. It has been possible to propose an intermediate training level in which the participant will be able to identify and apply the different formulas and functions, with which he will achieve great information management.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><div class=\"vc_tta-panel\" id=\"1586388263161-15decab7-39d1\" data-vc-content=\".vc_tta-panel-body\"><div class=\"vc_tta-panel-heading\"><h4 class=\"vc_tta-panel-title vc_tta-controls-icon-position-left\"><a href=\"#1586388263161-15decab7-39d1\" data-vc-accordion data-vc-container=\".vc_tta-container\"><span class=\"vc_tta-title-text\">Addressed to<\/span><i class=\"vc_tta-controls-icon vc_tta-controls-icon-plus\"><\/i><\/a><\/h4><\/div><div class=\"vc_tta-panel-body\">\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<p>The Advanced Excel Course Is Aimed At:<\/p>\n<ul>\n<li>Students, Teachers and Administrative<\/li>\n<\/ul>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><div class=\"vc_tta-panel\" id=\"1586388292656-deb66141-14a5\" data-vc-content=\".vc_tta-panel-body\"><div class=\"vc_tta-panel-heading\"><h4 class=\"vc_tta-panel-title vc_tta-controls-icon-position-left\"><a href=\"#1586388292656-deb66141-14a5\" data-vc-accordion data-vc-container=\".vc_tta-container\"><span class=\"vc_tta-title-text\">Study plan<\/span><i class=\"vc_tta-controls-icon vc_tta-controls-icon-plus\"><\/i><\/a><\/h4><\/div><div class=\"vc_tta-panel-body\">\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<p style=\"text-align: justify;\">The curriculum of the Advanced Excel Course was developed by highly trained professionals with extensive experience in pedagogical training.<\/p>\n<p style=\"text-align: justify;\">This program includes 10 modules in which each participant can study at their own pace and from anywhere, obtaining results that will increase their professional opportunities.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<div class=\"wpb_raw_code wpb_content_element wpb_raw_html\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<style type=\"text\/css\">\n\ttable.tableizer-table {\n\t\tfont-size: 12px;\n\t\tborder: 1px solid #CCC; \n\t\tfont-family: Arial, Helvetica, sans-serif;\n\t} \n\t.tableizer-table td {\n\t\tpadding: 4px;\n\t\tmargin: 3px;\n\t\tborder: 1px solid #CCC;\n\t}\n\t.tableizer-table th {\n\t\tbackground-color: #E00000; \n\t\tcolor: #FFF;\n\t\tfont-weight: bold;\n\t}\n<\/style>\n<table class=\"tableizer-table\">\n<thead><tr class=\"tableizer-firstrow\"><th>MODULES (THEME)<\/th><\/tr><\/thead><tbody>\n <tr><td>1. Introduction to Excel-<\/td><\/tr>\n <tr><td>Toolbars.<\/td><\/tr>\n <tr><td>Add and remove toolbars.<\/td><\/tr>\n <tr><td>Formatting: bold, italic, underline, color, font Insert and delete rows, columns, and cells.<\/td><\/tr>\n <tr><td>Data types: Text, number, formulas and functions. SUM, MAX, MIN, AVERAGE, COUNT, COUNTA. Simple mathematical operations.<\/td><\/tr>\n <tr><td>&nbsp;<\/td><\/tr>\n <tr><td>2.<\/td><\/tr>\n <tr><td>Creation of spreadsheets.<\/td><\/tr>\n <tr><td>calculations. Percentages.<\/td><\/tr>\n <tr><td>Types of errors in formulas.<\/td><\/tr>\n <tr><td>Format: Autoformat. Conditional format.<\/td><\/tr>\n <tr><td>Drag cells.<\/td><\/tr>\n <tr><td>Relative, absolute, mixed references.<\/td><\/tr>\n <tr><td>Sort data.<\/td><\/tr>\n <tr><td>&nbsp;<\/td><\/tr>\n <tr><td>3. <\/td><\/tr>\n <tr><td>Graphics.<\/td><\/tr>\n <tr><td>Creation of graphs based on a spreadsheet.<\/td><\/tr>\n <tr><td>Chart types. Setting. Personalize.<\/td><\/tr>\n <tr><td>Graphics tools.<\/td><\/tr>\n <tr><td>Color, lines, 3D, shading, textures, etc.<\/td><\/tr>\n <tr><td>Modification of data of a graph.<\/td><\/tr>\n <tr><td>Create Speedometer Charts<\/td><\/tr>\n <tr><td>&nbsp;<\/td><\/tr>\n <tr><td>4.<\/td><\/tr>\n <tr><td>Database.<\/td><\/tr>\n <tr><td>Creation of a database in Excel.<\/td><\/tr>\n <tr><td>Data. Filter, Autofilter.<\/td><\/tr>\n <tr><td>Sort data.<\/td><\/tr>\n <tr><td>Freeze panels.<\/td><\/tr>\n <tr><td>Subtotals. Validation. Forms.<\/td><\/tr>\n <tr><td>&nbsp;<\/td><\/tr>\n <tr><td>5.<\/td><\/tr>\n <tr><td>Basic functions.<\/td><\/tr>\n <tr><td>Text functions.<\/td><\/tr>\n <tr><td>Date functions.<\/td><\/tr>\n <tr><td>Counting functions.<\/td><\/tr>\n <tr><td>Financial functions.<\/td><\/tr>\n <tr><td>Logical functions.<\/td><\/tr>\n <tr><td>Functions of searching and referencing<\/td><\/tr>\n <tr><td>Combination of formulas and functions<\/td><\/tr>\n <tr><td>matrix functions<\/td><\/tr>\n <tr><td>advanced formulas. <\/td><\/tr>\n <tr><td>Statistical functions<\/td><\/tr>\n <tr><td>financial functions<\/td><\/tr>\n <tr><td>COUNT.IF, ADD.IF, IF, SEARCH, VLOOKUP, HLOOKUP.<\/td><\/tr>\n <tr><td>Creation and editing of complex spreadsheets combining formulas<\/td><\/tr>\n <tr><td>&nbsp;<\/td><\/tr>\n <tr><td>6.<\/td><\/tr>\n <tr><td>Formula Audits.<\/td><\/tr>\n <tr><td>Handle errors in functions.<\/td><\/tr>\n <tr><td>Error checking.<\/td><\/tr>\n <tr><td>Trace preceding cells that generate a formula.<\/td><\/tr>\n <tr><td>Trace dependent cells of a formula.<\/td><\/tr>\n <tr><td>Show formulas.<\/td><\/tr>\n <tr><td>Evaluate formula.<\/td><\/tr>\n <tr><td>Watch Window<\/td><\/tr>\n <tr><td>7.<\/td><\/tr>\n <tr><td>Data Protection<\/td><\/tr>\n <tr><td>Book level protection.<\/td><\/tr>\n <tr><td>Blade level protection.<\/td><\/tr>\n <tr><td>Cell level protection<\/td><\/tr>\n <tr><td>Databases.<\/td><\/tr>\n <tr><td>Data Import. From text, web, Access, Query<\/td><\/tr>\n <tr><td>Data validation.<\/td><\/tr>\n <tr><td>Dynamic tables.<\/td><\/tr>\n <tr><td>Dynamic Graphics.<\/td><\/tr>\n <tr><td>Segmentation<\/td><\/tr>\n <tr><td>Solve<\/td><\/tr>\n <tr><td>dashboard<\/td><\/tr>\n <tr><td>8. Excel Formulas for Accountants<\/td><\/tr>\n <tr><td>SEARCHV SEARCHH MATCH<\/td><\/tr>\n <tr><td>BDCOUNT BDEXTRACT BDMAX<\/td><\/tr>\n <tr><td>BDPRODUCT BDAVERAGE BDSUM<\/td><\/tr>\n <tr><td>ENTIRE RANDOM ABS<\/td><\/tr>\n <tr><td>SUMPRODUCT COUNT STATISTICS<\/td><\/tr>\n <tr><td>BONUS: PIVOT TABLES<\/td><\/tr>\n <tr><td>9. Macros.<\/td><\/tr>\n <tr><td>Macro recorder.<\/td><\/tr>\n <tr><td>References in macros<\/td><\/tr>\n <tr><td>Introduction to VBA.<\/td><\/tr>\n <tr><td>10. Identify the factors that facilitate the organization of data, developing exercises related to the reality of work.<\/td><\/tr>\n<\/tbody><\/table>\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_inner vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-6\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_raw_code wpb_content_element wpb_raw_html\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<div class=\"vc_btn3-container vc_btn3-center\">\n\t<a onmouseleave=\"this.style.borderColor='#e42313'; this.style.backgroundColor='transparent'; this.style.color='#e42313'\" onmouseenter=\"this.style.borderColor='#e42313'; this.style.backgroundColor='#e42313'; this.style.color='#ffffff';\" style=\"border-color: rgb(228, 35, 19); color: rgb(228, 35, 19); background-color: transparent;\" class=\"vc_general vc_btn3 vc_btn3-size-md vc_btn3-shape-rounded vc_btn3-style-outline-custom\" href=\"https:\/\/unisinucartagena.edu.co\/en\/educacioncontinua\/educacion-continua-virtual\/\" title=\"\">KNOW OUR COMPLETE OFFER<\/a><\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><div class=\"wpb_column vc_column_container vc_col-sm-6\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_raw_code wpb_content_element wpb_raw_html\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<div class=\"vc_btn3-container vc_btn3-center\">\n\t<a onmouseleave=\"this.style.borderColor='#e42313'; this.style.backgroundColor='transparent'; this.style.color='#e42313'\" onmouseenter=\"this.style.borderColor='#e42313'; this.style.backgroundColor='#e42313'; this.style.color='#ffffff';\" style=\"border-color: rgb(228, 35, 19); color: rgb(228, 35, 19); background-color: transparent;\" class=\"vc_general vc_btn3 vc_btn3-size-md vc_btn3-shape-rounded vc_btn3-style-outline-custom\" href=\"https:\/\/drive.google.com\/file\/d\/1ZHSu9mQ1UAois-D4KsW98VfJc96DU4Gx\/view\" target=\"_blank\" title=\"\">DOWNLOAD BROCHURE<\/a><\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"wpb_column vc_column_container vc_col-sm-4 vc_col-has-fill\"><div class=\"vc_column-inner vc_custom_1586388446444\"><div class=\"wpb_wrapper\">\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_left\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"vc_single_image-img\" src=\"https:\/\/i0.wp.com\/unisinucartagena.edu.co\/wp-content\/uploads\/2020\/04\/Llama-PNG2.png?resize=320%2C150&#038;ssl=1\" width=\"320\" height=\"150\" alt=\"Llama-PNG2\" title=\"Flame-PNG2\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<h3 class=\"miniform--title\" style=\"text-align: center;\"><span style=\"color: #ffffff;\">Request information<\/span><\/h3>\n\n\t\t<\/div>\n\t<\/div>\n<p class=\"wpcf7-contact-form-not-found\"><strong>Error:<\/strong> Contact form not found.<\/p><div class=\"vc_empty_space\"   style=\"height: 32px\"><span class=\"vc_empty_space_inner\"><\/span><\/div><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"Course - Advanced Excel Objective To develop skills in the processing of information in an efficient and timely manner, in such a way that the participant can organize, manipulate, process, present data and contents in a totalized way through the use of \u2026","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"_acf_changed":false,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-43247","page","type-page","status-publish","hentry"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/unisinucartagena.edu.co\/en\/wp-json\/wp\/v2\/pages\/43247","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unisinucartagena.edu.co\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/unisinucartagena.edu.co\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/unisinucartagena.edu.co\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unisinucartagena.edu.co\/en\/wp-json\/wp\/v2\/comments?post=43247"}],"version-history":[{"count":8,"href":"https:\/\/unisinucartagena.edu.co\/en\/wp-json\/wp\/v2\/pages\/43247\/revisions"}],"predecessor-version":[{"id":47276,"href":"https:\/\/unisinucartagena.edu.co\/en\/wp-json\/wp\/v2\/pages\/43247\/revisions\/47276"}],"wp:attachment":[{"href":"https:\/\/unisinucartagena.edu.co\/en\/wp-json\/wp\/v2\/media?parent=43247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}