EXCELPART4

MS Excel Lecture Part 4

Loan Calculation Example

Loan Amount = 100,000
Interest Rate = 10%

Step 1: Interest = 100,000 × 10%
Step 2: 100,000 × 0.10 = 10,000
Step 3: Total Repayment = 100,000 + 10,000 = 110,000

Excel Formula:
=A1*A2
=A1+A3

Goal Seek Example

If you want profit of 50,000:
Step 1: Click Data → What-if Analysis → Goal Seek
Step 2: Set cell (Profit Cell)
Step 3: To value = 50000
Step 4: Change Sales Cell

Excel adjusts automatically.

Pivot Table Example

Sales Data:
John – 2000
Mary – 3000
John – 1500

Pivot Result:
John = 3500
Mary = 3000