It can get really complex, but the basics are really the foundation of everything and aren't terribly hard to master quickly. I'm so glad it helped you! :)
Great video! And only in 7 Minutes, I dint have the patience to watch an hour long video but your video explained all the facts in only a few minutes! Thanks Man
Thank you. That’s what I was going for. Was worried that I might be rushing it along too fast for most people but I see that that’s not the case. Glad you enjoyed it and thanks for commenting! :)
I had heard of the program but never had to use it before. My boss asked if I knew how to use the program today. Now it doesn't seem so difficult to use! Thanks so much for sharing!!
I already have questions. How do you hide/unhide columns and delete columns? Also I saw someone take a portion or a spreadsheet and drop into a word doc and it turned into a table. How do you do that? Best Excel class I’ve seen on TH-cam. ❤
To the first question, Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent. Right-click the selected columns, and then select Hide. To the second question, you should just be able to select the cells you want to put into word, hit ctrl-c to copy to the clipboard, then in Word, hit ctrl-v to paste
That coffee mug makes your show look small 🤣 Thank you for the 101 on Excel, I have a job interview today and I will be trained on using excel but want to warm myself up to it!
Thank you! This is great for the Uber basics. I will share with my staff. Do you have like a Part 2 more advanced video to learn functionality? I use excel as a clinical nurse educator and want to learn how to create staff lists and see if there is a way to have a function where let’s say for example someone’s certification was expiring I could set up an algorithm or formula to high the date in the sheet when the date is approaching expiration like 30 days out and shows up yellow or shows up red when it’s expired? This is to help keep track of staff records and compliance. Thanks again!!
Thanks for your feedback! I am working on a "level 2" video. I was going to create a basic income/expense spreadsheet, but I like your idea. Let me see what I can put together for you ;)
Thanks! I didn't realize how popular and in demand a REAL tutorial would be, so I definitely plan on making more advanced tutorial videos! Thx again for your comment, glad you enjoyed!
Sir this a great efficient and concise way to wrap up everything ,is it possible for you to display another powerpoint for beginner and advanved presentation in 4D?
I'm not an Excel wizard by any means...there are lots of Excel tutorial channels on YT...but when I come across something that I find useful (like my income tracking spreadsheet video), I will make a video on it!
Can you point me to a video on how to format a column to hyperlink multiple email addresses at the same time that are plain text and currently not linked? Also, is there a way to change the hyperlinked emails so that when they are selected they use the contacts from my Google contacts rather than pulling up Microsoft Outlook?
I'll have to look on the first part. The second part, Excel will open the default mail program using the "mailto:" tag in the hyperlink. To my knowledge, there is no way to get it to open Google contacts. That being said, if you set up Outlook or Thunderbird to be your mail program, and configure your Gmail account there, it *would* work that way
It's not hard. Learn the basics, then when you need to know something specific, search for a how-to, then master that. Eventually you'll be an absolute whiz. Everything I know I've just learned on the go, as needed. You got this!
@@AskYourComputerGuy Yeah surprisingly so far its not as bad as it seems. They want me to learn it good for my job training in accountant. Great Video!
great videblo can you talk louder about macro java recording just can't get enough of macro java recording gotta lobb excel 2007 on a xp pile of shit using macro java recording can u tell me blow abowt macro java recording and excell 2007 please
This was one of my first videos from over 2 years ago. I used what I had to work with, as I wasn't making revenue yet. I'm sure your first videos weren't top of the line. Cut me a break, will ya? I've gotten better.
Honestly, it kinda did. People tend to think TH-camrs have it all together from minute one, that we are professional audio and video experts with unlimited budgets. We aren't. We spend hundreds and thousands of hours working hard to maybe one day make enough money and buy the equipment so people will take us seriously. I have a thick skin (have to on THIS channel). Guess you just caught me in a mood. All is forgiven. Unless I still suck as bad as I did then...then you have permission to blast me 😂😂😂
@@AskYourComputerGuy I guess our accounts use it for keeping up with data your videos are really good for starters and you teach in depth enough that I can understand and follow along on my computer because I learn hands on rather then being told
Thank you! That was my plan from day one is to make techie stuff simple enough for "everyday" people. I'm glad you agree, it's nice to hear when your target audience appreciates the grind that it takes to put out quality content! :)
@@AskYourComputerGuy do you have a video on how to do math formulas with excel that’s the one that I can figure out, they video I watched for school called it a intrest calculator they used on excel
Great video. I’ve been intimidated by excel my whole life but feel like it’s simpler than I made it up to be.
It can get really complex, but the basics are really the foundation of everything and aren't terribly hard to master quickly. I'm so glad it helped you! :)
@@AskYourComputerGuy Where’s part two to this video?
once you get the basics down, its really feels much simpler
@@Countcho yes definitely you got that right I’m struggling to master it rn 😅. Any tips?
Hopefully I was able to help with that 👍
I can now say in job interviews that I know how to use excel! Thank you!
That is the most amazing thing ever! Thank you so much :)
Great video! And only in 7 Minutes, I dint have the patience to watch an hour long video but your video explained all the facts in only a few minutes! Thanks Man
Thank you. That’s what I was going for. Was worried that I might be rushing it along too fast for most people but I see that that’s not the case. Glad you enjoyed it and thanks for commenting! :)
I had heard of the program but never had to use it before. My boss asked if I knew how to use the program today. Now it doesn't seem so difficult to use! Thanks so much for sharing!!
It's actually quite simple, once you understand the basics. Glad it helped you out!
I already have questions. How do you hide/unhide columns and delete columns? Also I saw someone take a portion or a spreadsheet and drop into a word doc and it turned into a table. How do you do that? Best Excel class I’ve seen on TH-cam. ❤
To the first question, Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent. Right-click the selected columns, and then select Hide. To the second question, you should just be able to select the cells you want to put into word, hit ctrl-c to copy to the clipboard, then in Word, hit ctrl-v to paste
Needed this refresher, it's been a minute, great job making it easy to follow and grasp
Thanks so much! That was my goal. We all need reminders from time to time :)
Probably the best I have found so far.
Thanks! I hope to make more advanced (yet easy to follow) lessons. I appreciate the compliment! :)
Thank you! Great, clear, simple and easily understandable explanations!
I appreciate that! Glad it helped 👍
Great information for everyone, specially a novice trying Excel. Step by step in every day terms. Easy to understand. Your coffee cup - WOW!
LOL thanks!
watching before an interview, that i just found out i need excel for! thanks! i feel so much less intimidated now!
Awesome! Good luck! Hope it helps :)
Wonderful video. Brought back memories of when I tried Excel 97. Thx !!!
Glad you enjoyed it 👍❤️
I'm an old fart. Watched 3X & I got it & then immediately banged out my version. Your a great teacher! Well done!
Fantastic! ❤️👍
Thank you I’m really computer illiterate so I’m trying to educate myself👏🏿🙏🏿❤️
You're welcome! 👍
Thanks for the tutorial, looking on level 2 clip, need to learn how to create formulas that can sumn up quantities etc
Glad it was helpful!
That coffee mug makes your show look small 🤣 Thank you for the 101 on Excel, I have a job interview today and I will be trained on using excel but want to warm myself up to it!
The coffee mug was my feeble attempt at humor. Thx for noticing and good luck on the interview!
@@AskYourComputerGuy I got a good laugh, thanks for your humor 😂 & also, I got hired! 😃
Boom!!!! Way to go!!
Excellent "battleship" reference !
Video, A+
Thank you so much! I try 😂
Thank you! This is great for the Uber basics. I will share with my staff. Do you have like a Part 2 more advanced video to learn functionality? I use excel as a clinical nurse educator and want to learn how to create staff lists and see if there is a way to have a function where let’s say for example someone’s certification was expiring I could set up an algorithm or formula to high the date in the sheet when the date is approaching expiration like 30 days out and shows up yellow or shows up red when it’s expired? This is to help keep track of staff records and compliance. Thanks again!!
Thanks for your feedback! I am working on a "level 2" video. I was going to create a basic income/expense spreadsheet, but I like your idea. Let me see what I can put together for you ;)
I'm a little late to the party but THIS was so super helpful!! Thank you!
Glad it was helpful!
Nice beginning video. I hope you made more on Excel. Thanks!
Thanks! I didn't realize how popular and in demand a REAL tutorial would be, so I definitely plan on making more advanced tutorial videos! Thx again for your comment, glad you enjoyed!
Thanks for the best explanation
Glad it was helpful!
Thank you learnt a few things here today
Sir this a great efficient and concise way to wrap up everything ,is it possible for you to display another powerpoint for beginner and advanved presentation in 4D?
I don't do much with PowerPoint. I'm sure there are plenty of PP experts on TH-cam though! 👍
great video, i watched other tutoial videos but you made it so easy thank you. can you continue doing excel tutoial i want to be pro it excel 🙂👍
I'm not an Excel wizard by any means...there are lots of Excel tutorial channels on YT...but when I come across something that I find useful (like my income tracking spreadsheet video), I will make a video on it!
Great tutorial! Thank you☺
Thank you! Glad you enjoyed it! :)
Wow quick and easy, thank you.
Glad you enjoyed it! Thanks :)
Thanks this dummie got it!
Awesome! 👍
Very helpful
Thx for saying so! I appreciate it :)
Thx ur video just motivate me for more
Working on a follow-up video...a bit more advanced but easy to follow. Stay tuned!
🙏 thank you
Appreciate i man. I'm off using excel
Awesome 👌
That coffee mug, though. Lol
😂😂😂
Thank for this video. Can you help me create an excel calculator? I will send you a video of what i need.
Send to "askyourcomputerguy(at)gmail(dot)com" and I'll take a look. Or post the link here 👍
Can you point me to a video on how to format a column to hyperlink multiple email addresses at the same time that are plain text and currently not linked? Also, is there a way to change the hyperlinked emails so that when they are selected they use the contacts from my Google contacts rather than pulling up Microsoft Outlook?
I'll have to look on the first part. The second part, Excel will open the default mail program using the "mailto:" tag in the hyperlink. To my knowledge, there is no way to get it to open Google contacts. That being said, if you set up Outlook or Thunderbird to be your mail program, and configure your Gmail account there, it *would* work that way
That giant coffee mug killed me 😂😂😂😂
Is a worksheet another word for a spreadsheet?
No. A worksheet is one "page" of a spreadsheet. You can have 1 or 10000 worksheets inside a single spreadsheet
@@AskYourComputerGuy thank you.
@spencer_jackson542 you bet 👍
Solid man
Thank you :)
✌️
I am training to be an accountant I have to learn this excel
It's not hard. Learn the basics, then when you need to know something specific, search for a how-to, then master that. Eventually you'll be an absolute whiz. Everything I know I've just learned on the go, as needed. You got this!
@@AskYourComputerGuy Yeah surprisingly so far its not as bad as it seems. They want me to learn it good for my job training in accountant. Great Video!
Thanks so much! Keep at it, you can do it
great videblo
can you talk louder about macro java recording
just can't get enough of macro java recording
gotta lobb excel 2007 on a xp pile of shit using macro java recording
can u tell me blow abowt macro java recording and excell 2007 please
3:42 beverly hills oh yeah!
Sorry, don't know about macro Java recording 🤷♂️
😂
Michael Franco, accountant at Apple, Husband of Edith Silva, brought me here
"allegedly" he's jewish
Next video is sound check for dummies
This was one of my first videos from over 2 years ago. I used what I had to work with, as I wasn't making revenue yet. I'm sure your first videos weren't top of the line. Cut me a break, will ya? I've gotten better.
@@AskYourComputerGuy Fair enough. Hope my message didn't come off as too rude. I will give you a thumbs up :)
Honestly, it kinda did. People tend to think TH-camrs have it all together from minute one, that we are professional audio and video experts with unlimited budgets. We aren't. We spend hundreds and thousands of hours working hard to maybe one day make enough money and buy the equipment so people will take us seriously. I have a thick skin (have to on THIS channel). Guess you just caught me in a mood. All is forgiven. Unless I still suck as bad as I did then...then you have permission to blast me 😂😂😂
I don’t wanna learn it but I have to for school…. They teach us but i need a more in-depth
I use Excel almost daily. It's a good program to know and learn the basics of :)
@@AskYourComputerGuy I guess our accounts use it for keeping up with data your videos are really good for starters and you teach in depth enough that I can understand and follow along on my computer because I learn hands on rather then being told
Thank you! That was my plan from day one is to make techie stuff simple enough for "everyday" people. I'm glad you agree, it's nice to hear when your target audience appreciates the grind that it takes to put out quality content! :)
@@AskYourComputerGuy do you have a video on how to do math formulas with excel that’s the one that I can figure out, they video I watched for school called it a intrest calculator they used on excel
@@AskYourComputerGuy we have to learn it for the billing portion
First video that is REALLY simple and GOES STRAIGHT TO THE POINT!!! I appreciate it so much, thank you. You helped me at work today. 🫶🏼