Excel Beginner Tutorial

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

КОМЕНТАРІ • 259

  • @LearnitTraining
    @LearnitTraining  8 місяців тому +18

    Exercise Files: learnitanytime.com/p/exercise-files-excel-beginner-tutorial-2024

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

      I cant really access the file dont know why. Could you help me plz.

  • @danielkaribi1248
    @danielkaribi1248 8 місяців тому +23

    The tutorial was so profound and interesting....
    Can't wait for the intermediate tutorial...

  • @Amassosable
    @Amassosable 5 місяців тому +41

    Thank you so much for making this readily available and free. I need it for my new job, but couldn't afford to pay for a course, so you not only saved the day but also saved my new job.
    I'm sorry I can only offer you a modest "Thank you", but I did like the video and subscribed as well. Not to mention, I will talk about it to others. I want to help you as much as you helped me.

    • @LearnitTraining
      @LearnitTraining  5 місяців тому +16

      You support is more than payment enough! One goal of our channel is to make sure everyone has access to software training.

    • @naziatasneem213
      @naziatasneem213 5 місяців тому +1

      Thank you. Thanks a lot.

  • @TwistedFilm
    @TwistedFilm 9 днів тому +1

    I am or was a teacher, and so I taught video editing for the board of Ed schools, and I like to think that I am a very good teacher and very detailed. Having said that, I go to UA-cam or any other social media platform to learn certain softwares, and I absolutely hate it when you see a title "for beginners" and the person doing the lecture skips through so many things that it leaves you still confused by the end of the video and you've wasted all that time. You however my friend, should be the epitome of teachers! I am a filmmaker and I'm trying to do my budget on a full feature film and I have to use excel, and I can't tell you how many people I've called just on your first video because I've learned so many things on excel, you've made it absolutely understandable, tolerable, enjoyable, acceptable, comprehensible and any other word that I might've missed that ends in ABLE!!!!!! Absolutely lovable!......... This should be the go to video on how to learn excel and I can't wait to see what other software's you have on your video list that I can learn. I thank you very much for your video and I will be sharing this with several other individuals, I am now subscribing to your channel I will be watching every video you have .....once I finish my work ha ha ha ha ha thank you again

    • @LearnitTraining
      @LearnitTraining  8 днів тому

      We are so glad you found the tutorial helpful! Your kind words mean a lot.

  • @Rainbow_Pumpkin
    @Rainbow_Pumpkin 4 місяці тому +12

    I'm a fresh grad wanting to pursue HR, but don't really have foundation due to poor quality education. My friend sent this to me, thank you very much! This would be a big help for me as I'm in my job hunting era. Bless such kind soul like you ❤

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

      We are glad to help! Good luck on job hunting!

  • @bloomingorchid9407
    @bloomingorchid9407 6 місяців тому +257

    I lied in my resume..Now I'm here..

    • @LearnitTraining
      @LearnitTraining  6 місяців тому +22

      You got this!

    • @anime10679
      @anime10679 6 місяців тому +8

      Same 😅

    • @jNICE5600
      @jNICE5600 5 місяців тому +16

      😂I was offered a position that requires this 😢and that why I’m here help us lord learn this stuff!

    • @WindyIshhFabian
      @WindyIshhFabian 5 місяців тому +4

      LOOOOOOOOOOOOL SAME. WISH YOU ALL THE BEST

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

      @@jNICE5600 🤣🤣🤣May God help us

  • @johnstanners57
    @johnstanners57 4 місяці тому +1

    Thanks!

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

      Thank you so much for your support! It helps us continue to make new videos for everyone each Friday!

  • @VivekKumar-kf8yc
    @VivekKumar-kf8yc 5 місяців тому +7

    Greatest video ever shot in the history of mankind .

  • @shilprich
    @shilprich 13 днів тому +1

    Joe, Thanks for making this beginner tutorial, This makes perfect sense for new learners!!

  • @farhanikhwan2441
    @farhanikhwan2441 8 місяців тому +5

    Thank you, i got new knowledge here

  • @sergioswedenborg8746
    @sergioswedenborg8746 2 місяці тому +1

    Excellent lesson! You were born to be a teacher Joe! You've got a subscriber!

  • @tamkodaniel479
    @tamkodaniel479 3 місяці тому +7

    Super pure gold, this trainer is a master. Thank you so much!

  • @NedsReality
    @NedsReality 3 місяці тому +5

    you are a life saver man

  • @danielleornelas2187
    @danielleornelas2187 Місяць тому +1

    By far the best, most useful course I have taken. Excellent work and thank you for the content! I'm now moving onto Intermediate and excited to learn!

  • @WandaStewart-m5f
    @WandaStewart-m5f Місяць тому +1

    I really enjoyed this course! I am excited to take your other courses.

  • @nabihahnawal4245
    @nabihahnawal4245 3 місяці тому +5

    completed in 3days very much enjoyable and engaging and learnt a lot thank you.

  • @West_Deal
    @West_Deal Місяць тому +1

    you trained very well thanks a lot .

  • @rose_gold_hera
    @rose_gold_hera 2 місяці тому +1

    Sir, I can't thank you enough for this video! I've learnt so many things that are gonna make my career so easy. I really appreciate sharing these infos for free.

  • @RinkeyChakraborty-g7z
    @RinkeyChakraborty-g7z Місяць тому +1

    Hey, lots of greetings from India. Thankyou so much for providing a quality video on excel, thank you so very much Joe for providing so deep teaching in an easy way.

  • @emmanouilkalafatis7255
    @emmanouilkalafatis7255 3 місяці тому +2

    These videos are very useful if you don't use the programs every day. They are always a good refresher.

  • @akaidikra
    @akaidikra 2 місяці тому +1

    Your teaching method is wonderful. Thank you so much

  • @ihiabeadams8475
    @ihiabeadams8475 3 місяці тому +1

    You're doing a great job here, thank you for dishing out this wealths of knowledge for free.
    But I do have a question " does it mean each time I have an excel version upgrade, I'll have to undergo a fresh training ?" I really do hope you answer me as I am so burdened by this question.

    • @LearnitTraining
      @LearnitTraining  3 місяці тому +1

      Excel for the most is unchanged from it's core for nearly a decade now. There are obviously new features and a different UX/UI but the core functions of a spreadsheet software have not changed much. Any of our videos are going to give you a solid foundation on Excel.

  • @Cocacabanabudgets
    @Cocacabanabudgets 15 днів тому +1

    very thorough! thank you!

  • @MuhammadHaris-f8w5g
    @MuhammadHaris-f8w5g 6 місяців тому +6

    Best trainer tht i ever have

  • @claire9690
    @claire9690 Місяць тому +1

    Thank you so much for the comprehensive videos about the Excel! It helps a loooot:)

  • @josepichardo9102
    @josepichardo9102 4 місяці тому +3

    I want to take the opportunity to thank you for all the hard work and dedication you put into this its amazing how all this information is free thank you thank you!!!!!!

  • @nicolerod1804
    @nicolerod1804 5 місяців тому +3

    You explained it so simply and repeated instructions which was SO helpful. THANK YOU SO MUCH

  • @berylann1372
    @berylann1372 4 місяці тому +1

    Really got a lot out of this course, Joe! Thanks

  • @bogonko-n5f
    @bogonko-n5f Місяць тому +1

    Thanks , I have learnt a lot

  • @nickmak5674
    @nickmak5674 3 місяці тому +1

    Best teaching methodology so far …thank you

  • @shivendra3019
    @shivendra3019 8 місяців тому +9

    There are so many Excel courses from different years on this channel. The videos and dedication is superb but it is confusing for me as a beginner on which excel courses I need to learn. Will I become good in Excel if I just follow 2024 Excel courses alone? The quality of teaching is amazing btw.

    • @LearnitTraining
      @LearnitTraining  8 місяців тому +5

      We have all versions of Excel from different office suites such as Excel 2016, Excel 2019, etc. We always recommend watching the videos for the version of Excel you use most.

    • @shivendra3019
      @shivendra3019 8 місяців тому +3

      @@LearnitTraining Thank you

  • @PS_Tube
    @PS_Tube 4 місяці тому +1

    I've never used excel for some mathematics and making charts for college projects, mostly using Word or Oracle DB.
    Now I'm here to brush up my excel skills.

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

      We hope you learned everything you needed!

  • @delomuvis4162
    @delomuvis4162 3 дні тому

    Hello..., thank you for sharing the course with us. I do have a question regarding the workbook you shared. I could see from the year 2024 through to 2026 with the year 2024 nicely done.
    Are we to fill in for the remaining years as a way of practicing?
    I will appreciate it if you could clarify this for me, please. Many thanks.

  • @fbcreativemedia
    @fbcreativemedia 3 місяці тому

    Great tutorial Joe..... Gonna check out some of your others......

  • @NICHOLASKRAMPAH-w3o
    @NICHOLASKRAMPAH-w3o Місяць тому +1

    Wow perfect teaching with understanding

  • @zina3283
    @zina3283 Місяць тому +1

    That is amazing. Thank you so much for this. I managed to refresh everything I knew 🤩 Intermediate is next!

  • @luelue-ns7vf
    @luelue-ns7vf 4 місяці тому +1

    so detailed, I loved it. I feel like a pro for beginners

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

    This course is the osm course i have ever got of ms excel and i decided to buy the courses online but after watching your video i get the full beginer friendly lectures here❤

  • @6155ish
    @6155ish 4 місяці тому +1

    Do you have a video for how to format a total and year to date total for a row?

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

      Certainly! Let’s dive into formatting totals and year-to-date (YTD) totals in Excel.
      Formatting Totals:
      When you want to display a total for a row (such as the sum of values in that row), you can use the Total Row feature in Excel. Here’s how:
      Create a Table:
      First, convert your data range into an Excel table (select your data and press Ctrl + T or go to the “Insert” tab and choose “Table”).
      This step is essential because it enables the Total Row feature.
      Activate the Total Row:
      Once your data is in a table, you’ll see a new row at the bottom labeled “Total.”
      Click the checkbox in the Total Row for the column(s) where you want to display totals.
      Excel will automatically calculate and display the sum, average, or other aggregate functions for those columns.
      Customize the Total Row:
      You can right-click on the Total Row cell and choose different aggregate functions (like Sum, Average, Count, etc.).
      Additionally, you can format the Total Row cells (font, color, etc.) to make them stand out.
      Calculating Year-to-Date (YTD) Totals:
      Now, let’s tackle YTD totals. These are cumulative sums of data from the beginning of the year up to a specific month. Here are a few methods:
      Using SUM Functions:
      Suppose you have monthly sales data in columns C (quantity sold) and D (total price).
      In cell E5 (for January), enter this formula:
      =SUM($D$5:D5)/SUM($C$5:C5)
      Drag this formula down to calculate YTD totals for subsequent months.
      Combining Functions:
      You can use a combination of functions like SUM, IF, MONTH, and OFFSET.
      For instance, if your data starts in cell B5 (with dates in column B), and prices are in column D:
      =IF(MONTH(B5)=1, D5/C5, SUM(OFFSET($D$5,0,0,1,1):D5)/SUM(OFFSET($C$5,0,0,1,1):C5))
      This formula calculates YTD price per unit, considering the month.
      Using SUMPRODUCT:
      In cell E5:
      =SUMPRODUCT($D$5:D5)/SUMPRODUCT($C$5:C5)
      Drag down to fill for other months.
      Dynamic Formula for YTD Growth Rate:
      Compare sales data between two years (e.g., 2020 and 2021).
      Use SUM, OFFSET, and MATCH functions:
      =SUM(OFFSET(E5,1,1,1,MATCH($I$5,$F$5:$H$5,0)))/SUM(OFFSET(B5,1,1,1,MATCH($I$5,$C$5:$E$5,0)))-1
      Adjust cell references as needed.
      Remember, Excel provides various ways to achieve the same result, so choose the method that suits your specific scenario.

  • @louenrioichi8927
    @louenrioichi8927 5 місяців тому +1

    Next month I have to learn everything you teach. Thank you so much for your efforts. I hope I can do well in my job.

  • @YoussefMaarir
    @YoussefMaarir 3 місяці тому +1

    THANK YOU SO MUCH!

  • @sibolloanderson3375
    @sibolloanderson3375 4 місяці тому +1

    I realy appreciate your video. It is very clear and helpful. I will wacth it again and again and start practice. Thank you to much. Be blessed.

  • @emmanouilkalafatis7255
    @emmanouilkalafatis7255 3 місяці тому +1

    Very easy to learn from Joe

    • @LearnitTraining
      @LearnitTraining  3 місяці тому

      We hope all our instructors are easy to learn from!

  • @designhub360customapparel
    @designhub360customapparel 21 день тому +1

    OMG thank you! I got a D in accounting One 20 years ago before there was a UA-cam cause the teacher didn't teach the basics and was going too fast. I couldn't under everything until now.

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

    The Best Tutorial

  • @doublem8667
    @doublem8667 Місяць тому +1

    Data Scientist is the goal...and this is just perfect🤗🤗

  • @brightstarxiphos3261
    @brightstarxiphos3261 3 місяці тому +1

    Incredible video! Thanks for the help!

  • @OneBelle11
    @OneBelle11 5 місяців тому +1

    Thank you so much for this training. It is easy to understand. Now I am not that scared anymore when I'm faced with excel at work. Thank you.

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

      You are very welcome! We are glad we made Excel easier to use!

  • @rthonolatundesam7385
    @rthonolatundesam7385 5 місяців тому +1

    This tutorial was very explanatory and helpful.

  • @AML89
    @AML89 Місяць тому +1

    Very good 👏

  • @user-xf8le5bc1w
    @user-xf8le5bc1w 4 місяці тому +1

    Thank you so kindly, Joe. This video has helped me so greatly.

  • @MunavvarbekDadajonov
    @MunavvarbekDadajonov 18 днів тому +2

    It is really funny and informative to learn with Joe

  • @louis_ricks
    @louis_ricks 8 місяців тому +2

    Can I learn spreadsheet basics for “pages” on Mac with this video?

    • @ramsyrama
      @ramsyrama 8 місяців тому +2

      Yes

    • @LearnitTraining
      @LearnitTraining  8 місяців тому +1

      Sure can!

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

      @@LearnitTraining awesome, thank you 🙏

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

      @@ramsyrama thanks for your reply…👍

  • @llflavioll7178
    @llflavioll7178 4 місяці тому +1

    Wow that was so helpful thanks brother

  • @berylann1372
    @berylann1372 4 місяці тому +1

    Thank you for fantastic courses that I can comprehend!

  • @tolaniolumide9546
    @tolaniolumide9546 5 місяців тому +1

    Really helpful

  • @Olivia-h5v
    @Olivia-h5v 4 місяці тому

    Thank you very for this excellent presentation
    Are there any additional exercises on your site or only courses and certifications ?
    Thank you

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

      We have 60 more videos on Excel you can enjoy here: ua-cam.com/play/PLoyECfvEFOjbdwpIOtm_8PFzB_CPAD2_H.html&si=bbWKVzXXMRlnvOiJ

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

    The best excel beginners course

  • @josephchibor4591
    @josephchibor4591 3 місяці тому +1

    Thank you very much.

  • @MohammedElAmineOuldAbderrahman
    @MohammedElAmineOuldAbderrahman Місяць тому +1

    thank you so much

  • @kazimrahman7499
    @kazimrahman7499 4 місяці тому +1

    WoW....Very Helpful Tute....Thanks.

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

    boom, you are amazing Joe. Thank You So Much

  • @MeriothWangui-ml8pk
    @MeriothWangui-ml8pk Місяць тому +1

    wow for the first time i watched a full video🥰

  • @nneomaoji3362
    @nneomaoji3362 3 місяці тому +1

    Good day. Very wonderful and insightful video😊. I'm looking forward to the rest. But I'm not able to open the exercise files.

    • @LearnitTraining
      @LearnitTraining  3 місяці тому

      Hello! We just tested the link and files they are currently working

  • @Floptropican-Tim
    @Floptropican-Tim 3 місяці тому +1

    tysm for this amazing Tutorial!

  • @lnrbxslyv7820
    @lnrbxslyv7820 3 місяці тому +1

    Big thanks. so useful.

  • @shashiniedirisooriya2898
    @shashiniedirisooriya2898 3 місяці тому +1

    Thank you for making this vedios. This is very helpful my job. Again ..thank you so much.

  • @JuanPabloCravero-yd4rf
    @JuanPabloCravero-yd4rf 5 місяців тому +1

    So helpful, thank u buddy! Keep it up!

  • @darshans8147
    @darshans8147 3 місяці тому +1

    Excellent

  • @mlewis437
    @mlewis437 5 місяців тому +1

    This has helped me greatly, thank you!

  • @sammyiraki6227
    @sammyiraki6227 2 місяці тому +1

    I must say, this is incredibly advantageous to me.

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

    Completed this tutorial and I really Like it.

  • @kenethemitu77
    @kenethemitu77 5 місяців тому +1

    THis has been very helpful ,Thanks

  • @evawambura8517
    @evawambura8517 3 місяці тому +1

    The best video!!😊👌🏼

  • @elitefaruk
    @elitefaruk 2 місяці тому +1

    Blessings from the heart......

  • @flowersnspam3936
    @flowersnspam3936 8 місяців тому +1

    Thank you.

  • @mohammadvaziri1504
    @mohammadvaziri1504 8 місяців тому +3

    Thank you so much for your informative and excellent presentation.

  • @naziatasneem213
    @naziatasneem213 3 місяці тому +5

    I have terrible patience. It took me more than a month to finish this video only.
    I'm glad i could finish it finally.
    Thank you so much for giving away these contents for free.

  • @peoplewhoprogram
    @peoplewhoprogram 2 місяці тому +1

    hi sir, mine doesn't have custom view. where can i get it

  • @arpitkumarmishra1654
    @arpitkumarmishra1654 3 місяці тому +1

    This double click function of black haired arrow while taking up the sum of total sales is it accessible only to Excle 365 only or the normal one too?? Coz I'm not able to access it

    • @LearnitTraining
      @LearnitTraining  3 місяці тому +1

      This was recorded using Excel 365 so if you are using a different versions there may be some variations

    • @arpitkumarmishra1654
      @arpitkumarmishra1654 3 місяці тому

      @@LearnitTraining Ohh alright I think I'm not having the 365 version

  • @Tas_neem66
    @Tas_neem66 5 місяців тому +1

    Thank u a lot that really helped me✨

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

    Excellent, I'm enjoying this lesson

  • @sherda7079
    @sherda7079 4 місяці тому +1

    Thank you🙏🏼💙

  • @OluwayinkaJulius
    @OluwayinkaJulius 6 місяців тому +2

    So helpful. Thanks alot

  • @SanthoshKumar-bp1ku
    @SanthoshKumar-bp1ku 6 місяців тому +1

    Content is awesome Thank you so much

  • @haranvj1997
    @haranvj1997 Місяць тому +1

    Thankyou for your kind efforts to help out the NOBODYs. This is truly priceless.
    😍😄🙏

  • @karimsiuuu-q7c
    @karimsiuuu-q7c 2 місяці тому +1

    pls can you send the link for the functions ,but the one that belongs to you, not the google one🙏🙏

    • @mercedesbasilio4053
      @mercedesbasilio4053 2 дні тому

      If you have Excel on your computer. Ones u open Excel “on home” the first square is the “ blank workbook “ the second one is “ formula tutorial “ click on follow all the tab on the bottom, sheet. Hope that helps.

  • @Canatuna
    @Canatuna 3 місяці тому +1

    how do you group worksheets in excel 365 online?

    • @LearnitTraining
      @LearnitTraining  3 місяці тому

      To group worksheets in Excel 365 online, you can follow these steps:
      Right-click any worksheet tab.
      Click Select All Sheets.
      Hold down the Ctrl key and click the sheet tabs of interest one by one.
      To group adjacent (consecutive) worksheets, click the first sheet tab, hold down the Shift key, and click the last sheet tab.
      To remove a worksheet from the group, hold down Ctrl as you click the worksheet's tab.

  • @SaccaS-12
    @SaccaS-12 3 місяці тому +1

    loved it

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

    is it certified like can i put it in my cv when it done?

  • @uchayjoey9379
    @uchayjoey9379 4 місяці тому +1

    Hi,
    Can i follow along with Excel 2016?

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

      We have Excel 2016! ua-cam.com/video/tuk99Sgc6Fw/v-deo.html

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

      @@LearnitTraining Okay thanks

  • @sohag-ee04
    @sohag-ee04 8 місяців тому +2

    Your video is amazing. But there's a problem for me. The problem is I have the excel 2013 not the excel 2024. So, I have a question about it. "Can I do all thing the same way you are doing in excel 2024 in my excel 2013?"
    ( I HOPE and WISH that you will give answer of my question as soon as possible)

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

      Core stuff like formulas and functions will work the same but there have been many improvements since then. We recommend our 2016 Excel videos to begin with in you case.

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

    Thank you so much! You may not have an idea, bu you're helping a lot of people. Thank you so much for amazing effort that you put just to teach us! Have a blessed day! Jesus loves you!

  • @masaigrashuis16
    @masaigrashuis16 29 днів тому +1

    14x "how cool is that". Really useful though, best tutorial for excel 2024

  • @UmirDigir
    @UmirDigir 2 місяці тому +1

    29:00

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

    Is it just me or average function on 48:32 doesn't make sense regarding analysis?

  • @gamzebozdemir7446
    @gamzebozdemir7446 5 місяців тому +2

    This guy seems to be head over heels in love with Excel... Quite a lunatic!

  • @kojo7485
    @kojo7485 8 місяців тому +3

    I learned 😌 💯 Excel starting in 2004 at Wake Technical Community College 😅A Mandatory Excel Project is required 👌 👍 in 🇳🇬 👌 every science and 🤓 mathematics course 😉 🎉❤

    • @LearnitTraining
      @LearnitTraining  8 місяців тому +1

      We hope you learned even more in this course!

    • @kojo7485
      @kojo7485 8 місяців тому +1

      @@LearnitTraining 🏫 👨‍🏫 🚸 🎒 🏫 👩‍🏫 🚸 🎒 🏫 🤓 😎 🆒️

  • @EarthellFlowersEarthyPra-ho5xp
    @EarthellFlowersEarthyPra-ho5xp 8 місяців тому +1

    How do i bookmark the page i am on without having to start from the beginning? I am already paying 1.99/month.

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

      Hello Earthell Flowers! You can access the member only version of the video here: ua-cam.com/video/eQrVXQW25KM/v-deo.html
      Also you can make your own bookmarks by leaving the time stamp in the comments of the video.
      Example below:
      Search and Help 8:37

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

    Thank you so much!! I wish i know your channel earlier.