Тёмный
Smart Excel
Smart Excel
Smart Excel
Подписаться
Hi There!
Hi All, I love exploring MS Excel functions and formulas.
The objective of this channel is to help people by making their work on excel easy and efficient. I offer tutorials on MS Excel (Basic to Advance) 💻👍👨‍💻 Cheers!!
Комментарии
@charleneglory1279
@charleneglory1279 Месяц назад
English please
@keshavjha7676
@keshavjha7676 2 месяца назад
Nice one
@naeemmohammed-vg4nc
@naeemmohammed-vg4nc 2 месяца назад
Where?
@curvyfilms
@curvyfilms 3 месяца назад
Thank you So much!
@jhumaray-iz5fj
@jhumaray-iz5fj 3 месяца назад
Great ❤
@vidhya3400
@vidhya3400 4 месяца назад
Thank you so much
@avionserrao7943
@avionserrao7943 4 месяца назад
Only disadvantage of this formula is that we can't match it with names. But still it's a lot better then nothing.
@NaveenKumar-md9db
@NaveenKumar-md9db 5 месяцев назад
Very good
@muhammadkashaf9016
@muhammadkashaf9016 8 месяцев назад
Perfect formula. Thanks for sharing. 👍
@xavierinnocent55
@xavierinnocent55 10 месяцев назад
Superb...great...thank you so much
@AgapeoNtsinzi
@AgapeoNtsinzi 10 месяцев назад
which extension is that? thank you
@jasminedemian
@jasminedemian 11 месяцев назад
How do I find the excel tailor- I can’t seem to find it in the add ins list
@SmartExcel
@SmartExcel 11 месяцев назад
Hi Jasmine, you need to download it from the description link.
@alexking8222
@alexking8222 11 месяцев назад
Thank you so much!
@damiendeery4196
@damiendeery4196 Год назад
That is 100 thousand, not 1 million
@jasmeetbagga2550
@jasmeetbagga2550 Год назад
In to value : why have ýou written 70??? Please tell..tomorrow is my computer practical exam...
@SmartExcel
@SmartExcel Год назад
Because I want to change my current Average i.e 67.5 to 70(Average I want ), so how much I need to score in the 5th subject. Hope that clarifies!! All the best for your exam. Thanks
@jasmeetbagga2550
@jasmeetbagga2550 Год назад
To value :mein 70 kaise aaya??
@vencedor534
@vencedor534 7 месяцев назад
Ye isliye aaya kyunki Hume total 70 percentage chahiye thi. Jitne bhi mrks chahiye usse To value mai likhe hai.
@abdulalialokozay1538
@abdulalialokozay1538 Год назад
what is excel tailor full version please answer is this an addins
@SmartExcel
@SmartExcel Год назад
Hi!! Yes this is an addin. You can download the demo version for 60 days, if you want to check this out. Link is shorturl.at/ijsQW. Thanks
@Jjtxfc3
@Jjtxfc3 Год назад
But the order of the inserted file names are not the same as in the folder
@SmartExcel
@SmartExcel Год назад
Hi! Currently, the function renames files from similar folder, but there is a way we can use this function to rename files in multiple folders as well!! Will post a video soon on that. Thanks!!
@Jjtxfc3
@Jjtxfc3 Год назад
crazy u saved my life bro
@SmartExcel
@SmartExcel Год назад
Hi Ashfaq!, Thanks for your question. you have to Download the demo version of excel Add-in from the below location. Once you download and install it you will have access to all these functions. Let me know if you have any queries. shorturl.at/ijsQW
@ashfaq2033
@ashfaq2033 Год назад
Bhai get location option kis tab ma hy. Mujy toh 1 ghnaty say ye bhi ni mil rha 😢
@nigilv.d4237
@nigilv.d4237 Год назад
Great technique thanks
@eagleofthenorthmacroexcell6843
What office version you are using, couldn't find the text extract function in my computer?
@SmartExcel
@SmartExcel Год назад
Hi!! These formulas are available with the excel tailor addin. Please check the description for the download link. Thanks!!
@waqaspsychology1377
@waqaspsychology1377 Год назад
اسلام علیکم سر، سر ہم نے اگر کوئی ویلیو کو غلط پٹ کیا ہو، جیسے 0،1،2،3 لیکن بعد میں اسکو تبدیل کرنا ہو کہ 0 کی جگہ 1 ہوجائے، 1 کی جگہ 2 ہوجائے، 2 کی جگہ 3 اور 3 کی جگہ 4 ہوجائے تو یہ ہم کیسے کرینگے؟ اس کے لئے کوئی فارمولا ہے؟
@SmartExcel
@SmartExcel Год назад
آپ استعمال کر سکتے ہیں =Substitute ایکسل میں
@AmitParmar9
@AmitParmar9 Год назад
Sir what is prizes is add in?
@SmartExcel
@SmartExcel Год назад
Hi Amit, You can send an email to tailorofexcel@gmail.com along with your excel version for any queries / doubts or problems. Thanks!
@aiyazlakhani
@aiyazlakhani Год назад
Nice 👍
@user-br6ku7km8t
@user-br6ku7km8t Год назад
Hi If we have multiple debits and credits , debits counts may have more than the credits , what kind of farmula we need to use it
@SmartExcel
@SmartExcel Год назад
Hi, this formula identifies multiple pairs of debits and credits in first in first out method.
@rkcomputerclasses366
@rkcomputerclasses366 Год назад
Kindly make a short video on this and please reply me i will be thankful to you for this kindness Your business has a profit of Rs 26,000. You have set a new profit goal of Rs. 60,000. Currently you are selling 1400 items at Rs 25 each. If you still sell the same number of items, calculate by how much you should raise your price to achieve your target. Find the solution using Goat Seek.
@SmartExcel
@SmartExcel Год назад
I have created your solution, Check this out. You need to enter Cost of per item and in Profit you have to apply a formula i.e(SP*Qty)-(CP*Qty) i.e 25K. The amount you will get is 49.25(approx) drive.google.com/file/d/1l0NXQ3RWFTCh7m6WCPNRhcT9bwy9b2VW/view?usp=sharing
@georgemubanga1878
@georgemubanga1878 Год назад
Thanks 👍
@soumyajyotisarkar
@soumyajyotisarkar Год назад
Thank you so much
@dharmendarray1369
@dharmendarray1369 Год назад
Thanks..
@jwdkayani
@jwdkayani Год назад
Perfect Example 👍
@B3lpyj
@B3lpyj Год назад
thanks
@saileeparab70
@saileeparab70 Год назад
Very well explained. Keep up the good work.
@mehakkhakra9812
@mehakkhakra9812 Год назад
Thanku so much sir. It really helped me in my computer practical exam
@hanumantmisal
@hanumantmisal Год назад
Thank you Sir.... I learned very important formula.
@SammyRoy28
@SammyRoy28 Год назад
Hi, If i want to be knocked off the line items on the basis of currency value within each business area for ex.. debit 1000 & credit -1000 ... Then how to do that and which formula should I use?
@SmartExcel
@SmartExcel Год назад
Watch this video for the formula in detail: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sV5wJt8o-wg.html
@rohansalgotra1118
@rohansalgotra1118 Год назад
Thanks 👍
@Charles-eu1br
@Charles-eu1br 2 года назад
👌 p̶r̶o̶m̶o̶s̶m̶
@saileeparab70
@saileeparab70 2 года назад
Very nicely explained. It worked for me. You saved lot of time of mine. Keep it up. 👍
@saikatsaha2048
@saikatsaha2048 2 года назад
thnx a lot buddy
@07punit
@07punit 2 года назад
Thanks for the video... Can u also help matching with minimum diff? for eg. 100.32 and -100
@SmartExcel
@SmartExcel 2 года назад
It works only on similar debits and credits. However, you can round off all your numbers to 0 places of decimals and then apply this formula to make this work.
@kirankaranam7495
@kirankaranam7495 2 года назад
Thanks for your vedio...
@AmitParmar9
@AmitParmar9 2 года назад
This add in all time free or partly ? If no free how much cost?
@SmartExcel
@SmartExcel 2 года назад
This is free as of now. No cost added. We will be uploading the 2.0 version soon
@dangerdart111
@dangerdart111 3 года назад
Very good solution
@compliancesandupdates8909
@compliancesandupdates8909 3 года назад
hello sir, In addition to above, there is any formula which setoff the also setoff the non equal no. Example suppose in your video u 102 setoff with -102 but if in line I want to setoff 102 with -95, -5 & -2 is there is any formula.
@SmartExcel
@SmartExcel 2 года назад
To do that, we need a helper column and then it can be done either through a pivot or using sum if formula. Thnx
@compliancesandupdates8909
@compliancesandupdates8909 2 года назад
@@SmartExcel thanks for reply, if possible can u please make the video small video on this.
@devanjalibasou6331
@devanjalibasou6331 3 года назад
Sir this is AMAZING. Bohottt dhundne ke baad apka video mila....har jagah VBA complications hai...this was simple and VERY EFFECTIVE
@umarilyas8583
@umarilyas8583 3 года назад
Can linked picture be controlled by different sheet data?
@SmartExcel
@SmartExcel 3 года назад
Yes, you can link data of a sheet as picture in a separate sheet.
@27_Junaid
@27_Junaid 3 года назад
Thank you so so much, so usefull. Made my life very easier.