How to use ms Excel

 How to use ms Excel in mobile phone-

In this time computer knowledge is very 'important to earn money and get a respectfully life in this field. Every person want to earn money well. But you should knowledgeable in computer field for earn money. First you should be basic knowledge in this field. In this basic computer field also come Excel software. Yes, i am talking about Excel software. Here we will learn, how to use Excel in mobile phone. 

Let's learn all the options one by one in details.

project name- here you can see your project name. What ever you had given. If you want to rename your project name then you can rename it from here.

Edit- If you want to do some editing work in your worksheet then you can click on this icon. Here you will get all menu like Home, Insert, Formula tab etc. And you can use all menu according to your need.

Search- If there are lot of data in you work sheet and if you want to find something in your data then you can use this tool. First you need to select data range where you want to find out something after that click on this search icon and type here whatever you want to find out. And click on the search button after that you will get search result whatever you type on the search box.

Undo- If you are working on the excel sheet and you make suddenly mistake and if you want to go to one step back to improve the mistake that time you can use this button. In other words we can say, if you want to go to one step back from your current working time then you can use this undo button. 

Comment- if you have discribed something more about any particular word or text and you want to read comment that time you can use this tools to read out whatever you discribe.

If you want to learn ms excel more properly then you can watch below video or you can visit my youtube channel.

Share- If you want to share your sheet with any person like a Google excel sheet that time you can use this share button.

Column- The group of the vertical lines is called column. But remember lines should be in a pattern. Column name begins from A, B,C.........XFD. There are 16384 columns in the ms excel.

Rows- The group of a horizontally lines is called row. rows begins from 1,2,3......1048576. there are 1048576 rows in the ms excel. 

Cell- The combination of columns and rows is called cell. Cell address begins from A1 and end from XFD1048576. Total, there are 17179869184 cells in ms excel.

Formula bar- Formula baar show cell address, selected range, formula and functions. You will get a "fx button" in the left side of the formula bar from where you can choose any function or formula.

Now let us discuss one by one all tools about home tab.

Font size- If you want to increase text hight then you can use this tools. You can increase Maximum hight 72 and decrease minimum hight 8.

Bold- after using this tool you can make text more darker and highlight.

Fill color- let, you want to fill colour in the your heading to highlight the text. And you want to fill colour on the selected cell. First select the text where you want to fill colour and go to fill colour after that choose a colour which you want to fill in the selected range.

Border- now here we will learn how to apply border. First select text where you want to add border and go to border and choose a border according to your need.

Italic text- when you will apply italic tools with any selected text then your text will be a little bend.

Under line- If you want to draw a line under the text to light the text then you can use this tools.

Mid line- When will you use this tool then you can draw a line on the text mid.

Merge & center- You can change many cell in one cell by using this tool. First select the cells range and click on the merge button after that all cells will be change in one cell.

 Alignment- There are six types alignment here you can set alignment according to your need. Total alignment is left, right, top, bottom, mid.

Warp text- If your column width is small due to page space and you want to write something in the below side to manage the page space that time you can use this tools. First select the text range and click warp text button after that your space will be automatically compress. If your column space are not compress then you can customise it according to your need.

Format cell size- here we will get some formatted them from before if you want to do formatting fastly then you can use this tool. There are many formatted theme available here. You can apply any theme according to your need. First select the text where you want to apply formatting and click on this "format cell size" and choose your theme.

Clear- If you want to delete anything from your cell. Then you can use this tools. First select range where you want to delete anything and click on the clear button after that your data will be totally clear. But remember your cell will not be delete.

Filter- If there are lot of data in your worksheet and you want to apply filter to make your project more attractive. Mainly there are two type filters here first one is ascending order and second one is descending order. You can apply any filter according to your need.

Autosum- this is formula of sum. you can add many cell digit in on cell. In the above image you can see it's example. First select the range where is your data filled and clik on the autosum icon after that you will get total sum of selected range.

If you want to download this application then you can click on the below download button

If you have any doubt then you can ask me in the below comment box.

Thanks my dear.