Excel aplicado a los negocios (Nivel Avanzado) from Coursera

Objetivos Generales: Al finalizar el curso, podrás:

1.- ENTENDER y profundizar convenientemente aspectos específicos de diferentes formas de trabajo (individual o grupal),

2.- EVALUAR el uso de funciones avanzadas para manipular datos y CREAR tus propios análisis utilizando técnicas específicas tales como tablas dinámicas, análisis de hipótesis, administración de escenarios, tablas de simple y doble entrada, análisis de optimización de recursos.

3.- ANALIZAR cómo vincular Excel con otras aplicaciones importando información desde archivos de texto y bases de datos, exportando información a archivos de texto de diversas formas.

4.- ENTENDER el uso de macros lo que te permitirá vislumbrar otro universo de aplicaciones que harán mucho más productiva tu labor.

Los ejemplos sobre los cuales se apoyan los contenidos dictados por los profesores, tienen una profunda aplicabilidad al mundo de los negocios, con lo que su inmediata utilización empresarial está al alcance de la mano.

Finalmente, los profesores que han diseñado y elaborado este curso para ti, no solamente dan una visión académica de los usos avanzados del software, sino que, debido a su gran trayectoria profesional apoyada justamente en un uso intensivo y profundo de Excel, te transmitirán su propia vivencia, lo cual te permitirá tener una visión más concreta de las posibilidades que te brinda esta herramienta.

What's inside

Syllabus

Formas de trabajo. Trabajo individual o con otras personas

Bienvenido al Módulo 1, en éste módulo conocerás los siguientes contenidos: 1. Ventanas. División de la pantalla. Opciones de recálculo 2. Validación de datos 3. Formatos condicionales 4. Protección de celdas. Proteger y desproteger hojas y libros

Módulo 2: Funciones avanzadas para manipular datos

Bienvenido al Módulo 2, en éste módulo conocerás los siguientes contenidos: 1. Fórmulas de búsquedas avanzadas (BUSCARV, INDICE, COINCIDIR, DESREF) 2. Cálculos con matrices y vectores (MMULT y TRANSPONER) 3. Funciones lógicas y de error4. Funciones condicionales

Módulo 3: Tablas dinámicas

Bienvenido al Módulo 3, en éste módulo conocerás los siguientes contenidos: 1. Creación. Selección de datos de entrada 2. Agregar campos calculados 3. Formatos de los datos y de tablas

Módulo 4: Vinculación con otras aplicaciones

Bienvenido al módulo 4, en este módulo conocerás los siguientes contenidos: 1. Importación de archivos de texto. 2. Vinculación con bases de datos (Access, SQL)

Módulo 5: Análisis de hipótesis

Bienvenido al módulo 5, en éste módulo conocerás los siguientes contenidos: 1. Buscar objetivo 2. Administración de escenarios 3. Tablas de simple y doble entrada

Módulo 6: Exportación de datos a archivos de texto

Bienvenido al módulo 6, en éste módulo conocerás los siguientes contenidos: 1. Preparación de los datos 2. Generación de archivos de texto

Módulo 7: Análisis de optimización

Bienvenido al módulo 7, en éste módulo conocerás los siguientes contenidos: 1. Uso de Solver: aplicaciones empresariales 2. Función objetivo, celdas a variar, restricciones 3. Definición de restricciones. Resultados

Módulo 8: Introducción al uso de macros

Bienvenidos al módulo 8, en éste módulo conocerás los siguientes contenidos: 1. ¿Qué es una macro? Configuración para el uso de macros. 2. Uso de la grabadora de macros 3. Ejemplos prácticos de aplicación

Consigna Final

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Tiene una orientación clara hacia el mundo empresarial, lo que la hace muy valiosa para profesionales de negocios

Sus instructores son reconocidos por su amplia trayectoria y experiencia en el uso de Excel en entornos empresariales reales

Cubre una amplia gama de temas avanzados de Excel, lo que la hace adecuada para usuarios intermedios y avanzados

Incluye ejercicios prácticos y ejemplos del mundo real que muestran cómo aplicar las técnicas aprendidas

Requiere que los estudiantes tengan conocimientos previos de Excel, por lo que no es adecuada para principiantes absolutos

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Excel aplicado a los negocios (Nivel Avanzado) with these activities:

Repasar los fundamentos de Excel

Show steps

Refrescarás tus conocimientos básicos sobre Excel para mejorar la comprensión de los conceptos avanzados.

Browse courses on Excel

Show steps

Revisar la interfaz y las funciones esenciales
Practicar la manipulación y edición de datos

Resolver ejercicios de manejo de datos

Show steps

Mejorarás tu comprensión del manejo de datos mediante la práctica repetitiva.

Show steps

Identificar conjuntos de datos y variables
Aplicar funciones de búsqueda y manipulación de datos
Utilizar tablas y gráficos dinámicos para analizar y visualizar los datos

Iniciar un proyecto de análisis de datos

Show steps

Ponerás en práctica tus habilidades y conocimientos creando un proyecto de análisis de datos de principio a fin.

Show steps

Definir el alcance y los objetivos del proyecto
Recopilar y preparar los datos
Aplicar funciones y técnicas avanzadas de Excel para analizar los datos

Two other activities

Expand to see all activities and additional details

Show all five activities

Desarrollar una hoja de cálculo para resolver un problema de negocio

Show steps

Profundizarás tu comprensión y aplicación de conceptos avanzados al crear una solución práctica.

Show steps

Identificar un problema de negocio y recopilar los datos relevantes
Diseñar y crear una hoja de cálculo que utilice funciones avanzadas
Validar y optimizar la hoja de cálculo para garantizar precisión y eficiencia

Contribuir a proyectos de código abierto relacionados con Excel

Show steps

Mejorarás tus habilidades técnicas y colaborarás con la comunidad de Excel.

Browse courses on VBA

Show steps

Investigar y seleccionar proyectos de código abierto relevantes
Entender la base de código y las convenciones
Hacer contribuciones, como correcciones de errores o nuevas funciones

Career center

Learners who complete Excel aplicado a los negocios (Nivel Avanzado) will develop knowledge and skills that may be useful to these careers:

Business Analyst

Business Analysts use their understanding of advanced Excel functions, such as those taught in this course, to analyze business processes, identify areas for improvement, and develop solutions to business problems. By taking this course, you will develop the skills needed to use Excel to analyze business data, identify inefficiencies, and make recommendations for improvement.

See salaries and explore the career path for Business Analyst

Data Analyst

Data Analysts use their understanding of advanced Excel functions, such as those taught in this course, to clean, organize, and analyze large datasets. They use this information to identify trends, patterns, and insights that can help businesses make better decisions. By taking this course, you will develop the skills needed to use Excel to analyze data, draw conclusions, and communicate your findings effectively.

See salaries and explore the career path for Data Analyst

Management Consultant

Management Consultants use their understanding of advanced Excel functions, such as those taught in this course, to analyze business data and develop solutions to business problems. They use this information to help businesses improve their operations, increase their profits, and achieve their goals. By taking this course, you will develop the skills needed to use Excel to analyze business data, identify inefficiencies, and make recommendations for improvement.

See salaries and explore the career path for Management Consultant

Financial Analyst

Financial Analysts use their understanding of advanced Excel functions, such as those taught in this course, to build complex financial models. These models are used to forecast financial performance, make investment recommendations, and evaluate the riskiness of different investments. By taking this course, you will develop the skills needed to use Excel to analyze financial data, make sound investment decisions, and advance your career as a Financial Analyst. Some Financial Analyst roles may also require a master's degree.

See salaries and explore the career path for Financial Analyst

Operations Manager

Operations Managers use their understanding of advanced Excel functions, such as those taught in this course, to analyze operational data, identify inefficiencies, and develop solutions to improve efficiency. By taking this course, you will develop the skills needed to use Excel to analyze operational data, identify inefficiencies, and develop solutions to improve efficiency.

See salaries and explore the career path for Operations Manager

Marketing Manager

Marketing Managers use their understanding of advanced Excel functions, such as those taught in this course, to analyze marketing data, identify trends, and develop marketing campaigns. By taking this course, you will develop the skills needed to use Excel to analyze marketing data, identify trends, and develop marketing budgets.

See salaries and explore the career path for Marketing Manager

Sales Manager

Sales Managers use their understanding of advanced Excel functions, such as those taught in this course, to track sales performance, identify opportunities, and develop sales strategies. By taking this course, you will develop the skills needed to use Excel to track sales performance, identify opportunities, and develop sales forecasts.

See salaries and explore the career path for Sales Manager

Actuary

Actuaries use their understanding of advanced Excel functions, such as those taught in this course, to analyze risk and uncertainty. They use this information to develop insurance products, set premiums, and make investment decisions. By taking this course, you will develop the skills needed to use Excel to analyze risk and uncertainty, develop insurance products, and make sound investment decisions. Most Actuary roles require a master's degree.

See salaries and explore the career path for Actuary

Cost Accountant

Cost Accountants use their understanding of advanced Excel functions, such as those taught in this course, to analyze and control costs. They use this information to help organizations improve their profitability. By taking this course, you will develop the skills needed to use Excel to analyze and control costs, develop cost-saving strategies, and make recommendations for improvement.

See salaries and explore the career path for Cost Accountant

Financial Planner

Financial Planners use their understanding of advanced Excel functions, such as those taught in this course, to develop financial plans for individuals and families. These plans help people achieve their financial goals, such as saving for retirement, paying for college, or buying a home. By taking this course, you will develop the skills needed to use Excel to develop financial plans, analyze investment options, and make sound financial decisions.

See salaries and explore the career path for Financial Planner

Auditor

Auditors use their understanding of advanced Excel functions, such as those taught in this course, to examine financial records and ensure that they are accurate and complete. They use this information to identify fraud, waste, and abuse. By taking this course, you will develop the skills needed to use Excel to examine financial records, identify fraud, waste, and abuse, and make recommendations for improvement.

See salaries and explore the career path for Auditor

Tax Accountant

Tax Accountants use their understanding of advanced Excel functions, such as those taught in this course, to prepare tax returns and advise clients on tax matters. By taking this course, you will develop the skills needed to use Excel to prepare tax returns, calculate taxes, and advise clients on tax matters.

See salaries and explore the career path for Tax Accountant

Accountant

Accountants use their understanding of advanced Excel functions, such as those taught in this course, to prepare financial statements, manage budgets, and conduct audits. By taking this course, you will develop the skills needed to use Excel to prepare financial statements, manage budgets, and conduct audits.

See salaries and explore the career path for Accountant

Budget Analyst

Budget Analysts use their understanding of advanced Excel functions, such as those taught in this course, to develop and manage budgets. They use this information to ensure that organizations are using their resources efficiently and effectively. By taking this course, you will develop the skills needed to use Excel to develop and manage budgets, analyze financial data, and make recommendations for improvement.

See salaries and explore the career path for Budget Analyst

Product Manager

Product Managers use their understanding of advanced Excel functions, such as those taught in this course, to analyze market data, identify customer needs, and develop new products and features. By taking this course, you will develop the skills needed to use Excel to analyze market data, identify customer needs, and develop product specifications.

See salaries and explore the career path for Product Manager