Learn everything about excel insert tab

Blue marked area:

How to insert image, shapes and smart art in excel?

To insert image, shapes,smart art blue marked is used. If you want to insert image, click on the image option present in blue marked area. If you want to get image from online then click on online picture option present in the blue marked area.

Red marked area:

How to create graphs and charts in excel?

To insert a graph first select columns that you want to use in the graph and then go to the insert tab red marked area. Here you have a lot of options. If you want to choose by yourself then just click on a chart and automatically graph will be created. Here you will see a lot of graphs like line charts, pie charts, histograms, bar charts,3D charts, etc displayed as icons.

In the image, you can see there is a different chart for Group and Total marks. You can create these charts by selecting columns and then clicking on charts.

When you select columns then excel recommends some charts. If you want to use those recommended charts then click on recommended charts option. Creating chart process is same as previous process.

Graph and chart design tab:

After creating the chart a new tab will open named design tab. The tab visible when click on a chart. This tab is used for design charts.

Red marked area:
Here some pre-design charts are present. Click on the chart to get those designs on your chart.

Black marked area:
Suppose you have created a chart then you want to change that chart and use another chart. To this click on the change chart type option. Use the move chart option to move the created chart into another sheet.

Green marked area:
To change chart color use the change color options.

Blue marked area:
To use the quick layout of the chart use the quick layout option. Now there are some elements of a chart like an axis, axis title, chart title, data labels, data table, error bars, guidelines, legend, line, tread line, and up/down bars. You can add, change and edit these things by clicking on add chart element.

Graph and chart format tab:

After creating the chart, if you click on the chart, a new tab will open named format. This tab is used for change or edit the format of the chart.

In the image green marked area is used to edit graph background color, shape color, shape effect.

Blue marked are is used to edit text color, text shape, text shape, and outline effects.

For graph alignment, purple marked area is used and to get shapes yellow marked area is used.

To delete a chart just click on the chart and press the delete button.

How to create pivot table in excel?

To create a pivot table first select columns then go to the insert tab. There you will see two options, recommended pivot table and another is pivot table. Recommend means excel recommend you some pivot tables. If you want to use recommended tables then click on recommended pivot tables option and if you want to create your own then click on pivot tables.

After selecting the columns and clicking on the pivot tables option this types of sheet will be displayed:

In the image green marked area is used for creating a pivot table and the table will be displayed in the blue marked area.

Now let's create a pivot table:

Which column do you want as the pivot table column, put that column in the green marked area. In the image, the id column is used as the pivot table column.

Which column do you want as the pivot table row, put that column in the red marked area. In the image the grade column is used as the pivot table row.

The column you want as the pivot table value, put that column in the black marked area. In the image total marks are used as the pivot table value.

To put columns drag that column and drop it where you want.

The column you want as the pivot table filter, put that column in the blue marked area. In the image group name is used as the pivot table filter.
Filter means for which row and column value the pivot table will display. In group name, you have three values science, commerce, and arts. First, you get a pivot table for all values of the group name. Now if you click on the brown marked area then the value of the group name column will be displayed. If you click on science then the pivot table will be displayed for science. This way filter works.

Pivot table design tab

After creating a pivot table you will get a new tab named design tab.
Excel already created some pivot table templates for you. You can get those in the green marked area.

Change report layout, create blank rows, disable or enable subtotal and grand total columns are located in blue marked are.

Pivot table analyze tab

After creating a pivot table you will get another new tab named analyze tab
Green marked area is used for getting the pivot chart and recommended pivot chart.

Black marked area is used to give the pivot table a name.

In the red marked area, you can see your pivot table active fields name.

How to create slicer and timeline for pivot table?

Slicer and Insert timeline works as a filter. In the table, you have another two-column ranking and date. Only the DateTime column can be used for the timeline and any type of column can be used for the slicer. In the image, the ranking column is taken as a slicer and selected column(ranking) unique values will be the options of the slicer. In the image, you can see three options in the slicer because there are three unique values in the ranking column. For the timeline, all the unique dates of date columns will be the options of the timeline. Now if you click on 1 then only those values will show in the pivot table which is related to rank 1. If you click on 2 then only those values will be displayed which are related to rank 2. For timeline, same thing will happen
To create slicer and timeline just click on that option then select column and then click ok.

How to create slicer for the database?

Now if you want a slicer for the database then first convert the data into a table. You can do this in home menu where you have table format option or by clicking on the insert menu table option. After making the table if you click on the table a new design tab will appear. Go there and click on the slicer.