If you liked this video, check our other tutorials to supercharge your Google Sheets experience 🚀 🔵SUM, SUMIF, and SUMIFS functions kzread.info/dash/bejne/gq6Cyc6haJS0cbA.html 🔵conditional formatting basics kzread.info/dash/bejne/gZlozLubnLvdaM4.html 🔵ARRAYFORMULA basics kzread.info/dash/bejne/dolqvNCCe5yYp7A.html 🔵data validation basics kzread.info/dash/bejne/d5WTqdRvhcvVntY.html

Thanks! Here's a guide to the sections of the video. :) 00:11- Creating a new spreadsheet 01:31- Converting .csv and .xlsx files to Google Sheets Files 02:25- Creating and Formatting sheets inside of a spreadsheet 03:35- Adding and Customizing columns 05:11- Creating a Database 05:57- Formatting Data and Cells 07:55- Useful Shortcuts 08:20- Smart spreadsheet features (pasting values, format, transposed, sequences, using Math operators (* / + -) 10:10- Anchoring values using $ sign 11:00 - Basic functions/formula (SUM, AVERAGE, COUNT) 12:10 - Share and collaborate

@harshpreetsingh63

4 жыл бұрын

😊

@jwa7378

3 жыл бұрын

People like you are what we need!

@brylzenarosa5379

3 жыл бұрын

@@jwa7378 Thanks! Glad to be of help.

@rushikumarpatil3538

3 жыл бұрын

It is already available in Description, lol

@langstonreese7077

3 жыл бұрын

tyyyyyyyyyyy!

This is excellent for someone who wants a refresher of various functions in Google Sheets. Please consider doing another video for absolute beginners and you explain it more slowly.

@coupleracademy

5 жыл бұрын

Elizabeth, thanks a lot for your feedback. We will think about recording another video in a more slow thorough manner. You can also modify the playback speed in Settings of this video (bottom right corner).

@ruthvlessing3356

4 жыл бұрын

I would also like a much slower version of this, its too fast for me to follow... I have to go back many times to review every couple of sentence a number of times...

@NotThatBob

4 жыл бұрын

@@ruthvlessing3356 Hello! I watched this video at .75 speed. Sounds a little off, but for me the speed was perfect for following along and also pausing at the right spot. All the best

@GivingIsMyGift

4 жыл бұрын

Its not just too fast it was too advanced for a beginner...

@dreamervanroom

4 жыл бұрын

@@GivingIsMyGift Hi there. I have a pride in being able to explain things at any level. On the other hand it's something I work at not a talent I have. I'd love to hang out with you for some time and figure out what you need which will help me make something like that. I don't work for Google but I have found in my life that teaching something is an excellent way to learn it better. Right now, I'm again a beginner in making spreadsheets. Of course I think I understand all the concepts but applying them is something specific. I don't know how we'll figure out how to connect since Google insulates these things so well, but willingness provides opportunity. Reddit might be a good way, with private messages.

I'm new to spreadsheets altogether so came into this as a TRUE beginner. Tightly packed with information, really amazing and extremely helpful. But found it EXTREMELY fast for this older user (in my 60s) and had to pause and rewind many times throughout. Also, there were a numer of times where the actions illustrated visually took place a second or two BEFORE the verbal instructinos were made, which I found difficult to process- I would have preferred the verbal instruciton first, followed by the visual illustration- that 1-2 seconds made a big difference. Appreciated the subtitles as well, because it helped me to hear and process the information more effectively. Thanks!

@coupleracademy

3 жыл бұрын

Thank you for your feedback, Allen! We've taken it into account and will try to go at a slower pace next time. You may also want to take a look at our Google Sheets Tutorial for Beginners article: railsware.com/blog/google-sheets-for-beginners/ Maybe it'll come in handy for better information perception.

@krblr2007

2 жыл бұрын

true; the video did not clearly show how to freeze a row header, and I had to move on and search for another video

@susandarosa4614

2 жыл бұрын

I totally agree she goes way to fast

Loved it. I especially loved learning how creating calculations on another tab would be especially helpful. Changing variables row by row, column by column seemed loathsome. Thanks!!!

@coupleracademy

4 жыл бұрын

thank you for your kind feedback:)

It moves a little fast for someone who has never used spreadsheets before. Good overview.

@coupleracademy

5 жыл бұрын

Tiffany, thank you for your feedback! in web version, you can modify the speed of the video. Use Settings (bottom right corner of the video window) -> Select the Playback speed

@Tricks99_Official

5 жыл бұрын

@@coupleracademy I've used the Playback speed - option, but it's killing the interest to watch! :/

@ruxandrai6029

4 жыл бұрын

Same here..... from the minute 10 i could not keep the pase. Not all the video is for begginers. Thanks

@Actualhumanlive

4 жыл бұрын

@@coupleracademy THe speed of the video is not the issue. It is the glossing over of concepts such as "pulling the data from the next cell after 12" when referring to another sheet. You did not explain what this means or why it happens. It's just something you said and I have rewound that part multiple times to try to understand what you mean by that.

@dreamervanroom

4 жыл бұрын

@@coupleracademy You can modify the speed on an Android device as well. You touch the three dots in the upper right hand corner and they give you choices. Myself, I often listen to things at faster speeds. It helps me pay attention so that my mind doesn't wander. On the other hand, if I need to think things over as the person is speaking, or if the accent is difficult for me, I can -and do- listen at 0.75. If I miss a word, then go back and listen again and miss it again, I also use the speed button to replay that section. That almost always works for me.

Its a lot of clear information at a fast pace. I'm experienced with excel and had some difficulty following along due to the volume shared. I'd label the title differently.

I was just confused before I watched this video, now I'm mega confused.

@MsGoddess3

3 жыл бұрын

me too. She talked way too fast.

@noorm7781

3 жыл бұрын

Why you were confused? I'm confused about that.

@laurenzojames

3 жыл бұрын

same

@shifaabid1425

3 жыл бұрын

@@noorm7781 yes, I am also confused about his confusion??!

@blvkkgoku3359

3 жыл бұрын

Me too

OMG. I really loved this. I'm super new to this whole Googlesheets and Excel stuff. This stuff looks intimidating as hell haha. I don't have a solid understanding, but after taking notes on paper and trying out the drills on my Googlesheet, I feel like I learned an amount. Thanks for the educational video :)

This video was perfect. I am comfortable with computers for the most part and was able to open a blank spreadsheet and try things out by pausing the video and then coming back. Excellent introduction for basic functions, Thank you!

Офигеть крутая история по геометри деш молодец вернам продожай в том же духе

wonderful video - thank you for making it , I shall reviewing it several times over the months to follow. Always useful to be able to look back and "refresh" our skills

@coupleracademy

4 жыл бұрын

you are welcome:)

Excellent overview. Gave me the info I needed to start a spread sheet with calculations. I paused the video frequently to make my own sheet along side her.

@coupleracademy

4 жыл бұрын

that's great. Happy you've liked it. In other Google Sheets videos you can find practice sheets drafts with data to try new functions yourself. Just copy the file and use it while watching the video. Find the drafts in video descriptions.

thanks a lot! i had a science assignment with calculating planet sizes and scaling them down. 7th grade is hard but you made it a little easier :)

@coupleracademy

3 жыл бұрын

Awesome, glad we helped! :)

Thank you, it really helped!

Extremely well presented. Language is concise and no ad libs. Additionally, very informative. Very much appreciated. THANK YOU!

@coupleracademy

4 жыл бұрын

Glad it was helpful!

@fun-club

Жыл бұрын

kzread.info/dash/bejne/pYuWmKqBgLTFgto.html

4 minutes in, and I have learned so much already, thanks a lot! :)

лучшая гд история вернама

@rayzexbeats228

Жыл бұрын

согласен

Brilliant presentation! Well explained, with useful tips that will surely aid the practical exercise.

Вы тоже тут потому что хотите узнать что это делает в плейлисте у Вернама?

Easy to understand and very useful. Loved it!

This video is larger than usual, so it's easier to watch in smartphone. Nice!

Super stepping stone for the Google Drive excel sheets

Thank you so much. Very helpful and well explained!

Very short and simple but very informative! Thank you. I'm watching this because I applied for a promotion and I need to be well versed with google sheets. I hope I get it. 🙏

@coupleracademy

4 жыл бұрын

Good luck! happy you found it helpful:)

This is a very helpful tutorial. Thank you for providing it. I've just subscribed and am looking for forward to learning even more about how to use Google Sheets well.

@coupleracademy

4 жыл бұрын

great! thank you for watching. We will add more Google Sheets videos this fall.

@mdakramul2386

4 жыл бұрын

Wws

Thanks for this millennial friendly tutorial, love the speed through and foreign accent, really holds my attention. 9 out of 10 would continuously watch all the way through

@coupleracademy

4 жыл бұрын

great, happy you've liked it!

Thank You this helps me a ton!

Had no clue about the fact it add automatically date/day/months in order once you write one, so cool!

First 10 seconds and I already knew this is the right place to learn google sheets :)

Thank you so much! I will start working with an american company and they told me to know about google sheets, Very useful!

I'm a senior trying to learn. I do like that you talk to where I can understand you. But would like it to be slower so I can comprehend better. Thank you 😊❤️🙏

@zedyasay5995

4 жыл бұрын

You can adjust playback speed in "settings"!

@coupleracademy

4 жыл бұрын

Thank you for your feedback. For this particular video, the playback speed of 0.75 might help. In the future, we will record slower presentations, as this was often mentioned.

This was great and straight to the point and your drop dead gorgeous! A+ all the way 👍 thanks 🙏

Thank you! Much appreciated.

This video was fantastic - I took it to an AARP group and everyone ended up comfortable using excel after listening only a few times. The only ask they had was: since English is not your first language (but yours is very good), slow down rather than speed up to make sure you clearly pronounce all of the syllables needed for comprehension. For example, it is BUTTun (not bottom), FEELD (not filled), AWEtomatic (Not OW-to-matic), comMAND (not comment) -- and pay attention to your stresses. For example, is FOR-mat (not formint), SEE-kwnece (not sickens), LOCK (not log), pa-REN-thuh-sees (not parathesis) etc. Maybe small things, but it would have made a difference to the older audience, which I'm imagining is yours. Thanks again for this video

@coupleracademy

7 ай бұрын

Hi! Thank you so much for your valuable feedback. We'll pass it to our content creators and will work to improve future tutorials. And we're very glad your group found the video useful. Thank you once again!

Лучшая истроия вернама о гд!!!

THIS IS AMAZING OMG HOW DID U DO THIS

@calebwalters8517

4 жыл бұрын

@@jonjoporter7107 Thank you OMG that is rlly good advice

I aint gonna lie google sheets is probably the hardest google site to learn how to use, but this video helped me understand it

Thank you so much for being so kind and generous. This really helped me out.

Hello, I found this video very helpful and it is a good start for me. I am a writer and was looking to use something like this to categorize sections of my story (lore, characters, et cetera) into a simple to use file that I can reference at any point. My question is can anyone recommend a video/article that might help me with developing that? (For example, the best type of layout or template) Thanks again for the tips, much appreciated. Take care

This is a great video for me and my team, and I hope to apply all of this in our google spreadsheet.

Nice tutorial very informative 🔥💯

This tutorial was excellent. Thanks for sharing it.

Thanks, & very clear & helpful! Learned something new.

This is great, very brief and clear

Thank you so much. This was very helpful to me!!

@coupleracademy

4 жыл бұрын

great! watch our next videos - we will learn even more of the GSheets functions and approaches

Exactly what I was looking for, neatly explained! Thumbed up and subscribed! keep up the good work!

@coupleracademy

5 жыл бұрын

thank you!

This was very helpful!

Spreadsheets are so complicated that this woman has to take deep breaths before speaking

finna create the most extravagant pandabuy spreadsheet known to mankind

Seen a few tutorials on Google Sheets. This one is just great! Very user friendly, informative and stimulating/motivating to watch it all. - It gives a general idea of the options and why/how useful Google Sheets can be. - It is explained at a very good pace (no need for scrolling back) - The explanation is for all types of ways of learning/understanding something (not getting confused, again no need for scrolling back) If it's good, it is good. =)

@coupleracademy

4 жыл бұрын

thanks a lot for your detailed feedback! happy you found it helpful. watch our Google Sheets playlist to learn even more!

@lolkhalil

4 жыл бұрын

@@coupleracademy, I am actually now in the process of doing that =) Thanks again

@gamingfarm8533

4 жыл бұрын

@@coupleracademy great vedio, thank you! and you so pretty

@Actualhumanlive

4 жыл бұрын

@@gamingfarm8533 hi creep

Thank you for a quick guide.

Holy crap..... It will automatically add up values from any two rows or colums and continue on the pattern of adding and add the new values to the rows or colums for you????? are you kidding me?? you know how much time this just saved me!!!!!!??????? THANK YOU!!!!!!!!!

It is great video. For those who works in Excel everything is clear

Appreciate this video and the help

Short and great❤

This was pretty helpful! Thanks

this is fire

@caiuscraft5611

4 жыл бұрын

🔥🔥🔥

Thank you! This was super helpful in learning basic functions fast.

I'm so lost. I think that maybe this tutorial would be great for a more advanced learner.

Outstanding, thanks for providing this.

@coupleracademy

4 жыл бұрын

Thanks for the feedback! We're happy you liked it

Nice tutorial very informative

Perfect explanation, thank you very much for such a great content!

I learnt something new! Thank you!

Math operations at 8:35. Very informative video!

@coupleracademy

4 жыл бұрын

Glad you liked it!

Thanks much...this was really helpful...you are a great teacher😊

@coupleracademy

3 жыл бұрын

You're very welcome! Glad it was helpful!

Neat, clean, perfecto.

@coupleracademy

4 жыл бұрын

thank you!

Thank you very much was quite helpful.

Excellent introduction. Thanks.

Excellent content and teacher. Well organized. I would have preferred a slower format.

waoh that woman is so professional a real good speaker for the company. Wish i had a crew like that.

This is nice to watch and I have learn easily thank you for this!

THUMBSUP!!

AMAZING

Thanl you for your help. This was alot of help

Love Google Sheets !

thank you for your work, your videos are so useful.

I am new to this. really its Very useful for me

Thanks for the useful information for starters.

Brilliant & explained in professional way Thanks for information✅

Great video!! From #Taiwan~

this is so business-grade that i thought it was just an extremely captivating ad at the start

Beautiful smart teacher.

Very informative and easy to understand 🙏🙏 from India 🇮🇳

@coupleracademy

4 жыл бұрын

Glad it was helpful!

This is very helpful. Thanks.

@coupleracademy

4 жыл бұрын

Glad to hear it!

EXCITING TECHNOLOGY. THANKS FOR THE VIDEO!!!!!!!!!!!!!!

@coupleracademy

4 жыл бұрын

thank you!

Very helpful. Thank you!

Just in 15 min , i can listen it for lifetime

Very Very helpful!

Just wanted to give a thumbs up for making such easy content for beginner. I enjoyed the process! Thank you!

@coupleracademy

6 ай бұрын

We're so glad to hear that, thank you! :)

Great...!!!

Really helpful thanks.

@coupleracademy

4 жыл бұрын

thank you!

Amazing. Thanks for sharing

@coupleracademy

4 жыл бұрын

Thanks for watching!

thankyou for this one !

WOW great tutorial

Great tutorial

@coupleracademy

4 жыл бұрын

thank you!

Very Helpful, Thank you so much

Thanks.... this is super useful...

Fantastic very informative

Thank you !