OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Course image
Coursera logo

Crear Gráficos y Paneles con Microsoft Excel

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.

Enroll now

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until March 12, 2027
Save 40% Off 3 Months
Access thousands of top-rated learning programs with a Coursera Plus monthly subscription and take 40% off 3 months for a limited time.
Take
40%
off
Get offer

What's inside

Syllabus

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

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
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
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

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 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.
See salaries and explore the career path for Chart 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.
See salaries and explore the career path for Data 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.
See salaries and explore the career path for Business 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.
See salaries and explore the career path for Financial 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.
See salaries and explore the career path for Operations 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.
See salaries and explore the career path for Marketing 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.
See salaries and explore the career path for Sales 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.
See salaries and explore the career path for Risk Analyst
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.
See salaries and explore the career path for Auditor
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.
See salaries and explore the career path for Tax Accountant
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.
See salaries and explore the career path for Financial Planner
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.
See salaries and explore the career path for Insurance Agent
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.
See salaries and explore the career path for Loan Officer
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.
See salaries and explore the career path for Property Manager
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.
See salaries and explore the career path for Healthcare Administrator

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.
Cover image
Excel 2019 Bible
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.
(English) Excel 2019 Bible
Paperback
$$
(English) Excel 2019 Bible
Kindle Edition
$$
Cover image
Excel Dashboards & Reports For Dummies
Save
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.
(English) Excel Dashboards & Reports For Dummies (For Dummies...
Paperback
$$
(English) Excel Dashboards & Reports for Dummies
Paperback
$$
(English) Excel Dashboards & Reports for Dummies
Paperback
$$
(English) Excel Dashboards & Reports For Dummies
Kindle Edition
$$
Cover image
Data Visualization
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.
(English) Data Visualization: A Successful Design Process: A...
Paperback
$
(English) Data Visualization: Representing Information on...
Kindle Edition
$$$
(English) Data Visualization Design and Utilization (Korean...
Paperback
$$$
Cover image
Tableau Desktop Pocket Reference
Save
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.
(English) Tableau Desktop Pocket Reference: Essential...
Paperback
$$
(English) Tableau Desktop Pocket Reference: Essential...
Kindle Edition
$$
Cover image
Microsoft Excel VBA and Macros (Office 2021 and...
Save
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.
(English) Microsoft Excel VBA and Macros (Office 2021 and...
Paperback
$$
(English) Microsoft Excel VBA and Macros (Office 2021 and...
Kindle Edition
$$
Cover image
Microsoft Office 2010 with Microsoft Office 2010...
Save
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.
(English) Microsoft Office 2010 with Microsoft Office 2010...
Spiral-bound
$$
Exam 77-883 Microsoft PowerPoint 2010, with...
Mass Market Paperback
$$$$
(English) Set: Access 2010 with Microsoft Office 2010...
Paperback
$$$
(English) Exam 77-885 Microsoft Access 2010 with Microsoft...
Paperback
$$$$
(English) Exam 77-885 Microsoft Access 2010 with Microsoft...
Paperback
$$$$
(English) Exam 77-885 Microsoft Access 2010 with Microsoft...
Paperback
$$$$
(English) Exam 77-885 Microsoft Access 2010 with Microsoft...
Paperback
$$$$
(English) Exam 77-885 Microsoft Access 2010 with Microsoft...
Paperback
$$$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Crear Gráficos y Paneles con Microsoft Excel.
Conditional Formatting, Tables and Charts in Microsoft...
Most relevant
Master in Microsoft Power BI Desktop and Service
Most relevant
Create Charts and Dashboards Using Microsoft Excel
Most relevant
Master Excel Advanced Functions and Analytics
Most relevant
Learn ggplot2 in R for Data Visualization
Most relevant
Tableau A-Z: Hands-On Tableau Training for Data Science
Most relevant
Microsoft Excel for Mac - Office 365 on Mac OS
Most relevant
Microsoft Copilot for Excel: AI-Powered Data Analysis
Most relevant
Complete Introduction to Business Data Analysis
Most relevant

Coursera Buyer Protection & Guarantee

Verified partner policies & purchase protections

Accredited University Partner
Free Trial & Audit

7-Day Free Trial & Free Audit

7-day free trial on monthly Coursera Plus subscriptions; free audit option available on most individual courses to explore video lectures and readings at no charge.

Return & Refund Policy

14-Day Refund Guarantee

14-day refund window on annual Coursera Plus subscriptions and single-course purchases prior to certificate issuance. Monthly subscriptions do not offer refunds once billed.

Buyer Protections

Verified Academic & Industry Partner

Accredited university and industry certifications (e.g. Stanford, Google, IBM, Yale), secure SSL payment processing, and verifiable digital certificate links.

Key Purchase Protections
14-day refund window on annual Coursera Plus and single courses
7-day free trial on monthly Coursera Plus subscriptions
Free course audit option for lectures and readings
Verified certificates from top universities & companies
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Effort
2 horas
Level
Intermediate
Via
Coursera
Institution
Coursera Project Network
Instructor
Paula Del Rey
Language
Español
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
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to Crear Gráficos y Paneles con Microsoft Excel.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
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