Domine funciones avanzadas de Google Sheets: formato condicional, fórmulas complejas, visualización de datos y integración con Formularios de Google.
Domine funciones avanzadas de Google Sheets: formato condicional, fórmulas complejas, visualización de datos y integración con Formularios de Google.
This course cannot be purchased separately - to access the complete learning experience, graded assignments, and earn certificates, you'll need to enroll in the full Getting Started with Google Workspace en Español Specialization program. You can audit this specific course for free to explore the content, which includes access to course materials and lectures. This allows you to learn at your own pace without any financial commitment.
4.8
(57 ratings)
1,579 already enrolled
Instructors:
Spanish
English
What you'll learn
Aplicar formato avanzado y condicional en hojas de cálculo de Google
Crear y utilizar fórmulas complejas con funciones como IF e IFS para análisis de datos
Implementar validación de datos y rangos con nombre para mejorar la integridad de los datos
Generar visualizaciones efectivas mediante gráficos y tablas dinámicas
Integrar hojas de cálculo con otras aplicaciones de Google Workspace
Automatizar tareas repetitivas utilizando macros
Skills you'll gain
This course includes:
0.7 Hours PreRecorded video
4 assignments
Access on Mobile, Tablet, Desktop
FullTime access
Shareable certificate
Closed caption
Get a Completion Certificate
Share your certificate with prospective employers and your professional network on LinkedIn.
Created by
Provided by

Top companies offer this course to their employees
Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.





There are 6 modules in this course
Este curso avanzado de Google Sheets expande los conceptos básicos previamente cubiertos, enfocándose en características y técnicas sofisticadas para análisis de datos y visualización. El programa está estructurado en módulos progresivos que cubren formato avanzado con temas personalizados y formato condicional, fórmulas y funciones complejas como IF e IFS, validación de datos y rangos con nombre, visualización de datos mediante gráficos y tablas dinámicas, integración con otras aplicaciones de Google Workspace, y automatización con macros. También se explora la integración con Formularios de Google para recopilación de datos y análisis rápido. El curso culmina con un desafío empresarial que permite a los estudiantes aplicar todas las habilidades aprendidas en un escenario práctico, preparándolos para implementar estas técnicas avanzadas en entornos profesionales reales.
Introducción al curso
Module 1 · 3 Minutes to complete
Formato avanzado en una hoja de cálculo de Google
Module 2 · 17 Minutes to complete
Fórmulas y funciones avanzadas
Module 3 · 36 Minutes to complete
Analizar y generar informes
Module 4 · 56 Minutes to complete
Propagar datos con un formulario de Google
Module 5 · 37 Minutes to complete
Desafío empresarial
Module 6 · 12 Minutes to complete
Fee Structure
Instructor
Course Instructor, Technology and Product Planning
Jasmine McNeil is a seasoned manager and course instructor affiliated with Johns Hopkins University, where she leads the Technology and Product Planning course on Coursera. With dual master’s degrees in Business Administration and Management, she specializes in product strategy, agile project management, and human-centered design. Her teaching focuses on guiding learners through the end-to-end process of building digital health products—from ideation and research to deployment—by integrating healthcare technology, stakeholder management, and design thinking. Through insights from industry leaders and real-world case studies, she helps professionals understand how to bring innovative health technology solutions from concept to implementation.
Testimonials
Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.
Frequently asked questions
Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.