How to Smartly Manage Sales Purchase Customer Supplier in Excel Step by Step Urdu Hindi Tutorial

#ExcelSalesPurchase #ExcelCustomerSupplier #ExcelFormulas

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 .

Learn more at

Download TemplateĀ Sales Purchaes in Excel 2020