Excel 2010: Inserting Objects

• This document contains study notes on inserting objects in Microsoft Excel 2010.
• It includes topics such as inserting tables, illustrations, charts, links, text, and symbols.
• It also includes a set of questions related to the chapter, to check the understanding of the concepts.

Insert Tab

• The Insert Tab contains commands and features to insert and format objects.
• These objects include tables, pictures, shapes, charts, diagrams, links, text boxes, equations, and symbols.
• The Insert Tab includes the following groups such as Tables, Illustrations, Charts, Sparklines, Links, Filter, Text, and Symbols.

Tables Group

• The Tables group includes commands for inserting and working with tables in Excel.
• This group includes commands such as PivotTable, Table.
• A PivotTable is an interactive Excel report used to summarize and analyze data from various sources.
• You create a PivotTable by selecting data and choosing PivotTable from the Tables group.
• The PivotTable report helps in summarizing, analyzing, discovering, and presenting data.
• A PivotChart can display data from a PivotTable in a visually convenient way and shows comparisons.
• Use a PivotTable when you want to analyze related totals and when you need to analyze a large list of data.

Creating a PivotTable

• Select the range of cells containing the data.
• Go to the Insert tab, in the Tables group, click PivotTable.
• In the "Choose the data that you want to analyze" section, make sure "Select a table or range" is selected.
• Verify the cell range to use, which Excel usually selects automatically.
• In the "Choose where you want the PivotTable report to be placed" section, determine a location.
• To place the PivotTable in a new worksheet, click New Worksheet.
• To place it in an existing worksheet, choose Existing Worksheet and specify the cell range.

PivotTable Chart

• PivotChart is a chart that provides interactive data analysis.
• The display of data can be changed, different levels of detail can be viewed.
• The formatting of the chart can be reorganized by dragging fields or by displaying or hiding items.
• You can automatically create a PivotChart when you create a PivotTable for the first time.
• A PivotChart can be created from an existing PivotTable.

PivotTable Example

• Select a cell within the PivotTable.
• Go to the PivotTable Tools Options tab, in the Tools group, click PivotChart.

Adding and Removing Fields in a PivotTable.

• To place a field in the default area, select the check box next to the field name in the Field Section.
• Non-numeric fields are added to the Row Labels area by default.
• Numeric fields added to the Values area, and hierarchies of dates & times to the Column Labels area.
• To place a field in a specific area, right-click the field name, then choose "Add to Report Filter".
• Add to Column Labels, Add to Row Labels, or Add to Values.
• To drag a field to the desired area, click and drag the field name to an area inside the diagram.

Deleting a PivotTable.

• Click anywhere inside the PivotTable.
• The PivotTable Tools contextual tab becomes available, containing the Options and Design tabs.
• On the Options tab, in the Actions group, click the arrow below Select, then click Entire PivotTable.
• Press Delete.

Illustrations Group

• This group can insert various illustrations such as Pictures, Clipart, Shapes, Charts and Screenshot.
• To insert a picture within the sheet put the mouse at the place you want to but it there.
• Then insert from the illustration group after getting the pointer in place in the sheet.

ClipArt

• To add clipArt go to "Insert" Tab and then Clipart button.
• Then type the name such as "computer" or "travel" and press Go.
• To add desired picture double click the art.

Picture Tools Tab

• When you select a picture or clip art, the Picture Tools Format tab appears.
• It contains commands to modify the appearance and shape of the picture.

Artistic Effects

• Navigate to the effects under the Format option.
• Add after selecting the Clipart.

Text Wrapping

• Text Wrapping makes it easier to wrap text around a picture such as Behind, Across, or Front.
• The default setting is In Line with Text.

Position Picture

• This section changes the position the inserted image.

Format object

• Click on the image with the right mouse button to find it.
• Use this menu to change its size and layouts using the various tabs, then press apply.

AutoShapes

• AutoShapes include lines, drawing lines, arrows, flowcharts, stars, and banners.
• To insert an AutoShape, open the Insert Tab, then the in Illustrations group, click Shapes.
• Click on any shape with the left mouse button, then drag to the worksheet.
• When you select an AutoShape, a drawing tool called Format will appear, containing commands to modify its appearance.

SmartArt

• Colored charts with a set of prepared shapes to read info easier.
• From insert illustration, "SmartArt" will show possible options to draw.

Charts Group

• Charts group helps to show relations between edits with diagrams.
• This is done using the Excel worksheet.
• This helps mostly with statistical operations, with the commands in diagram form.
• Insert Tab - Charts is used to select which diagram to use.

Example Charts representation between two variables.

• Enter variables like months in column A and maximum temperatures in B.
• Select columns with data and from insert charting pick what type of graph to use for a visual aid.
• Clicking a chart opens the designer set of tools for axis etc.

Inserting Hyperlink

• A Hyperlink is a process of connecting content within the workbook to a webpage.
• You can link to a place in the same document to another workbook or a file.
• Select the text you want to be a link, insert-> links-> Hyperlink, and a window will open up.

Multiple Hyperlink Options

• Existing file of webpage sets a link to webpage.
• Link to location in the same sheet.
• Create a new document.
• Set an Address that will link to a existing email.

Shape Effects

• Under shapes many can be used as quick edits, with lots to pick.

Remove Hyperlink

• Right Click the selected text, then click remove hyperlink icon.

Bookmark

• This opens the side tab, you can save locations to get to with ease after long texts.
• Click the location you want this bookmark inserted.
• The the option for bookmark and name.

Text Group

• The text group's commands include insert, header and tail, insert sig, textbox.
• To insert a textbox from the text Tab a select form.
• Then can text and editing of fonts etc.

Header and tail.

• Header is added at top and footer at the base of sheet.
• "When on the footer or header the "Tools ""Header"" shows for editing.

WordArt

• Improves face. And puts design.
• With shadows and changeable fonts.

Signature Line

• Inserts and provides identification who made.
• Can be found under the test Tab.

Inserting objects

• From program such as powerpoint.

Symbols

• In order to use math edits use insert>symbol.
• The equation tool is included with the program too.
• Not only equations but other special letters.