Insert Tab

 Insert Tab

Insert Tab -:

1 Tables

2 Illustrations

3 Add-ins

4 Charts

5 Tours

6 Sparklines

7 Filters

8 Links

9 Text

10 Symbols

Tables -:

1 Pivot Table -; A Pivot Table is used to summarise, sort, reorganize, group, count, total or average data stored in a table.

2 Recommended -: Want us to recommend a Pivot Table that summarizes your complex data click a button to get a customized set of the pivot table that we think will best suit your data

3 Table -: Excel tables shouldn't be confused with the data tables that are part of a suite of What-If Analysis commands (Data Tools, on the Data tab). See Introduction to What-If Analysis for more information.

illustrations -:

1 Picture -: If needed, you can copy worksheet data, charts, or objects and paste them as a static. picture anywhere in a worksheet or chart. You can also paste data that you copied from another program and paste it as a picture in Microsoft Office Excel.

2 Online Pictures -: The Online Pictures dialog box enables you to use Microsoft's Bing search engine to search the entire web for 2-D images to use in your Excel sheet.

3 Shapes -: Insert read-made shapes such as circles squares and arrows.

4 Smart Graphics -: A SmartArt graphic is a visual representation of your information and ideas. You create one by choosing a layout that fits your message. Some layouts (such as organization charts and Venn diagrams) portray specific kinds of information, while others simply enhance the appearance of a bulleted list.

5 Screenshot -: Screenshots are useful for capturing snapshots of programs or windows that you have open on your computer. When you click the Screenshot button, open program windows are displayed as thumbnails in the Available Windows gallery. You can insert the whole program window, or use the Screen Clipping tool to select part of a window. Only windows that have not been minimized to the taskbar can be captured. 

Add-ins -:

1 Store

2 My Add-ins