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.
There are following groups appear on a insert tab in MS Excel :
- Tables Group
- Illustrations Group
- Apps Group
- Charts Group
- Sparklines Group
- Filter Group
- Links Group
- Text Group
- Symbols Group
This group of tool is used to manipulate the table in the worksheet and using 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 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 :
- Select a cell in a range of cells; Make sure that the range of cells has column headings.
- Go Insert tab, Select Pivot Table from the tables group, again select Pivot table or Pivot chart.
- The Create Pivot Table dialog box is displayed.
- If we want to display the report/pivot chart in new worksheet then select New Worksheet.
- 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.
- 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.
Create a table to manage and analyze related data.
Tables make it easy to sort, filter, and format data within a sheet.
Illustration as per the contains the command used to insert picture, Clip Art, Shapes and SmartArt etc.
With the help of this option, we can insert a picture in our worksheet.
Insert Clip Art into the documents, including drawings, movies, sounds, or stock photography to illustrate a specific concept.
Insert ready-made shapes such as rectangles and circles, arrows, lines, flowchart symbols and callout.
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.
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
Insert an app into your document and use the web to enhance your work.
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.
- XY ( Scatter)
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 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.
Use a slicer to filter data visually.
Slicer make it faster and easier to filter Tables, Pivot Tables, Pivot Charts and cube functions.
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 is used for linked another file with the excel worksheet.
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.
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.
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.
We can add some artistic flair using a Word Art text box.
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.
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.
Symbol Group is used for insert some mathematical equations and symbols which is not available on your keyboard.
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.
Add symbols that are not on your keyboard.
Choose a variety of options including mathematical, currency and copyright symbols.