Creating a Loan Calculator-2

Basic Microsoft Excel Course Creating a Loan Calculator
8 minutes
Share the link to this page
You need to have access to the item to view this lesson.
One-time Fee
List Price:  $139.99
You save:  $40
List Price:  €128.79
You save:  €36.80
List Price:  £110.19
You save:  £31.48
List Price:  CA$190.57
You save:  CA$54.45
List Price:  A$209.11
You save:  A$59.75
List Price:  S$188.40
You save:  S$53.83
List Price:  HK$1,091.62
You save:  HK$311.91
CHF 90.88
List Price:  CHF 127.24
You save:  CHF 36.35
NOK kr1,067.14
List Price:  NOK kr1,494.05
You save:  NOK kr426.90
DKK kr686.38
List Price:  DKK kr960.96
You save:  DKK kr274.58
List Price:  NZ$228.66
You save:  NZ$65.33
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  ৳16,338.55
You save:  ৳4,668.49
List Price:  ₹11,658
You save:  ₹3,331.09
List Price:  RM655.85
You save:  RM187.40
List Price:  ₦210,474.96
You save:  ₦60,140
List Price:  ₨38,865.72
You save:  ₨11,105.28
List Price:  ฿5,043.69
You save:  ฿1,441.16
List Price:  ₺4,508.30
You save:  ₺1,288.17
List Price:  B$714.43
You save:  B$204.14
List Price:  R2,546.38
You save:  R727.58
List Price:  Лв251.52
You save:  Лв71.86
List Price:  ₩190,204.11
You save:  ₩54,347.91
List Price:  ₪517.99
You save:  ₪148
List Price:  ₱8,104.60
You save:  ₱2,315.76
List Price:  ¥21,798.54
You save:  ¥6,228.60
List Price:  MX$2,323.18
You save:  MX$663.81
List Price:  QR508.83
You save:  QR145.39
List Price:  P1,890.63
You save:  P540.21
List Price:  KSh18,338.69
You save:  KSh5,240
List Price:  E£6,552.93
You save:  E£1,872.39
List Price:  ብር8,014.55
You save:  ብር2,290.03
List Price:  Kz118,777.64
You save:  Kz33,938.89
List Price:  CLP$124,991.07
You save:  CLP$35,714.28
List Price:  CN¥993.35
You save:  CN¥283.83
List Price:  RD$8,173.51
You save:  RD$2,335.45
List Price:  DA18,828.31
You save:  DA5,379.90
List Price:  FJ$311.92
You save:  FJ$89.12
List Price:  Q1,084
You save:  Q309.73
List Price:  GY$29,190.54
You save:  GY$8,340.75
ISK kr13,827.61
List Price:  ISK kr19,359.21
You save:  ISK kr5,531.60
List Price:  DH1,389.16
You save:  DH396.93
List Price:  L2,472.24
You save:  L706.40
List Price:  ден7,927.38
You save:  ден2,265.13
List Price:  MOP$1,121.33
You save:  MOP$320.40
List Price:  N$2,552.76
You save:  N$729.41
List Price:  C$5,136.75
You save:  C$1,467.74
List Price:  रु18,602.11
You save:  रु5,315.27
List Price:  S/521.05
You save:  S/148.88
List Price:  K541.86
You save:  K154.83
List Price:  SAR525.01
You save:  SAR150.01
List Price:  ZK3,561.44
You save:  ZK1,017.62
List Price:  L640.73
You save:  L183.08
List Price:  Kč3,182.25
You save:  Kč909.28
List Price:  Ft49,718.89
You save:  Ft14,206.41
SEK kr1,068.43
List Price:  SEK kr1,495.85
You save:  SEK kr427.41
List Price:  ARS$124,135.76
You save:  ARS$35,469.89
List Price:  Bs964.05
You save:  Bs275.46
List Price:  COP$534,257.88
You save:  COP$152,656.01
List Price:  ₡71,411.70
You save:  ₡20,404.80
List Price:  L3,454.78
You save:  L987.15
List Price:  ₲1,045,465.66
You save:  ₲298,725.81
List Price:  $U5,431.06
You save:  $U1,551.84
List Price:  zł548.49
You save:  zł156.72
Already have an account? Log In


Objective. By the end of this activity, you should be able to explain how to insert rows. Remove gridlines insert pictures, enter and Format Data, use shapes, insert symbols, use formulas, create charts. Let's now learn inserting rows. To do so select the row, then click on Insert. Then click on Insert sheet rows.

Notice the change now you can format the rows as required. Let's now learn removing grid lines. To do so, click the View tab. Click on grid lines. Let's now learn inserting pictures. To do so click the Insert tab.

Then click on pictures. The insert picture window is displayed on your screen, browse the folder, then click on suitable picture and then click on thing so just selected picture has been inserted Now drag to position the image suitably. Now click the cell Now drag it to suitable position. Similarly, you can insert other images. Let's now learn entering other data. You can repeat the same process for entering data as we did earlier.

Then click on shapes and then select a suitable shape Now track two brothers. Let's now learn enhancing sheep. To do so click on Save. Then click on more colors. The colors window is displayed on your screen, select suitable color and then click on OK. Now click on shape outline and then click on no outline. Nope is the change.

Similarly, you can insert other shapes. Now we will learn inserting symbols. To do so click on cell then click on number format. The format cells window is displayed on your screen. Click on currency then click on decimal places. Next, click on symbol drop down Scroll to view the appropriate symbol and then select English United States and then click on OK. Notice the change.

We will now learn to use formula for the same, select the cell. Then enter the formula in the formula bar and then select the interest rate. You will need to convert the annual rate to a monthly rate by dividing the value in cell 21 by 12. So type by 12 and select lone tenure cell. After selecting the cell, insert a comma. Now at last select the cell containing loan amount And then press Enter key on the keyboard.

Now let's type new formula in the cell E 24. You can see a formula suggestion list as you start typing. Select c u m IP empty from the formula suggestion list. Click into cell containing interest rate. as we did earlier, we need to convert the annual rate to a monthly rate. So, type pipeline and then select the cell containing loan tenure.

Then type multiplied by 12 and select cell having the loan amount value like one and then select the cell containing loan tenure. Type the remaining formula and press ENTER key on the keyboard Now let's insert the total payment. To do so, click AutoSum from editing group and click sum. Select the required cells. Then press ENTER key on the keyboard. You can see the total payment amount has been calculated as desired.

Scroll down to see the other cell containing formula. Notice the change let's now learn inserting pie chart. To do so, click the cell then press ctrl key and then select the cell. Repeat the same process. Now you can insert tab click on Insert file and then select suitable file. Now skim the pie chart as per the requirement and then drag to position the pie chart suitably.

Now we will learn to change the pie chart style. To do so, click Add chart element. Then click on legend. Then click on suitable option. Notice the change let's now learn formatting a pie chart. To do so, click the shape fill.

Then click on more colors. The colors window is displayed on your screen. Select suitable color, then click on OK. Now click the text then click on text and then click on suitable color. The required name. Now press Escape key on the keyboard. Click on Home tab.

Then click on bold. enhance the other text as per requirement. Then click on Design tab. Then click Add chart element. Click the data labels. Then select center.

Click the Format tab, click on shape and then select double color. Now you can track the shape as required. Somebody who have completed the activity. You are now able to insert rows. Remove grid lines, insert pictures, enter and Format Data. Use shapes, insert symbols, use formulas, create charts.

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.