Тёмный
The Excelism
The Excelism
The Excelism
Подписаться
Welcome to The Excelism! Your destination for all things related to Ms Excel, Power Query, Power BI, Caseware IDEA, and other ETL tools. With over 13 years of experience in the field of audit and finance, including work at top companies like Microsoft and Credit Suisse, our host is an expert in data analytics and technology.

On this channel, you'll find comprehensive tutorials and tips on how to use these tools effectively, as well as updates on the latest technology trends. Whether you're a beginner or an advanced user, you'll find valuable insights and techniques to enhance your skills and take your data analysis to the next level.

So, if you're looking to stay ahead of the curve in the world of data analytics and technology, be sure to subscribe to The Excelism and hit the notification bell to never miss a video!
Install Copilot for Windows 11
5:40
11 месяцев назад
Re-arrange Columns like a Pro!
4:52
Год назад
Комментарии
@BonaventureVaz
@BonaventureVaz 3 дня назад
Can you please complete this marginal relief formula =IF(R20>=700000,0,25000).. need to put a further argument to complete the formula for the salary income upto 7,27,000/-
@hnbviasuyiudcjzhcvusdbuh3638
@hnbviasuyiudcjzhcvusdbuh3638 6 дней назад
thank you very much
@7378saint
@7378saint 6 дней назад
Sir ,you made my day......thanks a lot...you are the best
@rajeevagarwal7130
@rajeevagarwal7130 8 дней назад
Excellent video on whole tube❤
@sanmathiraj8938
@sanmathiraj8938 11 дней назад
Epic!
@babu5376
@babu5376 24 дня назад
I was in search of this formula
@janaksingh6783
@janaksingh6783 Месяц назад
I don't know but in my case the formula is not working properly as per the new tax regime. It is ok when the amount is only 7lpa, but if you apply the same on more than 15lpa it is not working. Please correct me.
@BuzzingBlooom
@BuzzingBlooom Месяц назад
So boring sir. Too much time
@aslamanjum7802
@aslamanjum7802 Месяц назад
Sir New tax regime formula fy 24-25
@gopalgk4105
@gopalgk4105 Месяц назад
Excellant vdo, Thank you so much
@saravanawin
@saravanawin Месяц назад
Excellent Video explaining in a very simple yet effective way. Easy to follow and learn. This can be implemented for all repetitive reconciliations and save lot of time.
@user-su5do9tz8v
@user-su5do9tz8v Месяц назад
Excel witch version sir
@silksmily
@silksmily Месяц назад
Very well described.
@Tamarindgyal
@Tamarindgyal Месяц назад
It took me over two days to get this, I have never use these types of computations before. Your work is very patient and helpful, thank you very much for giving us all this 🙏
@ramrobertrahim8722
@ramrobertrahim8722 2 месяца назад
Thanks for your efforts sir. Very helpful. God bless you sir
@kinjalphatnani
@kinjalphatnani 2 месяца назад
=IF(C30<=700000,0,MAX(15000+(C30-600000)*10%,45000+(C30-900000)*15%,90000+(C30-1200000)*20%,150000+(C30-1500000)*30%))
@aslamanjum7802
@aslamanjum7802 Месяц назад
Pls tell me New tax regime formula for fy 24-25 new budget
@manisvs5550
@manisvs5550 2 месяца назад
Very useful function and explained clearly...thank you sir.
@saimraza56
@saimraza56 2 месяца назад
How to add a space between the text of two rows after concat?
@vandanadevi3206
@vandanadevi3206 2 месяца назад
Sir pls cover each and every audit in workshop.... And do some for MIS report
@aigriffin42604
@aigriffin42604 3 месяца назад
So what is the difference between Bing Chat and Copilot?❤
@akashkulkarni8593
@akashkulkarni8593 3 месяца назад
I want to access this course, but link is expired.
@inayatali910
@inayatali910 3 месяца назад
GOOD EVENING SIR ! My name is Inayat Waris Ali ,I am from Varanasi,UTTAR PRADESH . I have cleared my Intermediate exams recently .I loved your videos and gaining lots of knowledge in depth , i want to ask you sir do you have a firm in which i can apply to be an article . I am very much interested in doing articleship under you sir . Looking forward to see your reply .😊
@maheshmorey7034
@maheshmorey7034 3 месяца назад
Thank you Sir
@manishchoudhary365
@manishchoudhary365 3 месяца назад
this is very useful video sir...but i have diff. problem. taxpayer is selling and purchasing the same item to the same party and also making payment and receiving payment. Now how to adjust sale/purchae and payment made and received.
@anuragsawal1234
@anuragsawal1234 3 месяца назад
That's great
@lokeshbhasker627
@lokeshbhasker627 4 месяца назад
If margin relief is there sir what is the formula pls tell us
@2009vsa
@2009vsa 4 месяца назад
In your Old Tax Vs New Tax Calculation sheet - do we not to consider about the senior and super senior calculations Sir - CA Arun VS
@priyatirupur9060
@priyatirupur9060 4 месяца назад
Thank you so much sir
@venkateshk3461
@venkateshk3461 4 месяца назад
Thank you Sir. How Can I Get the Notes Sir ?
@surenderreddy7438
@surenderreddy7438 4 месяца назад
Hello sir, please share your contact details, i am planning to buy excel course, but not able to find website or contact details. Please help
@damudamodar7755
@damudamodar7755 4 месяца назад
Dear Sir, Thanks for conducting valuable session. I unable to get the excel from the drop box. only Img has downloaded.
@chanduhimalayas7386
@chanduhimalayas7386 4 месяца назад
Thank you so much sir 😊😊..your are Asset for our finance background. People....
@rohitvarshney8761
@rohitvarshney8761 4 месяца назад
Thanks a lot for all your practical knowledge.🙏
@rohitvarshney8761
@rohitvarshney8761 4 месяца назад
Thank a lot Mr Saran for this knowledge session.
@rohitvarshney8761
@rohitvarshney8761 4 месяца назад
Excellent Mr. Saran, i knew this feature but not from this perspective as you explained. 👏
@rohitvarshney8761
@rohitvarshney8761 4 месяца назад
May you please send me the link of Video where you have discussed the MS Excel to Google Sheet Connection.
@rohitvarshney8761
@rohitvarshney8761 4 месяца назад
Amazing Sir, You could easily charge money for this class. Thanks a lot for the knowledge you shared with us. 🙏
@farooqtahir538
@farooqtahir538 5 месяцев назад
Excellent
@dhanvarshaqualityexports5418
@dhanvarshaqualityexports5418 5 месяцев назад
1:34:00 to 1:49:30 Break
@raju1_official
@raju1_official 5 месяцев назад
Sir I was attende your Excel classes at uniqfin Business school. You are one of the best teachers. Would you please start a course on power BI.
@user-qk5nc9dh4i
@user-qk5nc9dh4i 5 месяцев назад
👍
@dhanvarshaqualityexports5418
@dhanvarshaqualityexports5418 5 месяцев назад
1:22:35 for SBI
@Prasadsirstockmarketdiscussion
@Prasadsirstockmarketdiscussion 5 месяцев назад
Sir , please take a class 🙏 on AI tool to be used in Excel
@TheExcelism
@TheExcelism 5 месяцев назад
Sure Next time on Thursday for Technology session.
@hemanthkumar-mm9hn
@hemanthkumar-mm9hn 5 месяцев назад
Excellent sir it's help me a lot for consolidation
@AgatheMontenegro
@AgatheMontenegro 5 месяцев назад
Thank you so much for this tips Saran! I've searched for this specific case for weeks, very useful and amazing explanation. Now, in case I have columns with number values instead of text, how could I ensure the original line volume to be divided by the figure indicated in my Quaterly Payment equivalent in my infant lines? Thank you!
@farooqtahir538
@farooqtahir538 5 месяцев назад
I have seen many videos on this problem this one is the best and easiest method
@seshumurthy5855
@seshumurthy5855 5 месяцев назад
Sir Not able to download files
@seshumurthy5855
@seshumurthy5855 5 месяцев назад
Sir Not able to download working files
@SatishKumar-ke7md
@SatishKumar-ke7md 5 месяцев назад
Video is not clear
@dpcomm
@dpcomm 6 месяцев назад
Thanks for simplifying the Index-Match formula. Cherry on top is FormulaText, I didn't knew that this formula exists. 😊