Creating Dashboards in Google Sheets
It’s recommended to complete our courses on pivot tables and/or charts before attempting this one
(or to have experience using these aspects within Sheets).
Keep on top of your data by creating visual dashboards in Google Sheets.
Dashboards are a great way of visualising your data both for yourself and collaborators and no understanding of code is required!
To get the best out of it we have created several sessions to cover all of the functionality that will help you master Google Sheets. This is just one in a series that covers Introduction and Intermediate levels through to more advanced sessions covering Functions and Pivot Tables and whilst we recommend you attend these it is not mandatory to do so. You can find them all in your course catalogue to enrol on.
In This session, we’ll focus on creating charts and displays of your data within Google Sheets, on a separate tab to the data itself, we’ll then look at ways of setting up dashboards off larger or “live” data sets. Finally, we’ll look at building dashboards from pivot tables and charts together.
Badge earned on completion

Difficulty

Shareable Certificate

Key Takeaways
- Dashboard Creation with functions and charts – Creating a dashboard using functions and charts
- Charts – Creating and editing charts is a staple of creating a visually appealing dashboard
- Dashboard Creation with Pivots – Creating a dashboard using pivot tables and charts
- Slicers – Make your dashboard more interactive by using slicers to actively filter data.
