Create Charts and Dashboard using Google Sheets
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.
Charts and Graphs
Data Visualization (DataViz)
由 LC 提供Oct 31, 2020
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
由 YA 提供Dec 26, 2021
The instructor explained things well to understand, but I encountered a few technical problems form my end. I plain to earn a certificate.
由 AA 提供May 23, 2021
Interesting course to understand how to visualize data with the help of Google Sheets.
由 SS 提供Aug 2, 2020
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.