DATA

In this post we will know about DATA in Menu Bar of Ms-Excel. Data is a very important part of Ms-Excel. All the persons used DATA Menu in every data. Data is for arrange your DATA. The most important part of DATA is filter. Select the first column of your data and then click Data. There is an option showing click Filter and it will create filter of your data.

https://upstox.com/open-account/?f=DAD0

Open your account and get a free stock with this company. One year moneycontrol pro subscription and other benefits. Just click on the link and complete all the informations.

https://upstox.com/open-account/?f=DAD0

If it ask for referral link then type 860716.

Then it will show the result as per next image. Please see the image.

https://upstox.com/open-account/?f=DAD0
Author

By click on the arrow we can check the marks of the students differently. Like when we click on arrow and select Himanshu it will show all subject's marks of Himanshu. Like that we can show all student's marks.







https://upstox.com/open-account/?f=DAD0
Here is one more important function of Data. That is sort. Sort Ascending and sort Descending. You can check it by yourself.
https://upstox.com/open-account/?f=DAD0
Example of Sort Ascending.

https://upstox.com/open-account/?f=DAD0

Author

 It is showing there names in sort Ascending. Like that the down option of this is sort descending. See the example of sort descending.











Example of Sort Descending.

https://upstox.com/open-account/?f=DAD0

It is showing there names in sort Descending.













You can ask me if you want to ask me anything.

WE WILL SEE THE NEXT OPTIONS IN THE NEXT POST.

THANKS!!

PAGE LAYOUT

PAGE LAYOUT

Hi Friends, there  is Page Layout Option in Menu bar of action. There are no more many functions we need to use here. There are not many more functions of this menu, we use as professionally. Let us see first option there is Theme.

THEME:

                          Select your data and click on Page Layout and then Theme. When will you click on theme, it will show all the designs, you move your cursor of mouse one by one, it will automatically change the design. Just have a look.

https://upstox.com/open-account/?f=DAD0

Here are showing many more designs of themes you can move your cursor and check it by yourself.

https://upstox.com/open-account/?f=DAD0

Here is another option we can see here fonts. We can change text fonts from here also. Here click on arrow of fonts and it will show many more options. Just have a look at the image.

https://upstox.com/open-account/?f=DAD0

FONTS:

Here is another option which is important in this section. We can use margins for set printing. If we want to set the print size area of the page then we will use MARGINS for this sections. Just have to see this image. We have to select custom margins to set the size of printing text and page according to our self. Select on the data and select custom margins. Then select the size which we want.

MARGINS:

After selection of custom margins, We see there are many options to use here. We see next window is open here. Have a look in the next window.

https://upstox.com/open-account/?f=DAD0

Here we can see the main parts of our page, TOP, LEFT, RIGHT and BOTTOM parts of our paper. Length is showing in inches here. We can change it by our self. We can increase or reduce the size by margins. 

https://upstox.com/open-account/?f=DAD0

If you want to anything else from this part page layout you can ask it from me by comment and Please follow me. The other part of excel is FORMULAS, but we will do this part later on. Because this part is very bigger than other parts. Then we will do the other parts in the next part.

https://upstox.com/open-account/?f=DAD0

THANKS!!

INSERT MENU

When we click on insert menu first option is show here TABLE. The data which is showing here is in the form of table. When we want to create a table, click on the first row and first column of border which you created before. Pivot Table is the most important part used in Insert. We will see it at the end of this post. Click on the TABLE and Look at the IMAGE.

Look at the image. Just click on name and then Insert. It will select all the columns and rows of TABLE.

Then you will see all the designs of table. You can click and it will show you the design of table. You can select the designs as per your choice. You will see when you place cursor in TABLE DESIGN, it will change one by one. You can choose the design as per your choice. Design will change itself when you place cursor one by one and when you click on arrow there are many designs in it.

In this image I don't click on any design but just place cursor of mouse and I show the style of design. In the next image, we will see when we place cursor on other design, it will automatically change its design. IN the  next picture we will see that my chosen table design was as it is but when you place your cursor to next design. Lets suppose that you place the cursor to next design of table is.  NOW see the image.

If you want to insert a picture in your data then you can do easily. Click on insert and then picture. It will say you insert picture from your computer, you can select and insert it easily. You can size the image and place it yourself where do u want to place. Just like that image.

You can rotate the image easily have a look at the IMAGE.

You can insert GRAPH, PIE and there are many options of insert data if you want and check statistics analysis. Symbols with colors also given there. You can check by yourself.

Just like 2 column graph you can use many type of graphs and you can use pie, you can check yourself.







And now most importantly used in excel is pivot table. Now we will learn about pivot table.

Here is another image of graph. Please have a look at this image also.

PIVOT TABLE

Click Insert and then pivot table. It will ask new sheet or existing sheet. To with your choice you can choose yourself. But it is good to choose other sheet. Just have a look.

HYPERLINK

We can insert HYPERLINK in INSERT menu of excel. Hyperlink is the very important function of Insert Menu. by hyperlink we can insert any of our file or Folder in our file with a small name. Have a look.

Here we select text to display car and select the file is demo. In the cell file would be demo but when we click it will open demo. You can check by yourself.

The Identification of Hyperlink is that it it underlined by itself. Have a look at the image







Here we create a pivot table and there we placed total in first section, then names and then it will show sum of math, We had only drag the three total, name and math. it will show automatically the result. JUST have a look

 AND WE WILL SEE THE OTHER IMPORTANT OPTIONS OF EXCEL IN THE NEXT POST. YOU CAN ASK ME ANY OTHER THING IF YOU WANT TO ASK OF THIS MENU AND YOU CAN FOLLOW ME TO READ ALL THIS TYPE OF POSTS.

THANKS!!