Insert tab in Excel With Videos

We use Insert tab to insert the picture, charts, filter, hyperlink etc. We use this option to insert the objects in Excel. To open the insert tab, press shortcut keys Alt+N.

Under the Insert tab, we have 10 groups:-


image 1










a)    Tables: –

We use this substitute to partner taking place the in doings table, Pivot table and recommended table. Pivot table is used to make the summary of description behind the built-in adding going on, and we have marginal to create our own tally. Tables create it easy to sort, filter and format the data within a sheet. This other is along with having recommended table that means going regarding for the basis of data, we can just proceed taking place the table as per the Excels guidance.

image 3






b)    Illustration: –

We use this option to insert the Pictures, Online Pictures, Shapes, SmartArt and Screenshot. It means if we want to insert any image, we can use Illustration feature.

image 4






c)     Apps: – We use this option to insert an app into the document and, in order to enhance the functionality, we can use web option.



d)    Charts: –

Charts is very important and useful function in Excel. In excel, we have different and good numbers of readymade chart options.  We have 8 types of different charts in Excel:- Column, Bar, Radar, Line, Area, Combo, Pie and Bubbles chart. We can insert Pivot chart as well as Recommended chart, and if we don’t know which chart we should insert for the data, we can use this option to fulfil the requirement.

image 6





e)    Reports: –

We use this option to create a better report on the basis of the decisions we take for business. It makes the report more  interactive and decipherable.



f)    Sparklines: –

Sparkline is a very tricky and useful option added by Microsoft Excel. On the basis of a range, it can visualize the trends in a single cell as charts. We have 3 different types of cell charts:- Line, Column and Win/Loss chart.

image 8







g)    Filters: –

We use this marginal to filter data visually and filter dates interactively. We have 2 options: Slicers and Timeline. We use Slicer to make the rapid and easier to filter tables, Pivot tables, Pivot Charts and cube functions. Timeline makes it faster and easier to pick period periods in order to filter Pivot Tables, Pivot Charts and Cube accomplish.

image 9









h)    Links: –

  • We use this option to create the link in the document for the quick access to webpage and files.
  • We can also use it to access different locations  in the document.

image 10








i)     Text: –

We use this another to adding happening occurring the Text bin, Header and Footer, Word art, Signature and objects. We append Text bin to write something in the image format. We use Header and Footer options to place the content on the subject of the peak and bottom of the page. Word art makes the text stylish. Insert the Add Signature Lines that specify the individual who is supposed to sign it. And intention jarring works for embedded objects, behind documents or tally files we have inserted into the document.

image 11






j)     Symbols: –

We use this option to complement the symbols and equation. Equation is used to put in the common mathematical equations to your document and afterward we can fee equation by using the mathematical symbols. We use Symbols to include the symbols which are not upon the keyboard and, to make the equation, we use the symbols from here.

image 12












Share This Post

Leave a Reply

Your email address will not be published.