We may earn an affiliate commission when you visit our partners.
Course image
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

What's inside

Syllabus

Visión general del proyecto
En este proyecto, aprenderá a crear gráficos y paneles en Microsoft Excel utilizando datos de ventas de una empresa de ejemplo.

Good to know

Know what's good
, what to watch for
, 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

Save Crear Gráficos y Paneles con Microsoft Excel to your list so you can find it easily later:
Save

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

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

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Crear Gráficos y Paneles con Microsoft Excel.
Excel: Creación de un panel gráfico de control empresarial
Most relevant
Excel: gestión de datos
Most relevant
Informes de ventas con HubSpot
Most relevant
Diseño de sistemas de información gerencial para intranet...
Most relevant
Google Sheets - Advanced Topics en español
Most relevant
Creación de Tablas de Base de Datos con SQL
Most relevant
Presentaciones en Canva: crea una presentación de ventas
Most relevant
Excel avanzado: importación y análisis de datos
Most relevant
Google Slides en Español
Most relevant
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 - 2024 OpenCourser