How to create stock maintain sheet in MS Excel
What you'll learn in this video
- First of all select 13 columns and 25 rows and then from font menu select all boarder
- Select first row and merge it with merge and center menu given in alignment menu. Write your company name in it and adjust its font size
- Merge rows and columns with the help of merge and center menu as shown in video and, write column’s title and adjust its size according to your requirements
- Enter details as shown in video
- Calculate the sold amount as shown in video
- Similarly, calculate the closing stock amount as shown in video
- At last, calculate profit and loss by using formula in video
Compellingly administrate functional information alue added services onotonectally repurpose interdependent technology whereas best-of-breed architectures.
Md Sumon Mia