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

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
Crear una hoja de asequilibilidad del hogar en Google Sheets (Coursera) Coursera
Coursera Project Network

Crear una hoja de asequilibilidad del hogar en Google Sheets (Coursera)

En este curso basado en un proyecto y de 2 horas de duración, aprenderás a crear una hoja de asequiblidad del hogar para calcular el rango de valores de vivienda que puede comprar, así como el pago mensual de la hipoteca. Utilizarás valores de ingreso anual bruto y deudas y gastos mensuales, así como parámetros de la hipoteca para calcular estos valores. Finalmente, representarás los gastos mensuales en un gráfico de anillo.

Feb 28th 2022
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
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 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
Sofware Requirements Prioritization: Risk Analysis (Coursera) Coursera
University of Colorado System

Sofware Requirements Prioritization: Risk Analysis (Coursera)

Risk Analysis, Assessment, and Prioritization looks at how you can manage conflicts at system levels, but it can also be applied to lower level assessments. How do you manage and document conflict, along with alternatives? In analyzing alternatives, you must consider risks. In this course, we'll look into how to analyze risk, evaluate risk, document risks, and use this information for prioritization of requirements. Qualitative and Quantitative approaches will be covered.

Jun 29th 2026
4 Weeks
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.

Sep 14th 2026
1 Week
Moving to the Cloud (Coursera) Coursera
University of Melbourne

Moving to the Cloud (Coursera)

The cloud is taking business by storm. In fact, due to the extraordinary growth of the cloud, it has been described as a tornado, not a fluffy white floating object! Commercial research analysts consider cloud as one of the most significant trends with a potential to change the whole global IT industry. Governments, including those in the US, Britain, and Australia, have cloud-first policies now in place which mandate cloud over non-cloud services in ICT procurement.

Sep 28th 2026
5-12 Weeks
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
Project Selection with Google Sheets (Coursera) Coursera
Coursera Project Network

Project Selection with Google Sheets (Coursera)

Project Selection is a critical aspect of Project Management. In an ideal world, organizations can initiate an unlimited number of projects. However, in the real world where organizations have limited resources (time, money, personnel, materials…) only a few projects, in most cases the projects deemed most beneficial are selected for initiation. There are numerous Project Selection Techniques organizations utilize to determine the most beneficial projects.

Mar 21st 2022
Self-Paced