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!!