Build a Google Sheets dashboard with Google Forms data (Automated)
Get help with your spreadsheet project, or personalized training:
https://www.spreadsheetclass.com/cons...
Get the ultimate formulas cheat sheet
https://www.spreadsheetclass.com/best...
Learn to build dashboards in Google Sheets:
https://www.spreadsheetclass.com/goog...
Above you will get free access to the entire data course that will take you from beginner to advanced. Here you can get the raw data, view the complete dashboards, and follow along step by step with a variety of dashboards builds.
Fast and Simple dashboard (Simple version of part 1): • Fast & simple dashboard tutorial for ...
Basic sales dashboard (Part 1 of the full course): • How to make a Dashboard in Google She...
To learn the 3 major steps for building any dashboard, check out this video: • Build a dashboard in 3 simple steps (...
In this video I will show you how to create a customer survey dashboard in Google Sheets. Our raw data will be based on responses that were generated with Google Forms. You will learn many important methods and formulas for analyzing data and building dashboards / data visualizations with that data.
0:00:00 1 Survey Dashboard Overview
0:02:10 2 Google Forms Intro
0:07:01 3 Optional How to create Google Forms
0:08:27 4 Importing the Customer Survey Data
0:13:09 5 Create and format new tabs
0:16:01 6 Using the UNIQUE formula
0:18:49 7 SORT function and nested functions
0:19:38 8 Copy formula to right with autofill
0:21:11 9 Add columns for totals
0:26:01 10 Use COUNTIF to calculate totals
0:29:42 11 Copy the COUNTIF formula down the column
0:30:40 12 Copy COUNTIF formula to the right
0:35:48 13 Simple Rating COUNTIF plus COUNTIF (Multiple Criteria)
0:44:21 14 Product type breakdown: COUNTIF Wildcard
0:50:48 15 Using MIN and MAX to find first and last response
0:54:45 16 NOTE about ending Enter and format headers for new formulas
0:58:38 17 Count number of responses: Count if not blank
1:01:06 18 Count number of responses after date
1:02:50 19 Count responses between dates: COUNTIFS Multiple Criteria
1:09:31 20 Change the tab color
1:10:55 21 Dashboard tab background formatting
1:13:21 22 Insert a pie chart
1:16:02 23 Chart Creation: Connecting Data- Method #2
1:17:56 24 Customizing Charts
1:21:53 25 Optional: Select custom colors
1:23:33 26 Create (Duplicate) more pie charts
1:29:23 27 Add a logo, and a note on simplicity
1:32:04 28 Hiding tabs, protecting, and sharing
1:37:46 29 Survey Dashboard Revamp
1:46:07 30 Optional: Copying and pasting values only (Survey Example)
Watch video Build a Google Sheets dashboard with Google Forms data (Automated) online without registration, duration hours minute second in high quality. This video was added by user Spreadsheet Class 02 April 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 10,984 once and liked it 122 people.