Gaurav Blog

Orientation is a tool, with the help of it you can change the position of the text in any cell you can give it a new look. For explain this option first of all i'll create a excel sheet with different headlines. Here i typed some Cricket players name and years and i just want to create a table to show which player has scored more runs? But wait, i want to change the look of "Players" cell or say to change its orientation. Let's know what will happen when i change the orientation (after selecting the cell which i want to change): you will observe that at the starting of the options, the direction of the text has given means after selecting the particular option you will oriented your text in these direction..    Now, I think, you must have understood the "Orientation" option. Hope you will like it. Use it and share it.

In this Group you will get the following options: Top Align Middle Align Bottom Align Left Align Center Align Right Align Orientation Decrease Indent Increase Indent Text Wrap  Merge And Center We will know about all of above one by one. The "Alignment Group" looks like this: Top Align Middle Align Bottom Align Left Align Center Align Right Align I'll explain all above options together in a single image : When You observe the pattern of the text in the cells you will find that  : Top Align            -    In top alignment Text appears on the top of the cell. Middle Align       -    In middle alignment Text appears on the Middle of the cell. Bottom Align      -    In bottom alignment Text appears on the bottom of the cell. Left Align           -    In left alignment Text appears on the left of the cell. Center Align       -    In ...

Today, we will know about last options of "Font Tab". They are "Fill Color" and "Font Color". Generally when you see these option you will get confuse  What's the thing for that? but i will explain you that how can we use it in proper way and for what, they are designed? Take a look on them... The First one is for color the cell, means this one change only cell color (Not Text in the cell). And another one is for text in the cell means it will change the color of the text in the cell not cell. Look it here i have an example to show you how do they work: Let's a table with different items: Step 1 : If i select any one Row Or column and go to the first one it will appear "Fill Color" and after selecting the option you will get the following result:   Step 2 :  If i select any one Row Or Column and go to another one it will appear "Font Color" and when you select this you will get the following result: In the above two images, if y...

This is a "MS EXCEL TRICK" to save our time and get the result Immediately. Well there's a lot of tricks but i will try that i tell you them one by one. So that you can learn them properly and use it in your worksheet to make it more attractive, and less time consuming. okay today i tell you how can we use "Auto Fill" option for our worksheet. Let's we have a worksheet where we have to type Serial Number from 1 to 1000, if we type it manually, we will loss our time. "Excel" has a option named "Auto Fill", It will help us to create it fast.  Step 1: In any cell Type 1 Step 2: on the right bottom corner of the cell you will find a special point. step 3: When point your mouse on this point, your mouse pointer will change, after that you will have to pull down with left click and you will get the following result.... Step 4: When you place your mouse on highlighted area and click on down arrow you will get the options: Step 5: When you selec...

Hello Everyone, Let's know about the "Erase Border Tool" As it's Name shows, it will erase the border if we want and it's use is very simple.  Let's understand it by a example: There is a image given below with border grid. (In last post i told how to use "Border Grid"): If we want to remove all border, simply we will open the "Border" option and get a drop down list where in the bottom you will get "Erase Border", select the option and turn around the data with "Border Grid". After doing it you will find that all the order has removed. As shown below: Thanks For visit on my blog. If you like it please share.

Today we will know about a very useful thing about excel sheet. Generally we create any sheet in excel and print it but without border it will not look pretty and the document will not get a professional look. Therefor it is compulsory that we use "Border Option". Take a look if do not use border then how will our print preview.... Here, i note some records but if we print and it we don't find it in proper manner. Let's check it by print preview.... After Select "Print Preview" we will found the following result....... Here, records are not in proper way also not looking good. So if we want to give it a proper look we have to use "Border" option in "Home Tab" "Font Group"  When put your mouse cursor on the down-arrow of  border option you will get a list that which type of border do you need?? for example: If you need only "Top and Bottom Border" then select the cells on which you want to border and then select the opt...

Yesterday i define some options of "Font Group in MS Excel" today we will know about remains options of Font Group. In Excel worksheet, if we see nearby the "Font Size" You will get Arrows "Upwards" and "Downwards". They are pretty useful for increasing and decreasing the font size (after selecting the cells).  They look something like this: After that if you pay your attention on second row of font group you will get these options:  By clicking on them you will get following results respectively: B - To bold the cell. (Text get Dark) I  - To italic the cell's text. (Text get Skew) U  - To Underline  the cell's text. (The text get Underlined) Note: All the action will work only when you select the cell. About next options we will know in next post. Thanks to read. If you want any change in this Blog Please Comment. 

Hii Friends, Yesterday, we have talked about the "clipboard Group" in "Home Tab". But Today we will know about the next group of  Home Tab in MS EXCEL. It is "Font Group". It is very simple and easy to use tool. We can simply understand every option of it. But still i want to explain every thing so that you don't have any problem/doubt to use it. Let's start............. It looks like this  1. Font "Calibri" is the type of Font. In simple language we can say that if we change the font, we change style of writing. For Example if i select a filled cell and then change the font............ take a look what happens. It is the "Calibri" font but if change it by clicking on down arrow near "Calibri", look what happens..  So, you can watch that the style of font has changed. Simply we can change it in several styles.  Note: "For Select any cell you will have to left click on them by mouse. But if you want to select more...

Hello every one, After a long time i have come with a practical of a MS EXCEL's option witch has  Told in brief  by me in my last post but today i will explain you it by a demo file. Today we will learn about the option "Format Painter" that is a time saving and very useful tool. Let's a sheet of excel with different type of formatting..... Now i show you how can we copy only format in excel. Step 1- Select the cell which is formatted. Step 2-  Go to format painter in clipboard group. Step 3 - Now select the cells which you want to format, and you will get the same formatting.  So today we learnt about the uses of format painter. Which is very useful and time saving. If you want to ask any thing then please contact me : Gaurav Soni +91-7415160737

CLIPBOARD Yesterday, we learnt about the basic of MS EXCEL sheet. But from Today we will learn MS EXCEL step by step. So first of all we go to HOME TAB appear on left top of the excel screen. When we open the MS EXCEL the HOME TAB is default selected. So we do not need to select it.  Now in HOME TAB first group you will see "CLIPBOARD" In clipboard group there are four options as you (as you see in the image): (1) Cut  (2)  Copy  (3) Format Painter   (4) Paste 1. CUT  : The Use of cut is to Cut any text or number or any other data from the cell or Range (The Range is the group of cells). 2.   COPY  : It is used to copy a cell or range or whole sheet depending on selected area. 3. Format Painter  : It is used to copy only the formatting of any cell not it's value. 4. Paste : When we cut or copy any cell, after that we have to paste it on any other cell so that the value of cell which we copy or cut can be appear on other cell.

Hello everyone, Today we will become friendly with excel sheet and know about the different field of MS EXCEL . First of all to open a excel sheet you have to go to start button on your desktop and then place your mouse on all programs, you will get a list, find "MICROSOFT OFFICE" in it. if you find the option then left click on them and select "Microsoft office Excel". If you don't find the "MICROSOFT OFFICE" in all programs list, then firstly you have to install the program. Start button  > All Programs > MICROSOFT OFFICE > MICROSOFT OFFICE EXCEL (The instructions are based on Windows 7 and MICROSOFT OFFICE 7) you will get the following window:  Here : 1. small empty blocks are called "cell". 2. If you select any cell by click on them it will called "active cell". 3. Left side of the top there is a button called "office button" (when you place your cursor on them it       will show its name). 4. "HOME"...

We all know that MS EXCEL is a powerful tool for any office to create sheets, charts, graphical reports etc. If we know how to operate it properly, then we can get a job easily in any office.  Therefore we can say that it is not only a tool but it is also a platform to get a job. I think that there should be a course  of MS Office in our education system so that students can get a practical and professional knowledge and can earn there pocket money them selves by doing a job in any office.  It will be a great pleasure for them as well as their parents that he/she is not more dependent on their parents. They are self. It also increase their Performance, Self respect, and ownership.  Therefor i make a decision that from today i'll post regularly about EXCEL and try to share the knowledge step by step. I request to all of you that please give me response that what should i improve ? and what should i change?   Thanks .................  

Today we will learn About "CONCATENATE" formula of excel. It is used for connect the text in two different cell in excel sheet.  Lets we understand it by an example: Step 1 - Open an excel worksheet and type "Art, Fun, Knowledge" in different cell.  Step 2 - Now in any other cell type the formula "=CONCATENATE("  Step 3 -  Now select the cells one by one separated by comma (,) and hit the Enter key & you will get the added text with each other.