????How to pull reports from multiple tabs with more than one range in the FILTER function Google S
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
561,570 views 4 days ago
523,888 views 3 days ago
1,205,629 views 3 days ago
908,418 views 1 day ago
333,897 views 1 day ago
391,210 views 14 hours ago
375,625 views 18 hours ago
1,291,205 views 2 days ago
Google AdSense
336 x 280
336 x 280
Up Next
Fixer Motos
18,146 views
10 months ago
10 months ago
Fabian Vivas Mecanico
97,709 views
2 years ago
2 years ago
Fabian Vivas Mecanico
14,316 views
8 months ago
8 months ago
Fabian Vivas Mecanico
180,105 views
3 years ago
3 years ago
Brothers Garage
716,736 views
4 months ago
4 months ago
Fabian Vivas Mecanico
71,840 views
3 years ago
3 years ago
Jonatan Parraguez (Doc Motors Catamarca)
191,382 views
7 years ago
7 years ago
Fabian Vivas Mecanico
71,782 views
3 years ago
3 years ago
Fabian Vivas Mecanico
79,813 views
2 years ago
2 years ago
Vargas Biker
65,540 views
4 years ago
4 years ago
Fabian Vivas Mecanico
102,878 views
2 years ago
2 years ago
ISALO TV
31,893 views
1 year ago
1 year ago
あんはるのゲーム実況チャンネル
23,018 views
1 month ago
1 month ago
あんはるのゲーム実況チャンネル
55,708 views
1 month ago
1 month ago
Google AdSense
336 x 280
336 x 280