Sir please continue this excel series 😊🙏

Good information sir

Good sir very useful sir

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

6 күн бұрын

Exactly

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

I always like your video

superb

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

nice video

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.

my god yeh kya sikaha diay gazab

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

Excel ka latest version konsa hai?

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

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

Thanks a lot! Very useful.....

@FocusLocus

25 күн бұрын

Glad it was helpful!

Sir affiliate marketing per video banaya

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

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

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.

currency conversion is not working

Could you please share the practice file in the description.

@FocusLocus

20 күн бұрын

Added

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

@rakibullearning574

6 күн бұрын

Right, Cell reference didn't fixed

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

Stock ka tricks is not working sir

Excel pe or video banaye sir inke sath ❤

@FocusLocus

21 күн бұрын

Sure

nice sir ❤❤❤❤❤

@FocusLocus

24 күн бұрын

Thanks and welcome

flash fill short cut is ctrl + e

Bhai ye kam koi freshar bhi kar sakta hai

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

thank you sir,

@FocusLocus

29 күн бұрын

Most welcome

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

IT ko why plus in net profit

@FocusLocus

21 күн бұрын

:)

How do i get a discount on excel subscription from Microsoft

@FocusLocus

7 күн бұрын

I use Microsoft 365 subscription

Aisa aur video lao inke sath hi

@FocusLocus

26 күн бұрын

Surely

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

@FocusLocus

21 күн бұрын

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

@mazzanilife8221

18 күн бұрын

​@@FocusLocusMake lot of mistake

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

gem vid

Khudki hi ad arhi he pehle 😂

Countif formula range lock ni kiya😂😂😂😂

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

@ytpro-tq1fy

15 күн бұрын

Me bhi yahi bolne wala tha

@BeingPossimpible

14 күн бұрын

30:31 pe bataya hai na mistake hai bolkey

@resonance.439

14 күн бұрын

@@BeingPossimpible plz maf kardo bhaiya galti hogai

@Rahulmandloi587

11 күн бұрын

20 l and combine

I want an advanced course on Google ads.

@FocusLocus

Ай бұрын

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

Rephrasing by ankur is just increasing the duration of video.

@FocusLocus

7 күн бұрын

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

sir tumhi marathi ahat ka ?

@FocusLocus

21 күн бұрын

Guess :)

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