Habilidades de Excel para el negocio: Intermedio I from Coursera

El software de hojas de cálculo sigue siendo uno de los componentes de software más ubicuos que se utilizan en lugares de trabajo de todo el mundo. Aprender a operar con confianza este software significa agregar un activo muy valioso a su cartera de empleabilidad. Solo en los Estados Unidos, se publican millones de anuncios de empleo todos los días que requieren habilidades en Excel. La investigación de Burning Glass Technologies y Capital One muestra que las habilidades digitales conducen a mayores ingresos y mejores oportunidades de empleo en un momento en que los trabajos que requieren habilidades digitales están creciendo mucho más rápido que los trabajos que no los requieren.

En este segundo curso de nuestra especialización en Excel, Habilidades de Excel para el negocio, aprovechará las bases sólidas del curso de Conceptos básicos. Habilidades intermedias I ampliará su conocimiento de Excel a nuevos horizontes. Va a descubrir una amplia gama de habilidades y técnicas que se convertirán en un componente estándar de su uso diario de Excel. En este curso, creará una capa sólida de habilidades más avanzadas para que pueda gestionar grandes conjuntos de datos y crear informes significativos. Estas técnicas y herramientas clave le permitirán agregar una capa sofisticada de automatización y eficiencia a sus tareas diarias en Excel.

Nuevamente hemos reunido un gran equipo de enseñanza que estará con usted en cada paso del camino. Prashan y Nicky le guiarán cada semana (e incluso voy a hacer una aparición como invitado en la semana 5 para ayudarle a aprender sobre mi herramienta favorita en Excel; ¡shh, sin espóiler!). Trabaje en cada desafío nuevo paso a paso y en poco tiempo se sorprenderá con lo lejos que ha llegado. Esta vez, seguiremos las pruebas y tribulaciones de Uma mientras intenta encontrar su lugar en un nuevo cargo en la empresa ficticia PushPin. Aquellos de ustedes que han realizado el curso de Conceptos básicos, ya estarán familiarizados con la empresa. Resolver los desafíos que ella debe enfrentar, que son demasiado parecidos a los que debemos enfrentar todos los días, lo ayudará a relacionarse más fácilmente con las habilidades y técnicas aprendidas en cada semana y a aplicarlas a contextos nuevos y conocidos.

What's inside

Syllabus

Cómo trabajar con varias hojas de cálculo y libros

Este módulo se trata de trabajar con varias hojas de cálculo y libros. Aprenda cómo puede combinar datos, gestionar conjuntos de datos y realizar cálculos en múltiples fuentes. Y no olvide la caja de herramientas con prácticos accesos directos y consejos ninja.

Funciones de texto y fecha

Al final de este módulo, será un experto en las funciones de Fecha y Texto. Este módulo analiza las formas en que puede extraer información y manipular datos para cumplir con requisitos comerciales específicos.

Rangos con nombre

Aprenda cómo puede crear, gestionar y aplicar rangos con nombre para mejorar sus cálculos.

Resumen de datos

Graduarse a fórmulas avanzadas en este módulo. Aprenda cómo puede usar funciones como CONTAR.SI.CONJUNTO para extraer información a partir de datos, así como generar representaciones gráficas de ella.

Tablas

Tablas, tablas, tablas. Comience por crear, formatear y administrar tablas y luego pase a clasificar y filtrar las tablas para obtener los datos que necesita. Por último, concluya este módulo automatizando sus tablas para que su trabajo sea más eficiente.

Tablas dinámicas, gráficos y segmentaciones

Este módulo profundiza en las tablas dinámicas populares (y muy útiles). Aprenda cómo puede crearlas y modificarlas para resolver una variedad de problemas comerciales. Luego, adquiera habilidades para crear tableros interactivos con gráficos dinámicos y segmentaciones.

Evaluación final

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Desarrolla habilidades y técnicas que se convertirán en un componente estándar del uso diario de Excel

Enseña funciones de fecha y texto, lo que permite a los alumnos manipular datos para cumplir con requisitos comerciales específicos

Examina las tablas dinámicas, que son muy útiles para resolver una variedad de problemas comerciales

Crea una capa sólida de habilidades más avanzadas para que los alumnos puedan gestionar grandes conjuntos de datos y crear informes significativos

Requiere conocimientos previos del curso Conceptos básicos de Excel

Reviews summary

Highly praised excel skills course

Habilidades de Excel para el Negocio: Intermedio I is highly recommended according to 35 reviews. Students say they found the course to contain excellent content with easy-to-understand videos, useful exercises, and step-by-step demonstrations. The teachers are highly praised for their clear explanations and helpful guidance. Overall, this course receives top marks for providing valuable skills that can be applied in real-world scenarios.

Skills can be applied to work

"EXCELENTE CURSO ME AYUDO A COMPRENDER MAS A CERCA DE LAS FUNCIONES DE EXCEL"

"Creí que sabía lo necesario en Excel, sin embargo me di cuenta que me faltaba mucho por aprender, agradezco al curso porque me ha ayudado en varios ámbitos."

"Un curso exigente pero que a la vez te entrega herramientas valiosísimas para mejorar tus habilidades en el uso de la planilla de cálculo Excel en tus diferentes roles. Totalmente recomendable."

"Excelente curso, habian muchas cosas utiles que no sabia hacer y que me permitiran desarrollar mi trabajo de forma mas productiva. 100% recomendado."

Exercises help reinforce learning

"Funcional y muy sencillo de entender"

"Es un curso muy completo, muy buena explicación por parte de los maestros y cada exámen de la semana es práctico y organizado."

"Los contenidos del curso están muy bien explicados y los ejercicios ayudan a reforzar el conocimiento; al llegar a la evaluación final me pude dar cuenta de todo lo que había aprendido hasta ese momento."

"Me parecio una muy buena herramienta. "

Teachers clearly explain concepts

"Excelente nivel, excelentes profesores."

"El mejor curso que he podido encontrar de excel."

"Es un curso muy completo para el nivel al que va dirigido. Facil de entender y con explicaciones muy claras"

"Un curso ameno y práctico. Excel es una herramienta poderosa que con cada actualización nos acerca a reportes que van hacia lo visual y análisis de datos. Ha agregado valor a mi trabajo diario. Lo recomiendo"

Content highly praised

"Excelente Curso, Recomendado"

"Excelente contenido, Recomendado"

"Los videos son muy completos y faciles de entender."

"Excelente!! Buen material, excelente profesor, aprendi muchisimo. Realmente lo recomiendo!!"

"Excelente, aprendizaje de calidad"

"Excelente, super bien explicado y con ejercicios suficientes para comprender los temas. MEGASATISFECHA con el curso. "

"Excelente Curso, excelente presentaciones y ejercicios, todas las practicas y exámenes son puntuales y te hacen pensar y llevar practica."

Some translation errors present

"Existe algunos errores de traducción en cuanto a los nombres de algunas fórmulas ya que tienen otros nombres en las versiones de Excel en español y no los que se usan a lo largo del curso."

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 para el negocio: Intermedio I with these activities:

Review basics of working with multiple sheets and workbooks

Show steps

Refreshing these basics will ensure you have a strong foundation before diving into more advanced techniques.

Browse courses on Multiple Worksheets

Show steps

Review online documentation or tutorials on working with multiple sheets and workbooks
Create a new workbook and practice adding, deleting, and renaming sheets
Combine data from different sheets or workbooks using formulas and functions

Revise basic spreadsheet concepts

Show steps

Reviewing the basics will help refresh your memory and ensure you have a solid foundation before diving into advanced material.

Browse courses on Spreadsheet Basics

Show steps

Review online tutorials or documentation on Excel basics
Create a simple spreadsheet and practice entering and formatting data
Perform basic calculations using formulas and functions

Join a study group or online forum to discuss Excel concepts and techniques

Show steps

Engaging with peers can provide different perspectives, enhance your understanding, and identify areas where you need further clarification.

Show steps

Find a study group or online forum dedicated to Excel
Participate in discussions, ask questions, and share your knowledge
Collaborate on projects or challenges related to Excel

Five other activities

Expand to see all activities and additional details

Show all eight activities

Create charts and graphs from sample data

Show steps

Working with sample data will help you gain hands-on experience in creating visual representations of information.

Browse courses on Data Visualization

Show steps

Download a sample dataset from the internet or create your own
Import the data into Excel and create different types of charts (bar, line, pie, etc.)
Customize the charts to improve their appearance and readability
Analyze the charts and draw insights from the data

Learn advanced Excel functions through online courses or tutorials

Show steps

Online resources can provide additional guidance and support as you explore more advanced Excel functions.

Browse courses on Advanced Excel Functions

Show steps

Identify specific Excel functions or techniques you want to learn
Search for online courses or tutorials that cover those topics
Follow the instructions and practice using the new functions
Apply the new skills to your own spreadsheets or projects

Participate in online Excel competitions or challenges

Show steps

Competitions can provide a fun and motivating way to test your skills, learn from others, and showcase your abilities.

Browse courses on Problem-Solving

Show steps

Research and identify relevant Excel competitions or challenges
Register and prepare for the competition
Compete against other participants and strive for a high score
Analyze your performance and identify areas for improvement

Develop a spreadsheet to solve a real-world problem

Show steps

Applying your skills to solve a practical problem will deepen your understanding and demonstrate your ability to use Excel effectively.

Show steps

Identify a real-world problem that can be solved using Excel
Gather the necessary data and organize it in a spreadsheet
Use formulas and functions to perform calculations and analyze the data
Create charts or graphs to visualize the results
Write a brief report summarizing your findings and recommendations

Become a mentor or tutor for beginner Excel users

Show steps

Mentoring others can reinforce your own understanding and help you identify areas where you need further development.

Show steps

Identify opportunities to mentor or tutor others in Excel
Prepare materials and resources to support your mentees
Meet regularly with your mentees to guide them, answer their questions, and provide feedback

Career center

Learners who complete Habilidades de Excel para el negocio: Intermedio I will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts leverage large sets of structured and unstructured data to make sense of it and extract meaningful insights. This course would be helpful for Data Analysts because they need to be able to manage and manipulate large datasets, which is a skill that is covered in depth in this course.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial Analysts use data to make investment decisions. They need to be able to understand financial data and also be able to use Excel to analyze data and create financial models. This course would be helpful for Financial Analysts because it covers a wide range of topics that are relevant to financial analysis including data management, data analysis, and data visualization.

See salaries and explore the career path for Financial Analyst

Business Analyst

Business Analysts use data to solve business problems. They need to be able to understand the business side of things and also be able to analyze data to come up with solutions. This course would be helpful for Business Analysts because it covers a wide range of topics that are relevant to business analysis including data management, data analysis, and data visualization.

See salaries and explore the career path for Business Analyst

Operations Research Analyst

Operations Research Analysts use data to solve problems in a variety of industries, including manufacturing, healthcare, and transportation. They need to be able to understand the problem at hand and also be able to use Excel to analyze data and come up with solutions. This course would be helpful for Operations Research Analysts because it covers a wide range of topics that are relevant to operations research including data management, data analysis, and data visualization.

See salaries and explore the career path for Operations Research Analyst

Management Consultant

Management Consultants use data to help businesses improve their performance. They need to be able to understand the business side of things and also be able to analyze data to come up with solutions. This course would be helpful for Management Consultants because it covers a wide range of topics that are relevant to management consulting including data management, data analysis, and data visualization.

See salaries and explore the career path for Management Consultant

Software Engineer

Software Engineers use data to build software applications. They need to be able to understand the business side of things and also be able to use Excel to analyze data and create software applications. This course may be helpful for Software Engineers because it covers a wide range of topics that are relevant to software engineering including data management, data analysis, and data visualization.

See salaries and explore the career path for Software Engineer

Product Manager

Product Managers use data to make decisions about products. They need to be able to understand the business side of things and also be able to use Excel to analyze data and make decisions. This course may be helpful for Product Managers because it covers a wide range of topics that are relevant to product management including data management, data analysis, and data visualization.

See salaries and explore the career path for Product Manager

Chief Executive Officer

Chief Executive Officers use data to make decisions about the overall direction of the company. They need to be able to understand the business side of things and also be able to use Excel to analyze data and make decisions. This course may be helpful for Chief Executive Officers because it covers a wide range of topics that are relevant to chief executive officers including data management, data analysis, and data visualization.

See salaries and explore the career path for Chief Executive Officer

Financial Manager

Financial Managers use data to make decisions about financial matters. They need to be able to understand the business side of things and also be able to use Excel to analyze data and make decisions. This course may be helpful for Financial Managers because it covers a wide range of topics that are relevant to financial management including data management, data analysis, and data visualization.

See salaries and explore the career path for Financial Manager

Human Resources Manager

Human Resources Managers use data to make decisions about human resources matters. They need to be able to understand the business side of things and also be able to use Excel to analyze data and make decisions. This course may be helpful for Human Resources Managers because it covers a wide range of topics that are relevant to human resources management including data management, data analysis, and data visualization.

See salaries and explore the career path for Human Resources Manager

Chief Financial Officer

Chief Financial Officers use data to make decisions about the financial direction of the company. They need to be able to understand the business side of things and also be able to use Excel to analyze data and make decisions. This course may be helpful for Chief Financial Officers because it covers a wide range of topics that are relevant to chief financial officers including data management, data analysis, and data visualization.

See salaries and explore the career path for Chief Financial Officer

Marketing Manager

Marketing Managers use data to make decisions about marketing campaigns. They need to be able to understand the business side of things and also be able to use Excel to analyze data and make decisions. This course may be helpful for Marketing Managers because it covers a wide range of topics that are relevant to marketing management including data management, data analysis, and data visualization.

See salaries and explore the career path for Marketing Manager

Sales Manager

Sales Managers use data to make decisions about sales strategies. They need to be able to understand the business side of things and also be able to use Excel to analyze data and make decisions. This course may be helpful for Sales Managers because it covers a wide range of topics that are relevant to sales management including data management, data analysis, and data visualization.

See salaries and explore the career path for Sales Manager

Data Scientist

Data Scientists use data to build models that can predict future outcomes. They need to be able to understand the business side of things and also be able to use Excel to analyze data and create models. This course may be helpful for Data Scientists because it covers a wide range of topics that are relevant to data science including data management, data analysis, and data visualization.

See salaries and explore the career path for Data Scientist

Statistician

Statisticians use data to make informed decisions. They need to be able to collect, analyze, and interpret data. This course may be helpful for Statisticians because it covers a wide range of topics that are relevant to statistics including data management, data analysis, and data visualization.

See salaries and explore the career path for Statistician