Crear datos de soporte al Cliente con Google Sheets (Coursera)

Crear datos de soporte al Cliente con Google Sheets (Coursera)

Al final de este proyecto, usted creerá un Google Sheet que transforma datos brutos de soporte al cliente de una empresa en un conjunto de datos útiles , ofreciendo a la empresa una visión general de anteriores requisitos de soporte. Usted podrá determinar cuáles departamentos de la empresa están excediendo normas y cuáles departamentos están rindiendo por debajo del estándar.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

Este proyecto incluirá una introducción a Google Sheets , cómo enlazar varias fichas, una introducción a la creación de fórmulas de apalancamiento , y como utilizar Google Sheets para determinar si el soporte ofrecido se encuentra dentro de los niveles necesarios de servicio.
Este proyecto es designado para personas sin conocimientos de Google Sheets, o para personas con experiencias limitadas de Google Sheets.

In this Free Guided Project, you will:

  • Crear fichas con fórmulas en Google Sheets
  • Showcase this hands-on experience in an interview

Learn step-by-step
In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:
1- El estudiante podrá acceder a Google Sheets y podrá entender cuando el uso de este producto es beneficioso.
2- El estudiante podrá crear nuevas fichas en Google Sheets, introducir y organizar datos brutos en las fichas.
3- El estudiante podrá crear fórmulas dentro de las fichas en Google Sheets para obtener información útil.
4- El estudiante podrá crear listas desplegables en Google Sheets aplicando el instrumento de validación de datos.
5- El estudiante podrá enlazar datos brutos de varias fichas en una sola ficha en Google Sheets , para obtener un resumen de los resultados del negocio.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Requirements Specifications: Goals and Conflict Analysis (Coursera) Coursera
University of Colorado System

Requirements Specifications: Goals and Conflict Analysis (Coursera)

In Requirements Goal Development and Language Analysis, we move from the spoken word to precise writing. A first step in this is writing goals. We will talk about goals used in requirements engineering and, from this, writing use cases from what we learn. Use cases can be in diagram and written form. Then- the villains enter- misuse cases and abuse cases are discussed in how we can deal with them in a Requirements environment. In gathering requirements, you'll have many questions remaining. Often this leads to the need of more interviews and group sessions. We'll go through how to handle group meetings, dealing with inconsistency, and handling conflict between stakeholders.

Oct 19th 2026
4 Weeks
Create a Value versus Complexity Matrix in Google Sheets (Coursera) Coursera
Coursera Project Network

Create a Value versus Complexity Matrix in Google Sheets (Coursera)

In this 2-hour long project-based course, you will create a Value versus Complexity Matrix in Google Sheets and learn how to interpret the outcomes to prioritize product features. In the process, you will review the basics of this prioritization framework as well as Google Sheets functionality such as lookup tables, data validation, and charts. Because time and resources are limited, prioritization is a critical skill that product managers must master in order to optimize product value and minimize development time and costs.

Self Paced
Self-Paced
Getting Started with Google Workspace (Udacity) Udacity
Udacity,Google Cloud

Getting Started with Google Workspace (Udacity)

Learn the skills to be productive with Google Workspace. This training equips students with the skills they need to become productive with Google Workspace. By the end of this course, the student will be proficient in the use of the core Google Workspace applications: Gmail, Google Calendar, Google Drive, Google Docs, Google Sheets, Google Slides, Google Meet, and Google Chat.

Self Paced
Self-Paced
Analyzing Data with Excel (edX) EdX
IBM

Analyzing Data with Excel (edX)

Build the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis. The course covers the basic workings and key features of Excel to help students analyze their data. This course provides students with the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis.The course consists of several videos, demos, examples, and hands-on labs to help you learn, and ends with a final assignment project which will help you put what you have learned into practice.

Self Paced
Self-Paced
Freelancer Toolkit: Collaborating with Google Sheets (Skillshare) Skillshare
Skillshare

Freelancer Toolkit: Collaborating with Google Sheets (Skillshare)

If you're a freelancer then you have a lot of information to remember and share. Well, you can organize and collaborate in Google Sheets! It is a free program from the great folks at Google that allows you to track information with your coworkers, clients and friends simultaneously! Take this class and find out how you can start to collaborate better and get amazing insights into your information.

Self Paced
Self-Paced
Getting Started with Google Sheets (Coursera) Coursera
Google Cloud

Getting Started with Google Sheets (Coursera)

Google Sheets is a robust, cloud-based application that empowers you to create sophisticated spreadsheets. Whether you are working at your desk—or from your smartphone or tablet on-the-go—Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, you’ll learn how to make your own supercharged spreadsheets.

Jul 6th 2026
5-12 Weeks
Crear una hoja para la Gestión de Proyectos en Google Sheets (Coursera) Coursera
Coursera Project Network

Crear una hoja para la Gestión de Proyectos en Google Sheets (Coursera)

En este curso basado en un proyecto y de 2 horas de duración, aprenderá a utilizar las herramientas de Google Drive para crear un archivo de hojas de cálculo de Google Sheets que podrá compartir con miembros de un equipo. A lo largo de este proyecto creará una hoja para el seguimiento de gestión de proyectos simple.

Mar 21st 2022
Self-Paced
Preparing for and Passing Technical Certifications (Coursera) Coursera
ROI Training

Preparing for and Passing Technical Certifications (Coursera)

Technology provides you with great opportunities for professional advancement, and technical certifications prove your knowledge, expertise, and hands-on experience to prospective employers or clients. It is extremely important to organizations like AWS, Google, Microsoft, Oracle, ITIL, PMI, and many others that their certifications prove technical expertise; otherwise, their certifications are of no value. That is why the exams are so hard. This course is intended to help you formulate an effective learning plan that will build the knowledge you need, not only to pass the exam but to be truly competent in the technology you are being tested on.

Nov 9th 2026
1 Week
Initiation à Google Drive (Coursera) Coursera
Coursera Project Network

Initiation à Google Drive (Coursera)

Dans ce projet guidé, vous découvrirez Google Drive le service de collaboration de Google qui offre 15 Giga de stockage gratuit à tous ses utilisateurs, Google Drive a de nombreux outils que nous allons découvrir au cours de ce projet guidé, tels que : Google Docs (équivalent de Word), Google Sheets (équivalent de Excel), Google Slides (équivalent de PowerPoint) et Google Forms (équivalent de Microsoft Forms).

Feb 28th 2022
Self-Paced
Crear un Informe Financiero con Google Sheets (Coursera) Coursera
Coursera Project Network

Crear un Informe Financiero con Google Sheets (Coursera)

En este curso basado en un proyecto y de 2 horas de duración, aprenderá a completar una plantilla de informe financiero con Google Sheets. Aprenderá a ingresar las transacciones de su empresa y a definir los elementos del Balance Financiero. Con la información ingresada, aprenderá a interpretar los datos presentados acerca de las pérdidas y ganancias. Con ello, comprenderá cómo utilizar esta herramienta para realizar un seguimiento y presentar la información financiera de su empresa con el uso de gráficos.

Feb 28th 2022
Self-Paced
Designing and Implementing Your Coaching Strategy (Coursera) Coursera
University of California, Davis

Designing and Implementing Your Coaching Strategy (Coursera)

In order to be an effective manager in increasingly fast-paced and complex organizational environments, coaching skills to develop and get the best work out of employees has become essential. Throughout the Coaching Skills for Managers specialization, we’ve discussed many topics for improving coaching conversations with our employees. It is now time to put all of that theory and discussion into practice as you solidify your coaching philosophy, develop your coaching practice and agendas, and demonstrate mastery at handling everyday coaching conversations!

Nov 16th 2026
3 Weeks