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

Рет қаралды 67,345

Күн бұрын

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

Пікірлер: 69

@harishakumarmb6813 19 күн бұрын

Sir please continue this excel series 😊🙏

@sanjoy8167 12 күн бұрын

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.

@rajesabnaversadiq3415 22 күн бұрын

Good information 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 9 күн бұрын

Exactly

@Sandeesh_Srikantam 16 күн бұрын

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

@pushpendrarathore4435 22 күн бұрын

Good sir very useful sir

@Ashish_5354 Ай бұрын

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

@bijaykumarmishra7689 20 күн бұрын

I always like your video

@IndiaVLog-xw7br 20 күн бұрын

superb

@ecanalysis7589 18 күн бұрын

nice video

@RahulSingh-ow8qj 27 күн бұрын

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

@user-ox8no1dw8x 29 күн бұрын

Thanks a lot! Very useful.....

@FocusLocus 28 күн бұрын

Glad it was helpful!

@ajaharansari2270 17 күн бұрын

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

@yashwrdhansharma7208 14 күн бұрын

Excel ka latest version konsa hai?

@aniruddhapaul9376 12 күн бұрын

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

@thehindueditors 6 күн бұрын

my god yeh kya sikaha diay gazab

@ayushsrivastava6636 7 күн бұрын

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

@TravelAwesomeWorld-o6n 12 күн бұрын

Sir affiliate marketing per video banaya

@DevendraPaal-pt8mf 9 сағат бұрын

Sir, can we use it in mobile

@yogeshsutar3861 29 күн бұрын

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

@sachinsinghania6349 5 күн бұрын

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.

@RSJPTCreation 27 күн бұрын

nice sir ❤❤❤❤❤

@FocusLocus 27 күн бұрын

Thanks and welcome

@dipeshrawat251 26 күн бұрын

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

@rakibullearning574 8 күн бұрын

Right, Cell reference didn't fixed

@souvikdas9110 28 күн бұрын

Could you please share the practice file in the description.

@FocusLocus 23 күн бұрын

Added

@Nitixhjha 25 күн бұрын

Excel pe or video banaye sir inke sath ❤

@FocusLocus 24 күн бұрын

Sure

@ganeshlaxmi45 21 күн бұрын

flash fill short cut is ctrl + e

@hindustanexpress7441 14 күн бұрын

currency conversion is not working

@rahulh2526 21 күн бұрын

Stock ka tricks is not working sir

@travediary 3 күн бұрын

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

@reyansh304 Ай бұрын

thank you sir,

@FocusLocus Ай бұрын

Most welcome

@rishukumarjha5620 16 күн бұрын

Bhai ye kam koi freshar bhi kar sakta hai

@a2zfun181 24 күн бұрын

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

@FocusLocus 24 күн бұрын

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

@mazzanilife8221 21 күн бұрын

@@FocusLocusMake lot of mistake

@vishalkushwaha1498 11 күн бұрын

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

@anuragdas4113 3 сағат бұрын

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

@kuldeepyadav72 25 күн бұрын

IT ko why plus in net profit

@FocusLocus 24 күн бұрын

@seoexpertramansharma2046 29 күн бұрын

Aisa aur video lao inke sath hi

@FocusLocus 29 күн бұрын

Surely

@manojk2890 Күн бұрын

Goal seek new tha baki sab knew it well, average

@latenightstorieswnadiamill8057 21 күн бұрын

gem vid

@user-eg7ll1sd9k 13 күн бұрын

How do i get a discount on excel subscription from Microsoft

@FocusLocus 10 күн бұрын

I use Microsoft 365 subscription

@Sagar_jain89 16 күн бұрын

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

@Naifitullah 8 күн бұрын

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

@theAV_anantvashuki 19 күн бұрын

Khudki hi ad arhi he pehle 😂

@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 18 күн бұрын

Countif formula range lock ni kiya😂😂😂😂

@sanketdongare1002 25 күн бұрын

sir tumhi marathi ahat ka ?

@FocusLocus 24 күн бұрын

Guess :)

@Raahulsingh 11 күн бұрын

Rephrasing by ankur is just increasing the duration of video.

@FocusLocus 10 күн бұрын

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