Advanced Excel Full Course 2024 | Excel Tutorial For Beginners | Excel Training | Simplilearn

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

КОМЕНТАРІ • 366

  • @SimplilearnOfficial
    @SimplilearnOfficial  Рік тому +151

    "🔥Data Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/data-analyst-masters-certification-training-course?Ob8Hre_SnI&Comments&UA-cam
    🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-analytics?Ob8Hre_SnI&Comments&UA-cam
    🔥Purdue - Post Graduate Program in Data Analytics - www.simplilearn.com/pgp-data-analytics-certification-training-course?Ob8Hre_SnI&Comments&UA-cam
    🔥Caltech - Data Analytics Bootcamp (US Only) - www.simplilearn.com/data-analytics-bootcamp?Ob8Hre_SnI&Comments&UA-cam
    🔥IITG - Professional Certificate Program in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitg-generative-ai-data-analytics-program?Ob8Hre_SnI&Comments&UA-cam"

  • @陆Lux
    @陆Lux Рік тому +147

    This video was recommended in China, so I came here, I think this video deserves to be seen by more people, thank you very much!❤

  • @mr.savageryt2613
    @mr.savageryt2613 Рік тому +246

    Guys am just 7minutes into this video , but am already here to say THANK YOU! for the time taken to explain so deeply and separately.

  • @blossomstar-e3x
    @blossomstar-e3x Рік тому +1861

    Can we take a minute just to appreciate this brother for this selfless efforts Thanku bro.. But bro u can use Hindi a little bit so it understand and help many users

    • @SimplilearnOfficial
      @SimplilearnOfficial  Рік тому +110

      We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!

  • @Naeem2460
    @Naeem2460 Рік тому +157

    I can't believe, its free, i would recommend to my every fellow learner to see and appreciate this masterpiece❤

  • @shalinisinghania5004
    @shalinisinghania5004 Рік тому +100

    19:15 lower case upper case formula
    21:23 Add rows 1 or more
    24:35 select entire row/column
    26:13 select column having data only
    27:00 disadvantage of selecting whole column

  • @chukwumanwakpa3330
    @chukwumanwakpa3330 Рік тому +528

    Can we get all the datasets that were used in this video please. This is so that we can practice alongside with similar data from the video. Meanwhile, you guys are just the best. Kudos! In anticipation.

  • @jayeshkumbhani1531
    @jayeshkumbhani1531 Рік тому +157

    I have bought course for Excel from one site, and I can say that this free video contains more valuable content than my course. Also, very easy language and great explanation. Thanks ❤

    • @SimplilearnOfficial
      @SimplilearnOfficial  Рік тому +12

      We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!

  • @foxbob2395
    @foxbob2395 Місяць тому +4

    I'm a beginner. So I want to thank you for this video 🙏. For my financial issues and household I quit learning. Now I'm in a job of 1.2 lakhs/A. But I always wanted to learn this type of things. So thank you for making it free. It helped a lot. 🙏😊. May be there's a way to learn more and getting a perfect job. Please help me learn more bro

  • @deepakrana7949
    @deepakrana7949 Рік тому +284

    simply awesome, and I appreciate all your team's efforts to provide the valuable training free of cost, for which I can't express my gratitude. I owe it to you. I am aware that some course providers do not provide such knowledge despite charging exorbitant fees. Salute to you guys.

  • @4signup452
    @4signup452 Рік тому +123

    Every tutorial like this one is really something that every beginner is dreaming of . God bless you.❤❤❤

  • @punjabivlogsbyumer
    @punjabivlogsbyumer 11 місяців тому +14

    this complete course is more worth then any course on the internet on free basis thank you so much

  • @salikmirza9941
    @salikmirza9941 Рік тому +25

    i am starting this course today from your video hope i will get succeed in completing with the same interest

  • @markin_mask5592
    @markin_mask5592 Рік тому +51

    I'm joining a b-school next month thank you so much for this course i really was looking for this !💗

  • @amritamaheshwari9221
    @amritamaheshwari9221 Рік тому +50

    Thankyou for explaining this course in such a easy manner. It would be a great help if you could please provide all the database that you have used in explaining so that I can practice alongside. Thanks again!

  • @andiidoode
    @andiidoode Рік тому +25

    I love the enthusiasm, I'll be back as soon as I have some time over the next few weeks.

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

      Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )

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

    As your new subscriber ,I hope you don't delete this, i have found you change today and i am going to learning day by day because it very long video.
    Such information for free thank you so much you don't know how much it's means to students like me who don't have money.

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

      Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.

  • @samarrathore6220
    @samarrathore6220 Рік тому +23

    a great headstart for any MBA aspirant a must watch video

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

      We are delighted to have been a part of your learning journey! If you want to continue honing your skills and keeping up-to-date with industry trends, check out our course offerings in the description box.

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

    Thank you for your assistance to learn Excel from Basic to Advance this is very amazing course to do. I'll recommend this course to beigners, I also request please also share the sheets for practices
    So this will be easy for students to practice and learn fast

  • @FusionFlicks-f21
    @FusionFlicks-f21 4 місяці тому +10

    You saved me brother. I got a 26000sr( Saudi riyal) job because of you

  • @shrinivas1086
    @shrinivas1086 Рік тому +53

    Hi,
    in DAX Date & Time function (01:07:35) u calculated 'Retirement age' . U simply multiplied 65 y to the DOJ but in reality u should "multiply 65 y to dob" and u need to take "year" from that calculation & then "date & month" should be taken from DOJ.
    (if i am wrong, correct me.)

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

    2 Hour Video Completed, Just Wow ❤

  • @ajaybhalekar4622
    @ajaybhalekar4622 Рік тому +28

    Dear [ Simplilearn team ],
    I hope this message finds you well. Firstly, I would like to express my appreciation for your informative video on the topic of standard deviation. I found it to be quite insightful and helpful.
    However, I did notice something that I believe could potentially improve the viewing experience for your audience. While you were providing information of standard deviation on the right side of the screen, there was an animated video of graphs on the left side. Although it looked cool, I found it to be somewhat distracting from the main content. As a viewer, I am more interested in the information being presented rather than the animation.
    Therefore, I would like to suggest using a single image instead of the animated videos. I believe this would enhance the clarity and focus of your video, allowing your audience to better comprehend the material being presented.
    Thank you for your time and consideration.
    Best regards,
    Ajay Bhalekar

  • @SantanuSinhaRoy
    @SantanuSinhaRoy Рік тому +23

    Why don't you share the Excel Exercise Files here which can save us time to create new files with so many data for every small video tuto ??

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

    Thank you so much sir for providing such quality content for free!! I'm currently in high school learning all this as it would help me in b-school in future.

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

    Time series analysis was not clearly understandable . Rest of the video was Great . Thanks alot to Simplilearn for such a teaching !

  • @MAwais-kc4cn
    @MAwais-kc4cn Рік тому +6

    I appreciate you sir, you covered this course brilliantly and effectively lots of love from Pakistan❤❤❤❤❤

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

      We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!

  • @islam-co3re
    @islam-co3re 4 місяці тому +1

    Hats off to you. This video has a lot to share. It's really appreciating that it's free to access.

  • @mritunjaykumarmani9672
    @mritunjaykumarmani9672 11 місяців тому +4

    Sir great video but if you put the pdfs and other materials which you are using in this class it will be really helpful.

  • @JK-ws1el
    @JK-ws1el Рік тому +9

    You have done a great work but a small thing is we need those data to practice

  • @pritichanda-lr4vg
    @pritichanda-lr4vg 6 місяців тому +1

    GOD Your already blessed sir ................i wish you all the success......i just started its been 2 min and the content you covered is really awesome, stay blessed sir .

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

      WooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!

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

    Simplilearn is awesome.

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

    Thanks you all of the team simplilearn for providing more valueable video once again thank you.

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

    Thank you for making this video just started to watch it's helpful n can't wait to complete😊

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

    THANK YOU SO SO MUCH FOR THIS WONDERFUL AND DETAIL VIDEO IT HAS HELPED ME TO LEARN MANY NEW THINGS. REALLY THANKFUL FOR THIS WONDERFUL VIDEO AND YOUR ENERGY LEVEL ALONG WITH YOUR PATIENCE. THANK YOU

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

      Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)

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

    How much efforts this man gave is just speechless 🙏 thanku alot for such fruitful video

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

      Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)

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

    Outstanding sir super and excellent teaching i really inspired...

  • @suganraj2662
    @suganraj2662 4 місяці тому +2

    its my first vedio i see pateince to see your becasue each day go go intreseted thank you

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

      Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)

  • @twstruzik
    @twstruzik Рік тому +26

    Super helpful! I appreciate the indexing, especially. I've used super basic excel, but my new job needs advanced skills. This helped me so much!

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

      We're thrilled to have been a part of your learning experience, and we hope that you feel confident and prepared to take on new challenges in your field. If you're interested in further expanding your knowledge, check out our course offerings in the description box.

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

    Hi @SimplilearnOfficial. You have shows three methods of comparing the two columns. But in each method the result is different. Don't you think this is wrong. Time around 30 minutes to 33 minutes section

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

    whatever u are writing in the database , make sure it's visible to viewers also and provide some practice worksheets to practice excel if possible it will be implemented whatever you taught.
    Thanks 👍

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

    Good information shared....Thank You

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

      We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!

  • @SmithAnderson-083
    @SmithAnderson-083 Рік тому +4

    Thanks for this content free of cost❤

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

      We're thrilled to have been a part of your learning experience, and we hope that you feel confident and prepared to take on new challenges in your field. If you're interested in further expanding your knowledge, check out our course offerings in the description box.

  • @honeybee2919
    @honeybee2919 Рік тому +28

    This is great, looking forward to working through this!

  • @Suman-KD007
    @Suman-KD007 Рік тому +16

    Could you please provide the sample sheets so that we can practice at the same time.

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

    Respect and love for your invaluable education ❤❤❤

  • @-Sunshines-girl_
    @-Sunshines-girl_ 4 місяці тому +1

    It would be helpful if you could do this detaild on SQL also... The time and topic mentioned in description is highly appreciated.

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

    THIS EFFORT IS APPRICIABLE

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

      We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!

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

    Thank you very much for such a awesome tutorial ❤️ watching from ktm, Nepal 🇳🇵

  • @market_insights07
    @market_insights07 11 місяців тому +3

    Thanks man

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

    Great Video ❤

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

    very helpful and very simple to understand thank you .

  • @pandybalashanmughanandan5851
    @pandybalashanmughanandan5851 9 місяців тому +1

    Thank you sir very useful

  • @markdavies-ei8sf
    @markdavies-ei8sf 11 місяців тому +5

    Aye big man, I appreciate your time and effort you put into this tutorial. Quick question, can you create more courses in excel that a newbie like me, can just learn everything in one place? Like a beginner cource, since this is an advance course? Thanks.

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

    Excellent content!

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

    Hello, in the video 46.32 - to convert number to text, you copied the macro from google where the function name was "Spell Number". However when you pasted macro in VBA Module, and you scrolled up to the first line- it read "NumbertoText". How was it?

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

      The Macro was from Microsoft's official website. Please have your email address shared with us. We will have it sent out to you at the earliest

  • @revatimate5711
    @revatimate5711 9 місяців тому +1

    Thank You so much for this...❤🎉

  • @-Himanshu.Dixit_
    @-Himanshu.Dixit_ Рік тому +5

    Hello sir, if this video was in Hindi, then we would have got to learn a lot, thank you.

  • @SudhaYadav-q6z
    @SudhaYadav-q6z 11 місяців тому +1

    Nice information 👍

  • @ShivamChhatwal-e8f
    @ShivamChhatwal-e8f Рік тому +8

    can you please provide me with the sample data used in excel dashboards tutorial, it would be a great help.

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

    Great brother nicely explain

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

      Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.

  • @ashutoshjoshi4379
    @ashutoshjoshi4379 4 місяці тому +2

    What an effort

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

      Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)

  • @rajnishranjan_centralunive7604
    @rajnishranjan_centralunive7604 Рік тому +11

    at 36:00, transpose function is working only for one cell not as in video

  • @sanjivanigupta7
    @sanjivanigupta7 11 місяців тому +1

    Great sir...🔥🔥

  • @Sonbeersingh-j3s
    @Sonbeersingh-j3s Рік тому

    Thanyou simpliearn this videi is very very excellent so thanks for this video

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

      We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!

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

    Nice video sir iam listing daily n noting in book

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

      We're thrilled to have been a part of your learning experience, and we hope that you feel confident and prepared to take on new challenges in your field. If you're interested in further expanding your knowledge, check out our course offerings in the description box.

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

    How can I remember everything that I've learnt? Should I note these down? It will be helpful? 🙁

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

      Taking notes is definitely a great strategy to retain what you've learned! It can help reinforce the material and give you a quick reference for future review. Also, consider revisiting the notes regularly and practicing what you've learned through practical applications or quizzes.

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

    Thank you so much Simplilearn Good Job

  • @ARJUNKUMAR-LtoE
    @ARJUNKUMAR-LtoE Рік тому +1

    Great!

  • @jayendrachoudhary5314
    @jayendrachoudhary5314 9 місяців тому +1

    A big thanks to you bro

  • @KrishnaGarg-qv3tw
    @KrishnaGarg-qv3tw 5 місяців тому

    Okay sir,
    Thank you very much for this video❤❤

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

      Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)

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

    Very good! Thanks!

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

    5:04:02 Mail merge

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

    That's a good session

  • @ShahbazKhan-hw4co
    @ShahbazKhan-hw4co Рік тому +11

    can you please provide the sheets so that we can practice
    🙂

  • @MindBlownTidbits
    @MindBlownTidbits Рік тому +10

    At 04:46:57 , how did we get the right results while selecting the bottom 3 entries for the lowest female graduates, when the list had been sorted in ascending order?
    Also at 04:50:45, according to my calculations, sum of sales for fruits is:16510, and for the vegetables it's:12350, and sales of both sumsup to 28,860(16510+12350).Then why it's displaying different results or did I get it wrong?

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

    Hats off to your hard work. but you guys should've made this video in full hindi, Your english speaking is too formal to connect with people, if there was an actual uk or usa narrator it would be good in speaking english,

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

    Can I directly watch adavaned excelr course video or should I watch excel for beginners video first

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

    Thank you Sir for this valuable Video 🙂

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

    Session was informative welldone (Y)

  • @YashPatel-bw2ik
    @YashPatel-bw2ik 6 місяців тому

    Thank you so much for the amazing Content

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

      WooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!

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

    Such a amazing work ❤️❤️❤️

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

    Thank u so much for doing selfless work for ppl who want to learn Excel. It’s really helpful. Keep up good work god bless u.

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

    It's very nice and help ful thanks for sharing

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

    Thank you

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

    Thank you so much

  • @srinivaskannan-o2w
    @srinivaskannan-o2w Місяць тому

    Superb thank you ❤

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

    Thanks for all you do, please can I get the exercise files for me to practice as I'm learning

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

      If you're looking for datasets to work on for your data science projects, there are several great resources available. Sites like Kaggle, UCI Machine Learning Repository, and Google Dataset Search offer a wide range of datasets across different domains. These can be excellent for practicing your skills, whether you're working on data cleaning, analysis, or even machine learning models. Check them out and find a dataset that interests you!

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

    Best vedio ever

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

    TQ so much ❤❤❤

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

      We are delighted to have been a part of your learning journey! If you want to continue honing your skills and keeping up-to-date with industry trends, check out our course offerings in the description box.

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

    Thanks a bunch 🎉🎉🎉

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

      We are glad that you have enjoyed your learning experience with us : )

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

    Thank you only this channel provide all Content for free

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

    Thank you so much sir.

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

    Thank you so much sir ❤

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

      vWooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!

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

    01:35:00 completed

  • @PriyaDharshini-o3k
    @PriyaDharshini-o3k Рік тому +1

    best 100%

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

      Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.

  • @Bimanpatra4
    @Bimanpatra4 19 днів тому

    Very informative video❤

    • @SimplilearnOfficial
      @SimplilearnOfficial  11 годин тому

      Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)

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

    Thanks

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

    Nice course

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

    This indeed a great learning experience for all of us. I still have a doubt. From where we get the data to practice? It's a bit challenging for me especially when it comes to data entry manually. Please help!