Тёмный

How MNCs Use Excel Smartly? Learn MS Excel From IIM Graduate... 

Focus Locus
Подписаться 371 тыс.
Просмотров 70 тыс.
50% 1

How to use Excel for work? We brought about 6 case studies in this basic Excel course to answer this question. These include basic and advanced formulas and some mindset tricks that will increase your understanding of the software in Hindi.
Understand how to use Microsoft Excel for your job in data entry, data analysis, or for normal everyday use.
More videos for you:
Excel basics: • Basic Excel Tutorial F...
Excel functions and formulas: • Excel Functions & Form...
Excel for data entry: • Free Data Entry Operat...
Aditya Sir's RU-vid channel: / @aditya_shelar
Excel training file: bit.ly/ExcelPracticeFileFL
Join this channel to get access to perks:
/ @focuslocus
Talk to me on Instagram: / focusankur (@focusankur)
Join my WhatsApp Group: bit.ly/focuswat
Chapters:
00:00 Introduction
01:34 Fast fill
03:33 Removing duplication
04:20 COUNTIF
06:30 Tax calculations
10:48 What if analysis
14:00 Loan/EMI calculation
16:53 Reverse calculation/ Goal seek function
18:25 Cleaning data
20:00 Cleaning phone numbers
23:00 Currency conversion
24:53 Stock market data/history
28:57 Bonus feature
#focuslocus #excel #msexcel

Хобби

Опубликовано:

 

3 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 71   
@harishakumarmb6813
@harishakumarmb6813 22 дня назад
Sir please continue this excel series 😊🙏
@sanjoy8167
@sanjoy8167 16 дней назад
Mistakes are as follows---- 1]COGS should be a negative value, just include a '-ve' sign before in the formula; 2]Income tax calculation should include only '=max(0,Tax Rate*Pretax Income)' in the max formula; 3]Net Profit calculation is having an error too, it should subtract Income Tax from Pretax Income.
@imtiazshaikh2158
@imtiazshaikh2158 Месяц назад
Mistake in Net profit calculation is adding pretax and income tax amount And mistake in income tax calculation it should be only tax amount, it should not subtract the pretax amount
@abdulafshan12
@abdulafshan12 13 дней назад
Exactly
@rajesabnaversadiq3415
@rajesabnaversadiq3415 26 дней назад
Good information sir
@bijaykumarmishra7689
@bijaykumarmishra7689 24 дня назад
I always like your video
@pushpendrarathore4435
@pushpendrarathore4435 25 дней назад
Good sir very useful sir
@user-ox8no1dw8x
@user-ox8no1dw8x Месяц назад
Thanks a lot! Very useful.....
@FocusLocus
@FocusLocus Месяц назад
Glad it was helpful!
@IndiaVLog-xw7br
@IndiaVLog-xw7br 24 дня назад
superb
@Ashish_5354
@Ashish_5354 Месяц назад
Sir basic se document verification सीखने के लिए एक वीडियो बना दीजिए please 🙏🙏
@Sandeesh_Srikantam
@Sandeesh_Srikantam 19 дней назад
Thanks for the trick to fetch stock market historical data. Is there Any such source to fetch the stock market’s index TRI ?
@ecanalysis7589
@ecanalysis7589 22 дня назад
nice video
@thehindueditors
@thehindueditors 10 дней назад
my god yeh kya sikaha diay gazab
@RahulSingh-ow8qj
@RahulSingh-ow8qj Месяц назад
COGS should be in Minus Sign (-). So, Gross Profit will be 8 Lakh
@aniruddhapaul9376
@aniruddhapaul9376 15 дней назад
Why you have not lock the range by F4 function key . The c7 to c56 range should be lock.
@ayushsrivastava6636
@ayushsrivastava6636 11 дней назад
at 5:50 you have to fix the C7:C56 otherwise will change with each step you are copying down
@TravelAwesomeWorld-o6n
@TravelAwesomeWorld-o6n 16 дней назад
Sir affiliate marketing per video banaya
@ganeshlaxmi45
@ganeshlaxmi45 25 дней назад
flash fill short cut is ctrl + e
@yashwrdhansharma7208
@yashwrdhansharma7208 17 дней назад
Excel ka latest version konsa hai?
@Nitixhjha
@Nitixhjha 28 дней назад
Excel pe or video banaye sir inke sath ❤
@FocusLocus
@FocusLocus 28 дней назад
Sure
@RSJPTCreation
@RSJPTCreation Месяц назад
nice sir ❤❤❤❤❤
@FocusLocus
@FocusLocus Месяц назад
Thanks and welcome
@DevendraPaal-pt8mf
@DevendraPaal-pt8mf 4 дня назад
Sir, can we use it in mobile
@ajaharansari2270
@ajaharansari2270 21 день назад
Excell me ek sheet par row ya column insert kare to dusre sheet me change ho aisa ho sakta hai plz give me link any one
@reyansh304
@reyansh304 Месяц назад
thank you sir,
@FocusLocus
@FocusLocus Месяц назад
Most welcome
@souvikdas9110
@souvikdas9110 Месяц назад
Could you please share the practice file in the description.
@FocusLocus
@FocusLocus 27 дней назад
Added
@yogeshsutar3861
@yogeshsutar3861 Месяц назад
Data tab main jo stock and operations ka option nahi aata Excel upto date hai
@Naifitullah
@Naifitullah 11 дней назад
It's not advance course Excel it's basic task
@dipeshrawat251
@dipeshrawat251 Месяц назад
5:40 sir.. range freeze nahi karoge kya????????????????
@rakibullearning574
@rakibullearning574 12 дней назад
Right, Cell reference didn't fixed
@sachinsinghania6349
@sachinsinghania6349 8 дней назад
if pretax value is 19lac (that's profit before tax) how net profit will be 38lac even after paying 0% income tax. After tax, net profit value should be increased or decreased ? and at 0% tax net profit should be equal to pretax income.
@parthpandya5631
@parthpandya5631 День назад
I STILL DO NOT UNDERSTAND PRETAX 19L AND AGAIN AFTER ADDING 28% TAX HOW IT CAN BECOME 32l?
@travediary
@travediary 7 дней назад
mistake is instead of substracting IncomeTax amount u have added that!
@seoexpertramansharma2046
@seoexpertramansharma2046 Месяц назад
Aisa aur video lao inke sath hi
@FocusLocus
@FocusLocus Месяц назад
Surely
@latenightstorieswnadiamill8057
@latenightstorieswnadiamill8057 25 дней назад
gem vid
@a2zfun181
@a2zfun181 28 дней назад
Lucknow iim se pdker excel per kam krna pad rha hai.. 😂😂😂😂 Etna Applitutue, reasoning pdne ka kya faayda.
@FocusLocus
@FocusLocus 28 дней назад
😂😂 bhai aisa mat bolo humare channel par guest hai. Wapas bhi bulana hai 🤗
@mazzanilife8221
@mazzanilife8221 24 дня назад
​@@FocusLocusMake lot of mistake
@manojk2890
@manojk2890 5 дней назад
Goal seek new tha baki sab knew it well, average
@hindustanexpress7441
@hindustanexpress7441 18 дней назад
currency conversion is not working
@rahulh2526
@rahulh2526 24 дня назад
Stock ka tricks is not working sir
@rishukumarjha5620
@rishukumarjha5620 20 дней назад
Bhai ye kam koi freshar bhi kar sakta hai
@kuldeepyadav72
@kuldeepyadav72 29 дней назад
IT ko why plus in net profit
@FocusLocus
@FocusLocus 28 дней назад
:)
@Sagar_jain89
@Sagar_jain89 20 дней назад
Maaa mujhe to ye sab already aata hai maaa....😂😂😂😂😂
@vishalkushwaha1498
@vishalkushwaha1498 14 дней назад
28% net profit 3273184 hai to 18 % per net profit please dout clear
@user-eg7ll1sd9k
@user-eg7ll1sd9k 17 дней назад
How do i get a discount on excel subscription from Microsoft
@FocusLocus
@FocusLocus 13 дней назад
I use Microsoft 365 subscription
@theAV_anantvashuki
@theAV_anantvashuki 23 дня назад
Khudki hi ad arhi he pehle 😂
@user-sc2vi7kk4f
@user-sc2vi7kk4f Месяц назад
I want an advanced course on Google ads.
@FocusLocus
@FocusLocus Месяц назад
We're working on that. It would be long and detailed. Hence taking time
@anuragdas4113
@anuragdas4113 3 дня назад
Kya tax calculate Kiya ye IIM grad ne? Tax Dene ke baad jo bachega usko hi tax bana diya.
@rupakadhikari3369
@rupakadhikari3369 3 дня назад
Inko firse bulaiye
@resonance.439
@resonance.439 25 дней назад
wow salesis 20 L AND PROFIT IS 32 L , WOW , IIM KA BANDA 🤣
@ytpro-tq1fy
@ytpro-tq1fy 22 дня назад
Me bhi yahi bolne wala tha
@BeingPossimpible
@BeingPossimpible 20 дней назад
30:31 pe bataya hai na mistake hai bolkey
@resonance.439
@resonance.439 20 дней назад
@@BeingPossimpible plz maf kardo bhaiya galti hogai
@Rahulmandloi587
@Rahulmandloi587 18 дней назад
20 l and combine
@sourabhbatham7720
@sourabhbatham7720 22 дня назад
Countif formula range lock ni kiya😂😂😂😂
@Raahulsingh
@Raahulsingh 15 дней назад
Rephrasing by ankur is just increasing the duration of video.
@FocusLocus
@FocusLocus 13 дней назад
Does it also help understand better for beginner? I’m just trying for more clarity for beginner who are watching 🙏🙏
@Raahulsingh
@Raahulsingh 3 дня назад
@@FocusLocus it was not helpful for me i closed the video in less than 2 mints. You can take feedback from others. May be they can show you different perspective
@sanketdongare1002
@sanketdongare1002 29 дней назад
sir tumhi marathi ahat ka ?
@FocusLocus
@FocusLocus 28 дней назад
Guess :)
@ajaharansari2270
@ajaharansari2270 21 день назад
Excell me ek sheet par row ya column insert kare to dusre sheet me change ho aisa ho sakta hai plz give me link any one
Далее
Make Easy Excel Dashboard and Earn Rs  5000 🚀
27:51
Китайка и Шрек в Домике😂😆
00:20
ЮТУБ ТОЧНО ВСЕ!
11:23
Просмотров 948 тыс.
This is how I ACTUALLY analyze data using Excel
24:05
Просмотров 101 тыс.
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
РЫБАЛКА ДОМА
0:17
Просмотров 17 млн