Introduction

The Insert Tab in Microsoft Excel provides tools for adding different types of objects and elements to a worksheet. These options help users create professional reports, presentations, dashboards, charts, tables, and data-based documents.

Using the Insert options, you can add:

• Tables
• PivotTables
• Pictures
• Shapes
• Icons
• SmartArt
• Charts
• Sparklines
• Text Boxes
• WordArt
• Links
• Headers & Footers
• Symbols

Note: The exact options may vary slightly depending on the Excel version.

---

1. Insert Tab Overview

The Insert Tab is available on the Excel Ribbon.

Common groups include:

---

2. Insert Table

An Excel Table converts a normal data range into an organized and interactive table.

Example

Steps

1. Select the data range.
2. Go to Insert → Table.
3. Confirm the selected range.
4. Select My table has headers if applicable.
5. Click OK.

Benefits

• Automatic filters
• Professional formatting
• Easy sorting
• Automatic expansion
• Structured references
• Easy data management

---

3. PivotTable

A PivotTable is used to summarize and analyze large amounts of data quickly.

Example

Suppose a training institute has thousands of student records. A PivotTable can show:

• Number of students per course
• Total fees collected
• Students by city
• Average marks by course
• Course-wise performance

Steps

1. Select the source data.
2. Go to Insert → PivotTable.
3. Select the table/range.
4. Choose where to place the PivotTable.
5. Click OK.
6. Drag fields into:
   • Rows
   • Columns
   • Values
   • Filters

Example

Course → Rows

Student Name → Values

This can show the number of students enrolled in each course.

---

4. Insert Pictures

Pictures can make an Excel worksheet more attractive and easier to understand.

Uses

Pictures can be added for:

• Company logos
• Product images
• Course-related images
• Certificates
• Reports
• Project documentation

Steps

1. Go to Insert → Pictures.
2. Select the picture source.
3. Choose the image.
4. Click Insert.
5. Resize or reposition the picture.

Picture Formatting

After selecting a picture, you can usually:

• Crop
• Resize
• Rotate
• Add borders
• Apply picture styles
• Adjust brightness
• Remove background, where supported

---

5. Insert Shapes

Shapes are useful for creating diagrams, flowcharts, buttons, and visual explanations.

Common Shapes

• Rectangle
• Circle
• Triangle
• Arrow
• Line
• Callout
• Flowchart shapes

Example

You can create a computer process diagram:

Input → Processing → Output → Storage

Steps

1. Go to Insert → Shapes.
2. Select a shape.
3. Drag it onto the worksheet.
4. Resize it.
5. Type text inside the shape.
6. Format it as required.

---

6. Insert Icons

Icons are small graphical symbols that can improve the visual appearance of reports and dashboards.

Examples include:

• Computer
• People
• Telephone
• Email
• Location
• Calendar
• Money
• Education

Steps

1. Go to Insert → Icons.
2. Search for an icon.
3. Select the required icon.
4. Click Insert.
5. Resize and position it.

---

7. SmartArt

SmartArt is used to represent information visually.

It is useful for creating:

• Processes
• Hierarchies
• Cycles
• Lists
• Relationships
• Organizational structures

Example

For an education institute:

Admission → Training → Practical → Assessment → Certificate

Steps

1. Go to Insert → SmartArt.
2. Select a category.
3. Choose a SmartArt design.
4. Enter the required information.
5. Format the SmartArt.

---

8. Insert Charts

Charts represent numerical data graphically.

They make data easier to understand and compare.

Common Chart Types

---

Column Chart

A Column Chart displays values using vertical columns.

Example

A column chart can visually compare student enrollment.

---

Line Chart

A Line Chart is useful for showing changes over time.

Example

Monthly admissions:

January → 20
February → 28
March → 35
April → 42

A line chart can show the increasing or decreasing trend.

---

Pie Chart

A Pie Chart displays data as portions of a whole.

For example:

• ADCA – 40%
• DCA – 25%
• Tally – 20%
• Excel – 15%

---

9. Recommended Charts

In many Excel versions, Recommended Charts suggests suitable chart types based on the selected data.

Steps

1. Select your data.
2. Go to Insert → Recommended Charts.
3. Review the suggestions.
4. Select a chart.
5. Click OK.

This is useful for beginners who are unsure which chart type to choose.

---

10. Sparklines

Sparklines are small charts displayed inside individual cells.

They are useful for quickly showing trends without creating a large chart.

Types

• Line
• Column
• Win/Loss

Example

Steps

1. Select the destination cell.
2. Go to Insert → Sparklines.
3. Select the type.
4. Select the data range.
5. Click OK.

---

11. Insert Hyperlink

A hyperlink allows you to connect a worksheet to:

• Websites
• Files
• Email addresses
• Another location in the workbook

Example

You can create a cell containing:

Visit DSD Education Website

and connect it to your institute’s website.

Steps

1. Select a cell.
2. Go to Insert → Link.
3. Enter or select the destination.
4. Click OK.

Shortcut

Ctrl + K

---

12. Text Box

A Text Box allows you to place text anywhere on a worksheet.

Uses

• Report headings
• Notes
• Instructions
• Dashboard labels
• Important information

Steps

1. Go to Insert → Text Box.
2. Draw the text box.
3. Enter your text.
4. Resize and format it.

---

13. Header and Footer

Headers and footers allow you to place information at the top or bottom of printed worksheets.

Common Information

• Company name
• Report title
• Date
• Page number
• File name
• Author name

Steps

1. Go to Insert → Header & Footer.
2. Select the header or footer area.
3. Enter the required information.
4. Use the available options to insert page numbers, dates, or file information.

---

14. WordArt

WordArt creates decorative and stylized text.

It can be useful for:

• Report titles
• Project headings
• Certificates
• Dashboard headings

Steps

1. Go to Insert → WordArt.
2. Select a style.
3. Enter your text.
4. Adjust size, position, and formatting.

---

15. Symbols

Excel allows users to insert special characters that may not be available directly on the keyboard.

Examples

• ₹ – Indian Rupee
• © – Copyright
• ® – Registered
• ™ – Trademark
• ± – Plus/Minus
• ° – Degree
• µ – Micro

Steps

1. Go to Insert → Symbol.
2. Select the required symbol.
3. Click Insert.

---

16. Equation

Excel can be used to insert mathematical equations and formulas as formatted objects.

Examples

• Mathematical expressions
• Algebraic equations
• Scientific formulas
• Mathematical symbols

Steps

1. Go to Insert → Equation.
2. Select an available structure or symbol.
3. Enter the required equation.

---

17. Insert Objects

Depending on the Excel version, Object options can allow you to embed or link content from another application.

Examples may include:

• Word documents
• Other spreadsheets
• PDFs or other supported objects

This can be useful when preparing professional reports that contain supporting documents.

---

Practical Example: Student Performance Report

Create a worksheet named:

Student Performance Report

Enter the following data:

Perform the following tasks:

1. Convert the data into an Excel Table.
2. Create a PivotTable showing students by course.
3. Insert a Column Chart showing student marks.
4. Insert a Pie Chart showing course distribution.
5. Add a Text Box containing the report title.
6. Insert an institute logo or suitable picture.
7. Add a relevant Shape.
8. Create a SmartArt showing the learning process.
9. Add a Hyperlink to the institute website.
10. Insert Header & Footer.
11. Add a suitable WordArt heading.
12. Insert the ₹ symbol where required.
13. Save the workbook as:

ADCA_Excel_Insert_Options.xlsx

---

Practical Activity

Project: Excel Professional Report

Create a professional Student Performance Dashboard using Excel.

Your dashboard should contain:

• Student data table
• PivotTable
• Column Chart
• Pie Chart
• At least one Sparkline
• Shapes
• Icons
• Text Box
• Hyperlink
• Report heading
• Header and Footer

The final worksheet should be clean, readable, and suitable for presenting to a teacher or organization.

---

Learning Outcomes

After completing this lesson, students will be able to:

• Use the Excel Insert Tab.
• Create and format Excel Tables.
• Create basic PivotTables.
• Insert and customize charts.
• Use Pictures, Shapes, Icons, and SmartArt.
• Create Sparklines.
• Add hyperlinks.
• Insert text boxes and WordArt.
• Add headers and footers.
• Insert symbols and equations.
• Create professional Excel reports and dashboards.