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

Financial Reporting Capstone (Coursera) Coursera
University of Illinois at Urbana-Champaign

Financial Reporting Capstone (Coursera)

The Capstone is the culminating project in the Financial Reporting Specialization. You will have the opportunity to combine the concepts and techniques obtained through all the courses in this specialization (Accounting Analysis I: The Role of Accounting as an Information System, Accounting Analysis I: Measurement and Disclosure of Assets, Accounting Analysis II: Measurement and Disclosure of Liabilities, and Accounting Analysis II: Accounting for Liabilities and Equity) and apply them to a real world accounting project.

Sep 21st 2026
3 Weeks
Crear una carta de proyecto con Hojas de cálculo Google (Coursera) Coursera
Coursera Project Network

Crear una carta de proyecto con Hojas de cálculo Google (Coursera)

Para el fin de este proyecto, usted va a aprender cómo crear una carta del proyecto con Hojas de cálculo Google para gestionar y mejorar su gestión de tareas. Va a aprender como organizar su trabajo para mejorar su rendimiento y su eficiencia. Va a aprender el proceso DMAIC de Six Sigma. Agregado a nuestra gestión de tareas para visualizar nuestro trabajo nos ayudará a mejorar la productividad de nuestro sitio de trabajo.

Mar 7th 2022
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
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
RShiny for Everyone (edX) EdX
Davidson College,DavidsonX

RShiny for Everyone (edX)

Use R’s Shiny package to create data-driven, interactive web applications. In this course, you will use R Shiny to create an interactive web application that highlights the biodiversity of America’s National Parks. Your application will feature an interactive map, biodiversity calculator, trail journal and species images. Using R Shiny, you will expand your data analysis and visualization skills while developing your workflow through web application deployment.

Self Paced
Self-Paced
Summarizing Data Using Google Sheets (Coursera) Coursera
Coursera Project Network

Summarizing Data Using Google Sheets (Coursera)

This project gives you easy access to the invaluable summarizing data techniques used by experts in business, science, math, sports, art, music, literature, and many other disciplines. We’ll learn how to summarize vast amounts of data into a few numbers, charts, and graphs to gain the invaluable insights hidden in them. We’ll also cover the most commonly used methods in the business setting while focusing on how to develop them and when one is more appropriate than others. We will use Google Sheets and large data sets to illustrate how to create the summary techniques.

Mar 21st 2022
1 Week
Creando un Presupuesto en Google Sheets (Coursera) Coursera
Coursera Project Network

Creando un Presupuesto en Google Sheets (Coursera)

En este curso basado en un proyecto y de 2 horas de duración, aprenderás a usar una plantilla de presupuesto anual de Google Sheets para realizar un presupuesto personal. Practicarás cómo modificar y personalizar el contenido de las pestañas así como comprender las diferentes secciones de las pestañas de Gastos, Ingreso, y Resumen. Utilizaremos el formato condicional para clasificar y resaltar resultados importantes.

Mar 14th 2022
Self-Paced
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.

Aug 24th 2026
4 Weeks
Predicción de Ventas Pronosticando Tendencias (Coursera) Coursera
Coursera Project Network

Predicción de Ventas Pronosticando Tendencias (Coursera)

En este curso basado en un proyecto y de 2 horas de duración, aprenderás a realizar pronósticos de tendencia y a entender cómo los pronósticos apoyan la toma de decisiones. Aprenderás a utilizar hojas de cálculo para visualizar y realizar un examen estadístico de datos analizando la pendiente de la línea de regresión y creando una gráfica de línea. Al final del curso entenderás cómo evaluar los modelos y cuándo utilizar técnicas de ingeniería para mejorar la exactitud de la previsión.

Aug 24th 2026
Self-Paced
Capstone Value Creation through Innovation (Coursera) Coursera
EIT Digital

Capstone Value Creation through Innovation (Coursera)

This capstone course is the final course of the Value Creation Through Innovation Specialization. The specialization covers technology bases innovation and transformation and how to spot and to capitalize on emerging opportunities. UC Berkeley Haas School of Business and KTH Royal Institute of Technology are the academic partners in the Value Creation Through Innovation Specialization.

Sep 21st 2026
5-12 Weeks