Create Charts and Dashboard using Google Sheets
Skills:
Data Literacy80%
Key Takeaways
Creates charts and a dynamic dashboard using Google Sheets
Original Description
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.
Watch on External: Coursera ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
More on: Data Literacy
View skill →Related Reads
📰
📰
📰
📰
Scraping Indian government open data in 2026: what actually works
Dev.to · Manideep Chittineni
2026 Enterprise Data Recovery: What IT Teams Should Look For
Medium · AI
I Was Mad About the Jaylen Brown Trade. So I Simulated 10,000 Seasons to See If I Should Be.
Medium · Data Science
Mosaic Plots in Data Visualization: Turning Complex Relationships into Clear Business Insights
Medium · Data Science
🎓
Tutor Explanation
DeepCamp AI