Introduction to Microsoft Excel - Excel Basics Tutorial
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 KZread 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 KZread, LinkedIn, Instagram, Facebook and Twitter amassing a following of 3 Million+ people.
He posts 3 Hindi and English videos every week on his KZread 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/
Пікірлер: 1 700
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
@Blue_Horizon1406
2 жыл бұрын
Y its showing 8k course.. and in your video its 500 rs course.. could please help me with that... Thankyou sir
@pdab5550
2 жыл бұрын
Very costly promotion . Your video is not for beginner.. thankyou. It Is good for. Alreday known to execl
@Hope027
2 жыл бұрын
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 😅😅.
@NB-je5sn
2 жыл бұрын
Earlier it was showing price of 700 but now it is showing price of 8640
@kirankulkarni9509
2 жыл бұрын
@warikoo ..sir why it's firstly showing rupees 500 and now rupees 8640 can you help us in this
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 !
The teaching skills of Ankur sir are just amazing. The simplifying ability is extraordinary. Always love to watch your videos
@toonheart1991
Жыл бұрын
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
@balramkumarmishra5206
11 ай бұрын
Amazing sir
@CMAAbhishek
7 ай бұрын
Follow our channel for excel tutorials 🙏
@mrphlips1031
6 ай бұрын
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.
@aryanop1995
Жыл бұрын
Ha na
@CMAAbhishek
7 ай бұрын
Follow our channel for excel tutorials 🙏
Weekdays - MS Excel Weekend - Surf Excel 😂 Aap Excel ke peeche, Excel aapke peeche.. too much fun 😂
@piyushmathurkar5693
2 жыл бұрын
@шarikoo spanner
@Theformulafix
4 ай бұрын
Follow us for more tips about excel
@dhruvarora6541
4 ай бұрын
Daag ache hai😂
@MahamAtteeq
2 ай бұрын
😅😅😅
@A1_GAMEz482
Ай бұрын
Haha
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.
@Tonysirivlogs2688
3 ай бұрын
😊😊
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. 🙂
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 🧡
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.
@warikoo1402
2 жыл бұрын
```Thanks~~~~
@Theformulafix
4 ай бұрын
Check my work please
@jaibhagat7441
3 ай бұрын
50% would be an exaggeration although the way he speaks is amazing
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👍🏻
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.
The way you explained this concept was superb, your energy was totally high while teaching , which motivated alot. Thank you😃
KZread 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 .
Ankur, we're waiting for this series..thank you so much.
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. :)
Thanks for sharing. Loved the way you explained. Tried this on sheet practically today itself.
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♥️♥️
@prashantdhebar
2 жыл бұрын
Hehe so well said
@Iamlucifeerrr
2 жыл бұрын
Same bro.
@chetankumarkoli5707
2 жыл бұрын
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
@prem3957
2 жыл бұрын
@Rishabh Galhotra. Man you've already cleared intermediate, I haven't clear foundation despite giving my 2nd attempt.
@rishabhgalhotra3528
2 жыл бұрын
@@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
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.
I literally don't get bored a single minute... U ARE AMAZING
Everyone is temporary But ankur sir is always on top🔥❤️ Please make more videos like this❤️❤️
Sir thank you so much for bringing this lovely piece of content. Hope to learn more from the Excel master himself 😊
@CMAAbhishek
7 ай бұрын
Follow our channel for excel tutorials 🙏
Thank you so much sir. This video will helps so much for my tomorrow's interview. Wish you luck sir!!😊
Very informative he just made entire exel in this 30min video really helpful for beginners to know it ❤️
I started the course of kyle pew on udemy. This is what you have informed me. Thanks for that
Final formula ko magnify kar ke dikhaya Karo. Yahan beginners aate hai. So go slow if the purpose is to teach.
😃 never had that much fun in learning Excel. That is really sweet of you thankyou. plz make more video on excel as you have 20 year experience in Excel, you would have something different to offer than other educators.
Easy explanations make learning easier....was Fun to watch this and so helpful👍
Thank u so much..I had a zero knowledge in Excel..but now ...I got some points.....
First time I love to learn Excel.❤️ You teach more better than my computer teacher.🔥🌹👍👍👍
Ankur sir, this is the best intro to Excel video I've ever seen ...............please make a series on Excel. Loved your energy.
The way he explained is so exciting that I got so much interest in this excel! love from Pakistan
Ye Banda kia h Bhai 😭 itny mazy se parhata ... Sir you masterpiece 💗 Kash ap Meri clg me hoty
@RoshniVerma-ot6px
7 ай бұрын
..college ke liy etne achee teacher miljate kash
@CMAAbhishek
7 ай бұрын
Follow our channel for excel tutorials 🙏
@jagatjasaihembram9360
6 ай бұрын
Sahe bola 😂...
@Keshvin2905
4 ай бұрын
Investment kaise aaya amount plus karna hai kya
This is what I wanted, was searching for courses and asking from friends, thankyou sir. 🤟
@premkalasamukhrao3311
2 жыл бұрын
True
@evelynlucas617
2 жыл бұрын
I think crypto currency is the best thing to trade on
@evelynlucas617
2 жыл бұрын
I trade with Mr james Alex he is a professional broker here is his email
@evelynlucas617
2 жыл бұрын
Jamesales 63 🤳
Can't even imagine the jinx! Like I had my first excel class in college on Saturday and couldn't understand a thing coz I'm not good with technical stuff. Tysmm for this✌️🤗
Hi Sir, it was a very knowledgeable video please continue this series learning from you would be better than any other course.
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)👍🏻👌🏻
@Crocodile_Gaming.2002
Жыл бұрын
No need to buy any online excel course. Brother search "Innozant" on KZread. And watch pure beginners to super advance excel course (Fully free).
I was waiting for this more please 🙏
Thank you so much sir your explanation method are awesome it's really helpful please more videos.🙂
Thank You! It gave me a good kick on how to begin with excel finally.
We all want this course. From beginner to advanced
Sir aapne hi khudh tutorial bana dhiya?? Thank you so much for this.
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 ❤
that was so simple yet quite useful. Thank YOu Warikoo!
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 :)
@warikoo1402
2 жыл бұрын
```Thanks~~~~
Sir please make a complete series on basic to advanced Excel to financial modeling Some people can't afford the expensive courses
@4dimusic
2 жыл бұрын
Yea 💯😀
@akk92278
2 жыл бұрын
Yes
@rohitagrawal6787
2 жыл бұрын
I want this as well
@vinayrathore560
2 жыл бұрын
Yes
@vinayakrokade9237
2 жыл бұрын
Yes
Ankur, you make learning anything so effortless!
Wow, it was so useful to use Excel after this video. Thanks for that and love how your teach things! 💯
This was a very funny and joyous short lecture😂. Loved it!
We want more of these Excel tutorials !
I really love it Ankur Sir, while watching your video i was following the step and it was amazing experience👍👍👍👍
Ankur, the way you present anything, be it Excel or Investment is quite interesting. Keep it up.
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.
@ishantsharma62
2 жыл бұрын
Yeh konsa version h excel kaa
Ye baaat 😂 Ankur sir finally Passing his magical powers to others 🤣
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 ❤❤❤❤❤❤❤❤❤
Thank you very much Sir you are a great teacher making us learn a lot about life and skills.
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!
@mohitsaini9725
2 жыл бұрын
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
@imanghadzi11
2 жыл бұрын
⬆️⬆️⬆️ thanks for the comment.. Contact the What'sap line above for more information, and a new investment plan ✉️...
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.
Love the way you teach! Thank you so much 😊
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
@harshmehra5527
2 жыл бұрын
You are not a beginner ??
@rudraupadhyay1379
2 жыл бұрын
Yr koi udemy ke course ka Link dedo. Kyunki jo link h usse specify course nhi khul rha
@tvisha7572
2 жыл бұрын
Actually!! Teachers don't teach utni achhe se.. at least meri ne to nahi kiya
Mr.Warikoo..Please Bring an entire series on excel in as simplest manner as you do..thanks for the effort 👍
@tsewangdolkar2995
2 жыл бұрын
@шarikoo 🤣🤣🤣🤣🤷
Your content and video quanlity is amazing. Thanks Ankur
Great help for a beginner. Thank you!
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)
Saw this coming
Most easiest way you have used to explain sir thank you I am going to watch this video multiple time.
Awsome way to express things, I love it i learned so many tricks thanks for making this video for true learner
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. 👌
@warikoo
2 жыл бұрын
Yay
@themindriser999
2 жыл бұрын
Want more videos plz
@SumantKumar-nv5hj
2 жыл бұрын
@@warikoo please continue this. Want to learn from the people who use this for work
Thanku sir.. Can u bring more lesson vlook up and many more stuff
This was just amazing , I have just started learning excel and i must say you are making my learning easy . Well done Ankur
@imanghadzi11
2 жыл бұрын
⬆️⬆️⬆️ thanks for the comment.. Contact the What'sap line above for more information, and a new investment plan ✉️...
Such an amazing tech KZreadr Thanks to your teaching in a beautiful way thanks alot
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. 🙂
@CMAAbhishek
7 ай бұрын
Follow our channel for excel tutorials 🙏
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.
Thanq so much Sir.. this video was much needed for me.. u really explained it very well.. really excel is a magic😍😍🙏🙏
Why don't you make more videos on excel,your teaching skills are easy to understand ❤😌
I was taught this in school... I wish I paid attention 😭😭😭, let's go for the Udemy course
@RaviVerma-my4gp
2 жыл бұрын
Deepti kaise hai course ye
@deeptisaini4155
2 жыл бұрын
@@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
@RaviVerma-my4gp
2 жыл бұрын
@@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 😀😀
@deeptisaini4155
2 жыл бұрын
@@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
@RaviVerma-my4gp
2 жыл бұрын
@@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
Sir your teaching way is just marvelous. It seems like em at my school days back 🙏💯 more power to you .
Thank you sir simple and clear 🎉🎉🎉🎊🎊
hello mr. Hulk thanks to teach me excel
The Udemy link is Missing in the description.
i am lucky i found your channel. You're the best teacher 🙏🙌🙌
Simple and sweet like a hot cake explaining process its make to look more videos about your tutor on Excel - Thanks
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
@VaibhavSharan
2 жыл бұрын
Not sure who are elders in the your comment reference. FD is good for people who are retiring in the next 10 years.
@barathpa
2 жыл бұрын
@@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
@KirtiRanjan
2 жыл бұрын
@@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
@barathpa
2 жыл бұрын
@@KirtiRanjan exactly why there needs to be a well made clip to show the previous generation that this is the case
3:21 Warikoo Rocked with that reaction.!! Also where is the Pinned comment??
First time i tried it and it worked as you told . You are amazing sir
🙏🙏🙏 thank you souch sir its easy and very simple to understand and most importantly the formula you have gave to us which was so smart work 🥳
OMG 🤯
@warikoo1402
2 жыл бұрын
```Thanks~~~~
Ye kia hoa jaduuu😂
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 KZread, thank you so much sir for this video❤❤❤❤😊😊
Thank you so much for giving us so much of knowledge about Excel
Very good explanation. Never seen more transparent explanation than this. This is very very usefull. And you made it really interesting. Love it ✍️
What a simple and i interesting way , i watched many videos buy found this to be worth👏
EXCELLENT WAY OF TEACHING STARTED LOVING EXCEL
Thanks for this valuable knowledge.
Well done sir.. Ap ne bohat Achay se samjhaya hai Excel.. Thankyou 😊
Didn't skipped a single part Such an engaging video thank you sir 👍
The way you teach It's very interesting I didn't felt bored.🤭 Thank you for your efforts sir.🥀
I was exactly finding a teacher like you which can taught us easily
As always you are precise and vivid
Super cool personality of teaching and in such a easy way... I wish I could get a personal coaching for Computers from you.. Keep it up 👍!