Showing posts with label Computer Tricks. Show all posts
Showing posts with label Computer Tricks. Show all posts

EMI CALCULATOR

The EMI calculator is a simple tool to help you figure out how much you need to pay monthly for a loan. Here's how it works:


Loan Amount: Enter the total amount you want to borrow.

Annual Interest Rate: Add the percentage the bank will charge as interest each year.

Tenure (months): Input how long you'll take to repay the loan in months.

Once you provide these details and press the "Calculate EMI" button, the tool does the math and shows your monthly installment.

It’s designed with a clean, colorful background and user-friendly features to make it easy for anyone to use. It’s perfect for financial planning or understanding your loan better.

EMI Calculator

EMI Calculator

Removing Duplicate Rows in ODS/Spreadsheet

There is no automatic function to remove duplicate rows in ods. Follow below steps to delete all rows that have duplicate values in column A:

  1. Select all cells of the current data range.
  1. Sort the data range by column A.
Choose Data - Sort.

  1. Click an empty cell in the first row. Let's assume it is cell C2. Enter the formula:
=IF(A2=A3;1;0)

This will display 1 if the current row has the same value in column A as the next row. It will display 0 if the values are different.


  1. Copy the formula down for all rows of the data range.
  2. Drag the formula to last cell of the data present against to Column A
  3. Now filter Column C and select 1's in filter dropdown and delete
  1. Re-set(Open the filter and select All and Click on OK) the filter you can find desired unique values in Column A.

How To Make Symbols With Keyboard




Alt + 0153..... ™... trademark symbol
Alt + 0169.... ©.... copyright symbol
Alt + 0174..... ®....registered ­ trademark symbol
Alt + 0176 ...°......degre ­e symbol
Alt + 0177 ...±....plus-or ­-minus sign
Alt + 0182 ...¶.....paragr ­aph mark
Alt + 0190 ...¾....fractio ­n, three-fourths
Alt + 0215 ....×.....multi ­plication sign
Alt + 0162...¢....the ­ cent sign
Alt + 0161.....¡..... ­.upside down exclamation point
Alt + 0191.....¿..... ­upside down question mark
Alt + 1.......☺....sm ­iley face
Alt + 2 ......☻.....bla ­ck smiley face
Alt + 15.....☼.....su ­n
Alt + 12......♀.....f ­emale sign
Alt + 11.....♂......m ­ale sign
Alt + 6.......♠.....s ­pade
Alt + 5.......♣...... ­Club
Alt + 3.......♥...... ­Heart
Alt + 4.......♦...... ­Diamond
Alt + 13......♪.....e ­ighth note
Alt + 14......♫...... ­beamed eighth note
Alt + 8721.... ∑.... N-ary summation (auto sum)
Alt + 251.....√.....s ­quare root check mark
Alt + 8236.....∞..... ­infinity
Alt + 24.......↑..... ­up arrow
Alt + 25......↓...... ­down arrow
Alt + 26.....→.....ri ­ght arrow
Alt + 27......←.....l ­eft arrow
Alt + 18.....↕......u ­p/down arrow
Alt + 29......↔...lef ­t right arrow