📝 FREEBIE: Download my free CHATGPT and MIDJOURNEY Cheatsheets ►www.learnwithseb.com/go/newsletter/ ✨Want to learn AI Marketing Secrets Used By The Top 1%. Get my AI Marketing Blueprint ►www.learnwithseb.com/go/ai-marketing-blueprint/
No silly animations and you don't feel the need to green screen your face. It's much better for the learner. Thank you for making a no nonsense tutorial.
All my conversions had a dollar sign in front of them and I had no clue how to fix it. To be honest, I had no faith you’d answer my question in this video but you sure did! Thank you!
Excellent, Thank you. I have many hundreds of Excel hours under my belt, but have not used it a great deal since retiring. I liked the idea of the portability offered by Google Docs and Sheets for a current family-related project. The task does not require much "horsepower"... mainly keeping lists and transaction details synched over multiple devices. It's working out great. Having watched your video, I am delighted to find how many features and shortcuts in Google Sheets are identical to the Excel equivalents. I am happiness filled! Thanks again... Liked & Subscribed.
GREAT VIDEO!!!! Only 1 suggestion......pasting data from outside of Sheets and want to maintain internal formatting that you're already using.... Control - Shift - V is the fastest way to paste values only. I use it all the time.
Thank you for the informative course; I've learned many new things! Just one thing I noticed: Tip 12: on mac, I had to use a semi colon instead of a comma.
Great video, Seb. Thank you. I have a question of a bit more advanced nature. I have a spreadsheet ing Google Sheets with 16 tabs. Within the 16 tabs, there are many formulas pulling information from a tab called "T1 Descriptions." I have copied duplicated T1 Descriptions and called it "T1 Descriptions." I would now like to duplicate the other 15 tabs, HOPING that they would draw information from T2 Descriptions instead of T1 Descriptions. However, I am unable. When I duplicated the 15 tabs, they still try to find information from T1 Descriptions. If that makes any sense, do you have any suggestions? Thanks.
Hi, some great tips, thank you. I have a question for you if you could help. I have a sheets file spanning several months on different pages. When I open the the file on an android device it always opens on the last created sheet/page, but when I open the file on desktop it always opens on the first created page & not the most recently one. I cannot find a command to make the file open on the last created page. Is there a command or formula I can insert in the sheet file to make it open on the last created page.
I am trying to find a method to insert a column while not interrupting formulas that are calculating a running total across time from left to right. I track events that sometimes need to be inserted, and I need the same formulas to be inserted, and the ones to the right should correspondingly adjust. A simple description is that I need to copy a range of cells, including format and formulas, and insert a copy to their left, including formatting and formulas.
Dear Sir, I need your help in google sheet, how to insert blank row formula/automatically between data in google sheet. For Example : I have my working data on google sheet with 7 columns a thousand rows and in my 4th column has a city's name and I want to insert a blank row after the city's name change in my google sheet. Excel has that option to select the whole sheet and insert a blank row but I am a new user of google sheet and it's difficult for me for my work. I hope you help me for this matter
How to split paragraph text to subsequent columns? In excel we can delimit by selecting Other and type control J then the text in single cell will split. Can you show that and want that feature in dynamic way., so everytime I add new data it should split automatically
I MAY BE ABLE TO HELP YOU! But probably not... I have just spent a stoopid amount of time trying to find out how to name, or rename a Google Sheets spreadsheet. I created a spreadsheet a few days ago, and gave it a name... easy and logical; no research requiired. Today, I tried to create another one, with a different name... I couldn't figure out how to change from the default name. All the search responses said much the same thing: "Click on 'File' at the top-left of the screen"... NOT ONE OF THEM SAID "IF YOU CAN'T SEE 'FILE', CLICK THE DOWN ARROW AT THE RIGHT HAND END OF THE ICON BAR"! 👎 😡 Like a lot of things... It's easy once you know how! 🥴
📝 FREEBIE: Download my free CHATGPT and MIDJOURNEY Cheatsheets ►www.learnwithseb.com/go/newsletter/
✨Want to learn AI Marketing Secrets Used By The Top 1%. Get my AI Marketing Blueprint ►www.learnwithseb.com/go/ai-marketing-blueprint/
No silly animations and you don't feel the need to green screen your face. It's much better for the learner. Thank you for making a no nonsense tutorial.
TIMESTAMPS:
0:14 Lock top row
0:54 Resize column
1:50 Add column
2:24 Jump to end cells
2:58 Highlight cells
3:28 View sum
4:27 Flip row and column
5:11 Add date
7:07 Capitalise names
7:47 Remove extra spaces
8:10 Combine formulas
8:56 Split text cells
9:36 Join cells
10:16 Filter data
11:15 Copy style
😊😊pp😊😊😊😊😊😊😊😊😊😊😊😊p😊😊😊😊😊
Thank you… 💜
Thank you very clear directions. Easy for beginner. You covered so much great info I subscribed!
Thanks for this video it is very informative and easy to follow. Cheers!
All my conversions had a dollar sign in front of them and I had no clue how to fix it. To be honest, I had no faith you’d answer my question in this video but you sure did! Thank you!
Excellent, Thank you.
I have many hundreds of Excel hours under my belt, but have not used it a great deal since retiring. I liked the idea of the portability offered by Google Docs and Sheets for a current family-related project. The task does not require much "horsepower"... mainly keeping lists and transaction details synched over multiple devices. It's working out great.
Having watched your video, I am delighted to find how many features and shortcuts in Google Sheets are identical to the Excel equivalents. I am happiness filled!
Thanks again... Liked & Subscribed.
Excellent, thank you. Undoubtedly the most useful 12 minutes I've had today. 👍
This is straight forward..easy to understand. Thank you.
GREAT VIDEO!!!!
Only 1 suggestion......pasting data from outside of Sheets and want to maintain internal formatting that you're already using....
Control - Shift - V is the fastest way to paste values only. I use it all the time.
Really needed this, Thank you so much Sir.
Great tips. Transpose is available as a function. You can directly reference it, instead of copy paste
Simple yet perfect 12mins learning
You have made love Data Entry again!! May the rest of your life and days be this effecient and enjoyable!
0o0 creating Filters will be godsend for me at work! TYSM!!!!!
OMG you answered my question in the first 30 seconds of the video! love it!
I'm so glad! Happy to help.
Thanks for sharing those tips and tricks it made my work easier and benevolent .
I really needed such information THANK YOU
Thank you for the informative course; I've learned many new things! Just one thing I noticed:
Tip 12: on mac, I had to use a semi colon instead of a comma.
When combining for address labels, what character between the quotation marks in fx will go to new line rather than letting it wrap in awkward places?
thank you so much! great video!
Great video, well explained! Thank you.
Thanks man. That really helps
tq bro. i surprise all little things is new knowledge for me.
I have learned so much in this video. Thank you for uploading this. Keep it up.
Very useful and well done tutorial. Thank you
super SUPER useful. thank you so much.
Useful tips. Thank you
Welcome 😊
Thanks Seb. Another cracking video - I learned a few new tricks.
Thanks Timothy.
Thank you so much for this video ❤
Thank you so much for your help. 😊
@7:49 Thank you for sharing this. This is huge!
Your pronunciation of 'spreadsheet' at 11:22 had my girlfriend crying in tears! But in all seriousness, thank you for the good content.
Thank you Seb, you are always on point... Great hook!
So helpful!!! Thank you!!
Your explanation was very nice. I give you full star rating. Very pleasant voice.
Thanks
Great video, Seb. Thank you. I have a question of a bit more advanced nature. I have a spreadsheet ing Google Sheets with 16 tabs. Within the 16 tabs, there are many formulas pulling information from a tab called "T1 Descriptions." I have copied duplicated T1 Descriptions and called it "T1 Descriptions." I would now like to duplicate the other 15 tabs, HOPING that they would draw information from T2 Descriptions instead of T1 Descriptions. However, I am unable. When I duplicated the 15 tabs, they still try to find information from T1 Descriptions.
If that makes any sense, do you have any suggestions?
Thanks.
These productivity tips are just what I needed! 💫 Keep rising to be who you want to be! 💫 #keeprising #risingtobe #aswerise #riser #irise
Very useful....thank you!
its very useful Thank you so much
Thanks for the information
Great Video!
Very useful tips! Thanks! 👏🏻
Hi, some great tips, thank you. I have a question for you if you could help. I have a sheets file spanning several months on different pages. When I open the the file on an android device it always opens on the last created sheet/page, but when I open the file on desktop it always opens on the first created page & not the most recently one. I cannot find a command to make the file open on the last created page. Is there a command or formula I can insert in the sheet file to make it open on the last created page.
Top Class - Really useful, great video - Thanks!
Thank you so much for this great content!
Thanks for this very simple but very clear guide.
You're welcome. Glad you liked it
That ctrl + arrow made me WOW
Thanks! As a newbie, do you know if I can track birthday rewards using Google Sheets?
Very clear a really well done video. Thank you so much for this. Was really helpful. :))
Thx you for sharing 😊
An excellent tut!
Thanks!
I'm watching It in 2024 and it was a great help. Thank you.
Pressing the F4 key is a quick way to lock cell reference.
Wow! Thanks
Welcome!
hi ,
excellent teaching, sir i want google sheet password protect colunms A to Z and columns B to Z
It is very important for beginners the you sir
I like this video a lot. It's really helpful
Thanks
Perfect 👍 please share data file for practice
from where can I download this sheet to practice?? can you pls give the link
How can I customize or organize the too many sheets tabs appearing at the footer of my spreadsheet?
Excellent teaching style. Subscribed.
Awesome, thank you!
how to copy formula without draging with mouse? is it possible to use proper function without make new column?
Thanks!
Nice! helpful video
Very well done .. you have a de-stressing Voice ha ha makes things easier 2 learn .. Cheers :)
Thanks. Glad you found it helpful.
I am trying to find a method to insert a column while not interrupting formulas that are calculating a running total across time from left to right. I track events that sometimes need to be inserted, and I need the same formulas to be inserted, and the ones to the right should correspondingly adjust. A simple description is that I need to copy a range of cells, including format and formulas, and insert a copy to their left, including formatting and formulas.
Thank you sir
Oh my god thanks so much
Thank you
Hi , how can i get the developer tap in google sheets. I need to use combo box(Forms Control) becuae i want to create a Leave Tracker. Thanks
Gracias!♥
Thank you..
Dear Sir,
I need your help in google sheet, how to insert blank row formula/automatically between data in google sheet.
For Example :
I have my working data on google sheet with 7 columns a thousand rows and in my 4th column has a city's name and I want to insert a blank row after the city's name change in my google sheet.
Excel has that option to select the whole sheet and insert a blank row but I am a new user of google sheet and it's difficult for me for my work.
I hope you help me for this matter
Really good video
Glad you liked it. Thanks for stopping by.
Thanks...!
great content
Super useful. Thanks a lot for the video :)
omg autosize all in google sheets was driving me crazy, how would you split names if there's multiple middle names and some people have 2 -5names?
Bro! you are awesome!!!
do you know filter drop list short cut for google sheets?
How to split paragraph text to subsequent columns?
In excel we can delimit by selecting Other and type control J then the text in single cell will split. Can you show that and want that feature in dynamic way., so everytime I add new data it should split automatically
Proper function is not working in google sheets it is giving as it is formula in that cell how to do camel case the entire column?
THANKS FOR VIDEO
You're welcome. Thanks for watching,
Brilliant video
merci beaucoup
Do these work on excel?
SUPER HELPFUL
How to copy as picture option
Thanks for the tip for my new job hahahaha
Need a tutorial for iPads
Amazing video🤩
Thank you kindly. Appreciate you for stopping by.
Nice
10:29 they are green not blu :O
autocrat is what you leran to use in google sheets
I MAY BE ABLE TO HELP YOU! But probably not...
I have just spent a stoopid amount of time trying to find out how to name, or rename a Google Sheets spreadsheet. I created a spreadsheet a few days ago, and gave it a name... easy and logical; no research requiired.
Today, I tried to create another one, with a different name... I couldn't figure out how to change from the default name. All the search responses said much the same thing: "Click on 'File' at the top-left of the screen"... NOT ONE OF THEM SAID "IF YOU CAN'T SEE 'FILE', CLICK THE DOWN ARROW AT THE RIGHT HAND END OF THE ICON BAR"! 👎 😡
Like a lot of things... It's easy once you know how! 🥴
where da fuccin QUERY😢
Why do i hear a baby crying in the background? It can be something else, but jesus
Very helpful! Thank you!
So helpful! Thank you!