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

Usar fórmulas y funciones básicas en Microsoft Excel

Paula Del Rey

¿Ha comenzado a utilizar hojas de cálculo como Excel y desea aprender a escribir fórmulas y funciones para realizar análisis de datos simples? En este proyecto, aprenderá sobre el formato general para escribir fórmulas y funciones en Excel para realizar análisis de los datos de ventas de una empresa de ejemplo. En este análisis, calculará sumas totales de ganancias, aprenderá a utilizar funciones para analizar la popularidad de los artículos vendidos y también aprenderá a calcular promedios y porcentajes de ganancias mensuales. A lo largo del proyecto, trabajará con algunos ejemplos que le mostrarán cómo aplicar las fórmulas y funciones que ha aprendido.

Enroll now

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 December 2
Annual Subscription
Invest in your career growth and save. Start your annual subscription to Coursera Plus and access 10,000+ programs.
Take
40%
off
Get offer
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
Este curso es adecuado para personas que recién comienzan a utilizar hojas de cálculo como Excel y desean aprender a usar fórmulas y funciones para un análisis de datos simple
El curso está diseñado para ayudar a los estudiantes a calcular sumas totales de ganancias, analizar la popularidad de los artículos vendidos y calcular promedios y porcentajes de ganancias mensuales
Los ejemplos proporcionados en el curso ayudarán a los estudiantes a comprender cómo aplicar las fórmulas y funciones que han aprendido

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Dominando excel básico para análisis de datos

Según los estudiantes, este curso de Excel es una introducción excelente y práctica a las fórmulas y funciones básicas. Muchos lo recomiendan por sus explicaciones claras y concisas, así como por los ejemplos prácticos y demostraciones paso a paso que facilitan la aplicación inmediata de los conocimientos, especialmente en el ámbito profesional. El instructor es elogiado por su metodología didáctica. Sin embargo, algunos consideran que el contenido es demasiado básico para usuarios con experiencia previa, sugiriendo una profundidad limitada en temas más avanzados. La velocidad del curso es ideal para principiantes, pero puede ser lenta para otros. En general, proporciona una base sólida para el uso fundamental de Excel.
Algunas capturas de pantalla de Excel parecen ser de versiones anteriores.
"Lo único que noté es que algunas capturas de pantalla de Excel parecían de una versión ligeramente anterior, pero no afectó la comprensión."
"Aunque el contenido es atemporal, las imágenes podrían actualizarse para reflejar la interfaz más reciente de Excel."
El instructor explica con didáctica, paciencia y de forma concisa.
"Las explicaciones son muy claras y concisas..."
"El instructor tiene una forma de explicar muy didáctica y paciente."
"Las explicaciones sobre cómo funciona cada parte de la fórmula fueron muy esclarecedoras."
Ofrece demostraciones y ejercicios útiles para aplicar en el trabajo.
"...los ejemplos prácticos realmente ayudan a consolidar el aprendizaje. Las demostraciones paso a paso me permitieron seguir fácilmente y aplicar lo aprendido de inmediato en mi trabajo."
"Los ejercicios prácticos son clave y me permitieron entender la lógica detrás de las fórmulas."
"Un curso muy directo y al grano. Aprendí exactamente lo que necesitaba para mis tareas diarias. El enfoque en datos de ventas de ejemplo lo hizo muy relevante."
Ideal para quienes inician en Excel, con explicaciones paso a paso.
"Este curso es excelente para quienes empiezan con Excel. Las explicaciones son muy claras y concisas..."
"Me encantó este curso. Pasé de no saber nada de Excel a sentirme cómodo usando SUMA, PROMEDIO y CONTAR."
"Este es el curso perfecto para principiantes absolutos en Excel. Todo está explicado paso a paso sin asumir conocimientos previos."
"Es bueno para el que empieza de cero, pero para los demás, se queda corto."
Podría beneficiarse de más ejercicios para una aplicación independiente.
"Las instrucciones son claras, pero creo que podría beneficiarse de más ejercicios para practicar. A veces sentí que solo miraba al instructor sin poder aplicar tanto por mi cuenta."
"Aunque las demostraciones son buenas, me gustaría tener más oportunidades de aplicar las fórmulas por mi cuenta."
No es adecuado para usuarios con experiencia previa en Excel.
"Mi única crítica es que me gustaría que incluyera algunos temas un poco más avanzados, ya que sentí que el material era demasiado básico..."
"Es un curso decente para aprender lo muy básico. Lo encontré útil para repasar, pero si ya tienes algo de experiencia con Excel, la velocidad puede ser un poco lenta."
"Para ser sincero, esperaba más. Aunque cubre las bases, sentí que la profundidad es limitada. Quizás no era el curso adecuado para mí, ya que buscaba algo más allá de lo elemental."

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 fórmulas y funciones básicas en Microsoft Excel with these activities:
Join a study group or online forum for Excel
Connect with fellow learners to share knowledge, ask questions, and improve your understanding
Show steps
  • Search for Excel study groups or online forums
  • Join the group or forum and actively participate in discussions
  • Ask questions, share your insights, and help others
Review spreadsheet formulas and functions
Brush up on your Excel formulas and functions to strengthen your foundation for this course
Browse courses on Excel Formulas
Show steps
  • Go through your notes or review online tutorials on Excel formulas
  • Practice using formulas and functions in a spreadsheet
Follow tutorials on data analysis in Excel
Enhance your data analysis skills by exploring tutorials that demonstrate practical applications in Excel
Show steps
  • Search for tutorials on data analysis in Excel
  • Follow the steps and instructions provided in the tutorials
  • Apply the techniques you learn to your own data analysis tasks
Show all three activities

Career center

Learners who complete Usar fórmulas y funciones básicas en Microsoft Excel will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data Analysts collect, analyze, and interpret data to help businesses make informed decisions. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to perform simple data analysis. You will learn how to calculate sums, averages, and percentages, and how to use functions to analyze data and identify trends.
See salaries and explore the career path for Data Analyst
Financial Analyst
Financial Analysts use financial data to make recommendations to businesses and investors. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to perform financial analysis. You will learn how to calculate financial ratios, analyze financial statements, and forecast financial performance.
See salaries and explore the career path for Financial Analyst
Business Analyst
Business Analysts use data to identify and solve business problems. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to analyze business data. You will learn how to identify trends, develop solutions, and communicate your findings to stakeholders.
See salaries and explore the career path for Business Analyst
Market Analyst
Market Analysts use data to understand market trends and make recommendations to businesses. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to analyze market data. You will learn how to identify customer segments, analyze market trends, and forecast market demand.
See salaries and explore the career path for Market Analyst
Operations Analyst
Operations Analysts use data to improve the efficiency and effectiveness of business operations. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to analyze operational data. You will learn how to identify bottlenecks, develop solutions, and track progress.
See salaries and explore the career path for Operations Analyst
Project Manager
Project Managers use data to plan, execute, and track projects. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to manage project data. You will learn how to create project plans, track progress, and identify risks.
See salaries and explore the career path for Project Manager
Sales Analyst
Sales Analysts use data to analyze sales performance and identify opportunities for growth. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to analyze sales data. You will learn how to identify trends, develop sales strategies, and forecast sales performance.
See salaries and explore the career path for Sales Analyst
Marketing Manager
Marketing Managers use data to develop and execute marketing campaigns. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to analyze marketing data. You will learn how to identify customer segments, develop marketing campaigns, and track campaign performance.
See salaries and explore the career path for Marketing Manager
Product Manager
Product Managers use data to develop and launch new products. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to analyze product data. You will learn how to identify customer needs, develop product specifications, and track product performance.
See salaries and explore the career path for Product Manager
Financial Advisor
Financial Advisors use data to help clients make informed investment decisions. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to analyze financial data. You will learn how to calculate financial ratios, analyze financial statements, and develop investment strategies.
See salaries and explore the career path for Financial Advisor
Auditor
Auditors use data to ensure that financial statements are accurate and reliable. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to analyze financial data. You will learn how to identify errors, develop audit procedures, and report audit findings.
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 can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to analyze tax data. You will learn how to calculate taxes, prepare tax returns, and advise clients on tax matters.
See salaries and explore the career path for Tax Accountant
Management Consultant
Management Consultants use data to help businesses improve their performance. This course can help you develop the skills needed to succeed in this role by teaching you how to use formulas and functions in Microsoft Excel to analyze business data. You will learn how to identify problems, develop solutions, and communicate your findings to stakeholders.
See salaries and explore the career path for Management Consultant
Data Scientist
Data Scientists use data to build models and solve business problems. This course may help you build a foundation for a career in this field by introducing you to the basics of data analysis. You will learn how to use formulas and functions in Microsoft Excel to analyze data and identify trends.
See salaries and explore the career path for Data Scientist
Statistician
Statisticians use data to collect, analyze, and interpret data. This course may help you build a foundation for a career in this field by introducing you to the basics of data analysis. You will learn how to use formulas and functions in Microsoft Excel to analyze data and identify trends.
See salaries and explore the career path for Statistician

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 Usar fórmulas y funciones básicas en Microsoft Excel.
Cover image
Microsoft Excel Data Analysis and Business Modeling...
Save
Este libro integral aborda los fundamentos de las hojas de cálculo y proporciona una guía completa sobre el uso de Microsoft Excel para el análisis de datos, el modelado y la toma de decisiones.
(English) Microsoft Excel Data Analysis and Business Modeling...
Paperback
$$
(English) Microsoft Excel Data Analysis and Business Modeling...
Kindle Edition
$$
Cover image
Power Pivot and Power Bi: The Excel User's Guide to...
Save
Esta guía práctica aborda PowerPivot y Power BI, herramientas de Microsoft Excel para modelar datos y crear informes de inteligencia empresarial. Cubre técnicas de modelado, visualización de datos y publicación de informes.
(English) Power Pivot and Power BI: The Excel User's Guide to...
Paperback
$$
(English) Power Pivot and Power BI: The Excel User's Guide to...
Kindle Edition
$$
Cover image
Microsoft Excel Pivot Table Data Crunching (Office...
Save
Este libro se centra en la creación de paneles e informes impactantes y efectivos con Microsoft Excel. Cubre técnicas de diseño, visualización de datos y automatización.
(English) Microsoft Excel Pivot Table Data Crunching (Office...
Paperback
$$
(English) Microsoft Excel Pivot Table Data Crunching (Office...
Kindle Edition
$$
Cover image
Excel Formulas & Functions For Dummies
Save
Esta guía fácil de seguir se centra en el uso de fórmulas y funciones en Microsoft Excel. Proporciona explicaciones claras, ejemplos prácticos y consejos de resolución de problemas.
(English) Excel Formulas & Functions For Dummies (For Dummies...
Paperback
$$
(English) Excel Formulas And Functions Fd, 5e (For Dummies)
Paperback
$$
(English) Excel Formulas and Functions FD 4e (For Dummies)
Paperback
$$
(English) Excel Formulas and Functions For Dummies
Paperback
$$$
(English) Excel Formulas & Functions For Dummies
Kindle Edition
$$
Cover image
Microsoft Office Step by Step (Office 2021 and...
Save
Esta guía paso a paso proporciona instrucciones claras y detalladas sobre cómo utilizar las funciones y características de Microsoft Excel 2019, incluyendo fórmulas y funciones básicas.
(English) Microsoft Excel Step by Step (Office 2021 and...
Paperback
$$
(English) Microsoft Office Step by Step (Office 2021 and...
Paperback
$$
(English) Microsoft Excel Step by Step (Office 2021 and...
Kindle Edition
$$
(English) Microsoft Office Step by Step (Office 2021 and...
Kindle Edition
$$
Cover image
Don't Fear the Spreadsheet
Save
Esta guía paso a paso ayuda a los principiantes a crear macros y utilizar Visual Basic for Applications (VBA) en Microsoft Excel. Cubre conceptos básicos, ejemplos prácticos y técnicas de resolución de problemas.
(English) Don't Fear the Spreadsheet: A Beginner's Guide to...
Kindle Edition
$

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 Usar fórmulas y funciones básicas en Microsoft Excel.
Analyze Data to Answer Questions
Most relevant
Excel Basics for Data Analysis
Most relevant
Google Sheets - The Comprehensive Masterclass
Most relevant
Introduction to Microsoft Excel
Most relevant
Pivot Tables in Google Sheets
Most relevant
Google Sheets - A Complete course from Scratch
Most relevant
Excel Essentials: The Complete Excel Series - Level 1, 2...
Most relevant
Microsoft Excel - Excel from Beginner to Advanced
Most relevant
Microsoft Excel 2024 - From Beginner to Expert in 6 Hours
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
Introductory
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
Este curso es adecuado para personas que recién comienzan a utilizar hojas de cálculo como Excel y desean aprender a usar fórmulas y funciones para un análisis de datos simple
El curso está diseñado para ayudar a los estudiantes a calcular sumas totales de ganancias, analizar la popularidad de los artículos vendidos y calcular promedios y porcentajes de ganancias mensuales
Los ejemplos proporcionados en el curso ayudarán a los estudiantes a comprender cómo aplicar las fórmulas y funciones que han aprendido
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 Usar fórmulas y funciones básicas en 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