HOW TO SHOW 0 VALUES BEFORE THE NUMBER IN EXCEL

Worrying about Add '0' values before Number in Excel .

Don't Worry I will show you How to visible 0 values before any number value

Let's look here

steps:
1.  Type any one value (ex: 0012345) in excel cell as per show above and select it.
2. go home menu->  Number Section -> Change 'General' to 'Text'.
3. Now it gives an Error message at right corner of the cell -> Set Ignore Error.

USING CONVERT FUNCTIONS
HOW TO CONVERT CM TO INCH
Normally Everybody knows that 1 CM = 0.393 inches, 1 Inch = 2.54 cm .
1 CM = 0.393 INCH
1 INCH = 2.54 CM Now, Let us do How to convert Inches to CM
INCHES 1 convert to CM 2.54
to Convert Inch to CM    Write Below Function    =CONVERT(B1,"in","cm")

Excel Tricks: HOW TO USE COMPOUND INTEREST FORMULA IN EXCEL ?

Excel Tricks: HOW TO USE COMPOUND INTEREST FORMULA IN EXCEL ?: HOW TO USE COMPOUND INTEREST FORMULA IN EXCEL  A                                                           B Intial investment ...

HOW TO USE COMPOUND INTEREST FORMULA IN EXCEL ?

HOW TO USE COMPOUND INTEREST FORMULA IN EXCEL 
A                                                           B

Intial investment	24000
annual interest rate	8%
No. of Compounding periods	12
Years	1
Balance	25,991.99

in the Above table We have to find out compound interest and future value from the using given formula. 

the Compound Formula : =B3*(1+B4/B5)^(B6*B5)

B3 = Initial Investment                     : Rs. 24000/-

B4 = Annual interest Rate                : 8% p.a

B5 = no of Compound periods         : 12 

B6 = Year                                          : 1

Future Balance                                  :  Rs. 25,991.99/-

How to use Auto sum in Excel sheet

How to use Auto sum in Excel sheet

Hi..Readers !

    In this lesson we are going learn How to use 'Auto Sum' in Excel. Normally Autosum is great feature in excel, because in excel when we have huge value which need to be added then this option will used, it will not require any formula or function to be written by manually. So we no need to have functional knowledge in excel. 

      It is very easy use let us see small example about 'Autosum'

First let us prepare a table like below, here we have some employees and their salary list are given, here I want total salaries to be find. Let's see how to do this work.

1. create a table like above given screen shot

2. Place your cursor on 'D9'  ( means total amount required cell )

3. Now, Home tab -> 'Autosum' -> Click 'Sum' -> Press 'Enter' key.

4. then it show total value of salaries amount.

5. here it takes all values(from Range D2:D8) located in salary column and adds values and returns total values.

Normally it gives formula   =sum(d2:d8)

you can see this formula in your formula bar above table.

Thank you

excel trics blog

How to Set Currency Symbol to Values in Excel Data

How to Set 'Currency Symbol' to Values in Excel Data

Hi...Reader.!

         Worrying about adding currency symbols for values in excel data. Don't worry in this lesson we will show you how to add currency symbols before a numeric value in excel data. So for this we just create a small database table in excel like below

as of show above prepare a table about employee salaries now,

1. select a column D here salary of employees
2. Home tab -> Accounting -> click '$' button -> set currency Style ($, Rs..)
3. Now watch your table it shows $ Symbol before employees salary amount.


Thank you
Excel Trics blog

Conditional formatting in Excel

How to work with conditional formatting in excel

Hi...Readers !

          In this lesson you can learn how to use conditional formatting in Excel data. This feature is most useful when we have more data if we want to highlight some specified cells in the database. "conditional formatting is nothing but highlighting data with different color formats and font styles for specified cells in entire database". 

Let us see create a small database like below 

1. Create a small database for employees and their salary details like above
2. home tab-> conditional formatting -> highlight cell rules -> equals to 
3. now you will see below settings 

4. type 'manager' in left input box
5. select 'light red fill' in right list menu.
6. click 'ok'
7. now in your database all your employees who are having manager designation will be highlighted with Red fill color. 

we can use this for other columns like salary, emp names or id nos also by using other conditions  like lessthan, greaterthan or equalsto ect...

thank you
excel trics blog