483 calificaciones
16.217 ya inscrito
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.
Spreadsheet
Google Sheets
Charts and Graphs
Data Analysis
Data Visualization (DataViz)
En un video que se reproduce en una pantalla dividida con tu área de trabajo, tu instructor te guiará en cada paso:
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
por RD
19 de mar. de 2021It'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.
por JF
31 de ago. de 2021Perfect intro. The instructor made things clear and gave different samples in the guided project to give enough opportunities to try the skills.
por LC
31 de oct. de 2020the 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
por SS
2 de ago. de 2020It 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.
