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 www.youtube.com/learnwithpurpose
Download Template Sales Purchaes in Excel 2020