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.
Overview
Syllabus
- Project Overview
- In this guided project, you will learn how to clean your data sets and create effective charts and a dashboard to visualize these data sets. You will gain hands-on learning about how to clean raw data, perform basic functions and formulas like vlookups and pivot tables and create basic charts, find out duplicate data, and do some advanced analyses. By the end of this project, 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 visualize the data.
Taught by
Ishita Sinha
