This channel is designed to share video tutorials on MS Excel and other office software which are very useful in making our office work smart. We will post most videos on Microsoft Excel templates, formulas and functions and I will also upload tutorials on other software like MS Word, MS Access, MS Power point and any other productivity software. Learning these will be very helpful on improving quality of our work life. Stay connected and enjoy learning.
Brilliant explanation and, I think, it would be great if you could share the excel file for downloading and easier practice by your subscribers. Thanks a lot!!
feel sad that this is not advance search condition, i need to have search something like input "(Raj AND indian) OR (PK AND INDian)", this simple criteria. U this is simple search, not advance search LOL
Thanks a lot. Suppose we have to find max value among Jan to December and how to get name of that month and item using a formula. Hope you can suggest a solution.
Great tutorial. I enjoyed the sequential approach. It was very helpful. Please how do you handle a situation where you placed an other for two different products, say Products A and B, but had only product A delivered. If you replace the 'T' with 'R' for Product A, how do you deal with product B which you are yet to receive? Thanks.
It assumes that the transit quantity in one column is delivered together. If not, we have to keep undelivered product in another column and mark it as transit
Hello. Thank you very much for your video, excellent. Can I ask you a question, please? I would like to know what type of value I must to consider in the sale (accounts receivable) : net sale (without VAT) or with VAT? I understand that the sales values, cost, expenses, must always be recorded without VAT. Thank you so much!