We may earn an affiliate commission when you visit our partners.
Andres Rodriguez
Al final de este proyecto aprenderás cómo realizar aritméticas básicas en Excel. Te familiarizarás con 12 funciones diferentes de Excel y las utilizarás para realizar cálculos básicos. Algunas de las funciones que aprenderás cómo usar incluyen: PROMEDIO, SUMA, IF y BUSCAR. Este proyecto guiado se presenta en un formato paso a paso y será fácil de seguir.
Register for this course and see more details by visiting:
OpenCourser.com/course/1341mb/usar
What's inside
Syllabus
Visión general del proyecto
Al final de este proyecto serás capaz de utilizar funciones y fórmulas básicas en Excel para aumentar tu productividad. Utilizarás la version gratuita de Microsoft Excel para la web.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Desarrolla conocimientos básicos en Excel, incluyendo funciones y fórmulas
Es un curso guiado paso a paso, lo que lo hace fácil de seguir
Cubre funciones básicas como PROMEDIO, SUMA, SI y BUSCAR
Utiliza la versión gratuita de Microsoft Excel para la web, lo que lo hace accesible
Save this course
Save Usar Funciones y Fórmulas Básicas en 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 Usar Funciones y Fórmulas Básicas en Excel with these
activities:
Revisa el libro Microsoft Excel de John Walkenbach
Show steps
Refresca tus conocimientos sobre los conceptos básicos de Excel y familiarízate con las funciones y fórmulas utilizadas en este curso.
View
La biblia de Excel 2010
on Amazon
Show steps
-
Lee los capítulos 1-3 del libro.
-
Completa los ejercicios al final de cada capítulo.
Participa en sesiones de práctica grupales
Show steps
Colabora con tus compañeros para resolver problemas de Excel y compartir conocimientos.
Show steps
-
Únete a un grupo de estudio o foro en línea.
-
Publica preguntas y respuestas.
-
Ayuda a otros estudiantes con sus dudas.
Crea una hoja de cálculo personalizada para un propósito específico
Show steps
Diseña y crea una hoja de cálculo personalizada que automatice tareas y mejore tu productividad.
Show steps
-
Identifica un problema o necesidad que pueda resolverse mediante una hoja de cálculo.
-
Diseña la estructura de la hoja de cálculo y las fórmulas necesarias.
-
Implementa la hoja de cálculo y pruébala.
Show all three activities
Revisa el libro Microsoft Excel de John Walkenbach
Show steps
Refresca tus conocimientos sobre los conceptos básicos de Excel y familiarízate con las funciones y fórmulas utilizadas en este curso.
View
La biblia de Excel 2010
on Amazon
Show steps
Show steps
Show steps
- Lee los capítulos 1-3 del libro.
- Completa los ejercicios al final de cada capítulo.
Participa en sesiones de práctica grupales
Show steps
Colabora con tus compañeros para resolver problemas de Excel y compartir conocimientos.
Show steps
Show steps
Show steps
- Únete a un grupo de estudio o foro en línea.
- Publica preguntas y respuestas.
- Ayuda a otros estudiantes con sus dudas.
Crea una hoja de cálculo personalizada para un propósito específico
Show steps
Diseña y crea una hoja de cálculo personalizada que automatice tareas y mejore tu productividad.
Show steps
Show steps
Show steps
- Identifica un problema o necesidad que pueda resolverse mediante una hoja de cálculo.
- Diseña la estructura de la hoja de cálculo y las fórmulas necesarias.
- Implementa la hoja de cálculo y pruébala.
Show all three activities
Career center
Learners who complete Usar Funciones y Fórmulas Básicas en Excel will develop knowledge and skills
that may be useful to these careers:
Financial Analyst
Financial Analyst
As a Financial Analyst, you will need to be proficient in using Excel for various tasks such as building financial models, analyzing financial data, and creating presentations. This course will provide you with a strong foundation in Excel functions and formulas, which are essential for performing complex calculations, automating tasks, and ensuring the accuracy of your financial analysis.
Operations Research Analyst
Operations Research Analyst
This course can be beneficial for aspiring Operations Research Analysts who need to develop strong analytical skills. Excel is widely used in Operations Research to analyze data, build models, and optimize processes. By learning the basics of Excel functions and formulas, learners can gain a valuable foundation for performing complex calculations, creating visualizations, and solving business problems using quantitative methods.
Management Consultant
Management Consultant
Excel is a widely used tool in the field of Management Consulting, and this course can be beneficial for those who wish to pursue this career. By learning how to use basic Excel functions and formulas, you can develop the skills necessary to analyze data, build models, and create presentations effectively. These skills are crucial for Management Consultants who need to provide insights and recommendations to clients based on their analysis.
Product Manager
Product Manager
Excel is a valuable tool for Product Managers, and this course can provide a solid foundation for those seeking to enter this field. By learning how to use Excel functions and formulas, you can develop the skills necessary to analyze market data, track product performance, and create financial projections. These skills are essential for Product Managers who need to make informed decisions and drive product strategy.
Statistician
Statistician
Statisticians use Excel for various tasks such as data analysis, statistical modeling, and creating reports. This course can provide a helpful foundation for those aspiring to become Statisticians by introducing them to basic Excel functions and formulas. By gaining proficiency in Excel, learners can improve their ability to analyze data, develop statistical models, and communicate their findings effectively.
Sales Analyst
Sales Analyst
Sales Analysts often use Excel for tasks such as data analysis, forecasting, and creating reports. This course can provide a helpful foundation for those aspiring to become Sales Analysts by introducing them to basic Excel functions and formulas. By gaining proficiency in Excel, learners can improve their ability to analyze sales data, make accurate forecasts, and identify opportunities for growth.
Project Manager
Project Manager
Project Managers often use Excel to manage budgets, track timelines, and communicate with stakeholders. This course can provide a helpful foundation for those aspiring to become Project Managers by introducing them to basic Excel functions and formulas. By gaining proficiency in Excel, learners can improve their ability to plan, execute, and control projects effectively.
Data Analyst
Data Analyst
This course can be useful for Data Analysts as it provides a foundation in using Excel functions and formulas to manipulate, analyze, and visualize data. Data Analysts often use Excel to clean and prepare data, perform statistical analysis, and create reports and presentations. By completing this course, learners can develop the skills necessary to effectively use Excel for data analysis tasks and enhance their overall productivity.
Marketing Analyst
Marketing Analyst
This course can provide a helpful foundation for those aspiring to become Marketing Analysts. Proficiency in Excel is essential for Marketing Analysts as it allows them to analyze data, track campaign performance, and create reports to measure the effectiveness of marketing initiatives. By completing this course, learners can develop the skills necessary to confidently use Excel for marketing analysis tasks and contribute to data-driven decision-making.
Supply Chain Analyst
Supply Chain Analyst
Supply Chain Analysts often use Excel for tasks such as data analysis, inventory management, and logistics planning. This course can provide a helpful foundation for those aspiring to become Supply Chain Analysts by introducing them to basic Excel functions and formulas. By gaining proficiency in Excel, learners can improve their ability to analyze supply chain data, optimize inventory levels, and plan logistics effectively.
Risk Manager
Risk Manager
Risk Managers use Excel for various tasks such as data analysis, risk modeling, and scenario planning. This course can provide a helpful foundation for those aspiring to become Risk Managers by introducing them to basic Excel functions and formulas. By gaining proficiency in Excel, learners can improve their ability to identify, assess, and manage risks effectively.
Research Analyst
Research Analyst
Research Analysts often use Excel for data analysis, financial modeling, and creating reports. This course can provide a helpful foundation for those aspiring to become Research Analysts by introducing them to basic Excel functions and formulas. By gaining proficiency in Excel, learners can improve their ability to conduct research, analyze data, and communicate their findings effectively.
Quantitative Analyst
Quantitative Analyst
This course may be useful for aspiring Quantitative Analysts who need to develop strong analytical and problem-solving skills. Excel is widely used in Quantitative Finance for tasks such as data analysis, risk modeling, and portfolio optimization. By learning the basics of Excel functions and formulas, learners can gain a foundation for performing complex calculations, creating visualizations, and solving quantitative problems.
Teacher
Teacher
This course may be useful for Teachers who wish to incorporate Excel into their teaching. Excel can be a valuable tool for creating interactive lessons, analyzing student data, and managing classroom activities. By completing this course, Teachers can develop the skills necessary to effectively use Excel in their classrooms and enhance the learning experience for their students.
Business Analyst
Business Analyst
Considering that this course is meant to equip learners with basic Excel functions and formulas, it may be useful for Business Analysts who need to analyze data and make recommendations based on their findings. Proficiency in Excel is a valuable skill for Business Analysts as it allows them to perform complex calculations, create visualizations, and automate tasks, which can enhance their efficiency and improve the quality of their analyses.
For more career information including salaries, visit:
OpenCourser.com/course/1341mb/usar
Reading list
We've selected ten 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
Usar Funciones y Fórmulas Básicas en Excel.
Explora en profundidad las funciones y fórmulas de Excel, ofreciendo una guía integral para usuarios intermedios y avanzados que buscan ampliar sus conocimientos y habilidades.
Se enfoca en fórmulas y funciones prácticas de Excel, proporcionando ejemplos y estudios de casos del mundo real que mejoran la comprensión y la capacidad de resolución de problemas de los usuarios.
Save
Amplía el curso al cubrir técnicas avanzadas de análisis de datos en Excel, proporcionando información sobre el uso de funciones y fórmulas para extraer información valiosa de conjuntos de datos.
Amplía el curso al cubrir herramientas avanzadas de análisis de datos como Power Pivot y Power BI, lo que permite a los usuarios analizar y visualizar grandes conjuntos de datos de manera eficiente.
Complementa el curso al proporcionar una guía para crear paneles e informes dinámicos en Excel, lo que permite a los usuarios visualizar y comunicar datos de manera efectiva.
Sirve como una guía paso a paso completa para Excel 2019, cubriendo funciones y fórmulas básicas en un formato fácil de seguir, lo que lo hace adecuado para principiantes y estudiantes.
Proporciona una introducción a la creación de modelos en Excel, que amplía el curso al cubrir técnicas para desarrollar modelos financieros y comerciales efectivos utilizando funciones y fórmulas.
Save
Ofrece consejos y trucos prácticos para optimizar el uso de Excel, incluyendo el uso eficiente de funciones y fórmulas, lo que mejora la productividad y la eficiencia de los usuarios.
Aunque está dirigido a contadores, este libro ofrece información valiosa sobre el uso de funciones y fórmulas de Excel en un contexto financiero, lo que puede ser beneficioso para los usuarios que buscan aplicar Excel en el campo de la contabilidad.
Aunque el curso no cubre VBA, este libro ofrece una guía completa para desarrollar macros y aplicaciones personalizadas en Excel, lo que permite a los usuarios automatizar tareas y ampliar la funcionalidad de Excel.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/1341mb/usar
Share
Similar courses
Here are nine courses similar to
Usar Funciones y Fórmulas Básicas en Excel.
Usar Funciones de Búsqueda, Matemáticas y Texto en Excel
OpenCourser.com/course/ni6jpn/usar
Usar Funciones de Búsqueda, Matemáticas y Texto en Excel
Most relevant
Usar Funciones de Fecha y Hora en Excel
OpenCourser.com/course/xx5mwg/usar
Usar Funciones de Fecha y Hora en Excel
Most relevant
Usar fórmulas y funciones básicas en Microsoft Excel
OpenCourser.com/course/ji1u45/usar
Usar fórmulas y funciones básicas en Microsoft Excel
Most relevant
Excel: Fundamentos y herramientas
OpenCourser.com/course/04sod0/excel
Excel: Fundamentos y herramientas
Most relevant
Introducción a Microsoft Excel
OpenCourser.com/course/cd05zh/introduccion
Introducción a Microsoft Excel
Most relevant
Crear una calculadora de pago de hipoteca en Google Sheets
OpenCourser.com/course/6e3imr/crear
Crear una calculadora de pago de hipoteca en Google Sheets
Most relevant
Prototipos en Adobe InDesign: Incorporar interactividad
OpenCourser.com/course/juvsk8/prototipos
Prototipos en Adobe InDesign: Incorporar interactividad
Most relevant
Conceptos Básicos de Excel para el Análisis de Datos
OpenCourser.com/course/y54rs9/conceptos
Conceptos Básicos de Excel para el Análisis de Datos
Most relevant
Analizar datos para responder preguntas
OpenCourser.com/course/bhr4dh/analizar
Analizar datos para responder preguntas
Most relevant
Effort
2 horas
Level
Introductory
Via
Coursera
Institution
Coursera Project Network
Instructor
Andres Rodriguez
Language
Español
Good to know
Desarrolla conocimientos básicos en Excel, incluyendo funciones y fórmulas
Es un curso guiado paso a paso, lo que lo hace fácil de seguir
Cubre funciones básicas como PROMEDIO, SUMA, SI y BUSCAR
Utiliza la versión gratuita de Microsoft Excel para la web, lo que lo hace accesible
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