Create Charts and Dashboard using Google Sheets
Perform basic functions and generate basic charts to visualize data.
Generate dynamic charts, sparklines and find duplicate data entries.
Learn how to use slicers and create a robust and dynamic dashboard.
Demuestra esta experiencia práctica en una entrevista
In this 2-hour long project-based course, you will learn how to create effective charts and a dynamic dashboard to visualize data sets. You will be able to work with vlookups, pivot tables and basic formulas and be able to create dynamic charts, sparklines, and a robust, dynamic dashboard to present the data. By the end of the project you will be able to: - Understand the terminologies of spreadsheets - Work with basic formulas in Google Sheets - Create 8 Basic Charts for visualizing data - Generate Dynamic Charts from a dropdown list - Generate Sparklines to represent data - Build a dashboard and introduce Basic and Advanced Charts - Use Slicers to filter data and create a robust and dynamic dashboard Note: If you don't have a Google account, you will need to create one to be able to complete the content.
Familiarity with Google Sheets or Microsoft Excel is helpful but not required.
Habilidades que desarrollarás
- Spreadsheet
- Google Sheets
- Charts and Graphs
- Data Analysis
- Data Visualization (DataViz)
Aprende paso a paso
En un video que se reproduce en una pantalla dividida con tu área de trabajo, tu instructor te guiará en cada paso:
Introduction + Log In to Google Sheets
Basic formulas in Google Sheets
Introducing 8 Basic Charts
Dynamic Charts
Sparklines
Building Dashboard Part 1 - Basic Charts
Building Dashboard Part 2 - Advanced Charts
Building Dashboard Part 3 - Slicers
Cómo funcionan los proyectos guiados
Tu espacio de trabajo es un escritorio virtual directamente en tu navegador, no requiere descarga.
En un video de pantalla dividida, tu instructor te guía paso a paso
Reseñas
Principales reseñas sobre CREATE CHARTS AND DASHBOARD USING GOOGLE SHEETS
It was really Great Guide project for beginners ,Those who want the basic knowledge or Good Foundation in this particular Topic .I learnt a Good Basic Knowledge regarding this topic.
the cloud worksheets was a struggle because operation was slow... I don't know if the problem was with my laptop or it is naturally slow. But overload, it was very informative
It's a great course. Thank you. But, since it is meant for beginners. the instructor may want to explain why she chooses a particular formula over (similar sounding) others.
It was great experience to learn , how to use Google-sheets. Instructor guide me very well. i recommended this course to everyone who wanted to enhance their IT skills.
Preguntas Frecuentes
Preguntas Frecuentes
¿Hay proyectos guiados disponibles en computadoras de escritorio y dispositivos móviles?
¿Quiénes son los instructores para proyectos guiados?
¿Puedo descargar el trabajo de mi proyecto guiado después de completarlo?
¿Cuánta experiencia necesito para hacer este proyecto guiado?
¿Puedo completar este proyecto guiado directamente a través de mi navegador web, en lugar de instalar un software especial?
¿Cómo es la experiencia de aprendizaje con los proyectos guiados?
¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.
Coursera Footer
