Creating a Loan Calculator-1

Basic Microsoft Excel Course Creating a Loan Calculator
8 minutes
Share the link to this page
Copied
  Completed

Transcript

As Robbins works in the loan department of the Financial Corporation bank, loan disbursement is one of the bank's major activities, the bank has decided to simplify matters of prospect to customers as much as possible. Ash has been assigned the task of creating a loan calculator, which will be uploaded on the bank's website. Customers can enter the loan amounts required themselves and get instant information regarding monthly payments and interest amounts. Ashe uses a spreadsheet program for this task. Let us see how he went about it. You can quickly perform detailed calculations by using formulas in a spreadsheet, we shall learn to create a spreadsheet that is used for loan related calculations.

Let us begin with a blank sheet. Enter the required data. Use the merge and center feature to create a large cell to display required information. Then I just have the first column, increase the height of the design rules. Now, apply suitable shading and create the required borders. Create another table like structure by applying suitable borders.

Next, insert a row at the top, apply suitable shading and enter the required text. Create an arrow shape to indicate fields that a user needs to fill up. format it appropriately and enter the required text next to it. Create another similar shapes, insert the required currency and percentage symbols. Then, enter the formula for calculation of various amounts. Do the same for the table below.

Now, insert a suitable picture, then insert a chart at the right displaying the percentage wise breakup of the total amount do automatic as required and enter a suitable title. Use the conditional formatting feature to display small colored circles based on the values in the cells of the bottom table. Now, enter a suitable name on the sheet tab and color it appropriately. Create copies of this sheet for other types of loans and make the required changes. Finally, create another sheet for the homepage cruising suitable data, pictures and cell shading objective by the end of this activity, you should be able to explain how to start the application. save the document, enter and Format Data.

Use the merge and center feature Wrap Text, adjust column width and row height. Apply cell shading, create code headquarters. Let's now learn starting Excel. To do so, click on Start. Then click on All Programs. Scroll down to select Microsoft Office folder.

Then click on Microsoft Office. Then click on Excel. Excel window opens. Click on Blank Workbook. The new blank workbook is open. Now we will learn to save the document.

To do so, click the File tab. Then click on Save. Click on Browse the Save As window is displayed on your screen. Browse the folder then enter the file name and then click on Save. Now they can see that the workbook is saved with me Name, NaVi learn to enter data. To do so, click the required cell and then enter the suitable text.

Similarly, you can insert other text. Let's now learn using merge and center. To do so, select the required cells, and then click on merge and center. Similarly, you can merge other types. Let's now learn wrapping text. To do so, select the required cell and then click on Wrap Text.

Group is the change. Let's now learn aligning text. To do so, click the cell then click on Align Left. Then click on middle align. Notice the change made to the document. Let's now learn existing column grid.

To do so, select the column then click on format. Then click on column with the column ID window is displayed on your screen. Now enter value in column width and click OK. Similarly, you can adjust weight of other columns. Now we will learn adjusting row height. To do so, select the row then click on format.

Then click on row height. The row height window is displayed on your screen. Enter the suitable value in row height box and then click on OK. Similarly, you can add this type of other roles Let's now learn formatting text. To do so, click the font. Scroll down to select suitable font style and then select suitable font.

Click on font size and then select suitable font size. Similarly, you can apply formatting to other texts. Let's now learn making the text bold. To do so, click on bold. Similarly, you can make other text bold. Now they've learned to apply cell shading.

To do so select the cell then click on fill color. Then click on more colors. The colors window is displayed On your screen, select suitable color. Now click on OK notice the change let's now learn changing font color. To do so, click the cell then click on font color. Click on more colors.

The colors window is displayed on your screen. Select suitable color and then click on OK. Notice the change let's now learn applying border to sell. To do so, select the required cell and then click on borders. Then click on line style. Then click on suitable line style. Now click on borders.

Then click on line color and then select suitable color Now click on borders and then click on all borders. Now click outside. Similarly, you can apply borders to other cells. Somebody you have completed the activity, you are now able to start the application. save the document, enter and Format Data. Use the merge and center feature that text, adjust column width and row height.

Apply cell shading create borders

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.