{"id":27900,"date":"2026-02-23T19:03:34","date_gmt":"2026-02-23T18:03:34","guid":{"rendered":"https:\/\/www.educapharos.com\/moocs\/excel-desde-cero\/"},"modified":"2026-02-23T19:03:34","modified_gmt":"2026-02-23T18:03:34","slug":"excel-from-scratch","status":"publish","type":"mooc_course","link":"https:\/\/educapharos.com\/en\/excel-desde-cero\/","title":{"rendered":"Excel from Scratch"},"content":{"rendered":"<p><strong>Microsoft Excel <\/strong>is the tool <strong>office automation<\/strong> most commonly used by individuals and, above all, by businesses to <strong>manage data, analyze it, and create attractive charts<\/strong>.<\/p>\n<p>For a company to operate properly, it is important that it keep its data up to date. In other words, the <strong>accounting, invoices, schedules, payroll, and employee check-ins and check-outs<\/strong>\u2026 everything must be under control, which is why we use tools like Excel to make this task easier. In this training course on <strong>Excel<\/strong> <strong>from scratch <\/strong>You will acquire the knowledge necessary to perform your tasks effectively.<\/p>","protected":false},"excerpt":{"rendered":"<p>This Excel training course, which starts from scratch, prepares you to become an expert in using Excel. Therefore, it is ideal for professionals working in accounting, administration, or human resources departments at any company, as well as students who wish to pursue careers in these fields.<\/p>","protected":false},"featured_media":0,"template":"","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"educalms_repo_code":"AFO0288P1","educalms_repo_id":"3510600","educalms_lang":"es","educalms_duration":"30","educalms_duration_type":"693","educalms_image":"https:\/\/dam.educaedtech.com\/sharings\/a01k71n1c4ce0sbhjhzff1qbthv.jpg","educalms_tags":"An\u00e1lisis de datos, Datos, Escenarios, Excel, Filtrar., F\u00f3rmulas, Funciones, Gr\u00e1ficos, Microsoft Excel, ofimatica, Pron\u00f3sticos, Solver, Tablas, Tablas de datos, Tablas din\u00e1micas","educalms_tittle":"Excel desde Cero","educalms_type_of_training":"753","educalms_description":"<p><strong>Microsoft Excel <\/strong>es la herramienta <strong>ofim\u00e1tica<\/strong> m\u00e1s utilizada por particulares y sobre todo por empresas para <strong>administrar datos, analizarlos y elaborar gr\u00e1ficos atractivos<\/strong>.<\/p><p>Para que una empresa funcione correctamente es importante que lleve sus datos al d\u00eda. Es decir, la <strong>contabilidad, facturas, horarios, n\u00f3minas, entradas y salidas<\/strong>... todo debe estar bajo control y es por ello que utilizamos herramientas como Excel para facilitar esta tarea. En esta formaci\u00f3n en <strong>Excel<\/strong> <strong>desde cero <\/strong>adquirir\u00e1s los conocimientos necesarios para llevar a cabo las tareas de manera eficaz.<\/p>","educalms_objectives":"<ul><li><p>Conocer la <strong>interfaz de Microsoft Excel<\/strong> y en qu\u00e9 pesta\u00f1as se encuentran sus diferentes funcionalidades.<\/p><\/li><li><p>Saber manejar datos, formatearlos y trabajar entre diferentes <strong>hojas<\/strong>.<\/p><\/li><li><p>Crear diferentes tipos de <strong>gr\u00e1ficos<\/strong> profesionales en base a una serie de datos.<\/p><\/li><li><p>Conocer las principales <strong>f\u00f3rmulas<\/strong> que se utilizan para editar datos y referenciar <strong>celdas<\/strong>.<\/p><\/li><li><p>Crear y administrar <strong>tablas de datos<\/strong> utilizando <strong>filtros<\/strong>, <strong>agrupaciones<\/strong> de datos y <strong>f\u00f3rmulas<\/strong>.<\/p><\/li><li><p>Utilizar diferentes tipos de tablas, <strong>funciones<\/strong> y herramientas para elaborar <strong>an\u00e1lisis de datos<\/strong> m\u00e1s profundos.<\/p><\/li><li><p>Conocer la herramienta <strong>Solver<\/strong> para resolver determinados problemas.<\/p><\/li><\/ul>","educalms_what_prepares_you_for":"<p>Gracias a esta formaci\u00f3n en <strong>Excel<\/strong> <strong>desde cero<\/strong> aprender\u00e1s a <strong>manejar datos<\/strong> mediante diferentes <strong>funciones<\/strong> de ordenaci\u00f3n, b\u00fasqueda y an\u00e1lisis o el uso de <strong>filtros<\/strong>. Tambi\u00e9n podr\u00e1s representar los datos en <strong>tablas y gr\u00e1ficos<\/strong> que mejoren la visualizaci\u00f3n de valores y faciliten la <strong>toma de decisiones<\/strong>.<\/p>","educalms_audience":"<p>Esta formaci\u00f3n en<strong> Excel<\/strong> <strong>desde cero<\/strong> te prepara para convertirte en un experto en el manejo de Excel. Por tanto, es ideal para todos aquellos <strong>profesionales<\/strong> que est\u00e1n trabajando en <strong>departamentos de contabilidad, administraci\u00f3n o recursos humanos<\/strong> de cualquier empresa o <strong>estudiantes<\/strong> que quieran optar a puestos en estos departamentos<\/p>","educalms_academies":"937","educalms_area_group":"Transversal","educalms_area_id":"3","educalms_area_name":"Competencias Digitales","educalms_academy_ids":"937"},"mooc_category":[250,269,249],"class_list":["post-27900","mooc_course","type-mooc_course","status-publish","mooc_category-area-3","mooc_category-academy-937","mooc_category-group-transversal"],"acf":[],"_links":{"self":[{"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/mooc_course\/27900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/mooc_course"}],"about":[{"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/types\/mooc_course"}],"wp:attachment":[{"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/media?parent=27900"}],"wp:term":[{"taxonomy":"mooc_category","embeddable":true,"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/mooc_category?post=27900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}