Creating a Loan Calculator-3

Basic Microsoft Excel Course Creating a Loan Calculator
3 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€95.55
List Price:  €133.77
You save:  €38.22
£79.30
List Price:  £111.02
You save:  £31.72
CA$141.90
List Price:  CA$198.66
You save:  CA$56.76
A$157.20
List Price:  A$220.09
You save:  A$62.88
S$134.19
List Price:  S$187.87
You save:  S$53.68
HK$777.47
List Price:  HK$1,088.50
You save:  HK$311.02
CHF 90.03
List Price:  CHF 126.04
You save:  CHF 36.01
NOK kr1,113.09
List Price:  NOK kr1,558.38
You save:  NOK kr445.28
DKK kr712.70
List Price:  DKK kr997.81
You save:  DKK kr285.11
NZ$175.11
List Price:  NZ$245.17
You save:  NZ$70.05
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.91
৳12,166.46
List Price:  ৳17,033.53
You save:  ৳4,867.07
₹8,691.60
List Price:  ₹12,168.59
You save:  ₹3,476.99
RM444.50
List Price:  RM622.32
You save:  RM177.82
₦150,999.89
List Price:  ₦211,405.89
You save:  ₦60,406
₨27,959.15
List Price:  ₨39,143.93
You save:  ₨11,184.78
฿3,368.76
List Price:  ฿4,716.40
You save:  ฿1,347.64
₺3,627.05
List Price:  ₺5,078.02
You save:  ₺1,450.96
B$572.50
List Price:  B$801.52
You save:  B$229.02
R1,838.04
List Price:  R2,573.33
You save:  R735.29
Лв186.91
List Price:  Лв261.69
You save:  Лв74.77
₩144,050.71
List Price:  ₩201,676.76
You save:  ₩57,626.04
₪356.60
List Price:  ₪499.25
You save:  ₪142.65
₱5,816.56
List Price:  ₱8,143.42
You save:  ₱2,326.86
¥15,183.26
List Price:  ¥21,257.18
You save:  ¥6,073.91
MX$2,025.94
List Price:  MX$2,836.40
You save:  MX$810.45
QR365
List Price:  QR511.01
You save:  QR146.01
P1,382.22
List Price:  P1,935.16
You save:  P552.94
KSh12,923.70
List Price:  KSh18,093.70
You save:  KSh5,170
E£5,060.50
List Price:  E£7,084.90
You save:  E£2,024.40
ብር12,853.61
List Price:  ብር17,995.56
You save:  ብር5,141.95
Kz91,190.88
List Price:  Kz127,670.88
You save:  Kz36,480
CLP$94,785.52
List Price:  CLP$132,703.52
You save:  CLP$37,918
CN¥727.91
List Price:  CN¥1,019.11
You save:  CN¥291.19
RD$6,215.25
List Price:  RD$8,701.60
You save:  RD$2,486.34
DA13,481.55
List Price:  DA18,874.71
You save:  DA5,393.16
FJ$229.81
List Price:  FJ$321.75
You save:  FJ$91.93
Q772.59
List Price:  Q1,081.66
You save:  Q309.06
GY$20,950.95
List Price:  GY$29,332.18
You save:  GY$8,381.22
ISK kr14,017.59
List Price:  ISK kr19,625.19
You save:  ISK kr5,607.60
DH997.60
List Price:  DH1,396.68
You save:  DH399.08
L1,864.97
List Price:  L2,611.03
You save:  L746.06
ден5,879.23
List Price:  ден8,231.16
You save:  ден2,351.92
MOP$802.38
List Price:  MOP$1,123.37
You save:  MOP$320.98
N$1,845.90
List Price:  N$2,584.33
You save:  N$738.43
C$3,684.65
List Price:  C$5,158.65
You save:  C$1,474
रु13,912.57
List Price:  रु19,478.15
You save:  रु5,565.58
S/370.44
List Price:  S/518.64
You save:  S/148.19
K402.76
List Price:  K563.88
You save:  K161.12
SAR375.01
List Price:  SAR525.03
You save:  SAR150.02
ZK2,816.41
List Price:  ZK3,943.09
You save:  ZK1,126.67
L475.58
List Price:  L665.83
You save:  L190.25
Kč2,396.16
List Price:  Kč3,354.72
You save:  Kč958.56
Ft38,385.49
List Price:  Ft53,741.23
You save:  Ft15,355.73
SEK kr1,071.44
List Price:  SEK kr1,500.06
You save:  SEK kr428.62
ARS$105,926.90
List Price:  ARS$148,301.90
You save:  ARS$42,375
Bs694.44
List Price:  Bs972.25
You save:  Bs277.80
COP$413,151.75
List Price:  COP$578,428.98
You save:  COP$165,277.22
₡50,717.92
List Price:  ₡71,007.11
You save:  ₡20,289.19
L2,552.87
List Price:  L3,574.13
You save:  L1,021.25
₲791,418.37
List Price:  ₲1,108,017.38
You save:  ₲316,599.01
$U4,324.45
List Price:  $U6,054.41
You save:  $U1,729.95
zł397.30
List Price:  zł556.24
You save:  zł158.93
Already have an account? Log In

Transcript

Objective. By the end of this activity, you should be able to explain how to apply conditional formatting, copy and rename sheets, color sheet tabs, pad sheets, insert links. Let's now learn using conditional formatting. To do so, select the required cells. Then click on conditional formatting. Click on icon sets, and then select icon set option.

Let's now learn the renaming and coloring worksheet. To do so, click on format. Then click on rename sheet. Enter the suitable name and then press Enter key on the keyboard. Click on format Then, click on That color and then select a suitable color. Let's now learn copying and pasting worksheet.

To do so, click on format. Then click on move or copy. The move or copied window is displayed on your screen. Click mu two and click on create a copy. Now click on OK. Now change the data as per your requirement. Similarly, you can copy and paste other sheet in Sochi.

The new sheet has been inserted. You can add the required data as displayed. Let's now learn inserting hyperlinks. To do so click the cell then click on Insert tab click on hyperlink the Insert Hyperlink window is displayed on your screen. Click on place in this document then click on car loan. Then click on OK. To navigate click on FC bank car loan summary you have completed the activity.

You are now able to apply conditional formatting, copy and rename sheets, color sheet tabs at sheets, insert links quick summary. We have reached the end of the case study. In the process, we have learned to enter and Format Data. Use the merge and center feature. Apply cell shading, adjust columns column and row height. Create borders insert Crews use shapes, use symbols, use formulas, insert pictures, create charts, apply conditional formatting, copy and rename sheets, color sheet tabs.

Sign Up

Share

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.