Format Painter in Excel

Hello friends,

                      today we will discuss about a important function called Format Painter in excel.

With the help of below given example it will be easy for us to understand the function.

Here we can see that in cell A1 there is a text in bold, italic and underline format but the same text we can see in a different cell A3 but this is neither bold nor italic and underline, but if we take our cursor to cell A1 and click from mouse on the above shown Format Painter brush  icon and click on icon and paste the same to the cell i.e. A3 to change the format like the cell A1

It will be look like as follows that cell A3 has become same as cell A1 bold, italic and underlined.

Shortcut for above cell format like bold, italic and underline

Cntr B, for Bold, Cntr U for Underline and Cntr I for Italic

Simply Cntr B,U,I

So by this way we can use this tool to change format without going to format a cell option.


Thanks and good bye for now!


Narendra

Picking a Random Name from given list

Today we will discuss about random list i.e. how to look for a random name in the given excel list.

Here below we have a excel list from range A1:A14, and in range B2 there is value "Vimal" but the fact is cell B2 has a formula i.e. INDEX and RANDBETWEEN both formula has separate solution like Index has a list of names and randbetween has to pick any name from the give list so below is the example and we can understand in a very easy way.

Here in this example we are watching in this list A1:A14 it has 14 names so if we want  any name from this list, so put a randbetween formula, randbetween formula look for any no. value from the given range. And what index function does, it provides a list range as an array like range A1:A14

so simple index function provides a range and randbetween look for any no. value i.e. name from the list. So easily we can get the random no. or name from the given list.

Thanks

Narendra

If or Nested If function in Excel

             Today I am writing about If or Nested If function in Excel.


If or Nested If function are both same function. Basically these are conditional function , like :-(if this value is 50 then what and if this value is greater or less than 50 then what) so these kind of condition we deals in If or Nested If function.

This function are useful in rating or grading system, same as preparing a marks sheet for the student or doing some grading  system of job in the office.

Here are some example

Example No 1.

Here in this example we can see that  in column A names are mentioned and in column B the score of the respective name and in column C the result is appearing according to their score like average, good, excellent and so on.

Example No. 2

Here in this example we can see the result in grade system but what is additional in this example that here you can see AND function.

I put another condition in this example like should be B2 >33 but should (less than) B2 <45, similarly B2>45 but (less than) B2<55, so these are the condition I have added in this example. So we can use this two condition also.

Example No. 3

In this example we see that there are two condition Pass or Fail and there is score also. simply we are putting the formula and according to the score the result appearing in column C.

So there are the If o Nested If example.

We can not say that this is the only use of this function but we can use If function in many ways and it depends upon the logic we can apply. We can use this function as many ways and I am sure that we we will use this function in future also because this is a very very useful function.

So goodbye for now

Narendra

Some Excel shortcuts

Hello friends,


                    Here are some excel essential keyboard shortcuts keys :-

1.                 Time                                                    CNTR+SHIFT+:

2.                 Date                                                     CNTR+;

3.                 Copy data from above cell                  CNTR+' and CNTR+D

4.                 Giving a line break in a cell                ALT + ENTER

There are a lot more keyboard shortcut keys in Excel but I will discussed in the future post.



Goodbye for now

Narendra