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.
- 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
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.
Keep learning. Keep growing.
Discover this selection of interesting courses
We have a range of courses available: from online courses to short courses and master's degrees. Start your search by checking out our most popular courses below.
Your role Are you a motivated self-starter? Do you want the chance to experience a diverse area of the business? We’re looking for someone who can: – Proactively support your host department in daily ...