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

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 RUclips 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

[@harishakumarmb6813]

Sir please continue this excel series 😊🙏

[@rajesabnaversadiq3415]

Good information sir

[@Ashish_5354]

Sir basic se document verification सीखने के लिए एक वीडियो बना दीजिए please 🙏🙏

[@Sandeesh_Srikantam]

Thanks for the trick to fetch stock market historical data. Is there Any such source to fetch the stock market’s index TRI ?

[@bijaykumarmishra7689]

I always like your video

[@sanjoy8167]

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.

[@pushpendrarathore4435]

Good sir very useful sir

[@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]

Exactly

[@IndiaVLog-xw7br]

superb

[@ecanalysis7589]

nice video

[@RahulSingh-ow8qj]

COGS should be in Minus Sign (-). So, Gross Profit will be 8 Lakh

[@yashwrdhansharma7208]

Excel ka latest version konsa hai?

[@user-ox8no1dw8x]

Thanks a lot! Very useful.....

[@FocusLocus]

Glad it was helpful!

[@aniruddhapaul9376]

Why you have not lock the range by F4 function key . The c7 to c56 range should be lock.

[@ajaharansari2270]

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

[@thehindueditors]

my god yeh kya sikaha diay gazab

[@DevendraPaal-pt8mf]

Sir, can we use it in mobile

[@TravelAwesomeWorld-o6n]

Sir affiliate marketing per video banaya

[@ayushsrivastava6636]

at 5:50 you have to fix the C7:C56 otherwise will change with each step you are copying down

[@sachinsinghania6349]

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.

[@yogeshsutar3861]

Data tab main jo stock and operations ka option nahi aata Excel upto date hai

[@souvikdas9110]

Could you please share the practice file in the description.

[@FocusLocus]

Added

[@dipeshrawat251]

5:40 sir.. range freeze nahi karoge kya????????????????

[@rakibullearning574]

Right, Cell reference didn't fixed

[@Nitixhjha]

Excel pe or video banaye sir inke sath ❤

[@FocusLocus]

Sure

[@hindustanexpress7441]

currency conversion is not working

[@rahulh2526]

Stock ka tricks is not working sir

[@RSJPTCreation]

nice sir ❤❤❤❤❤

[@FocusLocus]

Thanks and welcome

[@ganeshlaxmi45]

flash fill short cut is ctrl + e

[@Naifitullah]

It's not advance course Excel it's basic task

[@reyansh304]

thank you sir,

[@FocusLocus]

Most welcome

[@travediary]

mistake is instead of substracting IncomeTax amount u have added that!

[@rishukumarjha5620]

Bhai ye kam koi freshar bhi kar sakta hai

[@vishalkushwaha1498]

28% net profit 3273184 hai to 18 % per net profit please dout clear

[@seoexpertramansharma2046]

Aisa aur video lao inke sath hi

[@FocusLocus]

Surely

[@manojk2890]

Goal seek new tha baki sab knew it well, average

[@kuldeepyadav72]

IT ko why plus in net profit

[@FocusLocus]

:)

[@a2zfun181]

Lucknow iim se pdker excel per kam krna pad rha hai.. 😂😂😂😂
Etna Applitutue, reasoning pdne ka kya faayda.

[@FocusLocus]

😂😂 bhai aisa mat bolo humare channel par guest hai. Wapas bhi bulana hai 🤗

[@mazzanilife8221]

​@@FocusLocusMake lot of mistake

[@latenightstorieswnadiamill8057]

gem vid

[@user-eg7ll1sd9k]

How do i get a discount on excel subscription from Microsoft

[@FocusLocus]

I use Microsoft 365 subscription

[@anuragdas4113]

Kya tax calculate Kiya ye IIM grad ne? Tax Dene ke baad jo bachega usko hi tax bana diya.

[@Sagar_jain89]

Maaa mujhe to ye sab already aata hai maaa....😂😂😂😂😂

[@theAV_anantvashuki]

Khudki hi ad arhi he pehle 😂

[@rupakadhikari3369]

Inko firse bulaiye

[@user-sc2vi7kk4f]

I want an advanced course on Google ads.

[@FocusLocus]

We're working on that. It would be long and detailed. Hence taking time

[@sourabhbatham7720]

Countif formula range lock ni kiya😂😂😂😂

[@Raahulsingh]

Rephrasing by ankur is just increasing the duration of video.

[@FocusLocus]

Does it also help understand better for beginner? I’m just trying for more clarity for beginner who are watching
🙏🙏

[@Raahulsingh]

@@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]

sir tumhi marathi ahat ka ?

[@FocusLocus]

Guess :)

[@resonance.439]

wow salesis 20 L AND PROFIT IS 32 L , WOW , IIM KA BANDA 🤣

[@ytpro-tq1fy]

Me bhi yahi bolne wala tha

[@BeingPossimpible]

30:31 pe bataya hai na mistake hai bolkey

[@resonance.439]

@@BeingPossimpible plz maf kardo bhaiya galti hogai

[@Rahulmandloi587]

20 l and combine

[@ajaharansari2270]

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