Kure naalaayi oru malayalam excel tips kittiyirunnengil ennu vichaarikkunnu. Thanks

@rows_columns

4 жыл бұрын

Hope this video will help you🙂 - kzread.info/dash/bejne/Z6WOo6uslLCsmqw.html

@LIFE-wb8sl

Ай бұрын

😊​@@rows_columns

Good job dear, opening stock, purchase return, sales return എന്നിവ കൂടി ഉൾപ്പെടുത്തിയാൽ കൂടുതൽ നന്നായിരിക്കും.

@SJ-uq9nv

2 жыл бұрын

That's good

Excellent topic. Very useful

Very helpful presentation 👍👍

ഈ ചാനൽ സബ്സ്ക്രൈബ് ചെയ്തവർക്ക് എൻ്റെ വാക്കുകൾ ഉപകാരപെടുകയാണെങ്കിൽ വായിക്കുക, വിദ്യാർത്ഥികൾക്കും പ്രൊഫഷനുകൾക്കും പെട്ടെന്ന് മനസിലാകുന്ന തരത്തിൽ വളരെ ലളിതകരമായ രീതിയിലാണ് അൽഫാൻ ഓരോ കാര്യങ്ങളും അവതരിപ്പിചിരിക്കുന്നത്. ഓരോ ഫങ്ക്ഷൻസും ഫോർമുലകളും എങ്ങനെയാണ് ഉപയോഗിക്കേണ്ടത് അത് പോലെ അതിൻറെ റിസൾട്ട് എങ്ങനെയാണ് ലഭിക്കുന്നത് എന്നൊക്കെ വളരെ ക്ലാരിറ്റിയോടു കൂടിയാണ് പറഞ്ഞു തരുന്നത്.എന്തായാലും എക്സെലിന്റെ ഉപയോഗം ഉള്ളവർ ഈ വീഡിയോസ് ഒക്കെ ഒരു പ്രാവശ്യം കാണുന്നത് നന്നായിരിക്കും.

Thank you very much for uploading such a great tutorials, can you pls explain how to change the cell colour (red) automatically when the stock alert cells turn to "OUT OF STOCK"

@rows_columns

4 жыл бұрын

Thanks for watching video🙂 Regarding your query ; I have applied conditional formatting over there, same I have explained in detailed under below video (link provided) kzread.info/dash/bejne/rIWlqJineKWdodY.html

@craftcorner1290

4 жыл бұрын

@@rows_columns Thanks mate

@prabhankrishnan5609

3 жыл бұрын

Can you share your Mobile number please to discus something about my business, need your help. or whatsApp me on 8078332475

കണ്ടതിൽ വെച്ച് വളരെ നല്ല വീഡിയോ നല്ല അവതരണം എളുപ്പത്തിൽ ചെയ്യാൻ താങ്കളുടെ വീഡിയോ മൂലം സാധിച്ചു അഭിനന്ദനങ്ങൾ

@rows_columns

Жыл бұрын

Thank you, I am happy to hear you feel that way!

Simply described... thanks for your mail with templates

@rows_columns

4 жыл бұрын

😇

Ithil vat , price , including cheyithu kanichu tharamo grocery stock 👍👍👍nalla avatharanam

Very intersting subject. If you are incorporate opening balance of qty in Inventory system, it will be more beautiful. Your all video is are informative. Thank you so much.

@rows_columns

4 жыл бұрын

Sure I will👍😊

@SaleemSaleem-sm6wq

Жыл бұрын

New prodact the salaction new do

Thanks a lot... its very helpful

Super bro.. Ningalude presentaion super.. Mansilakkunnund.. Nallavannamm👍

@saheersahi670

2 жыл бұрын

Hi

If you covert table to an excel table, the table will become dynamic and then we will not have to copy formula

@rows_columns

2 жыл бұрын

👍

Hi Alfan , in this case products are up to “G “ , how to add a new item in the formula after couple of transactions

@rows_columns

4 жыл бұрын

You can add up the line items for respective new products and after that same included it under 'drop down list'.. Once its done you can drag down the formula under Colum 'K' (Stock)

@sabithzzz1234

3 жыл бұрын

@@rows_columns can we make it table for automatic updation?

Very Good Presentation..thanks

Thank you somuch for your video’s broii..It’s Really helpful 🙏🏻🙏🏻

@rows_columns

2 жыл бұрын

Thanks Adish bro😊

how to add a new product in this system..?

@rows_columns

4 жыл бұрын

U can add manually and same included it under drop down list by editing the range😊

Hai sir, നിങ്ങളുടെ വീഡിയോ എന്നെ പോലെയുള്ള ഒരുപാട് ആളുകൾക് നല്ലപോലെ എക്സലിനെ മനസ്സിലാക്കി പഠിക്കാൻ പറ്റുന്നുണ്ട്, ഇങ്ങനെ ഒരു വീഡിയോ ചെയ്‌തതിനു ഒരുപാട് നന്ദി... 👌👏👍 Thank you

@rows_columns

Жыл бұрын

Thank you, I am happy to hear you feel that way!

Did well. Thank you very much

@rows_columns

3 жыл бұрын

Tnx Brother :)

Excellent presentation 👏👏👌👌.... Very useful

@rows_columns

Жыл бұрын

Thank you, I am happy to hear you feel that way!

Very useful goahead bro

Hi Bro, The video is very helpful one, can you please tell me that if i have more than 30 products and the customer buying one - one product each from the all. I have tried your same method but it is getting a long sheet and also not easy to manage also. please advise

Really great and good explanations so helpful for Xl fraternity good way of helping all let you grow day by day

@rows_columns

Жыл бұрын

Thank a ton😊

Useful video aayirunnu tnqq bhai

@rows_columns

2 жыл бұрын

Most welcome brother😊

It's super Tips bro ....thank you very much ....

@rows_columns

2 жыл бұрын

Welcome bro👍😊

Good presentation.. Thanks dear

@rows_columns

4 жыл бұрын

😊

Your classes helping me a lot in my work...

@rows_columns

3 жыл бұрын

Glad to know that😇

@santhoshcherukat4180

Жыл бұрын

Really worth with good and simple explanations

very useful video really appreciate your effort....

@rows_columns

Жыл бұрын

Thank you, I am happy to hear you feel that way!

നല്ല അവതരണം👍💐

@rows_columns

4 жыл бұрын

Tnx Brother😊

Hi Alfan,Is there any possibility to count the total number of qty for an year for a particular part number and also any ways to count all the parts starting with FP----- & sp-----.Balance code after fp varies , but i need to count all the parts if it starts with FP.Please reply

Very good but set cheitha era finish ayal coloms add cheyyan enth cheyyum

How to retrieve whole (before openig) file protection Password in Exl, if forgot P/word?

Hi, how we can add to purchase list, if I purchase a product not in the stock list??? Please help... I mean, can we automatically update the stock item data by adding items to purchase list???

Good simple videos Alfan👍👍

@rows_columns

4 жыл бұрын

🙏😊

Very helpful KZread channel 👍

@rows_columns

3 жыл бұрын

😊

The most informative video

@rows_columns

3 жыл бұрын

:)

ഞാൻ accountant ആയി work ചെയ്യുന്ന വ്യക്തിയാണ് ... നിലവിൽ ഞാൻ ഒരുപാട് excel work-കൾ ചെയ്യാറുണ്ട്..താങ്കളുടെ ഓരോ വീഡിയോസും വളരെയേറെ ഉപകാരപ്രദമാവുന്നുണ്ട്....

@rows_columns

3 жыл бұрын

Tnx a ton Brother :)

Your classes so good and easy to understand

@rows_columns

3 жыл бұрын

😇

@nihalamunaver6224

3 жыл бұрын

@@rows_columns 😎

E format aneshichu nadakuvayirunu appozhanu sirnte topic kandathu Thank you

@rows_columns

4 жыл бұрын

Tnx Bro😊

Really owsome.Ithu pole payroll records maintain cheyyan engane anenu kaniko.njan cheythu nokkuvanu.

@rows_columns

4 жыл бұрын

Sure👍😊 will upload it soon..

Excellent n great go ahead

@rows_columns

3 жыл бұрын

♥️

Items list poyittallaathe namuk ha coloums il txt cheith add cheyyaaan pato?? Eg : 1000 items undenkhil list il poitt item select cheyyal budhimutt alle?

Very useful class 💯

@rows_columns

2 жыл бұрын

Glad you think so!

Thanks Sir

Stock alertil 3 ennam kodukkan kazhiyille if 0= out of stock, less than 10 low stock, higher than 10 in stock paranju tharamo

This excel video helpful for Trading firm only, please upload a video for manufacturing firm

@rows_columns

2 жыл бұрын

Sure Bejoy😊 Thanks for your suggestion

Thank you sir....

@rows_columns

Жыл бұрын

❤️🙏

Super. Very useful

@rows_columns

4 жыл бұрын

😊

Superb

Thanks ebdurahma

Work sheet complete kazhinjal veendum add cheyyan enth cheyyanam

Nice presentation 🤝👌👌👌

@rows_columns

4 жыл бұрын

Thank you! Cheers!🙌

Good

Alfan Rishaf here,vidoes are good keep going. Do one more video wfor the same (sms) with opening stock plus qty &price and if there is huge product list like 2000 items how we tackle with drop down list etc.

@rows_columns

4 жыл бұрын

Sure... I will be uploading the separate video for the firm who keep large no of stocks by giving option like searchable drop drown list or Searchable box via VBA. Anyways tnx for your feedback😊

Thank you sir it was very useful...I will try to do it in excel..

@rows_columns

4 жыл бұрын

😊👍

Thank you...❤️

@rows_columns

2 жыл бұрын

🥰

Very useful videos. 😍😍😍

@rows_columns

3 жыл бұрын

Thanks a lot 😊

*Thank you very much*

@rows_columns

4 жыл бұрын

☺️

purchase report,sales report ഒക്കെ വേറെ വേറെ ഷീറ്റിൽ കാണാൻ ഉള്ള വീഡിയോ ചെയ്യുമോ?. like monthly report,year report please submit

Hii.. Just now got a call from Alfan by sharing my number in the comment box. What a quick response. Really hats off you dear. Really looking forward to solve all the accounts related issues with help of this gentleman. Thank you.

@rows_columns

4 жыл бұрын

😊🤝

Hope u r fine by the grace the almighty, if i want add 2 more products in the sheet how can it,

Stock valu koodi ulpeduthi oru columns undengil useful aayirunnu

@rows_columns

4 жыл бұрын

Pls refer this😊: kzread.info/dash/bejne/rIWlqJineKWdodY.html

kidu thanks alot

@rows_columns

2 жыл бұрын

Thanks for your feedback and I'm glad it helped 😊 You can download file used in the video : www.rowscolumns.com/free-excel-templates

Super Bro Very Good

@rows_columns

3 жыл бұрын

Thank you so much

you are amazing

@rows_columns

2 жыл бұрын

😊

Hy bro, Need spare parts stock inventory with price, how to add price list in this table.

@rows_columns

4 жыл бұрын

Sure Bro... Will figure out :)

how can we change out and in stock font colour

can do a video about how to create a form & highlights

@rows_columns

4 жыл бұрын

Sure Bro👍😊

താങ്കളുടെ വീഡിയോ വളരെ നല്ല നിലവാരം പുലർത്തുന്നു വളരെ പെട്ടെന്ന് മനസ്സിലാകുന്നുണ്ട് നന്ദി ഒരു സംശയം ഉണ്ടായിരുന്നു ഗൂഗിൾ ഡ്രൈവിൽ വർക്ക് ചെയ്യുന്നത് ഗൂഗിൾ ഷീറ്റിൽ ചെയ്യാൻ പറ്റുമോ.

Good dear

@rows_columns

2 жыл бұрын

Thanks dear😊

If opening stock is there then what is the procedure to be followed

Highly informative and useful, Thanks

@rows_columns

2 жыл бұрын

😊

thanks

@rows_columns

2 жыл бұрын

Thanks for your feedback and I'm glad it helped 😊 You can download file used in the video : www.rowscolumns.com/free-excel-templates

Njan ee formula apply cheythu 1 year ayi perfect ayirunnu,ippo complete cellil apply akunilla, chila cell purchase ans sale count akunilla . same formula copy cheythu koduthittum chila cellilil perfect akunilla.onnu reply edamo

superb bro

@rows_columns

2 жыл бұрын

Tnx Man😊

Thanks sir .. thanks for send file❤️❤️❤️

@rows_columns

4 жыл бұрын

🤝😊

@jamsheedjameha2066

3 жыл бұрын

Brother can share the file

@shemeemmr9211

2 жыл бұрын

eniykkum koodi share cheyyamo

Product name & size difference ulla 2 columns engane anu set cheyendathu

Daily stock maintain ചെയ്യുന്നതിനുള്ള idea ഉണ്ടോ

Hi Bro How can I implement above inventory management in Rental business, pls advise

@rows_columns

4 жыл бұрын

We can bro.. but using different function along with existing formulas which i shows here... will plan & upload it👍😊

@3sisters890

4 жыл бұрын

Skills to Succeed by AlFan many thanks Bro, await for same

Personal or office Income and expenses sheet ഇതുപോലെ സിമ്പിളായി ഒരു വീഡിയോ ചെയ്തുകൂടെ

how to create VBA code automatically transfer data other sheet inside excel table? please can you help

@rows_columns

3 жыл бұрын

Will show it in separate video.. Thanks for your suggestion :)

Ithil macro apply chyth kanikamo

Very usefull ❤️

@rows_columns

2 жыл бұрын

Thank you😊

@rows_columns

2 жыл бұрын

😊

God job bro

@rows_columns

4 жыл бұрын

Tnx Bro😊

Product nte different category engane list cheyyum

Restaurant inventory engane maintain cheyyam

Ithil oru puthiya item list cheyyanamegil formula full mattano

Second product purchase cheyyumbol net stockil varunnillallo..any mistake

My laptop keyboard F4 key is not working for this formula what to do ? Pls suggest a solution

@rows_columns

11 ай бұрын

Press Fn + F4😊

opening stock indel sum if function vach closing stock find cheyyan pato?

@rows_columns

2 жыл бұрын

Yes👍

How can add colour in condition. Eg red for out of stock

@rows_columns

3 жыл бұрын

Through conditional formatting - will show it in separate vid..

Color changing for IN STOCK and OUT stock

@rows_columns

4 жыл бұрын

You can apply conditional formatting and the same has been explained in below video link🙂 kzread.info/dash/bejne/rIWlqJineKWdodY.html

@shafeenaansar

4 жыл бұрын

@@rows_columns 👍👏👏

ബ്രോ medicine ഇപ്പോൾ ഉള്ള സ്റ്റോക്ക് il നിന്നും indent വരുമ്പോൾ balance stock കൂടുന്നു, expiry or sell വരുമ്പോൾ കുറയുന്നു അങ്ങനെ ഒരു balance amount കിട്ടും... പക്ഷെ enikku opd sheetil balance കാണിക്കണം. Opd used akunnathu main stockil kurayanam... Next വീണ്ടും same medicines opd used akumbol opening stock nerathe kuranjathil ninnum varanam.

How can we do, if we purchase and sale more than 1 product in one day

@rows_columns

4 жыл бұрын

First of all thanks for watching video😊 Yes, we can pass the entry by putting same transactions (Sales & Purchase) date in different cells (Row wise) by selecting respective products.. It works👍

Sir.... F4 അടിക്കുമ്പോൾ close ആകുന്നില്ലല്ലോ

Sir ഈ ഷീറ്റ് എങ്ങെനെ create ചെയാം എന്ന് കൂടി പറയാമോ.please this same function

Supper

@rows_columns

4 жыл бұрын

Thank you :)

How to put XL in Googlemap

ഇതിൽ sales and purchase ൽ price add ചെയ്തു കാണിക്കുമോ. For example, product A 20pcs *100RS =2000

@rows_columns

4 жыл бұрын

Am planning to upload (near future) similar system by including sales, Purchase, Invoice, LPO, day book.. (kind of small accounting solution). Thanks for the suggestion😊

Ithil abcd order il purchase cheithal matrame net stoçk report lek varunnullu ath enda

@rows_columns

3 жыл бұрын

Didn't get your question bro!