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)
Смотрите видео Build a Google Sheets dashboard with Google Forms data (Automated) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Spreadsheet Class 02 Апрель 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 10,984 раз и оно понравилось 122 людям.