Complete MS Excel Tutorial for Beginners | Part 2 of 3 | (with Download link)

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

КОМЕНТАРІ • 569

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

    This 1 hour 27min and 11sec course of Excel is GOAT .......just amazing.... Lots of respect .....thank you so much ..

  • @shivam_kumar1994
    @shivam_kumar1994 4 місяці тому +32

    I'm not sure if this comment will reach you, but I've been watching numerous videos to learn Excel for the past few months. However, most of the concepts weren't clear to me. The videos are often too long, such as 10 hours or 6 hours, and I end up getting bored at some point. The way you explain things really makes sense. Kudos to you! I would appreciate more videos at different levels, such as beginner, intermediate, and advanced.

  • @polokahmedtushar5860
    @polokahmedtushar5860 Рік тому +65

    I have just finished your tutorial and learnt many things. You explained each of these functions and formulas with the easiest possible ways. Thanks for your effort.

  • @afrinsheikh6911
    @afrinsheikh6911 Рік тому +40

    I am listening you since 2019, back then I used to watch your videos for my college placements, I'm glad to see you back on YT, lots of respect, you are inspiring :)

  • @akshatha.j5287
    @akshatha.j5287 2 місяці тому +3

    A complete excel tutorial without any lags and unwanted talks... Perfect if your looking for one. Without any hesitation anyone can watch it and it's worth your time.

  • @daphynegracias8515
    @daphynegracias8515 Рік тому +91

    This is one of the best excel courses out there. The practice sheet is so useful. I cant believe I had so much fun learning excel and I didnt even feel overwhelmed or bored. The simplicity and ease with which you explain translates to the viewers and makes everything look easy. Thanks a ton. The only problem that I faced was flashfill doesn't work in my version.

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

      Can you please tell me which version is this one

  • @krishyash643
    @krishyash643 25 днів тому +7

    I cracked my interview by watching your videos 😍❤.
    Thankyou so much Ma’am.
    I would request you to do more videos on MS EXCEL Classes which includes some basic day to day activities performed in Excel at companies.

  • @sweetmelodiesbysumeet4767
    @sweetmelodiesbysumeet4767 Рік тому +16

    have been learning excel from long time, but the way excel is being learned here is fun and easy to grasp. Have a blessed time ahead. right now finished 32 mins of this video and the joy of learning is increasing. Thanks a lot

  • @vaijayanthir8731
    @vaijayanthir8731 Рік тому +20

    I am from Tamilnadu. I was subscribed your channel when I seen your channel first time for the content of how to speak in English.
    What a great teacher you are! I love your way of teaching and expressions.
    Excel class for beginners is amazing...

  • @rishabhmakkar6624
    @rishabhmakkar6624 Рік тому +6

    Though I have blur knowledge of excel, it was all brushed up.
    Now I feel comfortable to learn hard core excel.

  • @poojatiwari3880
    @poojatiwari3880 Рік тому +18

    Very clean and clear! Great content, thankyou for sharing your knowledge!!

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

    THANKS , I GOT CLARITY OF EXCEL IN MY 6 YEARS ONLY AFTER WATCHING THIS VIDEO…., BECAME A FAN OF YOUR TEACHING

  • @priyankapanchal5306
    @priyankapanchal5306 Рік тому +6

    Thank you for such a good course in very easy way. I have one request to you, please don't stop making video. I eagerly wait for your video topic does't matter, because your every video gives so many learning. You are such a great you tuber. You helped me a lot. Your work is actually appreciable.

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

    Simply wow! Each of my boss used to do this freezing this and I was unaware. Never did anyone made effort to explain hoping I knew already. My work used to get so strenous because of it. Today, is the day I learnt Freeze Option just because of you!! Grateful

  • @SandhyaMundhe-jw8vl
    @SandhyaMundhe-jw8vl 2 місяці тому +1

    I am a beginner, and this is my first video learning excel, after completing this video i really felt when you said " you're just gonna fall in love what excel can do" TRUE"❤, your way of teaching really encourages learning more new tools and technologies, keep making more and more such videos , and lastly thankyou soo much for such a wonderful experiences ❤

  • @durgaprasad-bk8dj
    @durgaprasad-bk8dj Рік тому +2

    YOU ARE A GENIUS, HONEST, CANDID AND LOVING.

  • @veerendrakanduri1954
    @veerendrakanduri1954 Рік тому +9

    This trainings selling outside, but ur teaching us free of cost .
    God bless u all the way

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

    that was the simplest tutorial ever. thank you for making it easy to learn. you are the best teacher ever.

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

    🙂I have just finished your tutorial and learnt many things. You explained each of these functions and formulas with the easiest possible ways. Thanks for your effort.

  • @prashbk
    @prashbk Рік тому +38

    I have been using Excel for many years..but never used or observed flash fill feature. Even though many things are basics but very useful.. thanks for sharing 🙏

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

    I have been following you since 2020 I was in final year engineering college for placements, now it's 2024 and I'm watching again for job change you are the best

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

    I have watched the 3rd vid whc is interview vid first, then I'm here, The thing you said often you will enjoy the video is really damn true 💯 Thanks for making it in such a manner.

  • @sakshibenjamin2813
    @sakshibenjamin2813 Рік тому +18

    i literally enjoyed this session of yours !! The way you taught all the things, that was just awesome >>> Thanks a lot !! ❤

  • @vinayakjoshi1421
    @vinayakjoshi1421 10 місяців тому +2

    I've not seen such a mesmerizing teaching.. Hats off Mam. very useful

  • @athiresh-cm7pt
    @athiresh-cm7pt Рік тому +814

    Me who's watching this without even a laptop 😅

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

    I had completed your excel course . I'm soo glad to watch this vedio . you just had made me a fan of u

  • @radhavitiwari3876
    @radhavitiwari3876 Рік тому +8

    Thank you so much for Basic MS Excel video series.... Request you to make similar series on Advance Excel, MS PowerPoint, MS Outlook & MS Word.

  • @narutodihargo
    @narutodihargo Рік тому +8

    0:00 - Introduction
    2:18 - Workbook Basics
    2:58 - Cell Name/Cell Address and Cell Range
    5:09 - Insert/Delete and Hide Rows/Columns
    7:06 - Introduction to the MS Excel Ribbon
    8:21 - Autofill and Flashfill
    14:22 - Home Tab Features
    14:44 - Formatting Options
    15:52 - Wrap Text
    16:15 - Merge and Centre
    16:50 - Number Formats
    17:33 - Conditional Formatting (Highlight Cell Rules, Data Bars, Icon Sets, Colour Scales, Clear Rules..)
    19:50 - Auto-fit Column Width
    20:11 - Find, Select and Replace
    22:22 - Sort & Filter
    25:50 - Split and Freeze Pane (View Tab Features)
    28:59 - Difference Between Split and Freeze Pane
    29:38 - Functions and Formulas
    29:49 - Sum, Average, Max, Min
    31:50 - Count, CountA, CountBlank
    32:45 - Difference between Formula and Function
    33:54 - Relative and Absolute References
    38:38 - Mixed References
    42:12 - Logical Functions
    42:29 - IF Function
    44:14 - Nested IF
    45:09 - AND Function
    46:22 - OR Function
    47:40 - SumIF Function
    49:44 - CountIF Function
    50:30 - Text Functions
    50:52 - Left, Right, Mid
    51:40 - Upper, Lower, Proper
    52:05 - Len and Trim
    52:55 - Concat and TextJoin
    54:15 - VLOOKUP
    57:42 - VLOOKUP Limitation
    59:57 - MS Excel Tables (Creation and Features)
    1:04:14 - Slicers
    1:06:30 - Charts
    1:10:20 - Different Chart Types
    1:12:04 - Pivot Tables (Cleaning Data, Create Pivot Table and Analyse Data Option)
    1:21:27 - MS Excel Errors
    1:25:25 - IFError Function

  • @parthaedu9039
    @parthaedu9039 Рік тому +8

    Actually your IELTS video has helped me a lot, thank you very much

  • @simantadeeproychowdhury864
    @simantadeeproychowdhury864 13 днів тому +3

    This is a great video for both beginners and not beginners! Request you to do a video on VBA Macros.

  • @akashhugar1500
    @akashhugar1500 Рік тому +2

    Currently time is 3:20am when I ended up watching this video and it was totally worth watching, I hope this will help me lot in future, thank you for this video 😊.

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

      pratice workbook is not working is not editing....how to do???

  • @fortunatemiles2556
    @fortunatemiles2556 Рік тому +2

    Am looking forward to turning into a pro I can't believe it. Good teacher I love you. You really can explain. Words won't explain what am feeling of you thank you God bless you.❤❤❤❤❤❤❤❤❤❤❤❤

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

    Happy to see you after a long time, Good work I was searching this video for a week, exactly at the right time. Make videos consistently a kind request as a subscriber.

  • @parmarchetan7259
    @parmarchetan7259 Рік тому +2

    It's very easy to understand because of you ma'am.....I am so happy for this video created you❤❤❤❤❤❤❤thank you

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

    One of the best Excel course.. thanks for your time and efforts for making this useful course..

  • @rajaraja-nn2rw
    @rajaraja-nn2rw 16 днів тому +1

    Ur cluster and clear information, thanks a lot medam❤

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

    I have recently joined a new company was suffering from maintaining my dada in excel sheet this video is helpful but there are many ads

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

    Ur explanation is understandable,I really liked it. I wish to do more videos for even management related students.♥️

  • @PoeticPulse953
    @PoeticPulse953 7 місяців тому +4

    You are such a great teacher 😘, love you 😘☺️♥️

  • @mohanreddaboina
    @mohanreddaboina 11 місяців тому

    Liked your content so much and thanks for the videos sister..
    when you said "don't look at me this is supposed to be confusing" I literally laughed at my confusion and practiced the worksheet twice and it got cleared..

  • @kenathuthavalai1823
    @kenathuthavalai1823 Рік тому +8

    such a wonderful class ... planning, creation, delivery everything was amazing.
    new lead and concept no one replace your place.

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

    Great video for beginners..it's really helpful..take a bow 🙌

  • @Aadhya208
    @Aadhya208 Рік тому +2

    For brushing all the fields in my excel it is the best video

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

    I love how she explained everything I like how she talks.easy to understand video

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

    This is the best course I have ever come across... Thank you so much....

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

    Nice for beginner who nothing know about the ms -excel . And thank to ma' am for such useful video.

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

    This is the best excel tutorial have ever seen.

  • @ashasakpal3165
    @ashasakpal3165 Рік тому +2

    Love your way of teaching my dear you are too good ❤ God bless you in abundance with lots more success😊

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

    Iam a housewife. Saw video for just 5 min. Very interesting❤ and so Subscribed. I really thought of just simply to learn.. But I can't discover when I got interest into this. Now I want to get into an job using this knowledge. Please make video's on those who want to look for job.

  • @AnnaRinta
    @AnnaRinta 9 місяців тому +2

    Please do a video on other Microsoft tools like word, powerpoint etc . Your video is too good .

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

    really i have watch many video to learn excel but the way to explain and practice book helped me a lot. thanks a tone and i hope you will teach us more and more about excel (advanced excel, MIS, VBA, Data Science).

  • @Lokivlogs98
    @Lokivlogs98 Рік тому +2

    Best ever Excel video on youTube😍 Thanks a lot❤

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

    very nice explanation and best tutorial of MS EXCEL

  • @Rohitpatel-hr3jk
    @Rohitpatel-hr3jk 7 місяців тому +1

    Wonderful course I appreciate you for providing it at free of cost that makes you best tutor. I really like the way you teach us . Plz make videos on interview preparation

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

    Mam please make a separate video on v lookup and other types.

  • @v.ramachandran6034
    @v.ramachandran6034 Рік тому

    Thank you very much for this extremely useful video. Any user of Excel will admire it.Please continue your good work.Thank you

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

    You are so mean with Ron. Every sheet he got less score :) Well, Thank you so for providing such a great lesson on excel. Your explanation is sort, clear and understandable. Thank you!

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

    Wow...great. i just finished it today listening to this. thanks

  • @dudipayal
    @dudipayal Рік тому +2

    This Excel tutorial video is very helpful for me..... I love it❤
    Thnx a lot🍀

  • @simmi641
    @simmi641 Рік тому +2

    u were right!! u actually made excel learning interesting Thank you so much

  • @hari_kumar123
    @hari_kumar123 Рік тому +2

    Thanks a lot for making this amazing playlist on excel. Its very to understand the concept. Your way of explanation is too good. Thanks a lot , madam 😊😊

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

    Using Harry Potter character names, boosting my learning process and your training was so enriching.

  • @abhishekganguli117
    @abhishekganguli117 Рік тому +2

    it was awesome, the way you make us learn it was like having a fun.Thank you so much.

  • @ferrislkpokpa7867
    @ferrislkpokpa7867 24 дні тому +2

    Great Teacher, I love such a clear teaching!

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

    One of the best vedios, learnt lot of things. Thank you so much madam.

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

    I haven't watched it completely just those topics which i needed , The way you explained these pivot tables topicsare exceptional. It helps me for my assignment😂... Really thanks 😊

  • @soumenmaity7410
    @soumenmaity7410 Рік тому +2

    Please make a video on the pivot table so that we can learn more about the pivot table for analyzing data. Thank you.

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

    This Video was amazing..... Thank You so Much .... please please please keep making more excel videos

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

    Thank You for the Video and with the practice workbook it's very easy and helpful to practice.

  • @Gowthami.S-h9l
    @Gowthami.S-h9l 4 місяці тому

    thank you so much for this free course and it has helped me grasp the session sooooo effortlessly . Thank you for being patient

  • @Trannum-z5c
    @Trannum-z5c 25 днів тому +1

    Good midnight mam
    Mam your way of speaking in english with good attitude and your face expression waw(fida)

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

    Thanks maam...❣️. You made me confident and I can say That I can work on MS-Excel .

  • @pallavimalla5195
    @pallavimalla5195 Рік тому +2

    Thank you for every minute detail..

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

    Hi, it's really a easy way to understand the basics of Excel.

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

    Your way of teaching is amazing, Thanks for this 🙌

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

    One of my favorite channel .

  • @parthaedu9039
    @parthaedu9039 Рік тому +2

    Hello curly 🎉 good to see you after a long time
    Thank you

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

    After seeing all the tutorials on Excel video...I reached on right ▶️ it's really good and easy to understand for me😅

  • @kavithaunnikrishnan1919
    @kavithaunnikrishnan1919 Рік тому +2

    Something I was searching for.... Thank you so much Urban fight

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

    You are great teacher

  • @ramadevi-vm3vh
    @ramadevi-vm3vh Рік тому +2

    It's a useful session for beginners,tq u so much

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

    May Allah bless you and your Parents so sweet explanation you will be always in heart thanks a lot for this course.

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

    Nice crisp & clear explanation......Very Nice....Thank You..... :)

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

    Great cover of Excel important topic mam. Great 👍.

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

    Ma’am I’m here for you the way you talks it’s wow 🤩

  • @shyamalathangaraj
    @shyamalathangaraj Рік тому +2

    Very clear explanation thank you mam

  • @TT-xg7qd
    @TT-xg7qd Рік тому +2

    Wow it's amazing video lot of videos are there but here it's superb amazing work 🙏👏👏

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

    Your explanation is great. Can you please do videos on X lookup, Index Matching and advanced pivot tables

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

    i love this teacher.

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

    Thanks a lot for this. Even though I know Excel and have been using for sometime, I've learned new things in the tutorial
    Please make a video on index and match and macros(VBA) .

  • @udayvenkat6424
    @udayvenkat6424 Рік тому +3

    Heyyy, super daa....😊

  • @RaviKumar-rl3fe
    @RaviKumar-rl3fe 2 місяці тому

    The way u say always encourage me to do harwork. For many people u r the best thank u may god blesses u

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

    ou are a great instructor: organized, responsive, patient and able to clearly explain complex topics and nuances. May i know if you have any class on Udemy or online. I would like to buy you a coffee or bottle of wine.

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

    Very good explanation🎉 i didn't feel boredom in this video .very useful😼.

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

    Plz make pivot table complete video thanks for putting so much of hardwork to educate society

  • @becomingunstoppable1144
    @becomingunstoppable1144 Рік тому +2

    Mam please more video. It's just awesome 🙏

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

    This is one of the best excel video. It took me 5hr to complete it with practice. Thanks a lot. I enjoyed this session a lot. Please make another video of Excel with formula and functions. Would definitely love to watch and learn.❤❤❤

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

    I think your way of teaching is just wow

  • @shwetafursule1794
    @shwetafursule1794 Рік тому +3

    ❤❤ thanks mam

  • @daphynegracias8515
    @daphynegracias8515 Рік тому +3

    Thank you so much! It was such a helpful video and I was able to do it so easily. I just had a problem with flash fill though. It's not available in data in my excel version.