Excel - Insert TAB PDF

Preview

Summary

IT Excel tab...

Description

INSERT TAB ICON

NAME

SHORTCUT

DESCRIPTION Easily arrange and summarize complex data in a PivotTable.

PIVOT TABLE

N/A

RECOMMENDED PIVOTTABLE

N/A

FYI: You can doubleclick a value to see which detailed values make up the summarized total. Want us to recommend PivotTable that summarized your complex data? Click this button to get a customized set of PivotTables that we think will best suit your data. Create a table to organize and analyzed data.

TABLE

PICTURES

CTRL + T

N/A

N/A ONLINE PICTURES

SHAPES

N/A

Tables make it easy to sort, filter, and format data within a sheet Insert pictures from your computer or from other computers that you’re connected to. Find and insert pictures from a variety of online source. Insert ready – made, such as circles, squares and arrows. Insert a SmartArt graphic to visually communicate information.

SMARTART

N/A

SCREENSHOT

N/A

APPS FOR OFFICE

N/A

RECOMMENDED CHARTS

N/A

INSERT COLUMN CHART

INSERT BAR CHART

SmartArt graphic range from graphical list and process diagram to more complex diagram, such as Venn diagram and organization charts. Quickly add a snapshot of any window that’s open on your desktop to your document. Insert an app into your document and use the web to enhance your work. Want us to recommend a good chart to showcase your data? Select data in your worksheet and click this button to customized set of charts we think will fit best with your data. Use this chart type to visually compare values across a few values.

N/A

N/A

Click the arrow to see the different types of column charts available and pause the pointer on the icons to see a preview in your document. Use this chart type to visually compare values across a few categories when the chart shows duration or category text is long.

INSERT STOCK, SURFACE OR RADAR CHART

N/A

INSERT LINE CHART

N/A

INSERT AREA CHART

N/A

Click the arrow to see the different types of bar charts available and pause the pointer on the icons to see a preview in your document. Click the arrow to see the different types of stock, surface or radar charts available and pause the pointer on the icons to see a preview in your document. Use this chart type to show trends over time (years, month or days) and categories. Click the arrow to see the different types of line charts available and pause the pointer on the icons to see a preview in your document. Use this chart type to show trends over time (years, month or days) and categories. Use it to highlight the magnitude of change over time Click the arrow to see the different types of area charts available and pause the pointer on the icons to see a preview in your document. Use this chart type to highlight different types of information. Use it when the range of values in the chart varies widely or you have

INSERT COMBO CHART

INSERT PIE OR DOUGHNUT CHART

N/A Click the arrow to see the different types of column charts available and pause the pointer on the icons to see a preview in your document. Use this chart type to visually compare values across a few values. N/A

INSERT SCATTER (X, Y) OR BUBBLE CHART

N/A

PIVOTCHART

N/A

LINE SPARKLINE

N/A

COLUMN SPARKLINE

N/A

Click the arrow to see the different types of column charts available and pause the pointer on the icons to see a preview in your document. Use this chart type to visually compare values across a few values. Click the arrow to see the different types of column charts available and pause the pointer on the icons to see a preview in your document. Use PivotChart to graphically summarized data and explore complicated data. Sparkline are mini charts placed in single cells, each represents a row of data in your selection. Sparkline are mini charts placed in single cells, each represents a row of

data in your selection. Sparkline are mini charts placed in single cells, each represents a row of data in your selection Use a slicer to filter data visually.

WIN/LOSS SPARKLINE

N/A

SLICER

N/A

Slicer make it faster and easier to filter Table, PivotTable, PivotChart and cube function. Use a Timeline to filter dates interactively.

N/A

Timeline make it faster and easier to select time periods in order to filter Table, PivotTable, PivotChart and cube function. Create a link in your document for quick access to webpages and files.

TIMELINE

HYPERLINK

CTRL + K

TEXTBOX

N/A

HEADER & FOOTER

N/A

Hyperlinks can also take you to places in your document. Draw a text box anywhere. The content of the header and footer repeats at the top and bottom of each printed page.

N/A

This is useful for showcasing info, such as file name, date and time. Add some artistic flair to your document

WORDART

using a WordArt text box. Insert a signature line that specifies the individual who must sign. SIGNITURE LINE

N/A

OBJECT

N/A

EQUATION

N/A

Inserting a digital signature requires that you obtain a digital ID, such as one from a certified Microsoft partner. Embedded object are document or other files you have inserted into this document. Instead of having a separate file, sometimes it’s easier to keep them all embedded in a document. Add common mathematical equations to your document, such as the area of a circle or the quadratic formula. You can also build your own equation using the library of math symbols and structure. Add symbols that are not on your keyboard.

SYMBOL

N/A

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