Google Sheets Tables & Formulas

No video

Google Sheets Tables & Formulas

Рет қаралды 10,768

Learn Google Sheets & Excel Spreadsheets

2 ай бұрын

Learn how Google Sheets Tables work and how they integrate with formulas in spreadsheets.
#googlesheets #formulas #tables

Пікірлер: 128

@ExcelGoogleSheets Ай бұрын

Thanks everybody!

@xiaer Ай бұрын

Nice to see you again

@user-oe6bu1ud3w 29 күн бұрын

I kindly request a video tutorial demonstrating the use of Document AI for extracting insights from documents, statements, that might be followed by data visualization in Looker Studio and integration with spreadsheets.

@MISComputerNET Ай бұрын

3 days ago I was talking to a friend of mine about this channel's owner and had told him that he is one of the best spreadsheets teacher on the digital. Now I really am glad to see he's back after a long time. Welcome back!

@ajadsingh1652 Ай бұрын

Welcome back

@LawCoder Ай бұрын

I see I'm not the only one happy to see you back. Please keep it up, don't abandon the channel for so long. I learned JavaScript thanks to this channel and already write my own applications in nodejs, svelte, tailwind and use GAS as backend in them. With pleasure and deep sense of gratitude, your subscriber from Russia.

@richardthemagician8991 Ай бұрын

Same!

@ExcelGoogleSheets Ай бұрын

Thanks! I was really busy with my business, which is a good thing. KZfaq is a good hobby, but it doesn't make a living for me.

@wkardita Ай бұрын

Same... Your channel has helped me in automating my administrative activity, it had created more than 1mio covid letter pdfs during the pandemic before being taken over by the product team

@Soundofegypt Ай бұрын

Welcome Back We miss you and miss your beautiful lessons

@TheDroberto87 Ай бұрын

Welcome back here! I hope there will be new videos regularly, this is clearly the best Google sheet KZfaq channel.

@muraly3523 Ай бұрын

Love you sir.I learnt google sheet basics from you.Happy that you are back. From India

@melenev Ай бұрын

I've been wondering for the past few days, if you'd be back to cover this latest addition to GSheets ... Thank you, Thank you Thank you...Glad you're back.

@Allen-L-Canada Ай бұрын

You are back, I was thinking about you from time to time, especially when I use my Googlesheet. I was thinking you must have moved on to AI stuff already. :) so glad that you are back.

@compjotter2556 Ай бұрын

Great that you are back with awesome explanations.

@user-pg5kb3ow8p Ай бұрын

I have learnt so many spreadsheet things through your Tutorials. Thank you!

@ManojGuptahome Ай бұрын

Thank you very much for yet another informative post. Is there any way to format currency or date or even amounts in a particular format

@ExcelGoogleSheets Ай бұрын

Yes. Just select the column and use custom number format as you usually do when it's not a table.

@RyanHoilman-pj4pn Ай бұрын

I was worried you had quit. So thankful for all you have taught me in excel/google. Welcome back!

@shekhasif604 Ай бұрын

Welcome back good to see you 😊

@videosGNP Ай бұрын

The more I watch this video the more I am learning. And being able to implement the TABLE feature in my workload is the best part. Thank you again!

@pancux670 Ай бұрын

Waiting for so long from you Sir, finally you are back with awesome videos on Google Sheets

@googleguruji2553 Ай бұрын

Welcome back dude.

@MichaelBielski Ай бұрын

I saw the release of tables in Sheets and just hadn't gotten around to grokking it yet. You've done it for me, and in a very easy to understand way. Thank you! (OMG I have so much work to re-do now...)

@uribudnik Ай бұрын

Great to see that you are back. Your videos are always excellent.

@JoshPeterson Ай бұрын

I was just on Reddit last night talking about tables and here you are. Your tutorials are awesome. Thank you!

@canalhendstabanez Ай бұрын

Welcome back 🥳

@ExcelGoogleSheets Ай бұрын

Thank You!

@douglasteixeiragoncalves6084 Ай бұрын

Thank you so much for coming back, teacher! You are amazing!!!

@SheetsNinja Ай бұрын

Welcome back! Glad to see your perspective on Tables!

@Electric-Bob Ай бұрын

Teacher...Long Time No See! This Video I believe will Solve a Huge Problem with my Little Ongoing Project I have been Stuck On for Some Time!! Thanks...your The Best!!!

@hivinay83 Ай бұрын

Thank you sir. I had gained a lot from your videos.

@DreamWorker0 Ай бұрын

I waited for you every day, my google spreadsheet teacher!

@ryanduy Ай бұрын

Hi bro, long time no see. Welcome back

@ozgurugur7609 Ай бұрын

Thank you for the video king! Learned so many things from you!

@ugzmug8103 Ай бұрын

welcome back my brother nice to see you again

@mohitsharma-ym3km Ай бұрын

Happy to see you back 😊

@guihprado3366 Ай бұрын

Great great to see a new video!!🎉

@DIN-Norm Ай бұрын

Welcome back!

@AmmarMerhbi77 Ай бұрын

Welcome back.. It's been 1 year...

@canalhendstabanez Ай бұрын

This is the best channel of Google Sheets ever

@conuk35 Ай бұрын

Yeees! Learnt so much from your videos. Thanks for your efforts.

@jdml3575 Ай бұрын

He is back!!!

@bigbrother1211 Ай бұрын

This is very useful!

@anhjou Ай бұрын

the king is back!!

@xaquison Ай бұрын

Excellent video as always

@sharitambasco9780 Ай бұрын

Welcome back. I hope you are doing well. You are my favourite content creator and I have made so many useful things based off of your lessons. If life takes you away from the channel we will all understand, but for now I am so happy to see you back.

@rogersantoyo Ай бұрын

So glad you're back ! We missed you ! Great and helpful video as usual.

@khaledaboelhamd Ай бұрын

I am happy that you are back, I hope you are well

@MattDog_222 Ай бұрын

Oh wow I havent seen one of these thumbnails show up in my feed in a long time. I first subscribed 5+ years ago when working on some random side project in high school, and then stumbled across ur import HTML/XML parsing videos and thought it was some crazy magic I was populating my spreadsheets with... and now I'm a web developer. Thank you xD

@ExcelGoogleSheets Ай бұрын

I'm starting to despise web development lately 😀 Every month there is a new way of doing the same thing.

@ilhamyahyamiy720 Ай бұрын

My mannn

@Nataliia_B 15 күн бұрын

Welcome back! Thank you very much for the new video

@siddharthjain6629 Ай бұрын

I am Glad to see you back sirji. You spreadsheet tutorial are the best tutorial I have ever seen. Also I get a lot of respect because of you at my workplace. You are doing a great job keep doing it Sirji.

@Electric-Bob Ай бұрын

Sidd...you are so fortunate to know Sirji personally! He is an Incredible Teacher!! Be an Honor to Talk to him in person!!!

@ExcelGoogleSheets Ай бұрын

Thanks a ton

@arctichawk3502 Ай бұрын

Welcome back! And again a great tutorial on Google sheets Table!

@vlrvrl4443 Ай бұрын

Thank you and welcome back! Do you know if we can reference the table using gas as we can for namedranges?

@nikhilbhukhri2838 Ай бұрын

Welcome sir

@AlaaNoureldien Ай бұрын

Welcome back ❤🎉

@jamesepace Ай бұрын

Cool! I hadn't realized they added Tables! Thanks for the video.

@OussamaELAHMAR Ай бұрын

Salam o Aaalikom, it's nice to see you again with your great videos, we miss you a lot :)

@ExcelGoogleSheets Ай бұрын

😊 thanks!

@mistermtwentyforseven Ай бұрын

Welcome back buddy!

@AlaaNoureldien Ай бұрын

Welcome back ❤

@sam_safari Ай бұрын

wow you are back now

@shubhamcreation337 Ай бұрын

Welcome Back Sir! Thanks for making this valuable content. Lot's of love from 🇮🇳

@ExcelGoogleSheets Ай бұрын

👍

@tecnoideas7436 Ай бұрын

The King is back!

@samniengpollong7841 Ай бұрын

Thank you sir. I've learned so much from your video. You are amazing. More video pls..s

@cric8482 Ай бұрын

Thanks for this very good video and welcome back ! Take care when using array formula inside a table. If you sort the table by a column, the results may be strange or wrong.

@ExcelGoogleSheets Ай бұрын

good point!

@desrajsingh1345 Ай бұрын

So happy to hear your voice again 🙏.

@ExcelGoogleSheets Ай бұрын

😊 thank you

@jj342 Ай бұрын

Top stuff!

@lpanebr Ай бұрын

Good to see you back! I did not find a feature to unconvert a table. I think they forgot to add it?

@ExcelGoogleSheets Ай бұрын

Yea, the worst part is when you delete the table it deletes the entire thing 🤣

@ExcelGoogleSheets Ай бұрын

You'll have to copy/paste as values only someplace else.

@lpanebr Ай бұрын

@@ExcelGoogleSheets I almost fell from my chair when I found out! 😂🤣😂🤣

@lpanebr Ай бұрын

@@ExcelGoogleSheets I love that the new lines added to tables seen to retain the column formatting much better!

@Allen-L-Canada Ай бұрын

Does the table content has always be static? Can the content be a result set from a formula, eg. FILTER, UNIQUE etc.? thanks

@ExcelGoogleSheets Ай бұрын

No.

@gabrielamilla Ай бұрын

Welcome back! We love you! :)

@Ben-cc3fj Ай бұрын

Welcome Back!!

@xaquison Ай бұрын

YOU ARE BACK? 🙏

@bryan1311 Ай бұрын

First. Long time sir.

@jj342 Ай бұрын

Can i set a default view? for a table ...group by one of the columns, I want everyone to see it with this view

@marychan-e1t Ай бұрын

Where can I find all your google sheets practice files for all your videos here on your KZfaq Channel?

@66Komodo Ай бұрын

Welcome back.

@cric8482 Ай бұрын

Hi. Any idea if it is possible to populate a table with data using appscript ? Seems to be defined as a "banding" Create a banding : spreadsheet.getRange('D7:E7').activate(); var banding = spreadsheet.getRange('D7:E7').getBandings()[0]; banding.setRange(spreadsheet.getRange('D7:E700')) .setHeaderRowColor('#356854') .setFirstRowColor('#ffffff') .setSecondRowColor('#f8f9fa') .setFooterRowColor(null); Of couse an excellent video (as always) will be appreciated 🙂

@krishnatate4765 Ай бұрын

Thank u google sheet MASTER ❤

@richardthemagician8991 Ай бұрын

I can't wait to see how tables can work with JavaScript

@guihprado3366 Ай бұрын

How would tables work with imported data or query formulas that are always changing ranges?

@ExcelGoogleSheets Ай бұрын

Depends...

@richardthemagician8991 Ай бұрын

Do you have a question. Let's say make a table. For the data and column one, I want to pull in data from another sheet. Something like a form response. So every time I get a new form response, the array formula will pull the data in to the table. Will that expand the table as well? And if I delete data from the table, will it automatically shrink the table range? For example, if I'm pulling in data from another sheet using an array formula, if I delete one of the rows from the data range, then the listing column one of the table will decrease. Will that affect the table range itself?

@ExcelGoogleSheets Ай бұрын

No, I don't believe formula updates will grow or shrink your tables, at least not at the moment.

@richardthemagician8991 Ай бұрын

@@ExcelGoogleSheets gotcha. I appreciate the reply. What about pulling in data within the ray formula? Do you think that might work? It would at least be one problem solved.

@ExcelGoogleSheets Ай бұрын

I don't think array formula will grow or shrink the table. The purpose of the table is for formulas to react to table growth, not the other way around.

@mazaruddin9261 Ай бұрын

Could you please make a video on the sql in sheets video again because the old one is not working anymore

@ExcelGoogleSheets Ай бұрын

KZfaq removed the video for violating their terms of service. They said it was removed for posting offensive content, bullying. I've tried to appeal, but everything is automated these days, so it was rejected and their customer service is AI bots too and it said they stand behind their decision. Can you believe it? :) It was a one hour video, it took over a week to make it. Anyways, I don't think I'll be posting one again, sorry.

@DaveGhidiu Ай бұрын

Thanks!

@ExcelGoogleSheets Ай бұрын

Thank You!

@alihakanmutluay Ай бұрын

you have been missed

@francoischarette2139 Ай бұрын

Hello. Thanks for the video. Now is there a way to retrieve the data using the table name with App Script ?

@ExcelGoogleSheets Ай бұрын

Doesn't just the usual getRange() method work?

@francoischarette2139 Ай бұрын

@@ExcelGoogleSheets Of course you can use the getRange() method. But let's say you know the name of the table but not it's location. It would be nice to have a method getTableByName(). In Excel VBA we can do: set oTable = ActiveSheet.ListObjects("TableName"). Do you know if there is something similar in Google Sheets?

@francoischarette2139 22 күн бұрын

@@ExcelGoogleSheets Of course I can use the getRange() method. But what if I don't know the location of the table? In Excel VBA I can access the table using it's name with ActiveSheet.ListObjects.Item("tableName"). Do you you if something similar exist in Google Sheets?

@Medsabry98 Ай бұрын

what about another spreadsheet?

@Allen-L-Canada Ай бұрын

How is a Table different from a Named Range?

@StefanoVerugi Ай бұрын

I think Named Range just replaces usual format like B2:G17 with a "name" Table instead leverages on the column name reference and other features shown in the video

@ExcelGoogleSheets Ай бұрын

What he said ^^

@sergheyzaporojanu6872 Ай бұрын

useless feature they picked up from excel... I think Google just has to focus on their innovation more and never look back at that old and stupid Excel.... Everybody loves GSheets because it's better than Excel. And now they want to be like Excel?! really?! 😅

@ExcelGoogleSheets Ай бұрын

I find your logic very odd. The entire Google Sheets project is a copy of Excel to begin with. How are you upset that they copy Excel features all of the sudden? What innovation has Google Sheets made? I haven't seen anything innovative in Google Sheets since I've been making videos about it for 7-8 year now.

@sergheyzaporojanu6872 Ай бұрын

@@ExcelGoogleSheets IMPORTRANGE to begin with. UI, appscript on JavaScript, Query etc...

@ExcelGoogleSheets Ай бұрын

@@sergheyzaporojanu6872 As far as I'm concerned, none of that was improved in any way within the last 7-8 years. They couldn't even improve QUERY to support basic SQL like join statements. Don't get me wrong, it's not like I dislike Google Sheets, but at this point it has fallen behind. The only good things that were added in Google Sheets within the last 8 years were all thanks to Excel, like LAMBDA, named functions, REDUCE, MAP, BYROW, TOCOL, WARPCOL etc.

@ExcelGoogleSheets Ай бұрын