Microsoft Office

Insert Tab in MS Excel

Insert-tab-in-ms-excel: In Ms Excel, click the Insert tab and you will see the command buttons, you will use whenever you want to insert tables, images, pictures,  online pictures, charts, headers and footers and page numbers to your worksheet.

Insert Tab in MS Excel

There are following groups appear on a insert tab in MS Excel :

  1. Tables Group
  2. Illustrations Group
  3. Apps Group
  4. Charts Group
  5. Sparklines Group
  6. Filter Group
  7. Links Group
  8. Text Group
  9. Symbols Group

Tables Group

Tables Group

This group of tool is used to manipulate the table in the worksheet and using Pivot table.

Pivot Table

Pivot table report is an interactive way to quickly summarize large amounts of data. This report is also used to analyze numerical data in depth and to answer unanticipated questions about your data.

Pivot Chart

Pivot Chart report is used to visualise this summary data in a pivot table report and to easily see comparisons, patterns and trends.

Both a Pivot Table report and a Pivot Chart report enables you to make informed decisions about critical design data in your enterprise.

Steps for creating Pivot table and Pivot chart report :

  1. Select a cell in a range of cells; Make sure that the range of cells has column headings.
  2. Go Insert tab, Select Pivot Table from the tables group, again select Pivot table or Pivot chart.
  3. The Create Pivot Table dialog box is displayed.
  4. If we want to display the report/pivot chart in new worksheet then select New Worksheet.
  5. Then we can see the msg ” To build a report, choose fields from the pivot table field list. Checked the field which you want in a pivot table report.
  6. If you select Pivot Chart in the tables group from Insert tab then following pivot chart report will appear on your screen.
Recommended Pivot Table

If you want Excel to recommend Pivot Table that summarize your complex data.

Click this button to get a customized set of Pivot Table that excel think will best suit your data.

Table (Ctrl+T)

Create a table to manage and analyze related data.

Tables make it easy to sort, filter, and format data within a sheet.

Illustration Groups

Illustration as per the contains the command used to insert picture, Clip Art, Shapes and SmartArt etc.

Illustration Group
Picture

With the help of this option, we can insert a picture in our worksheet.

Clip Art

Insert Clip Art into the documents, including drawings, movies, sounds, or stock photography to illustrate a specific concept.

Shapes

Insert ready-made shapes such as rectangles and circles, arrows, lines, flowchart symbols and callout.

Smart Art

Insert a SmartArt graphics to visually communicate information.

SmartArt graphics range from graphical lists and process diagrams to more complex graphics such as Venn diagrams and organisation charts.

Screenshot

Insert a picture of any program that is not minimized to the taskbar.

Click Screen Clipping  to insert a picture of any part of the screen.

Apps for Office

Apps Group

Insert an app into your document and use the web to enhance your work.

Charts Group

You can create different type of chart using Excel that will help you to analyse data in a worksheet and give you a visual presentation of results. You can even customize the chart by adding text, arrows, titles and legends, etc.

Excel can draw 11 types of chart. It gives you option for representing data most effectively using any of these types of chart. Each of the chart types have several sub-types. Many chart types may also have 3D sub-types.

Chart Group
  • Column
  • Line
  • Pie
  • Bar
  • Area
  • XY ( Scatter)
  • Stock
  • Surface
  • Doughnut
  • Bubble
  • Radar

Sparklines Group

Sparklines Group

 Sparklines are mini charts placed in single cells, each representing a row of data in your selection.

There are three types of Sparklines in Excel :

  • Line Sparkline
  • Column Sparkline
  • Win/Loss Sparkline

Filter Group

Filter group is used for slice filter and timeline. In Excel 2010 slicers were added as a new way to filter Pivot Table data. In Excel 2013 and 2016 you can also create slicers to filter your table data.

Filter Group
Slicer

Use a slicer to filter data visually.

Slicer make it faster and easier to filter Tables, Pivot Tables, Pivot Charts and cube functions.

Timeline

Use a timeline to filter dates interactively.

Timelines makes it faster and easier to select time periods in order to filter Pivot Charts, Pivot Tables, and cube functions.

Links Group

Links Group

Links Group is used for linked another file with the excel worksheet.

Hyperlink (Ctrl+K)

Hyperlink is a shortcut, coloured, underlined text or a graphic that specifies the link to a location that is stored on a web, word or any other location. When we click this link, their specified while would open automatically.

Text Group

Text Group

These groups of commands are used to manipulate the word in the cell of the worksheet like Header & Footer, Word Art, Symbol, Signature Line and object etc.

Text Box

By using this option, you can draw a text box anywhere you want.

Header & Footer

The content of the header and footer repeats at the top and bottom of each printed page.

This is useful for showcasing info, such file name, date and time.

Word Art

We can add some artistic flair using a Word Art text box.

Signature Lines

Insert a signature line that specifies the individual who must sign.

Inserting a digital signature requires that you obtain a digital ID, such as one from a certified Microsoft partner.

Object

Embedded objects are documents or other files inserted into this document. Instead of having separate files, sometimes it is easier to keep them all embedded in a document.

Symbols Group

Symbols Group

Symbol Group is used for insert some mathematical equations and symbols which is not available on your keyboard.

Equation

Add common mathematical equations to your document such as the area of circle or the quadratic formula.

You can also build your own equations using the library of math symbols and equations.

Symbol

Add symbols that are not on your keyboard.

Choose a variety of options including mathematical, currency and copyright symbols.

You can also join us at QUORA and PINTEREST

About the author

Pooja Rastogi

Leave a Comment