🔥 NEW Video Advanced Excel with Aditya Sir: kzitem.info/news/bejne/lImGsal_hYBqaW0
@imtiazshaikh2158
2 ай бұрын
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
@googological
5 күн бұрын
Exactly 💯
@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.
@harishakumarmb6813
Ай бұрын
Sir please continue this excel series 😊🙏
@user-jp4xn4oq3f
4 күн бұрын
Sir please share the video of advance excel
@aniruddhapaul9376
Ай бұрын
Why you have not lock the range by F4 function key . The c7 to c56 range should be lock.
@RahulSingh-ow8qj
2 ай бұрын
COGS should be in Minus Sign (-). So, Gross Profit will be 8 Lakh
@ayushsrivastava6636
Ай бұрын
at 5:50 you have to fix the C7:C56 otherwise will change with each step you are copying down
@BytesBard
7 күн бұрын
1:36 Shortcut Ctrl+E
@preetshah3793
16 күн бұрын
same as make a video on sql for data analysis
@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 ?
@GopalBhowmick-vp3hn
12 күн бұрын
insightful video
@ganeshlaxmi45
Ай бұрын
flash fill short cut is ctrl + e
@The_Dark_zone5354
2 ай бұрын
Sir basic se document verification सीखने के लिए एक वीडियो बना दीजिए please 🙏🙏
@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.
@user-ox8no1dw8x
2 ай бұрын
Thanks a lot! Very useful.....
@FocusLocus
2 ай бұрын
Glad it was helpful!
@souvikdas9110
2 ай бұрын
Could you please share the practice file in the description.
@FocusLocus
2 ай бұрын
Added
@FitTrekVlogger
19 күн бұрын
MIS ka job ya data analysis job hota usme sab advance excil aata hai per isme coding wagira bhi hota hai kya
@rajesabnaversadiq3415
2 ай бұрын
Good information sir
@sameerrahmad5815
14 күн бұрын
sir G ap na detail digital markiting ka course ki koi update nhi dii
@dipeshrawat251
2 ай бұрын
5:40 sir.. range freeze nahi karoge kya????????????????
@rakibullearning574
Ай бұрын
Right, Cell reference didn't fixed
@yogeshyadav-zm1yt
5 күн бұрын
❤❤❤❤
@prakashgusai3119
20 күн бұрын
🙂good
@Lakkhu1
26 күн бұрын
❤nice
@parthpandya5631
Ай бұрын
I STILL DO NOT UNDERSTAND PRETAX 19L AND AGAIN AFTER ADDING 28% TAX HOW IT CAN BECOME 32l?
@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
@pushpendrarathore4435
Ай бұрын
Good sir very useful sir
@bijaykumarmishra7689
Ай бұрын
I always like your video
@ecanalysis7589
Ай бұрын
nice video
@dhrumilchanpura356
24 күн бұрын
konsa version hai excel ka?
@IndiaVLog-xw7br
Ай бұрын
superb
@yashwrdhansharma7208
Ай бұрын
Excel ka latest version konsa hai?
@TravelAwesomeWorld-o6n
Ай бұрын
Sir affiliate marketing per video banaya
@hindustanexpress7441
Ай бұрын
currency conversion is not working
@Naifitullah
Ай бұрын
It's not advance course Excel it's basic task
@RahulKumar-wj9qd
21 күн бұрын
Kon sa version hii
@Nitixhjhaa
2 ай бұрын
Excel pe or video banaye sir inke sath ❤
@FocusLocus
2 ай бұрын
Sure
@a2zfun181
2 ай бұрын
Lucknow iim se pdker excel per kam krna pad rha hai.. 😂😂😂😂 Etna Applitutue, reasoning pdne ka kya faayda.
@FocusLocus
2 ай бұрын
😂😂 bhai aisa mat bolo humare channel par guest hai. Wapas bhi bulana hai 🤗
@mazzanilife8221
Ай бұрын
@@FocusLocusMake lot of mistake
@travediary
Ай бұрын
mistake is instead of substracting IncomeTax amount u have added that!
@Jaihokarma
8 күн бұрын
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 😅 ...
@vishalkushwaha1498
Ай бұрын
28% net profit 3273184 hai to 18 % per net profit please dout clear
@yogeshsutar3861
2 ай бұрын
Data tab main jo stock and operations ka option nahi aata Excel upto date hai
@seoexpertramansharma2046
2 ай бұрын
Aisa aur video lao inke sath hi
@FocusLocus
2 ай бұрын
Surely
@RSJPTCreation
2 ай бұрын
nice sir ❤❤❤❤❤
@FocusLocus
2 ай бұрын
Thanks and welcome
@user-eg7ll1sd9k
Ай бұрын
How do i get a discount on excel subscription from Microsoft
@FocusLocus
Ай бұрын
I use Microsoft 365 subscription
@kuldeepyadav72
2 ай бұрын
IT ko why plus in net profit
@FocusLocus
2 ай бұрын
:)
@rahulh2526
Ай бұрын
Stock ka tricks is not working sir
@manojk2890
Ай бұрын
Goal seek new tha baki sab knew it well, average
@rupakadhikari3369
Ай бұрын
Inko firse bulaiye
@rishukumarjha5620
Ай бұрын
Bhai ye kam koi freshar bhi kar sakta hai
@reyansh304
2 ай бұрын
thank you sir,
@FocusLocus
2 ай бұрын
Most welcome
@resonance.439
Ай бұрын
wow salesis 20 L AND PROFIT IS 32 L , WOW , IIM KA BANDA 🤣
@ytpro-tq1fy
Ай бұрын
Me bhi yahi bolne wala tha
@DataMaxtern
Ай бұрын
30:31 pe bataya hai na mistake hai bolkey
@resonance.439
Ай бұрын
@@DataMaxtern plz maf kardo bhaiya galti hogai
@Rahulmandloi587
Ай бұрын
20 l and combine
@Umra867
3 күн бұрын
falsh fill waali trick toh kaam hi nai krri ☹
@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....😂😂😂😂😂
@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
@sourabhbatham7720
Ай бұрын
Countif formula range lock ni kiya😂😂😂😂
@theAV_anantvashuki
Ай бұрын
Khudki hi ad arhi he pehle 😂
@sanketdongare1002
2 ай бұрын
sir tumhi marathi ahat ka ?
@FocusLocus
2 ай бұрын
Guess :)
@user-sc2vi7kk4f
2 ай бұрын
I want an advanced course on Google ads.
@FocusLocus
2 ай бұрын
We're working on that. It would be long and detailed. Hence taking time
@Atiq298
8 күн бұрын
Excel is Overrated try SQL 😅
@latenightstorieswnadiamill8057
Ай бұрын
gem vid
@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
Пікірлер: 87