[{"id":"65730","title":"Introducción al curso","description":"

Este módulo abarca el temario. En él también se presenta la empresa Hasta las nubes y el desafío empresarial del curso a los alumnos.

","steps":[{"id":"448026","prompt":null,"isOptional":true,"activities":[{"id":"440771","href":"/course_templates/293/video/440771?locale=es","isLocked":false,"duration":147000,"title":"Introducción al curso","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448027","prompt":null,"isOptional":true,"activities":[{"id":"440772","href":"/course_templates/293/video/440772?locale=es","isLocked":false,"duration":78000,"title":"Temario","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"65731","title":"Formato avanzado en una hoja de cálculo de Google","description":"

Hay muchas opciones de formato avanzado que son útiles para personalizar las hojas de cálculo de Google y aprovechar los datos. En este módulo, hablaremos sobre cómo aplicar temas y opciones de formato condicional.

","steps":[{"id":"448028","prompt":null,"isOptional":true,"activities":[{"id":"440773","href":"/course_templates/293/video/440773?locale=es","isLocked":false,"duration":114000,"title":"Formato avanzado en una hoja de cálculo de Google","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448029","prompt":null,"isOptional":true,"activities":[{"id":"440774","href":"/course_templates/293/video/440774?locale=es","isLocked":false,"duration":108000,"title":"Formato condicional","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448030","prompt":null,"isOptional":true,"activities":[{"id":"440775","href":"/course_templates/293/video/440775?locale=es","isLocked":false,"duration":13000,"title":"Explicación de la actividad 1","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448031","prompt":null,"isOptional":true,"activities":[{"id":"440776","href":"/course_templates/293/documents/440776?locale=es","isLocked":false,"duration":1800000,"title":"Actividad 1: Aplique formato condicional a una hoja de cálculo de Google","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448032","prompt":null,"isOptional":false,"activities":[{"id":"440777","href":"/course_templates/293/quizzes/440777?locale=es","isLocked":false,"duration":600000,"title":"Cuestionario","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"65732","title":"Fórmulas y funciones avanzadas","description":"

Las fórmulas y funciones le permiten hacer cálculos rápidos y usar mejor sus datos. Hojas de cálculo de Google es compatible con muchas de las funciones que se encuentran en otras aplicaciones de hojas de cálculo. En este módulo, observaremos cómo crear una fórmula, cómo usar funciones, crear referencias y validar datos. También discutiremos cómo usar rangos con nombre puede ser útil cuando se trabaja con conjuntos de datos.

","steps":[{"id":"448033","prompt":null,"isOptional":true,"activities":[{"id":"440778","href":"/course_templates/293/video/440778?locale=es","isLocked":false,"duration":166000,"title":"Fórmulas y funciones avanzadas","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448034","prompt":null,"isOptional":true,"activities":[{"id":"440779","href":"/course_templates/293/video/440779?locale=es","isLocked":false,"duration":247000,"title":"Use IF e IFS para analizar datos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448035","prompt":null,"isOptional":true,"activities":[{"id":"440780","href":"/course_templates/293/video/440780?locale=es","isLocked":false,"duration":11000,"title":"Explicación de la actividad 2","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448036","prompt":null,"isOptional":true,"activities":[{"id":"440781","href":"/course_templates/293/documents/440781?locale=es","isLocked":false,"duration":1800000,"title":"Actividad 2: Use la función IFS en Hojas de cálculo de Google","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448037","prompt":null,"isOptional":true,"activities":[{"id":"440782","href":"/course_templates/293/video/440782?locale=es","isLocked":false,"duration":206000,"title":"Validación de datos y rangos con nombre","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448038","prompt":null,"isOptional":true,"activities":[{"id":"440783","href":"/course_templates/293/video/440783?locale=es","isLocked":false,"duration":12000,"title":"Explicación de la actividad 3","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448039","prompt":null,"isOptional":true,"activities":[{"id":"440784","href":"/course_templates/293/documents/440784?locale=es","isLocked":false,"duration":1800000,"title":"Actividad 3: Cree una regla de validación de datos y asigne un nombre a un rango","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448040","prompt":null,"isOptional":false,"activities":[{"id":"440785","href":"/course_templates/293/quizzes/440785?locale=es","isLocked":false,"duration":900000,"title":"Cuestionario","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"65733","title":"Analizar y generar informes","description":"

Las hojas de cálculo pueden contener millones de números, fórmulas y bloques de texto. Comprender todos esos datos puede ser difícil sin un resumen o una visualización, especialmente cuando se presentan los datos a los colegas, socios, clientes o clientes potenciales. En este módulo, exploraremos las opciones de visualización de datos en Hojas de cálculo de Google, como los gráficos y las tablas dinámicas. Discutiremos cómo la integración de Google Workspace facilita compartir gráficos y tablas en Documentos y Presentaciones de Google. También veremos formas de automatizar tareas repetitivas por medio de macros.

","steps":[{"id":"448041","prompt":null,"isOptional":true,"activities":[{"id":"440786","href":"/course_templates/293/video/440786?locale=es","isLocked":false,"duration":78000,"title":"Analizar y generar informes","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448042","prompt":null,"isOptional":true,"activities":[{"id":"440787","href":"/course_templates/293/video/440787?locale=es","isLocked":false,"duration":169000,"title":"Explorar gráficos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448043","prompt":null,"isOptional":true,"activities":[{"id":"440788","href":"/course_templates/293/video/440788?locale=es","isLocked":false,"duration":7000,"title":"Explicación de la actividad 4","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448044","prompt":null,"isOptional":true,"activities":[{"id":"440789","href":"/course_templates/293/documents/440789?locale=es","isLocked":false,"duration":1800000,"title":"Actividad 4: Cree un gráfico con Hojas de cálculo de Google","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448045","prompt":null,"isOptional":true,"activities":[{"id":"440790","href":"/course_templates/293/video/440790?locale=es","isLocked":false,"duration":48000,"title":"Tablas dinámicas","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448046","prompt":null,"isOptional":true,"activities":[{"id":"440791","href":"/course_templates/293/video/440791?locale=es","isLocked":false,"duration":217000,"title":"Crear una tabla dinámica","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448047","prompt":null,"isOptional":true,"activities":[{"id":"440792","href":"/course_templates/293/video/440792?locale=es","isLocked":false,"duration":9000,"title":"Explicación de la actividad 5","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448048","prompt":null,"isOptional":true,"activities":[{"id":"440793","href":"/course_templates/293/documents/440793?locale=es","isLocked":false,"duration":1800000,"title":"Actividad 5: Cree una tabla dinámica basada en datos existentes","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448049","prompt":null,"isOptional":true,"activities":[{"id":"440794","href":"/course_templates/293/video/440794?locale=es","isLocked":false,"duration":235000,"title":"Integración y publicación en Hojas de cálculo de Google","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448050","prompt":null,"isOptional":true,"activities":[{"id":"440795","href":"/course_templates/293/video/440795?locale=es","isLocked":false,"duration":9000,"title":"Explicación de la actividad 6","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448051","prompt":null,"isOptional":true,"activities":[{"id":"440796","href":"/course_templates/293/documents/440796?locale=es","isLocked":false,"duration":1800000,"title":"Actividad 6: Explore opciones de publicación","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448052","prompt":null,"isOptional":true,"activities":[{"id":"440797","href":"/course_templates/293/video/440797?locale=es","isLocked":false,"duration":155000,"title":"Macros","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448053","prompt":null,"isOptional":true,"activities":[{"id":"440798","href":"/course_templates/293/video/440798?locale=es","isLocked":false,"duration":76000,"title":"Aplicar una macro","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448054","prompt":null,"isOptional":false,"activities":[{"id":"440799","href":"/course_templates/293/quizzes/440799?locale=es","isLocked":false,"duration":1500000,"title":"Cuestionario","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"65734","title":"Propagar datos con un formulario de Google","description":"

Los formularios de Google son encuestas en línea que se usan para recopilar datos y, de este modo, ofrecen la posibilidad de hacer análisis de datos rápidamente. En este módulo, exploraremos cómo Formularios de Google y Hojas de cálculo de Google trabajan en conjunto por medio de la conexión de datos recopilados de un formulario a una hoja de cálculo, o con la creación de un formulario a partir de una hoja de cálculo existente.

","steps":[{"id":"448055","prompt":null,"isOptional":true,"activities":[{"id":"440800","href":"/course_templates/293/video/440800?locale=es","isLocked":false,"duration":228000,"title":"Propagar datos con un formulario de Google","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448056","prompt":null,"isOptional":true,"activities":[{"id":"440801","href":"/course_templates/293/video/440801?locale=es","isLocked":false,"duration":6000,"title":"Explicación de la actividad 7","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448057","prompt":null,"isOptional":true,"activities":[{"id":"440802","href":"/course_templates/293/documents/440802?locale=es","isLocked":false,"duration":1800000,"title":"Actividad 7: Cree un formulario de Google","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448058","prompt":null,"isOptional":true,"activities":[{"id":"440803","href":"/course_templates/293/video/440803?locale=es","isLocked":false,"duration":220000,"title":"Configurar un formulario y compartir un formulario de Google","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448059","prompt":null,"isOptional":true,"activities":[{"id":"440804","href":"/course_templates/293/video/440804?locale=es","isLocked":false,"duration":13000,"title":"Explicación de la actividad 8","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448060","prompt":null,"isOptional":true,"activities":[{"id":"440805","href":"/course_templates/293/documents/440805?locale=es","isLocked":false,"duration":1800000,"title":"Actividad 8: Comparta un formulario de Google","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448061","prompt":null,"isOptional":true,"activities":[{"id":"440806","href":"/course_templates/293/video/440806?locale=es","isLocked":false,"duration":86000,"title":"Administrar comentarios","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448062","prompt":null,"isOptional":false,"activities":[{"id":"440807","href":"/course_templates/293/quizzes/440807?locale=es","isLocked":false,"duration":1200000,"title":"Cuestionario","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"65735","title":"Desafío empresarial","description":"

En este módulo, pondrá en práctica todo lo que ha aprendido para ayudar a nuestro cliente ficticio de Google Workspace a resolver su desafío empresarial.

","steps":[{"id":"448063","prompt":null,"isOptional":true,"activities":[{"id":"440808","href":"/course_templates/293/video/440808?locale=es","isLocked":false,"duration":86000,"title":"Descripción general del desafío empresarial","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448064","prompt":null,"isOptional":true,"activities":[{"id":"440809","href":"/course_templates/293/video/440809?locale=es","isLocked":false,"duration":3000,"title":"Desafío empresarial explicado","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448065","prompt":null,"isOptional":true,"activities":[{"id":"440810","href":"/course_templates/293/documents/440810?locale=es","isLocked":false,"duration":1800000,"title":"Actividad 9 Desafío empresarial","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448066","prompt":null,"isOptional":true,"activities":[{"id":"440811","href":"/course_templates/293/video/440811?locale=es","isLocked":false,"duration":84000,"title":"Conclusión","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"next-steps","title":"Tus próximos pasos","description":null,"steps":[{"id":"badge-step","prompt":null,"isOptional":true,"activities":[{"id":"badge","href":null,"isLocked":true,"duration":null,"title":"Insignia del curso","description":null,"type":"badge","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":true}]

Google Cloud Skills Boost

Google Sheets - Advanced Topics - Español