We may earn an affiliate commission when you visit our partners.
Paula Del Rey
En este proyecto, aprenderá a crear gráficos en Microsoft Excel para analizar los datos de ventas de una empresa de ejemplo. Aprenderá a crear tablas dinámicas para evaluar diferentes aspectos de la información de ventas y representar la información de las tablas como gráficos de líneas, barras y circulares. Al crear los gráficos, aprenderá a formatearlos para que se puedan interpretar fácilmente y luego combinará los gráficos en un panel para proporcionar una visión global de los datos de ventas.
Register for this course and see more details by visiting:
OpenCourser.com/course/9b93id/crear
Two deals to help you save
Save money when you learn. Here are two deals and offers that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until July 14
Coursera Plus Annual
Work toward what's next for your career with access to 10,000+ programs. Discover emerging skills and save.
Up to
40%
off
Get offer
Valid until August 30
Google AI App Builder
Learn how to use Gemini API and API Studio with a three-course series from Google DeepMind
Take
100%
off
Get offer
What's inside
Syllabus
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Fortalece los fundamentos de los conocimientos en el análisis de datos de ventas
Proporciona una comprensión integral de las tablas dinámicas y los gráficos para el análisis de datos
Adecuado para principiantes que buscan desarrollar habilidades en análisis de datos de ventas
El curso no menciona requisitos previos específicos, lo que sugiere que puede ser accesible para una amplia gama de estudiantes
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Excel: gráficos y paneles prácticos
Según los estudiantes, este curso de Excel es excelente para comprender y aplicar la creación de gráficos y paneles. Los alumnos destacan la claridad y paciencia del instructor, así como los ejemplos y proyectos prácticos y realistas que facilitan la aplicación directa de lo aprendido en el ámbito profesional, especialmente para organizar y visualizar datos de ventas. Es ideal para principiantes y para quienes buscan un refresco de conocimientos. Sin embargo, algunos comentan que, si ya se tiene experiencia, el contenido puede ser demasiado básico y no profundizar en técnicas avanzadas de visualización o gráficos interactivos.
Existen opiniones divididas sobre el ritmo del curso, dependiendo del nivel de experiencia previo.
"Muy buen curso... algunas partes se sienten un poco rápidas si no tienes ninguna base en Excel."
"El curso cumple, pero lo encontré un poco lento al principio. Esperaba más sobre Excel avanzado."
"Me pareció muy básico y el instructor hablaba un poco rápido para mí."
Es muy valorado por su idoneidad para quienes se inician o buscan reforzar conceptos básicos.
"Un curso fantástico... Es ideal para principiantes y para quienes quieren refrescar conocimientos."
"Para alguien que empieza de cero está bien, pero no profundiza en técnicas avanzadas de visualización."
"Bueno para empezar, cubre lo esencial. La estructura es buena y fácil de seguir."
Valoran la habilidad del instructor para explicar conceptos complejos de forma sencilla y efectiva.
"El instructor explica de manera muy clara y los ejemplos prácticos son super útiles para aplicar lo aprendido en el trabajo."
"Maravilloso curso. El instructor es paciente y explica todo con ejemplos claros. Los ejercicios prácticos son clave."
"Excelente. Justo lo que necesitaba para mi trabajo. Los videos son concisos y los materiales descargables son un gran apoyo."
El curso se enfoca en habilidades directamente aplicables, ideal para el desarrollo profesional.
"Me encantó cómo enseña a usar las tablas dinámicas, algo que siempre me había costado."
"Un curso fantástico. Los proyectos son muy realistas y te guían paso a paso. Aprendí a crear informes interactivos que ahora uso en mi empresa."
"El contenido es relevante y el enfoque práctico es lo mejor. Los paneles quedan muy profesionales."
"Ahora puedo hacer mis propios dashboards de ventas sin problemas."
No profundiza en técnicas avanzadas, lo que puede ser limitante para usuarios experimentados.
"Es un curso básico. Si ya tienes experiencia con Excel y tablas dinámicas, quizás te resulte repetitivo. No profundiza en técnicas avanzadas de visualización."
"Lo encontré un poco lento al principio. Esperaba más sobre Excel avanzado."
"Me pareció muy básico y el instructor hablaba un poco rápido para mí. Esperaba más profundidad en los gráficos interactivos."
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 Crear Gráficos y Paneles con Microsoft Excel with these
activities:
Complete 3 Tutorials on Advanced Pivot Table Features
Show steps
These tutorials will supplement the course and provide you with more resources on creating advanced pivot tables
Show steps
-
Find and follow the first tutorial on advanced pivot table features
-
Find and follow the second tutorial on advanced pivot table features
-
Find and follow the third tutorial on advanced pivot table features
Create a Visual Dashboard Using Excel Data
Show steps
Creating a visual dashboard is a highly relevant activity that will showcase your skills in data analysis
Show steps
-
Finalize the format of your dashboard
-
Select the data that you want to include in your dashboard
-
Create graphs and charts to represent your data
Show all two activities
Complete 3 Tutorials on Advanced Pivot Table Features
Show steps
These tutorials will supplement the course and provide you with more resources on creating advanced pivot tables
Show steps
Show steps
Show steps
- Find and follow the first tutorial on advanced pivot table features
- Find and follow the second tutorial on advanced pivot table features
- Find and follow the third tutorial on advanced pivot table features
Create a Visual Dashboard Using Excel Data
Show steps
Creating a visual dashboard is a highly relevant activity that will showcase your skills in data analysis
Show steps
Show steps
Show steps
- Finalize the format of your dashboard
- Select the data that you want to include in your dashboard
- Create graphs and charts to represent your data
Show all two activities
Career center
Learners who complete Crear Gráficos y Paneles con Microsoft Excel will develop knowledge and skills
that may be useful to these careers:
Chart Analyst
Chart Analyst
Chart Analysts help businesses make data-driven decisions by creating and interpreting charts and graphs. This course teaches you how to use Microsoft Excel to create clear and concise charts that can help you communicate your findings to stakeholders. If you are interested in a career as a Chart Analyst, this course can help you develop the skills you need to succeed.
Data Analyst
Data Analyst
Data Analysts use data to solve business problems. This course teaches you how to use Microsoft Excel to analyze data and identify trends. If you are interested in a career as a Data Analyst, this course can help you develop the skills you need to succeed.
Business Analyst
Business Analyst
Business Analysts use data to improve business processes. This course teaches you how to use Microsoft Excel to analyze data and make recommendations for improvement. If you are interested in a career as a Business Analyst, this course can help you develop the skills you need to succeed.
Financial Analyst
Financial Analyst
Financial Analysts use data to make investment decisions. This course teaches you how to use Microsoft Excel to analyze financial data and make recommendations for investment. If you are interested in a career as a Financial Analyst, this course can help you develop the skills you need to succeed.
Operations Analyst
Operations Analyst
Operations Analysts use data to improve operational efficiency. This course teaches you how to use Microsoft Excel to analyze data and make recommendations for improvement. If you are interested in a career as an Operations Analyst, this course can help you develop the skills you need to succeed.
Marketing Analyst
Marketing Analyst
Marketing Analysts use data to improve marketing campaigns. This course teaches you how to use Microsoft Excel to analyze data and make recommendations for improvement. If you are interested in a career as a Marketing Analyst, this course can help you develop the skills you need to succeed.
Sales Analyst
Sales Analyst
Sales Analysts use data to improve sales performance. This course teaches you how to use Microsoft Excel to analyze data and make recommendations for improvement. If you are interested in a career as a Sales Analyst, this course can help you develop the skills you need to succeed.
Risk Analyst
Risk Analyst
Risk Analysts use data to identify and mitigate risks. This course teaches you how to use Microsoft Excel to analyze data and make recommendations for risk management. If you are interested in a career as a Risk Analyst, this course can help you develop the skills you need to succeed.
Auditor
Auditor
Auditors use data to ensure that businesses are operating in compliance with laws and regulations. This course teaches you how to use Microsoft Excel to analyze data and identify areas of non-compliance. If you are interested in a career as an Auditor, this course can help you develop the skills you need to succeed.
Tax Accountant
Tax Accountant
Tax Accountants use data to prepare tax returns and advise clients on tax matters. This course teaches you how to use Microsoft Excel to analyze data and make recommendations for tax planning. If you are interested in a career as a Tax Accountant, this course can help you develop the skills you need to succeed.
Financial Planner
Financial Planner
Financial Planners use data to help clients achieve their financial goals. This course teaches you how to use Microsoft Excel to analyze data and make recommendations for investment and retirement planning. If you are interested in a career as a Financial Planner, this course can help you develop the skills you need to succeed.
Insurance Agent
Insurance Agent
Insurance Agents use data to help clients choose the right insurance policies. This course teaches you how to use Microsoft Excel to analyze data and make recommendations for insurance coverage. If you are interested in a career as an Insurance Agent, this course can help you develop the skills you need to succeed.
Loan Officer
Loan Officer
Loan Officers use data to help clients get loans. This course teaches you how to use Microsoft Excel to analyze data and make recommendations for loan approval. If you are interested in a career as a Loan Officer, this course can help you develop the skills you need to succeed.
Property Manager
Property Manager
Property Managers use data to manage properties. This course teaches you how to use Microsoft Excel to analyze data and make recommendations for property management. If you are interested in a career as a Property Manager, this course can help you develop the skills you need to succeed.
Healthcare Administrator
Healthcare Administrator
Healthcare Administrators use data to manage healthcare organizations. This course teaches you how to use Microsoft Excel to analyze data and make recommendations for healthcare administration. If you are interested in a career as a Healthcare Administrator, this course can help you develop the skills you need to succeed.
For more career information including salaries, visit:
OpenCourser.com/course/9b93id/crear
Reading list
We've selected six books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Crear Gráficos y Paneles con Microsoft Excel.
Save
Este libro proporciona una guía completa para la creación y el uso de gráficos y paneles en Microsoft Excel. Cubre temas como la selección del tipo de gráfico correcto, el formateo y la personalización de los gráficos y la combinación de gráficos en paneles.
Este libro proporciona instrucciones paso a paso sobre cómo crear y utilizar paneles e informes en Microsoft Excel. Cubre temas como la creación de paneles, el uso de gráficos y tablas y la personalización de paneles e informes.
Save
Este libro proporciona una introducción completa a la visualización de datos. Cubre temas como los diferentes tipos de gráficos, cómo elegir el gráfico correcto y cómo diseñar gráficos efectivos.
Este libro proporciona una introducción completa a Tableau, una herramienta de visualización de datos popular. Cubre temas como la conexión a datos, la creación de gráficos y paneles, y el uso de Tableau para el análisis de datos.
Esta guía proporciona instrucciones completas sobre cómo crear y utilizar tablas dinámicas en Microsoft Excel. Cubre temas como la creación de tablas dinámicas, el filtrado y ordenación de datos y el uso de tablas dinámicas para el análisis de datos.
Este libro es un recurso integral para aprender Microsoft Excel. Cubre una amplia gama de temas, desde funciones y fórmulas básicas hasta técnicas avanzadas de análisis de datos.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/9b93id/crear
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser