🔴How to pull reports from multiple tabs with more than one range in the FILTER function Google Sheets
9,770 views
About :
In this class we will learn how to use the FILTER function in an advanced way where we will use ARRAYS + FILTER to have a slightly different and advanced dynamic in our Google Spreadsheet pulling data from various tabs in our Spreadsheet that we will filter with a drop-down menu . 👉Link to the Spreadsheet: https://docs.google.com/spreadsheets/... 👉How to make a copy of the Spreadsheet: 🔴 • ✅EASY - Copy Google Spreadsheets that... This means we can work better with the filter function where we pull more than one tab from our Google Sheets Spreadsheet and unifying it, we also apply a filter within an array to be able to work the filter on top of the database that we had to place within another array, this way we can apply several filters in our FILTER function. Of course, it still cannot be as malleable as the QUERY function where we can place different arguments within it and work more fluidly in our database; The query function is very powerful and we can perform several data treatments 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. Pull REPORT BETWEEN DATES with the QUERY function: 🔴 • Pull REPORT BETWEEN DATES with the function... It is also possible to pull data and group data by making a sum with the query function widely used to help and optimize our Google spreadsheet, bringing the grouped values as we need. How to GROUP SUM within the QUERY: 🔴 • How to GROUP SUM within the QUERY (Su... There are many resources within Google Sheets that can help you in different ways, in addition to sharing a spreadsheet, it is also important to learn basic functions in Google Sheets so that you better understand the dynamics and become more familiar with these functions that we will gradually combine with other functions and form formulas that will help a lot in our daily lives - Basic operations ... Remembering that all the links. The important things will always be here in the description for better learning and access to documents and video class handouts. in exclusive content from Google Sheets, subscribe so you don't miss any new video lessons on the channel! Playlist Link to Master Google Spreadsheets: 🔴 • How to pull data from other tabs in the spreadsheet... Teaching from scratch to advanced Google Spreadsheets, Google App Script and Data Studio, with tutorials, step-by-step Google Spreadsheets, step-by-step data Studio and Google App script walkthrough. So if you want to learn about Google spreadsheets 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 good luck with your spreadsheets!!! Chapters: 00:00 - Introduction to the Class #GoogleSheets #GoogleSheets #GoogleSheets #QUERY
5,586,295 views 2 weeks ago
877,750 views 1 day ago
543,988 views 3 days ago
1,281,307 views 2 days ago
543,988 views 3 days ago
6,142,554 views 13 days ago
1,202,441 views 3 days ago
314,448 views 1 day ago
Google AdSense
336 x 280
336 x 280
Up Next
シュガーオレンジ
19,012 views
1 year ago
1 year ago
ひろき / 鉄道Channel
195,833 views
1 year ago
1 year ago
越後けい / TOKImeki Train
42,736 views
9 months ago
9 months ago
シュガーオレンジ
18,246 views
7 months ago
7 months ago
ピーポー / People
457,620 views
2 years ago
2 years ago
ゆっくり歌激団 世界の鉄道ch.迷列車で行こう海外編
393,081 views
7 years ago
7 years ago
スーツ 交通 / Suit Train
1,220,776 views
4 years ago
4 years ago
ザルワーク
788,586 views
1 year ago
1 year ago
meihokkaido (迷列車で行こう北海道編)
158,440 views
4 years ago
4 years ago
空から日本をゆっくり観察
49,796 views
1 year ago
1 year ago
シュガーオレンジ
15,788 views
5 months ago
5 months ago
みかん
192,961 views
1 year ago
1 year ago
まいのり
129,768 views
4 years ago
4 years ago
へーそく
76,378 views
1 month ago
1 month ago
meihokkaido (迷列車で行こう北海道編)
53,221 views
2 years ago
2 years ago
シュガーオレンジ
11,697 views
1 month ago
1 month ago
Plantão da Oficina
1,232 views
6 months ago
6 months ago
O Mecânico
13,600 views
9 months ago
9 months ago
V8 TECNOCAMBIO
72,616 views
5 years ago
5 years ago
Alexandre Menezes
30,707 views
6 years ago
6 years ago
Professor Di'Caixa
55,138 views
2 years ago
2 years ago
FIESTA Dicas Automotivas
35,294 views
1 year ago
1 year ago
Clayton Nicola
36,408 views
2 years ago
2 years ago
José Leandro Dias Borges
3,158 views
1 year ago
1 year ago
Talvez possa ser útil para vocês
61,932 views
3 years ago
3 years ago
JJ mecânicapeyerl
28,425 views
3 years ago
3 years ago
Ivan Rechia , mecânica facil
31,698 views
2 years ago
2 years ago
Google AdSense
336 x 280
336 x 280