Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado from Coursera

El software de hojas de cálculo sigue siendo uno de los software más omnipresentes en las oficinas de todo el mundo. Aprender a utilizar con confianza este software significa agregar un activo muy valioso a sus oportunidades de empleo. En el mundo, se publican a diario millones de anuncios de empleo que requieren habilidades de Excel. En un momento en que los trabajos de conocimientos informáticos están creciendo mucho más rápido que los trabajos no digitales, este curso le proporcionará una ventaja competitiva, así que lo invitamos a que siga leyendo. Este último curso de nuestra Especialización en Habilidades de Excel Aplicadas a Negocios se basará en reforzar las bases adquiridas en los tres primeros cursos: Básico, Intermedio I + II.

En el curso Avanzado, le prepararemos para convertirle en un usuario avanzado de Excel; este es su último paso antes de especializarse a nivel profesional. Los temas que hemos preparado le propondrán desafíos a medida que aprenda a usar técnicas avanzadas de fórmulas y búsquedas sofisticadas. Limpiará y preparará los datos para el análisis, y aprenderá a trabajar con fechas y funciones financieras. Una mirada en profundidad al diseño y la documentación de la hoja de cálculo le preparará para nuestro gran final, donde aprenderá a construir paneles profesionales en Excel.

What's inside

Syllabus

Diseño y Documentación de Hojas de Cálculo

Como usuario intermedio de Excel, usted ya tiene los conceptos básicos. El primer módulo del curso Avanzado se centra en crear y mantener hojas de cálculo precisas, flexibles, receptivas y fáciles de usar. Usted aprenderá a diseñar hojas de cálculo flexibles y auditables, a construir cálculos transparentes, a crear una navegación fácil de usar y a usar estilos, temas y formatos para dejarlo todo atado con un bonito lazo.

Técnicas de Fórmulas Avanzadas

Excel a menudo requiere que realice análisis complejos en grandes conjuntos de datos. Esto se puede hacer mucho más fácil usando fórmulas de matriz, que pueden realizar múltiples cálculos simultáneamente y garantizar la precisión de su hoja de cálculo. Este módulo cubre el uso de fórmulas de matriz, cómo crearlas y usarlas de manera efectiva.

Limpieza y Preparación de Datos

¿Le han entregado una hoja de cálculo si ningún orden? Este módulo se centra en la limpieza y preparación de datos. Aprenderá a usar correcciones dinámicas y automatizadas, limpiar datos desordenados, automatizar estos procesos a través de funciones y garantizar que los datos se mantengan limpios dinámicamente. Utilizaremos funciones para fijar fechas, reemplazar espacios en blanco y eliminar caracteres no deseados de los datos, todo para ayudarnos a crear una solución eficiente y duradera.

Funciones Financieras y Trabajar con Fechas

Este módulo introduce funciones financieras en nuestra base de conocimientos de Excel. Las funciones financieras se utilizan a menudo en las empresas y Excel tiene una variedad de herramientas para ayudarle a ello. Esta semana, aprenderá a aplicar fórmulas de fecha en los cálculos, crear horarios de préstamos con funciones financieras, así como utilizar funciones de depreciación.

Funciones de Búsqueda Avanzada

Siempre es una buena idea hacer que sus hojas de cálculo (¡y trabajo!) sean más automatizadas. Las búsquedas automatizadas pueden hacer que su trabajo sea rápido y eficiente. Este módulo se centra en las capacidades de su matriz y explora una gama de funciones para crear rangos de búsqueda dinámicos: INDIRECTO, DIRECCIÓN, DESREF e ÍNDICE.

Creación de Paneles Profesionales

Para que quede claro, este módulo le guía a través de los pasos para construir un panel profesional. Los datos no tienen sentido a menos que cuenten una historia y puedan usarse como inteligencia empresarial. Este módulo le ayudará a configurar un panel: aprenderá a visualizar datos a través de gráficos y tablas, crear modelos de datos y agregar interactividad.

Evaluación Final

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Está pensado para aquellos que buscan desarrollar sus habilidades de Excel a un nivel avanzado, para mejorar sus oportunidades de empleo y obtener una ventaja competitiva en el mercado laboral

Ofrece una sólida base para usuarios intermedios de Excel, cubriendo temas como el diseño y la documentación de hojas de cálculo, técnicas avanzadas de fórmulas, limpieza y preparación de datos, funciones financieras y de trabajo con fechas, funciones de búsqueda avanzadas y creación de paneles profesionales

Los instructores del curso, Nicky Bull, el Dr. Prashan S. M. Karunaratne y la Profesora Yvonne Breyer, son destacados expertos en sus respectivos campos

Incluye un módulo completo dedicado a la preparación y limpieza de datos, lo que resulta esencial para manejar y analizar conjuntos de datos complejos

Enseña técnicas avanzadas de fórmulas, como fórmulas de matriz, que permiten a los usuarios realizar cálculos complejos y garantizar la precisión de sus hojas de cálculo

El desarrollo de habilidades para crear paneles profesionales ayuda a los estudiantes a presentar datos de manera efectiva y a obtener información valiosa para la toma de decisiones

Reviews summary

Advanced ms excel skills

This course, taught in Spanish, provides users with the tools and skills they need to become power users of MS Excel. It covers financial functions, advanced formula techniques and much more. The course is highly-rated by students, who appreciate the instructor's clear explanations and the course's in-depth approach. One potential drawback is that some students have reported issues with the accuracy of translations in non-English versions of Excel, although this issue can be overcome with some workarounds.

In-depth coverage of topics

"Un curso muy completo"

"Excelente curso. Algo complicado que mi idioma es español (y el del excel que tengo en mi computadora) pero algunas funciones no tienen una traduccion idonea, como DESREF para OFFSET, pero al resolver el primer caso ya los demas se adaptan con facilidad."

Well-organized, clear explanations

"Excelente, muy dinámico, interesante, bien guiado. Me encantó."

"Excelente curso, me ha ayudado a ser mucho mas productivo, el nivel es alto pero los profesores son geniales para explicar y también la redacción y el apoyo en texto es muy bueno."

Potential inaccuracies in translated versions of Excel

" Muy mal su adaptación al español en los exámenes no es muy detallada así que te topas con problemas. Si sabes ingles mejor inscríbete al curso en inglés y usa Excel en ingles para que obtengas los mimos datos. "

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 Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado with these activities:

Review basic Excel formula writing

Show steps

Excel formulas are essential throughout the course, and refreshing formula-writing will prepare you to be successful throughout the course.

Browse courses on Excel Formulas

Show steps

Review basic operators (+, -, *, /)
Write formulas using cell references
Use simple functions, such as SUM and AVERAGE

Attend a workshop on advanced Excel techniques

Show steps

Workshops are a great way to learn from experts and get hands-on experience with new skills. Attending a workshop on advanced Excel techniques will help you take your Excel skills to the next level.

Browse courses on Advanced Excel Techniques

Show steps

Find a reputable workshop on advanced Excel techniques
Register for the workshop
Attend the workshop and participate actively

Show all two activities

Career center

Learners who complete Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts are responsible for collecting, cleaning, and analyzing data to help businesses make informed decisions. They use their skills in statistics, data mining, and visualization to identify trends, patterns, and insights in data. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado can be helpful for Data Analysts because it provides them with the skills they need to clean and prepare data, perform analysis, and create visualizations. The course covers topics such as data cleaning, working with dates, and creating professional dashboards.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial Analysts are responsible for building financial models, conducting research, and making recommendations on investments. They use their knowledge of financial markets and economic trends to help companies make informed decisions about their financial future. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado can be helpful for Financial Analysts because it provides them with the skills they need to analyze data, build models, and make recommendations. The course covers topics such as financial functions, working with dates, and creating professional dashboards.

See salaries and explore the career path for Financial Analyst

Management Consultant

Management Consultants are responsible for helping businesses improve their performance. They use their skills in problem-solving, communication, and data analysis to help businesses identify areas for improvement and develop solutions. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado can be helpful for Management Consultants because it provides them with the skills they need to analyze data, identify trends, and make recommendations. The course covers topics such as data cleaning, working with dates, and creating professional dashboards.

See salaries and explore the career path for Management Consultant

Business Analyst

Business Analysts are responsible for analyzing business processes and identifying areas for improvement. They use their skills in problem-solving, communication, and data analysis to help businesses make better decisions. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado can be helpful for Business Analysts because it provides them with the skills they need to analyze data, identify trends, and make recommendations. The course covers topics such as data cleaning, working with dates, and creating professional dashboards.

See salaries and explore the career path for Business Analyst

Auditor

Auditors are responsible for examining financial records to ensure that they are accurate and compliant with GAAP. They use their skills in accounting, auditing, and data analysis to help businesses improve their financial reporting and internal controls. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado can be helpful for Auditors because it provides them with the skills they need to analyze data, identify trends, and make recommendations. The course covers topics such as data cleaning, working with dates, and creating professional dashboards.

See salaries and explore the career path for Auditor

Actuary

Actuaries are responsible for assessing and managing financial risk. They use their skills in mathematics, statistics, and economics to help businesses and individuals make informed decisions about their financial future. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado can be helpful for Actuaries because it provides them with the skills they need to analyze data, build models, and make recommendations. The course covers topics such as financial functions, working with dates, and creating professional dashboards.

See salaries and explore the career path for Actuary

Investment Analyst

Investment Analysts are responsible for researching and analyzing investments. They use their skills in financial analysis, valuation, and portfolio management to help investors make informed decisions about their investments. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado can be helpful for Investment Analysts because it provides them with the skills they need to analyze data, build models, and make recommendations. The course covers topics such as financial functions, working with dates, and creating professional dashboards.

See salaries and explore the career path for Investment Analyst

Risk Analyst

Risk Analysts are responsible for identifying, assessing, and managing financial risk. They use their skills in risk management, data analysis, and modeling to help businesses make informed decisions about their risk appetite and risk tolerance. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado can be helpful for Risk Analysts because it provides them with the skills they need to analyze data, build models, and make recommendations. The course covers topics such as financial functions, working with dates, and creating professional dashboards.

See salaries and explore the career path for Risk Analyst

Financial Planner

Financial Planners are responsible for helping individuals and families plan for their financial future. They use their skills in financial planning, investment management, and estate planning to help clients achieve their financial goals. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado can be helpful for Financial Planners because it provides them with the skills they need to analyze data, build models, and make recommendations. The course covers topics such as financial functions, working with dates, and creating professional dashboards.

See salaries and explore the career path for Financial Planner

Statistician

Statisticians are responsible for collecting, analyzing, and interpreting data. They use their skills in statistics, data mining, and visualization to help businesses make informed decisions. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado can be helpful for Statisticians because it provides them with the skills they need to clean and prepare data, perform analysis, and create visualizations. The course covers topics such as data cleaning, working with dates, and creating professional dashboards.

See salaries and explore the career path for Statistician

Data Scientist

Data Scientists are responsible for developing and implementing data science solutions. They use their skills in data mining, machine learning, and artificial intelligence to help businesses make informed decisions. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado may be helpful for Data Scientists because it provides them with the skills they need to clean and prepare data, perform analysis, and create visualizations. The course covers topics such as data cleaning, working with dates, and creating professional dashboards.

See salaries and explore the career path for Data Scientist

Database Administrator

Database Administrators are responsible for designing, implementing, and maintaining databases. They use their skills in database management, data modeling, and SQL to ensure that data is stored and managed efficiently. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado may be helpful for Database Administrators because it provides them with the skills they need to manage and analyze data. The course covers topics such as data cleaning, working with dates, and creating professional dashboards.

See salaries and explore the career path for Database Administrator

Software Engineer

Software Engineers are responsible for designing, developing, and maintaining software systems. They use their skills in computer science, software engineering, and programming to build software that meets the needs of users. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado may be helpful for Software Engineers because it provides them with the skills they need to manage and analyze data. The course covers topics such as data cleaning, working with dates, and creating professional dashboards.

See salaries and explore the career path for Software Engineer

Market Researcher

Market Researchers are responsible for conducting market research to identify consumer needs and trends. They use their skills in research design, data collection, and analysis to help businesses make informed decisions about their products and services. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado may be helpful for Market Researchers because it provides them with the skills they need to manage and analyze data. The course covers topics such as data cleaning, working with dates, and creating professional dashboards.

See salaries and explore the career path for Market Researcher

Project Manager

Project Managers are responsible for planning, executing, and closing projects. They use their skills in project management, communication, and leadership to ensure that projects are completed on time, within budget, and to the satisfaction of stakeholders. The course Habilidades de Excel Aplicadas a Negocios: Nivel Avanzado may be helpful for Project Managers because it provides them with the skills they need to manage and analyze data. The course covers topics such as data cleaning, working with dates, and creating professional dashboards.

See salaries and explore the career path for Project Manager