Interactive Google Sheets dashboard with drop down menus tutorial
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.
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...
Basic sales dashboard (Part 1 of the entire course): • How to make a Dashboard in Google She...
NOTE: If you are located in Europe or outside of the U.S., your date format will be different than the United States. If you want, you can change this by clicking File... Settings... General... Locale... United States
In this video I will show you how to build a sales dashboard in Google Sheets. You will learn how to make your dashboard interactive with drop-down selection menus, and you will learn many other important formulas and concepts for analyzing data and building dashboard in Google Sheets.
0:00:00 1 Sales Dashboard Overview
0:02:27 2 Create and Color Tabs
0:04:01 3 Import Sales Data
0:05:26 4 Build the Channel Filter tab_ FILTER function
0:09:22 5 Add an IF statement to the FILTER function
0:12:28 6 Use INDEX and SPLIT to extract the date
0:14:47 7 Use ARRAYFORMULA to extend the formula downwards
0:16:33 8 Apply the IFERROR function
0:17:49 9 Build the daily sales timeline
0:21:16 10 Add NOTE about ending Calculating the daily revenue_ SUMIF
0:26:16 11 Format the dashboard tab
0:31:43 12 Generate a list of prices and items
0:34:40 13 Calculate the total units sold_ SUMIF
0:37:41 14 Calculate the total revenue per item
0:40:17 15 Create the channel selection drop down menu
0:43:27 16 Create the item selection drop down menu
0:44:10 17 Use INDEX MATCH to lookup item data (Like VLOOKUP)
0:49:45 18 Optional_ Bonus INDEX Match Lesson
0:54:23 19 Optional_ Bonus lesson 1 (Copy and paste values only)
0:57:02 20 Calculate the total revenue per channel
1:01:12 21 Create a pie chart for channel revenue
1:04:16 22 Create a column chart for item revenue
1:10:04 23 Create a line chart for daily revenue
1:15:11 24 Add a logo
1:16:15 25 Protecting and sharing your dashboard
1:21:34 26 Sales Dashboard Revamp
Watch video Interactive Google Sheets dashboard with drop down menus tutorial online without registration, duration hours minute second in high quality. This video was added by user Spreadsheet Class 04 April 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 8,911 once and liked it 90 people.