In this tutorial you will learn excel very important concepts relating sales , purchases and customers, suppliers "Vendors " management with excel formulas in a practical way .
After completing this , you will be able to apply excel more quickly and can perform jobs in a very short time.
Following are the main topics covered in this tutorial :
1. Basic Concept of Sales, Purchase, Customers , Suppliers ,Balancing,
2. Vlookup formula in excel,
3. Sumif Formula in Excel,
4. Data Validation in excel , dropdown list ,
5. if formula in excel ,
6. sum formula in excel ,
7. Absolute reference and relative reference in excel , a Practical Example to clear the concepts and many more .
Complete Template can be downloaded from the given link but Plz Don't forget to Write a positive comment and subscribe our channel to support us for future videos like this..
Template and complete working file can be downloaded from :
Regards :
0 Comments