Explanation and Steps to create Commission sheet in MS Excel
What you'll learn in this video
- First of all select 8 columns and 20 rows then go font menu and select all borders
- 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
- Write column’s title such as
- Fill details according to given explanation in video
- Obtain commission by using commission formula as shown in video
- Obtain commission in amount by using its formula as shown in video
- Enter basic salary of salesman
- Calculate his net salary by using its formula as shown in video
Salesman ID
Salesman Name
Area
Commission
Commission in Amount
Basic Salary
Net Salary
Compellingly administrate functional information alue added services onotonectally repurpose interdependent technology whereas best-of-breed architectures.
Md Sumon Mia