How to pull data from other spreadsheet tabs Google Sheets - Query Function
214,192 views
About :
In today's video lesson, I will teach you how to pull data from other tabs of your spreadsheet using the QUERY Formula. ????Link to the Spreadsheet: https://docs.google.com/spreadsheets/... We often have to keep pressing CTRL C and CTRL V to copy some data from other tabs, but now with this formula this becomes automatic every time data is added to another tab. This way, we have a more dynamic and automated spreadsheet, avoiding repetitive and boring work that requires a lot of time and labor on a daily basis. Pull REPORT BETWEEN DATES with the QUERY function: ???? • Pull REPORT BETWEEN DATES with the ... Using another one of the QUERY arguments, it is possible to do this, and just include the contains argument within the function and specify what you want or you can reference a cell where you can later place a drop-down menu with the items to be filtered in our database. The query function is very powerful and we can perform various data processing with it. There are some video classes here on the channel about it and many arguments that we have already covered in other video classes. How to GROUP SUM within a QUERY: ???? • How to GROUP SUM within a QUERY (Su... If this video made sense to you, share it with other people who you know need to learn this formula and that way everyone can learn more and more about this Query Function within Google Sheets. ⚠️If you want to master Google Spreadsheets, even if you already know something but still want to learn a little more about this free Google tool or even if you know nothing and want to learn from scratch, from the basics to the advanced in exclusive Google Sheets content, subscribe so you don't miss any new video lessons on the channel! Playlist Link to Master Google Sheets: ???? • How to pull data from other tabs in the pl... Teaching from scratch to advanced Google Sheets, Google App Script and Data Studio, with tutorials, step by step Google Sheets, step by step Data Studio and step by step Google App Script. So if you want to learn about Google Sheets once and for all, you've come to the right channel, subscribe and follow all the video lessons on the channel. A big hug and success in spreadsheets!!! Chapters: 00:00 - Introduction to the QUERY class 01:25 - Applying the QUERY function to pull data from another Spreadsheet tab 04:35 - Automatically updating a report with the QUERY function 05:01 - Considerations about the QUERY function in Google Sheets #GoogleSheets #GoogleSheets #QUERY
877,750 views 1 day ago
1,281,307 views 2 days ago
314,448 views 1 day ago
270,809 views 1 day ago
543,988 views 3 days ago
520,149 views 2 days ago
1,202,441 views 3 days ago
543,988 views 3 days ago
877,750 views 1 day ago
Google AdSense
336 x 280
336 x 280
Up Next
La Tana del Frerito
151,054 views
1 year ago
1 year ago
La Tana del Frerito
334,218 views
3 years ago
3 years ago
La Tana del Frerito
399,149 views
3 years ago
3 years ago
La Tana del Frerito
326,814 views
3 years ago
3 years ago
Sicross1989
1,503 views
Streamed 9 days ago
Streamed 9 days ago
La Tana del Frerito
401,490 views
3 years ago
3 years ago
La Tana del Frerito
236,752 views
2 years ago
2 years ago
La Tana del Frerito
113,792 views
1 year ago
1 year ago
TOPCLIP ITA
38,761 views
2 years ago
2 years ago
La Tana del Frerito
164,421 views
3 years ago
3 years ago
La Tana del Frerito
246,298 views
3 years ago
3 years ago
La Tana del Frerito
789,495 views
3 years ago
3 years ago
La Tana del Frerito
326,462 views
3 years ago
3 years ago
La Tana del Frerito
126,288 views
3 years ago
3 years ago
La Tana del Frerito
268,599 views
3 years ago
3 years ago
Dayanch Nurmyradov
25,706 views
1 day ago
1 day ago
Dayanch Nurmyradov
79,864 views
4 months ago
4 months ago
Dayanch Nurmyradov
205,511 views
1 year ago
1 year ago
Dayanch Nurmyradov
55,270 views
1 month ago
1 month ago
Dayanch Nurmyradov
39,202 views
3 months ago
3 months ago
Dayanch Nurmyradov
100,958 views
11 months ago
11 months ago
ДЕТЕКТИВ 🇰🇬 КУМУШАЙ
98,419 views
15 hours ago
15 hours ago
Мир, гамарджоба
116,463 views
3 weeks ago
3 weeks ago
Google AdSense
336 x 280
336 x 280