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.
What you will learn
- 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
Who is the course for?
In this Guided Project, you will:
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.