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
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.
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.
@@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
🔥 NEW Video Advanced Excel with Aditya Sir: ua-cam.com/video/3SPKuILN968/v-deo.html
Interesting ❤❤
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
Exactly
Exactly 💯
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.
Kudos sir keep it up please ccontinue this series alongwith powerpoint too.
Sir, can we use it in mobile
konsa version hai excel ka?
Thanks for the trick to fetch stock market historical data. Is there Any such source to fetch the stock market’s index TRI ?
Sir please continue this excel series 😊🙏
sir G ap na detail digital markiting ka course ki koi update nhi dii
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?
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.
COGS should be in Minus Sign (-). So, Gross Profit will be 8 Lakh
Continue this excel series❤
same as make a video on sql for data analysis
MIS ka job ya data analysis job hota usme sab advance excil aata hai per isme coding wagira bhi hota hai kya
1. Flash Fill ke liye Ctrl + E press kar sakte hai.
2. Formula Drag Krna ke liye Bold + sign pr Double Click kr sakte hai.
Kon sa version hii
Sir please share the video of advance excel
Thanks sir for giving your knowledge
amazing
5:40 sir.. range freeze nahi karoge kya????????????????
Right, Cell reference didn't fixed
Could you please share the practice file in the description.
Added
I STILL DO NOT UNDERSTAND PRETAX 19L AND AGAIN AFTER ADDING 28% TAX HOW IT CAN BECOME 32l?
insightful video
MNC are 1000 steps ahead from this i worked on data which blow your mind
How do i get a discount on excel subscription from Microsoft
I use Microsoft 365 subscription
at 5:50 you have to fix the C7:C56 otherwise will change with each step you are copying down
this is a basic of basic excel
currency conversion is not working
Excel me school 6 to 12 class, 8 period ka Time' tebal kese banayenge
index match use krke
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
us sheet ko table form me change kr lo....Ctrl+t
Sir basic se document verification सीखने के लिए एक वीडियो बना दीजिए please 🙏🙏
Sir affiliate marketing per video banaya
Thanks a lot! Very useful.....
Glad it was helpful!
🙂good
Good information sir
❤nice
Bhai ye kam koi freshar bhi kar sakta hai
Stock ka tricks is not working sir
28% net profit 3273184 hai to 18 % per net profit please dout clear
my god yeh kya sikaha diay gazab
1:36 Shortcut Ctrl+E
mistake is instead of substracting IncomeTax amount u have added that!
I always like your video
Mistake.. Np is 32 lacs.. Minus sign is missed
nice video
superb
Good sir very useful sir
Data tab main jo stock and operations ka option nahi aata Excel upto date hai
Excel pe or video banaye sir inke sath ❤
Sure
It's not advance course Excel it's basic task
flash fill short cut is ctrl + e
Lucknow iim se pdker excel per kam krna pad rha hai.. 😂😂😂😂
Etna Applitutue, reasoning pdne ka kya faayda.
😂😂 bhai aisa mat bolo humare channel par guest hai. Wapas bhi bulana hai 🤗
@@FocusLocusMake lot of mistake
Wondering IIM ka tag itna sasta kyu hai ajkal .. koi bhi mu uthake likh de te hai founded by IIM guys .... Diluted the brand totally 😅 ...
❤❤❤❤
Kya tax calculate Kiya ye IIM grad ne? Tax Dene ke baad jo bachega usko hi tax bana diya.
I think tax calculation is wrong.
IT ko why plus in net profit
:)
Goal seek new tha baki sab knew it well, average
nice sir ❤❤❤❤❤
Thanks and welcome
Aisa aur video lao inke sath hi
Surely
Garcia Anthony Rodriguez Angela Martin Betty
Maaa mujhe to ye sab already aata hai maaa....😂😂😂😂😂
Rephrasing by ankur is just increasing the duration of video.
Does it also help understand better for beginner? I’m just trying for more clarity for beginner who are watching
🙏🙏
@@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
wow salesis 20 L AND PROFIT IS 32 L , WOW , IIM KA BANDA 🤣
Me bhi yahi bolne wala tha
30:31 pe bataya hai na mistake hai bolkey
@@DataMaxtern plz maf kardo bhaiya galti hogai
20 l and combine
sir tumhi marathi ahat ka ?
Guess :)
Khudki hi ad arhi he pehle 😂
falsh fill waali trick toh kaam hi nai krri ☹
Inko firse bulaiye
Countif formula range lock ni kiya😂😂😂😂
thank you sir,
Most welcome
Excel is Overrated try SQL 😅
I want an advanced course on Google ads.
We're working on that. It would be long and detailed. Hence taking time
Kya yrr itna basic sikha rhe ho 😅 kuch advance batao
Sure sir. Stating with these. More coming.
Advanced Excel Tutorial - Learn PIVOT Tables / VLOOKUP / HLOOKUP / XLOOKUP in MS Excel
ua-cam.com/video/3SPKuILN968/v-deo.html
Ye iim ki khani mera 5th class ka student janta h bhai agar ye iim h toh thuuuu h aisi degree pr
gem vid
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