Google Sheets - Slicers - Part 1

  Рет қаралды 106,901

Learn Google Sheets & Excel Spreadsheets

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

Пікірлер: 31
@mask75260
@mask75260 5 жыл бұрын
Thanks for the update. Please make more complex tutorials on Google web apps and html using spreadsheet as data base. Maybe using my sql. Keep up the good job you are best in KZbin in explaining Google web apps.
@oOoScarecrow31oOo
@oOoScarecrow31oOo 3 жыл бұрын
Maybe you could do it with Datastudio
@ilfiroihanmatondang2923
@ilfiroihanmatondang2923 3 жыл бұрын
the clearest gsheet tutorial ever. Thankyou!
@finderseeker6202
@finderseeker6202 4 ай бұрын
Thank you. Can you make the selections in the slicers display somewhere above the table or chart so that they are not concealed in the slicer GUI?
@iamArtificialIyIntelligent
@iamArtificialIyIntelligent 2 ай бұрын
This was so helpful
@jomacajo
@jomacajo Жыл бұрын
Is it possible to add graphics with the slicer?, can't find a way to put them back where they were
@tito13csi
@tito13csi 3 жыл бұрын
Can multiple users use the slicer? Some other users on my google sheet use the slicer, but the data does not seem to change. Thanks.
@mtwerder
@mtwerder 2 жыл бұрын
Is there a quick way to reset/clear multiple slicers with Google sheets?
@ExcelGoogleSheets
@ExcelGoogleSheets 2 жыл бұрын
I'm not aware of it.
@ytonaona
@ytonaona 3 жыл бұрын
Hi, very nice video. Question: if the second pivot table was under the first one. And the first one were to grow (because of more data inserted in first sheet), would the data of the second pivot table be overwritten ? (=erased)
@nicolecaday1201
@nicolecaday1201 4 жыл бұрын
very helpful. if I use slicer without pivot table it shows up blanks as my reference is the full column, how to remove the blanks?
@abhishekwaghmare5849
@abhishekwaghmare5849 5 жыл бұрын
Thanks.. Waiting from long time for this.
@aylinrayonsalinas3175
@aylinrayonsalinas3175 4 жыл бұрын
thaks a lot. The video is really useful for me!!!
@ZeYe-u5q
@ZeYe-u5q Жыл бұрын
Thank you so much.
@BrianKiplinger
@BrianKiplinger 4 жыл бұрын
Can I hire you to set up my google spreadsheet? I have several sales reps and regions of sales reps and I need to segment for proper accounting.
@karthiksaptharishi6136
@karthiksaptharishi6136 2 жыл бұрын
Cool!! Thanks..
@oOoScarecrow31oOo
@oOoScarecrow31oOo 3 жыл бұрын
Is there a way to show on what value you’re filtering? 🤔
@ariarc
@ariarc 5 жыл бұрын
Awesome as always. Thanks.
@endahdarwati1472
@endahdarwati1472 Жыл бұрын
Thanks a lot
@hanshima_
@hanshima_ 4 жыл бұрын
Is it possible to filter the connections of a slicer like in excel? Like making one slicer per chart.
@ExcelGoogleSheets
@ExcelGoogleSheets 4 жыл бұрын
It goes by the data source. So you can get that effect by using a different data range for each. It's not ideal, but slicers in Google Sheets are still a work in progress (hopefully).
@oozzee724
@oozzee724 4 жыл бұрын
how to change the legend of pie chart to count or real number instead of percentage?
@mohdnorrizihanmamat1616
@mohdnorrizihanmamat1616 4 жыл бұрын
"You trying to edit a protected cell or object.. pls contact the sprdsheet owner......" . how can i change the setting as the owner of the sheet.
@walterpaiva719
@walterpaiva719 5 жыл бұрын
Thanks for the video!
@dsky6689
@dsky6689 5 жыл бұрын
Спасибо за видео!
@helmeczitomi
@helmeczitomi 2 жыл бұрын
Hello there. Could anyone help me please? :) I'm using slicers but it would be more user friendly, if I could see all the filter options of the given slicer and I never should expand it. In Excel if you add a slicer, you will see all the elements of it just like buttons. Is it possible to make it to look like this in Google Sheets? Thank you very much! :)
@ExcelGoogleSheets
@ExcelGoogleSheets 2 жыл бұрын
Not without external tools.
@gregoryunderwood4121
@gregoryunderwood4121 5 жыл бұрын
Thank you! Thank you! Thank you!!
@Dan1keeper
@Dan1keeper 5 жыл бұрын
Thx for you videos. Round for GS
@martinachoi7843
@martinachoi7843 3 жыл бұрын
Thanks for letting me know that the slicer and the pivot table and the charts have to be in the same worksheet otherwise its not gonna work T_T
@DavidMarcadet
@DavidMarcadet 5 жыл бұрын
Thanks!
Google Sheets - Dashboard with Slicers for Pivot Tables & Charts - Part 2
20:41
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 123 М.
Google Sheets Slicer: How They Work & How to Add [Easy]
8:05
Spreadsheet Point
Рет қаралды 15 М.
啊?就这么水灵灵的穿上了?
00:18
一航1
Рет қаралды 74 МЛН
Synyptas 4 | Арамызда бір сатқын бар ! | 4 Bolim
17:24
Smart Sigma Kid #funny #sigma
00:14
CRAZY GREAPA
Рет қаралды 49 МЛН
pumpkins #shorts
00:39
Mr DegrEE
Рет қаралды 123 МЛН
QUERY - Drop Down List to Filter Data - Google Sheets
15:25
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 351 М.
Pivot Table - Google Sheets - Connect a Slicer/Filter to Multiple Pivot Tables,   Different Sources
9:33
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 53 М.
Interactive dashboards in Google sheets
17:42
David Benaim
Рет қаралды 96 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 738 М.
Filtering and Slicers - Google Sheets
7:02
Doug H
Рет қаралды 3 М.
5 Google Sheets Tips Every User Should Know!
12:02
Simpletivity
Рет қаралды 673 М.
How to Create Chart in Google Sheets in Tamil
22:15
Endless Knowledge
Рет қаралды 8 М.
Excel Settings That ACTUALLY Make a Difference
12:27
Excel Campus - Jon
Рет қаралды 35 М.
Pivot Table - Text Value Field Instead of Counts - Google Sheets
15:58
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 62 М.
啊?就这么水灵灵的穿上了?
00:18
一航1
Рет қаралды 74 МЛН