Microsoft Excel for dummies - learn the basics of Excel

Поділитися
Вставка
  • Опубліковано 3 гру 2024

КОМЕНТАРІ • 118

  • @helenaoki5079
    @helenaoki5079 Рік тому +66

    Great video. I’ve been intimidated by excel my whole life but feel like it’s simpler than I made it up to be.

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому +7

      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! :)

    • @furiousa6062
      @furiousa6062 9 місяців тому

      @@AskYourComputerGuy Where’s part two to this video?

    • @Countcho
      @Countcho 7 місяців тому +1

      once you get the basics down, its really feels much simpler

    • @furiousa6062
      @furiousa6062 7 місяців тому

      @@Countcho yes definitely you got that right I’m struggling to master it rn 😅. Any tips?

    • @AskYourComputerGuy
      @AskYourComputerGuy  7 місяців тому

      Hopefully I was able to help with that 👍

  • @palomahernandez8404
    @palomahernandez8404 Рік тому +33

    I can now say in job interviews that I know how to use excel! Thank you!

  • @fSebastianRe
    @fSebastianRe Рік тому +21

    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

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому +1

      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! :)

  • @cuprunnethover2509
    @cuprunnethover2509 Рік тому +4

    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!!

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому

      It's actually quite simple, once you understand the basics. Glad it helped you out!

  • @pikminfanclub
    @pikminfanclub 2 місяці тому

    I am amazed and frightened by the AMOUNT of people in the comments on ANY excel tutorial stating that they have a job interview and lied about their experience hahahahahah I always had a suspicion that not many people actually ever used excel, but this just confirms it! And I am no better: I have a job interview coming up and they want to test my excel knowledge. As someone who has just recently graduated and has NEVER; EVER used excel in school before (mainly word and powerpoint) this video is a blessing, thank you sir!
    Huge ass mug by the way :O

  • @cm9859
    @cm9859 Місяць тому

    I have not worked in Corporate Admin job since October 2020. I've moved and finally back in Orange County so will start looking for a new job. I had forgotten MS Word & MS Excel answers to successfully complete agency tests. I've had to practice to refresh. I now need to start taking Excel tests this week..Thank you for your easy and simplified steps.

  • @ritaturner9906
    @ritaturner9906 Рік тому +7

    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 UA-cam. ❤

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому +5

      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

    • @stellanwachukwu7359
      @stellanwachukwu7359 Місяць тому

      ​@@AskYourComputerGuymake a video on this

  • @patrickpepper2490
    @patrickpepper2490 2 роки тому +2

    Probably the best I have found so far.

    • @AskYourComputerGuy
      @AskYourComputerGuy  2 роки тому

      Thanks! I hope to make more advanced (yet easy to follow) lessons. I appreciate the compliment! :)

  • @GrippyGoth
    @GrippyGoth Рік тому +5

    Needed this refresher, it's been a minute, great job making it easy to follow and grasp

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому +1

      Thanks so much! That was my goal. We all need reminders from time to time :)

  • @lorenaw9454
    @lorenaw9454 3 роки тому +10

    Great information for everyone, specially a novice trying Excel. Step by step in every day terms. Easy to understand. Your coffee cup - WOW!

  • @smackroscoe
    @smackroscoe 10 місяців тому +1

    I'm an old fart. Watched 3X & I got it & then immediately banged out my version. Your a great teacher! Well done!

  • @KANJ612
    @KANJ612 10 місяців тому

    Wonderful video. Brought back memories of when I tried Excel 97. Thx !!!

  • @chuckbeattyo
    @chuckbeattyo 12 днів тому

    Thankyou, excellent intro, I'm the perfect guinea pig, good job. Ctrl-S !!

    • @AskYourComputerGuy
      @AskYourComputerGuy  12 днів тому

      LOL glad you liked the video! And yes, CTRL-S is your friend!

  • @zsuzsannamatalucci4318
    @zsuzsannamatalucci4318 4 місяці тому

    Thank you! Great, clear, simple and easily understandable explanations!

  • @LucretiusDraco
    @LucretiusDraco 2 місяці тому

    Thanks! Very clear instructions. I apprecitate the help.

  • @bethyberryy
    @bethyberryy Рік тому

    watching before an interview, that i just found out i need excel for! thanks! i feel so much less intimidated now!

  • @mostwantedmtl
    @mostwantedmtl Рік тому

    Thanks for the tutorial, looking on level 2 clip, need to learn how to create formulas that can sumn up quantities etc

  • @ashwaller2129
    @ashwaller2129 Місяць тому

    I start a temp job soon hopefully and I’m 33. I haven’t used this yet and I’m ready to play with it now

  • @AliGatorRN831
    @AliGatorRN831 Рік тому +1

    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!!

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому +1

      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 ;)

  • @binkyfaith
    @binkyfaith Рік тому

    Thank you I’m really computer illiterate so I’m trying to educate myself👏🏿🙏🏿❤️

  • @stellanwachukwu7359
    @stellanwachukwu7359 Місяць тому

    Oh my God for dummies like me😅 this is very simple. Please make more video on this please🙏🙏🙏🙏. I can't find another. This not enough. You are very good teachers for slow learners like me

  • @belindasedberry9479
    @belindasedberry9479 Рік тому

    I'm a little late to the party but THIS was so super helpful!! Thank you!

  • @EPYes
    @EPYes Рік тому

    Excellent "battleship" reference !
    Video, A+

  • @Hibosaidmoussacornejo
    @Hibosaidmoussacornejo Рік тому

    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?

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому

      I don't do much with PowerPoint. I'm sure there are plenty of PP experts on UA-cam though! 👍

  • @heidireyes6407
    @heidireyes6407 5 місяців тому

    Thanks for the best explanation

  • @Exercisewithleah
    @Exercisewithleah Рік тому

    Thank you learnt a few things here today

  • @gregallenphoto
    @gregallenphoto 9 місяців тому

    Thanks this dummie got it!

  • @arizonanative7409
    @arizonanative7409 Рік тому

    Nice beginning video. I hope you made more on Excel. Thanks!

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому

      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!

  • @berenicebluberry
    @berenicebluberry Рік тому +1

    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!

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому +1

      The coffee mug was my feeble attempt at humor. Thx for noticing and good luck on the interview!

    • @berenicebluberry
      @berenicebluberry Рік тому

      @@AskYourComputerGuy I got a good laugh, thanks for your humor 😂 & also, I got hired! 😃

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому

      Boom!!!! Way to go!!

  • @kingwolf3763
    @kingwolf3763 10 місяців тому

    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 🙂👍

    • @AskYourComputerGuy
      @AskYourComputerGuy  7 місяців тому +1

      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!

    • @stellanwachukwu7359
      @stellanwachukwu7359 Місяць тому

      ​@@AskYourComputerGuyplease we need more tutorials from you. Am new to this computer thing. So am trying to educate myself. You made very simple. Teach us the ones you know

  • @Takingavacation
    @Takingavacation Рік тому

    Great tutorial! Thank you☺

  • @maraelysantana7095
    @maraelysantana7095 10 місяців тому

    Awesome 👌

  • @EYCB1
    @EYCB1 9 місяців тому

    🙏 thank you

  • @stellanwachukwu7359
    @stellanwachukwu7359 Місяць тому

    Please need more on excel

  • @ludvigarstrand9666
    @ludvigarstrand9666 2 роки тому +1

    Very helpful

  • @VegaMain
    @VegaMain 2 роки тому

    Wow quick and easy, thank you.

  • @joyke66
    @joyke66 Рік тому

    Thx ur video just motivate me for more

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому +1

      Working on a follow-up video...a bit more advanced but easy to follow. Stay tuned!

  • @MetalockieMusic
    @MetalockieMusic Рік тому

    Solid man

  • @judepago8578
    @judepago8578 Рік тому

    Appreciate i man. I'm off using excel

  • @AmsterDanTheAmerican
    @AmsterDanTheAmerican Рік тому

    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?

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому

      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

  • @allstarsacademydaycare5405
    @allstarsacademydaycare5405 8 місяців тому

    Thank for this video. Can you help me create an excel calculator? I will send you a video of what i need.

    • @AskYourComputerGuy
      @AskYourComputerGuy  8 місяців тому

      Send to "askyourcomputerguy(at)gmail(dot)com" and I'll take a look. Or post the link here 👍

  • @columbagonzalez5203
    @columbagonzalez5203 2 роки тому

    That giant coffee mug killed me 😂😂😂😂

  • @azarspeaks
    @azarspeaks 5 місяців тому

    That coffee mug, though. Lol

  • @spencer_jackson542
    @spencer_jackson542 6 місяців тому

    Is a worksheet another word for a spreadsheet?

    • @AskYourComputerGuy
      @AskYourComputerGuy  6 місяців тому +1

      No. A worksheet is one "page" of a spreadsheet. You can have 1 or 10000 worksheets inside a single spreadsheet

    • @spencer_jackson542
      @spencer_jackson542 5 місяців тому

      @@AskYourComputerGuy thank you.

    • @AskYourComputerGuy
      @AskYourComputerGuy  5 місяців тому

      @spencer_jackson542 you bet 👍

  • @bursty2464
    @bursty2464 2 роки тому +1

    ✌️

  • @utahnick
    @utahnick Рік тому

    Next video is sound check for dummies

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому +1

      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.

    • @utahnick
      @utahnick Рік тому

      @@AskYourComputerGuy Fair enough. Hope my message didn't come off as too rude. I will give you a thumbs up :)

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому +1

      Honestly, it kinda did. People tend to think UA-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 😂😂😂

  • @driggs7906
    @driggs7906 2 роки тому +2

    Michael Franco, accountant at Apple, Husband of Edith Silva, brought me here

    • @driggs7906
      @driggs7906 2 роки тому

      "allegedly" he's jewish

  • @nicholasiezzi9790
    @nicholasiezzi9790 2 роки тому

    I am training to be an accountant I have to learn this excel

    • @AskYourComputerGuy
      @AskYourComputerGuy  2 роки тому +1

      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!

    • @nicholasiezzi9790
      @nicholasiezzi9790 2 роки тому

      @@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!

    • @AskYourComputerGuy
      @AskYourComputerGuy  2 роки тому

      Thanks so much! Keep at it, you can do it

  • @bobhardcore6707
    @bobhardcore6707 9 місяців тому

    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

  • @chrisannahampton
    @chrisannahampton Рік тому

    I don’t wanna learn it but I have to for school…. They teach us but i need a more in-depth

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому

      I use Excel almost daily. It's a good program to know and learn the basics of :)

    • @chrisannahampton
      @chrisannahampton Рік тому

      @@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

    • @AskYourComputerGuy
      @AskYourComputerGuy  Рік тому

      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! :)

    • @chrisannahampton
      @chrisannahampton Рік тому

      @@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

    • @chrisannahampton
      @chrisannahampton Рік тому +1

      @@AskYourComputerGuy we have to learn it for the billing portion

  • @yeve5819
    @yeve5819 Рік тому

    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. 🫶🏼