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
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
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
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
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.
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.
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.
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.
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.
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.
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.
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
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
OpenCourser.com/course/avii4v/excel
Excel: Creación de un panel gráfico de control empresarial
Most relevant
Excel: gestión de datos
OpenCourser.com/course/7mo82i/excel
Excel: gestión de datos
Most relevant
Informes de ventas con HubSpot
OpenCourser.com/course/loikqa/informes
Informes de ventas con HubSpot
Most relevant
Diseño de sistemas de información gerencial para intranet con Microsoft Access
OpenCourser.com/course/tubo35/diseno
Diseño de sistemas de información gerencial para intranet...
Most relevant
Google Sheets - Advanced Topics en español
OpenCourser.com/course/sogcsu/google
Google Sheets - Advanced Topics en español
Most relevant
Creación de Tablas de Base de Datos con SQL
OpenCourser.com/course/h4cjc8/creacion
Creación de Tablas de Base de Datos con SQL
Most relevant
Presentaciones en Canva: crea una presentación de ventas
OpenCourser.com/course/gleec7/presentaciones
Presentaciones en Canva: crea una presentación de ventas
Most relevant
Excel avanzado: importación y análisis de datos
OpenCourser.com/course/l5594p/excel
Excel avanzado: importación y análisis de datos
Most relevant
Google Slides en Español
OpenCourser.com/course/25hnm3/google
Google Slides en Español
Most relevant
Effort
2 horas
Level
Intermediate
Via
Coursera
Institution
Coursera Project Network
Instructor
Paula Del Rey
Language
Español
Good to know
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
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