Introduction to Microsoft Excel - Excel Basics Tutorial
HTML-код
- Опубликовано: 8 окт 2021
- Finally, a dedicated video to MS Excel!
In almost every video I make about Personal Finance, I figure out a way to include MS Excel in it!!
This video is not going to give a 100% understanding of Excel, so here is my recommended course on Udemy which I have taken personally, and go back to it whenever I need some help.
You can check it out here: bit.ly/3W0wkny
So why not give you a dedicated video on MS Excel?
MS Excel, in my opinion, is the most powerful software ever made!
I use it for everything - budgeting, my video ideas, all my personal finance, and whatnot!
In this video, I will explain to you the basic and most important thing about Excel, that if you understand this one thing, you are done with 80% of fundamentals!
Click here to subscribe to my RUclips channel: shorturl.at/bizNX
------------------------------------------------------------------------------------------------------------------
Ankur Warikoo is an entrepreneur, an angel investor, a mentor and an active public speaker.
For the past 4 years, Warikoo has been actively sharing content on RUclips, LinkedIn, Instagram, Facebook and Twitter amassing a following of 3 Million+ people.
He posts 3 Hindi and English videos every week on his RUclips channel, where he talks about entrepreneurship, how to grow in life, personal finance and failure.
Warikoo started his entrepreneurial journey in 2008. His most recent startup is nearbuy.com where he was the founder and CEO from 2015 until 2019.
Prior to that, Ankur started Groupon’s India business in 2011 and acted as the Country CEO from 2011-15, and Head of Groupon APAC from 2013-15.
An alumnus of the Indian School of Business, Ankur is an active Angel investor and mentor to several startups.
Ankur has been part of Fortune Magazine’s 40 under 40 List for India, LinkedIn India’s PowerProfiles List, LinkedIn India’s Spotlight List and India’s Top Executives under 40 list.
-----------------------------------------------------------------------------------------------------------------------------
My bestselling books:
‘GET EPIC SHIT DONE’: ankurwarikoo.com/getepicshitdone
‘Do Epic Shit’: ankurwarikoo.com/doepicshit
My gear for shooting this video:
🎥 Sony a7III camera: bit.ly/3M42wAV
🎬 Sony FE 24-70 f2.8 Lens: bit.ly/3KCCiF0
🎙️ Shure SM7B Microphone: bit.ly/3O1NAVA
🔆 Fill Light 60W: bit.ly/37aJolP
💡 Key Light 150W: bit.ly/3O9nyjs
📽️ Benro IT15 Tripod for Sony a7III camera: bit.ly/3O4PvJ1
Useful links:
20 books for your 20s: bit.ly/WarikooBooks
20 online courses for your 20s: bit.ly/WarikooOnlineCourses
Gadgets that I use: bit.ly/WarikooGadgets
The above links are on Amazon.
If you buy any of these using the above links, I stand to make affiliate income from it. 100% of this income is contributed towards the education of kids who cannot afford it. In 2021 we contributed 38L and in 2022 we contributed 53L.
Let’s connect online:
🎙️ My weekly podcast Woice with warikoo (Spotify): open.spotify.com/show/1g7wpoq...
📩 My weekly newsletter warikoo Wanderings: ankurwarikoo.com/newsletter/
📱 Instagram: / ankurwarikoo
🐦 Twitter: / warikoo
👨🏻💻 LinkedIn: / warikoo
😄 Facebook: / awarikoo
🖋️ Daily Blog: ankurwarikoo.com/blog/
This video is not going to give a 100% understanding of Excel, so here is my recommended course on Udemy which I have taken personally, and go back to it whenever I need some help.
You can check it out here: click.linksynergy.com/fs-bin/click?id=kYVAJQKrqC8&offerid=624447.19065&type=3&subid=0
Y its showing 8k course.. and in your video its 500 rs course.. could please help me with that... Thankyou sir
Very costly promotion . Your video is not for beginner.. thankyou. It Is good for. Alreday known to execl
Sir I know numbers app from apple each and every detail of it…. Is it useful? Are there any demand for that expert? Or job 😅😅.
Earlier it was showing price of 700 but now it is showing price of 8640
@warikoo ..sir why it's firstly showing rupees 500 and now rupees 8640 can you help us in this
Weekdays - MS Excel
Weekend - Surf Excel 😂
Aap Excel ke peeche, Excel aapke peeche.. too much fun 😂
@шarikoo spanner
Follow us for more tips about excel
Daag ache hai😂
😅😅😅
Haha
You removed all my problems sir!!!! Was learning excel since last one week on youtube...... and you just taught me the whole purpose in just 27 minutes. I've learned at least 50% of excel just through your video.
```Thanks~~~~
Check my work please
50% would be an exaggeration although the way he speaks is amazing
The teaching skills of Ankur sir are just amazing. The simplifying ability is extraordinary. Always love to watch your videos
Bhai ek question he - ek 12inch square size ka redium he uska price 100Rs he usmse mene 5inch redium cut kar diya fir us 5 inch redium ka price kitna hoga or baki bacha 7 inch redium ka price kitna hoga ye price Ms exel me kese nikale
Amazing sir
Follow our channel for excel tutorials 🙏
tu chuitya h bs iska ans yehi hoga
@@toonheart1991
Sir, a request to you, could you bring a series of excel?
bcz your teaching way is so amazing and i can bet everybody out there will love it. they will enjoy your series. Such a great work sir.
Ha na
Follow our channel for excel tutorials 🙏
I recently completed my Excel course from nearby Institute. It was excited to work on Excel and Play Excel-Excel with class mates. But you, you are really brilliant. I have never seen any guy so facinated to play with Excel. It seems as a child has got a treasure. So happy, so excited. You are really a cool guy and best mentor for me. Thank you for your contribution in my life and your dedication towards Investing. Thanks a lot Ankur.
😊😊
You add a different essence to your videos. I know good amount of Excel but still watched your video with a feeling '' Ke kuch naya to seekhne ko milega hi milega" and i know you never let down on our expectations.
Thanks Sir !
You have explained & taught Excel in the simplest way possible. Just a suggestion - A more close up look would be highly appreciated. When we watch this on phone, it gets a bit difficult to see things.
Just now watched this tutorial. Will try this out on my laptop today morning itself. Thanks a ton 🧡
Hey warikoo. I am just on 8 minutes and i am loving how you are teaching with logic, with patience and how in detail. Thankyou so much for being kind. :)
Ankur, we're waiting for this series..thank you so much.
Watching this video in 2023 really gives me chills . i enjoyed your videos a lot and learning Excel from you is a great experience. You should have brought many more videos on this topic . thanks for explaining it with such energy and creativity.
Hi Ankur, I really like your simplicity. I have recently started following you on your youtube channel. As you recommended a course for learning MS Excel on Udemy, I bought it and learning excel from Kyle Pew these days. I wanted to say thanks to you for recommending this course. its an awesome course. Thanks for providing useful information to viewers like me. 🙂
I Have good knowledge of Excel as I learnt it in my CA Articleship but still watching this video. That's the power of Ankur's content- it makes us addicted to his videos. Thank you Ankur♥️♥️
Hehe so well said
Same bro.
Share ---- No. ---- Price. Total
Berger -- 1. ---- 800. 800
Cams -- 2. ---- 3000. 6000
Hdfclife --- 1 ---- 600. 600
Indimart -- 2. ---- 6000. 120000
Infosys --- 3. ---- 2000. 6000
Sir aisa formula set kare jisse me quantity of share, price of share me change karte hi total bad jaye lekin uske sath sath percentage of shares bhi apne aap badne lag jaye. Please make a video on it.
I tried lot of time but still am trying.
Bhai u can also help me
@Rishabh Galhotra. Man you've already cleared intermediate, I haven't clear foundation despite giving my 2nd attempt.
@@prem3957 bro I qualified as a CA in 1st attempt in this July 2021. I cleared CA Inter in May 2018 and CPT in June 2017
I love your videos so much that whenever I get a notification about a new video I always put in my watch later list and make sure I always watch. Your videos are very informative👍🏻
Ye Banda kia h Bhai 😭 itny mazy se parhata ... Sir you masterpiece 💗 Kash ap Meri clg me hoty
..college ke liy etne achee teacher miljate kash
Follow our channel for excel tutorials 🙏
Sahe bola 😂...
Investment kaise aaya amount plus karna hai kya
The way you explained this concept was superb, your energy was totally high while teaching , which motivated alot.
Thank you😃
RUclips algorithm did its magic in 2021
found you & following ur every videos ever since ,
hats off to you sir for sharing such priceless information, life advices & self improvement tips on a free and widely reachable platform .
Thank u so much..I had a zero knowledge in Excel..but now ...I got some points.....
Aapke jaisa shikshak ho to attendance 100%❤
I literally don't get bored a single minute... U ARE AMAZING
Sir please make a complete series on basic to advanced Excel to financial modeling
Some people can't afford the expensive courses
Yea 💯😀
Yes
I want this as well
Yes
Yes
This is what I wanted, was searching for courses and asking from friends, thankyou sir. 🤟
True
I think crypto currency is the best thing to trade on
I trade with Mr james Alex he is a professional broker here is his email
Jamesales 63 🤳
Thanks for sharing. Loved the way you explained. Tried this on sheet practically today itself.
Most awaited video the moment we waiting for
We all want this course.
From beginner to advanced
OMG sir, I was just thinking about learning Excel but most of the courses I found online were boring and monotonous, please complete the whole series now that you have started it(great mind reading btw)👍🏻👌🏻
No need to buy any online excel course. Brother search "Innozant" on RUclips. And watch pure beginners to super advance excel course (Fully free).
How happy you are while doing this , Makes us realise a formula of life = sum( the work you love doing+ positive energy + skill ) Happy life ❤
i love the way of your teaching....
I started the course of kyle pew on udemy. This is what you have informed me. Thanks for that
This is why I love ❤️ Ankur. The financial planning excel totally changed my perception on budgeting. Super useful.
Thank you so much sir...the way you explained everything in the video in such a simple way is really helpful.
First time in my life ,I watched this man 's long video and I really enjoy it and learn new thing , so thank you so much sir ❤❤❤❤❤❤❤❤❤
I was waiting for this more please 🙏
Sir aapne hi khudh tutorial bana dhiya?? Thank you so much for this.
that was so simple yet quite useful. Thank YOu Warikoo!
EXCELLENT WAY OF TEACHING STARTED LOVING EXCEL
We want more of these Excel tutorials !
Everyone is temporary
But ankur sir is always on top🔥❤️
Please make more videos like this❤️❤️
The way he explained is so exciting that I got so much interest in this excel! love from Pakistan
Your content and video quanlity is amazing. Thanks Ankur
Ye baaat 😂 Ankur sir finally Passing his magical powers to others 🤣
Sir thank you so much for bringing this lovely piece of content. Hope to learn more from the Excel master himself 😊
Follow our channel for excel tutorials 🙏
love the way you teaching sir
First time I love to learn Excel.❤️
You teach more better than my computer teacher.🔥🌹👍👍👍
This was a very funny and joyous short lecture😂. Loved it!
Thank you sir.. bhot jiada usefull hai new student ke liye this is.for you ❣️
Thanks for this valuable knowledge.
Thank you for the basics Sir! looking forward for more! Also, I am just sharing what I have learnt differently in the same context,
1. [from my manager] Double clicking on the place where you are manually dragging (9:19) will actually adjust the column width automatically based on the length of the data entered in that cell on the top row.
2. [from my Dad] Typing two numbers in the cells one below the other that have a difference of X and then selecting those two cells and dragging them down as required will also populate the cells incrementally by X (12:18)
India’s 5th Grade computer lab teachers just lost their jobs 😂. Great work sir…..please keeping increasing the level of your excel teaching on this channel. ✌️Massive respect
You are not a beginner ??
Yr koi udemy ke course ka Link dedo. Kyunki jo link h usse specify course nhi khul rha
Actually!! Teachers don't teach utni achhe se.. at least meri ne to nahi kiya
Thank you so much sir. This video will helps so much for my tomorrow's interview. Wish you luck sir!!😊
Ankur, you make learning anything so effortless!
Dear sir,
Thank you so much for this video, I'm really hoping you continue this series. I personally believe instead of math classes, school should have a special course just on excel.
Yeh konsa version h excel kaa
Saw this coming
Great help for a beginner.
Thank you!
Most easiest way you have used to explain sir thank you I am going to watch this video multiple time.
Final formula ko magnify kar ke dikhaya Karo. Yahan beginners aate hai. So go slow if the purpose is to teach.
Are you that slow that you didn't understand what he was teaching?
It was so helpful!! I spent my Sunday tracking all my investments, expenses, and income from various side hustles!)
I have been working with excel for a while but I couldn't figure out how to use the sumif function!
But that alone was a huge revelation for me!
Can't wait for more videos on Excel.
Just to help you understand how big a deal it is. I am a Dental Postgraduate and financial management is a struggle.
You have given me a piece of knowledge that I would be using for the rest of my life.
As always you are precise and vivid
Very informative he just made entire exel in this 30min video really helpful for beginners to know it ❤️
Mr.Warikoo..Please Bring an entire series on excel in as simplest manner as you do..thanks for the effort 👍
@шarikoo 🤣🤣🤣🤣🤷
Thank you so much, Ankur for dropping knowledge bombs every week. I was hoping since we would near end of tax season by 31st December, could you produce individual videos on different tax investment systems. For example, I wouldn't know much about NPS, so would love a video around that whether it's something worth investing in to save tax and from a long term perspective as well. Thank you :)
```Thanks~~~~
thank you sir, just saw your video, because I newly step on excel, I need a video for basic learnings and got your video by findings on RUclips, thank you so much sir for this video❤❤❤❤😊😊
wonderful video Sir! I cant believe that you just explained the foundation of excel in 30 minutes. I wish everyone could have teachers like you who could breakdown and explain complex theories/knowledge in a simplified manner. thank you once again sir :)God bless you, Namaste!
Sir, I Really wish if you can spare some time in breaking down more complex excel commands like pivot and vlookup in your simplified version
⬆️⬆️⬆️ thanks for the comment..
Contact the What'sap line above for more information, and a new investment plan ✉️...
Thanku sir.. Can u bring more lesson vlook up and many more stuff
It was very helpful, thankyou!
The best excel tutorial so far!
Oh my god, u r doing great great work. Recently I was thinking, "agar ye banda excel p vedio banai toh maza aa jaiga" and u heard it. Genuinely impressed. 👌
Yay
Want more videos plz
@@warikoo please continue this. Want to learn from the people who use this for work
I was taught this in school... I wish I paid attention 😭😭😭, let's go for the Udemy course
Deepti kaise hai course ye
@@RaviVerma-my4gp abhi nahi shuru kiya. ek do din me karungi abhi skillshare pe dusra course kar rahi hun....lekin excel aasan hai bahut....bas basic mathematics aur logic aana chahiye baaki bas aaram se seekh loge
@@deeptisaini4155 skill. Share pe kaunsa course hai.
Pls give me feedback here or
If u could share no.
But pls come. Back and share your views
Ha basic maths aata hai 😀😀
@@RaviVerma-my4gp calligraphy ka... mujhe pasand hai wo....baaki agar aapko basic math aata hai to good aap jaldi seekh jaoge....you would have excel in your pc...start doing yourself and then buy the couse if you wish to
@@deeptisaini4155 ohh.. Great.. I will. Also like. To go for caligraphy.. Kyunki hand writing itni gandi hai. Na...
Yeps just baught lappy recently
.. Even though just come back and share.. Your view for Udemy
Easy explanations make learning easier....was Fun to watch this and so helpful👍
I love your explanation ❤😊
Would be great if you could design excel course of your own. Iam sure it would be cost effective as well as more valuable than those available on udemy . Your content flow is logical , examples very clear and Indianised , way of explaining much better. Please give it a thought. 🙂
Follow our channel for excel tutorials 🙏
hello mr. Hulk thanks to teach me excel
Well done sir.. Ap ne bohat Achay se samjhaya hai Excel.. Thankyou 😊
Hi Warikoo, Love your content. As few of your adds were related to Managing time, can you generate a Multiple Timer in Excel for Tracking the activities.
The Udemy link is Missing in the description.
First time i tried it and it worked as you told . You are amazing sir
I love this video, thanks warikoo👍
Why don't you make more videos on excel,your teaching skills are easy to understand ❤😌
I think you might need to make a video on why people shouldn’t take FD. We can share it to others, mainly our elders
Not sure who are elders in the your comment reference. FD is good for people who are retiring in the next 10 years.
@@VaibhavSharan well, to show parents, family members and colleagues who believe firmly that FD is the perfect long term investment. Basically people who assume stock related investing is a risk
@@barathpa Earlier FD used to give 9%+ which is a very good "risk free"investment. I would surely do it if that was the rate. Thus the previous generation had the trust on it. Now the FD rates are pathetic. New generation is moving to "attractive" ways of risky investments which gives better returns
@@KirtiRanjan exactly why there needs to be a well made clip to show the previous generation that this is the case
He is so happy 😊 thank you so much sir.
your way of teaching is awesome
3:21 Warikoo Rocked with that reaction.!!
Also where is the Pinned comment??
OMG 🤯
```Thanks~~~~
Thank You very much,Sir🙇🏻🙌🏻
This is so helpful. Thanks alot!
Ye kia hoa jaduuu😂
Very impressive thank you ji and God bless 😊 I love your teaching way. 😊
BEST EXCEL VIDEO FOR ME TILL NOW❤❤❤❤
Love the way you teach! Thank you so much 😊
Sir this is too much useful for beginners thank you so very much 👍👍👍
Not sure why 99 persons have disliked this video. It clearly depicts their mindset. Anyways Thank You Ankur for such wonderful videos. Keep making such videos.
Such a wonderful mentor! ❤ Lots of love from Bangladesh
Thank you very much sir bhot acchi video hai... Better than 2 hours video. 😊
Amazingly explained. Very simple yet so clear.
Thank you so much for thise valuable information 😊
I really love it Ankur Sir, while watching your video i was following the step and it was amazing experience👍👍👍👍
Thanq so much Sir.. this video was much needed for me.. u really explained it very well.. really excel is a magic😍😍🙏🙏
Thank you so much sir your explanation method are awesome it's really helpful please more videos.🙂
Thanks you a lot my brother... It helps me a lot..
Thank you very much Sir you are a great teacher making us learn a lot about life and skills.