PRACTICAL FILE

“IT SKILS - 2”
CODE: BMB 251

GREATER NOIDA INSTITUTE OF TECHNOLOGY

(MBA INSTITUE)
Greater Noida

SUBMITTED BY SUBMITTED TO
Name: Ayushi singh Dr. Rajat Pratap Singh

Class: MBA (C)

Roll No. 2502720700067

Name: Ghanshyam kr. Gautam

Roll No. 252720700091

(Affiliated to Dr. A.P.J. Abdul Kalam Technical University, Lucknow)

SESSION (2026-2027)

1
 TABLE OF CONTENT

Sr. No Practical Pg. No Sign

1 Create a Pivot Table and Analyze Data Using 3-8
Filters and Grouping
2 Goal Seek – Determine Optimal Price to 9-12
Achieve Target Profit
3 Using Solver to Optimize a Production Plan 13-18
4 Create Named Scenarios and Compare Business 19-24
Cases
5 Data Validation in Excel 25-29
6 Trace Precedents and Dependents in Excel 30-32
7 Identify Missing Dependents in Excel 33-35
8 Create a Simple Application in Spreadsheet 36-38
9 Record and Run a Macro to Automate a 39-42
Repetitive Task
10 Create a Column Chart to Visualize Sales Data 43-45
11 Create a Line Chart to Show Trend Analysis 46-48
12 Create a Pie Chart to Visualize Market Share 49-51

2
 Practical No 1
Create a Pivot Table and Analyze Data Using Filters and Grouping

1. Objective

To learn how to create a Pivot Table in Microsoft Excel and analyze data using filters and grouping.

2. Brief Explanation / Theory

A Pivot Table is a powerful feature in Microsoft Excel that allows users to summarize, analyze,
explore, and present large amounts of data quickly.

Instead of manually calculating totals or averages, a pivot table can automatically organize data into
categories and provide insights.

Key features of a Pivot Table include:

● Rows and Columns: Used to categorize data.

● Values: Used to perform calculations like Sum, Count, or Average.

● Filters: Used to display only specific data.

● Grouping: Used to group similar data such as months, years, or categories.

Pivot tables are commonly used in business analytics, sales reports, financial analysis, and data
summarization.

3. Requirements / Tools

● Computer or Laptop
● Microsoft Excel

● Dataset (example: sales dataset)

Example Dataset Structure:

Order ID Region Product Sales Month

101 North Laptop 50000 Jan

102 South Mobile 20000 Feb

103 North Tablet 15000 Mar

104 East Laptop 45000 Jan

105 West Mobile 30000 Feb

3
4. Step-by-Step Practical Implementation

Step 1: Enter the Dataset

1. Open Microsoft Excel.

2. Enter the dataset in rows and columns.

3. Ensure each column has a header name.

Step 2: Select the Data

1. Select the entire dataset including headers.

2. Go to the Insert tab in Excel.

4
Step 3: Create the Pivot Table

1. Click PivotTable in the Insert menu.

2. A dialog box will appear.

3. Select New Worksheet.

4. Click OK.

A blank Pivot Table and Pivot Table Fields panel will appear.

Step 4: Add Fields to Pivot Table

Drag the fields into the following areas:

● Rows: Region

● Columns: Product
● Values: Sales (set to Sum of Sales)

The pivot table will automatically calculate total sales for each product in each region.

Example Output:

Region Laptop Mobile Tablet

North 50000 0 15000

South 0 20000 0

East 45000 0 0

5
5. Using Filters

Filters allow users to display only selected data.

Steps:

1. Drag the Month field into the Filters area.

2. A filter dropdown will appear above the pivot table.

3. Select a specific month (e.g., January).

Now the pivot table will show sales data only for January.

6
6. Grouping Data

Grouping helps combine similar data for better analysis.

Example: Grouping Months

Steps:

1. Add Month to the Rows section.

2. Select the months in the pivot table.

3. Right-click on the selected months.

4. Click Group.

Excel will group months into quarters or custom groups.

Example grouped result:

Quarter Total Sales

Q1 85000

Q2 50000

7
8
7. Result

A pivot table was successfully created in Microsoft Excel, allowing quick analysis of sales data using
rows, columns, filters, and grouping.

8. Conclusion

Pivot Tables help users summarize large datasets efficiently and make data analysis faster and
easier. By using filters and grouping, users can quickly explore different patterns and insights from
the data.

9
 Practical No 2
Goal Seek – Determine Optimal Price to Achieve Target Profit

1. Objective

To learn how to use the Goal Seek feature in Microsoft Excel to determine the optimal selling price
of a product in order to achieve a specific target profit.

2. Brief Explanation / Theory

Goal Seek is a What-If Analysis tool available in Microsoft Excel. It helps users find the required
input value that will produce a desired result in a formula.

Instead of manually changing numbers many times, Goal Seek automatically adjusts a selected input
value until the target result is achieved.

In business analytics, Goal Seek is often used for:

● Finding the price required to achieve a target profit

● Determining sales quantity required to reach revenue goals

● Calculating break-even points

In this practical, Goal Seek will help determine what price should be set for a product to achieve a
specific profit.

3. Requirements / Tools

● Computer or Laptop
● Microsoft Excel

Example Data:

Item Value

Cost per Unit 500

Units Sold 100

Selling Price 700

Total Revenue

Total Cost

Profit

4. Step-by-Step Practical Implementation

10
Step 1: Enter the Data

Open Microsoft Excel and enter the following values:

A B

Cost per Unit 500

Units Sold 100

Selling Price 700

Total Revenue =B2*B3

Total Cost =B1*B2

Profit =B4-B5

Explanation:
● Revenue = Units Sold × Selling Price
● Total Cost = Cost per Unit × Units Sold

● Profit = Revenue – Cost

Step 2: Identify Target Profit

Assume the business wants to achieve a target profit of ₹40,000.

Currently, profit may be lower depending on the price.

Step 3: Open Goal Seek

1. Click the Data tab in Excel.

2. Select What-If Analysis.

3. Click Goal Seek.

11
A dialog box will appear.

Step 4: Set Goal Seek Parameters

Fill the Goal Seek dialog box as follows:

● Set Cell: Profit cell (B6)
● To Value: 40000
● By Changing Cell: Selling Price (B3)

Then click OK.

Step 5: Excel Calculates Optimal Price

Excel will automatically change the Selling Price value until the Profit becomes ₹40,000.

Example result:

Item Value

Cost per Unit 500

Units Sold 100

Selling Price 900

Profit 40000

This means the product must be sold at ₹900 per unit to achieve a profit of ₹40,000.

12
5. Result

Using Goal Seek in Microsoft Excel, the optimal selling price required to achieve the target profit
was successfully determined.

6. Conclusion

Goal Seek is a useful analytical tool that helps businesses determine required inputs for desired
financial outcomes. It simplifies decision-making by automatically calculating the values needed to
reach specific targets such as profit, revenue, or sales goals.

13
 Practical No 3
Using Solver to Optimize a Production Plan

1. Objective

To learn how to use the Solver tool in Microsoft Excel to determine the optimal production
quantity of products while considering constraints such as labor hours and material availability.

2. Brief Explanation / Theory

Solver is an advanced optimization tool in Microsoft Excel that helps find the best possible solution
for decision problems involving multiple variables and constraints.

Solver works by adjusting selected input values to maximize or minimize a target value, such as
profit or cost, while satisfying certain limitations.

In production planning, Solver helps businesses decide:

● How many units of each product to produce
● How to maximize profit
● While ensuring resources like labor and raw materials are not exceeded

Components used in Solver:

● Objective Cell: The value to maximize or minimize (e.g., total profit)

● Variable Cells: Decision variables (e.g., number of units produced)
● Constraints: Limits on resources (e.g., labor hours, materials)

3. Requirements / Tools
● Computer or Laptop
● Microsoft Excel

● Solver Add-in enabled

To enable Solver:

1. Go to File → Options → Add-ins

2. Select Excel Add-ins

3. Check Solver Add-in

4. Click OK

14
4. Example Dataset

Product Profit per Unit Labor Hours per Unit Material per Unit Units to Produce

Product A 50 2 3 ?

Product B 40 1 4 ?

Resource Limits:

Resource Available

Total Labor
100
Hours

Total Material 120

5. Step-by-Step Practical Implementation

Step 1: Enter Data in Excel

Open Microsoft Excel and enter the dataset as shown above.

Create formulas:

Total Profit

= (ProfitA * UnitsA) + (ProfitB * UnitsB)

Example formula:

=B2*E2 + B3*E3

Step 2: Calculate Resource Usage

Total Labor Used

=(LaborA * UnitsA) + (LaborB * UnitsB)

Example:

=C2*E2 + C3*E3

Total Material Used

15
=(MaterialA * UnitsA) + (MaterialB * UnitsB)

Example:

=D2*E2 + D3*E3

6. Step 3: Open Solver

1. Go to Data Tab

2. Click Solver

Solver Parameters window will open.

7. Step 4: Set Solver Parameters

Fill the parameters as follows:

Set Objective

● Select the Total Profit cell

● Choose Max

By Changing Variable Cells

● Select the Units to Produce cells

16
8. Step 5: Add Constraints

Click Add and enter the constraints:

1⃣La□bor Constraint

Total Labor Used ≤ 1 00

2⃣M□
aterial Constraint

Total Material Used ≤ 1 2 0

3 ⃣N □
o n - negative production

Units ≥ 0

Click OK.

17
9. Step 6: Solve the Model

1. Click Solve.

2. Excel will calculate the optimal production quantities.

Example Output:

18
Product Units to Produce

Product A 40

Product B 0

Maximum Profit = ₹2000

10. Result

Using the Solver tool in Microsoft Excel, the optimal production plan was calculated while
considering labor and material constraints.

11. Conclusion

Solver is a powerful optimization tool that helps organizations make better production and resource
allocation decisions. It allows businesses to maximize profit while efficiently utilizing limited
resources.

19
 Practical No 4
Create Named Scenarios and Compare Business Cases

1. Objective

To learn how to create named scenarios in Microsoft Excel using Scenario Manager and compare
different business cases such as Best Case, Worst Case, and Normal Case.

2. Brief Explanation / Theory

Scenario Manager is a What-If Analysis tool in Microsoft Excel that allows users to create and save
different sets of input values called scenarios.

Each scenario represents a possible business situation. By switching between scenarios, users can
quickly analyze how changes in variables affect the final results.

Businesses often create scenarios like:

● Best Case: Highest sales and profit

● Worst Case: Lowest sales and profit

● Expected Case: Average or normal business situation

Scenario Manager helps decision-makers compare outcomes and plan strategies accordingly.

3. Requirements / Tools
● Computer or Laptop

● Microsoft Excel

Example Business Data:

Item Value

Selling Price 500

Units Sold 100

Cost per Unit 300

Profit

Profit Formula:
Profit = (Selling Price × Units Sold) − (Cost per Unit × Units Sold)

4. Step-by-Step Practical Implementation

Step 1: Enter Data in Excel

20
Open Microsoft Excel and enter the following data:

A B

Selling Price 500

Units Sold 100

Cost per Unit 300

Profit =(B1B2)-(B3B2)

This formula calculates the total profit.

Step 2: Open Scenario Manager

1. Click the Data tab.

2. Select What-If Analysis.

3. Click Scenario Manager.

A Scenario Manager dialog box will appear.

21
Step 3: Create the Best Case Scenario

1. Click Add.

2. Enter Scenario Name: Best Case.

3. In Changing Cells, select:

o Selling Price (B1)

o Units Sold (B2)

4. Click OK.

Enter values for the best business condition:

Variable Value

Selling Price 600

Units Sold 150

Click OK.

22
Step 4: Create the Worst Case Scenario

1. Click Add again.

2. Scenario Name: Worst Case.

3. Select the same changing cells.

Enter values:

Variable Value

Selling Price 400

Units Sold 60

Click OK.

Step 5: Create the Normal Case Scenario

1. Click Add.

23
 2. Scenario Name: Normal Case.

Enter values:

Variable Value

Selling Price 500

Units Sold 100

Click OK.

Step 6: Compare Scenarios

1. Open Scenario Manager.

2. Click Summary.

3. Select the Profit cell as the result cell.

4. Click OK.

Excel will automatically generate a Scenario Summary Report comparing all scenarios.

24
Example Output:

Scenario Selling Price Units Sold Profit

Best Case 600 150 45000

Normal Case 500 100 20000

Worst Case 400 60 6000

7. Result

Different business scenarios were successfully created using Scenario Manager in Microsoft Excel,
and their effects on profit were compared.

8. Conclusion

Scenario Manager helps businesses analyze multiple possible outcomes without changing the
original data repeatedly. It is useful for decision-making, financial forecasting, and risk analysis.

25
 Practical No 5
Data Validation in Excel

1. Objective

To learn how to apply Data Validation in Microsoft Excel to control the type of data entered in a cell
range such as whole numbers, decimals, lists, dates, and time.

2. Brief Explanation / Theory

Data Validation is a feature in Microsoft Excel that restricts the type of data users can enter into a
cell. It helps maintain data accuracy and consistency by preventing incorrect entries.

Using data validation, users can allow only specific types of inputs such as:

● Whole numbers (e.g., 1–100)

● Decimals (e.g., 0.1–10.5)

● Lists (drop-down selections)

● Dates within a specific range

● Time values

Data validation is widely used in forms, surveys, data entry sheets, and business reports.

3. Requirements / Tools
● Computer or Laptop
● Microsoft Excel

Example Data Entry Sheet:

Name Age Salary Department Joining Date Working Time

4. Step-by-Step Practical Implementation

Step 1: Enter Data Fields

Open Microsoft Excel and create the following columns:

● Name
● Age

● Salary
● Department
● Joining Date

26
 ● Working Time

Step 2: Apply Whole Number Validation (Age)

1. Select the Age column cells.

2. Go to the Data tab.

3. Click Data Validation.

4. In the Settings tab, select:

● Allow: Whole Number

● Data: Between
● Minimum: 18
● Maximum: 60

Click OK.

Now only numbers between 18 and 60 can be entered.

27
Step 3: Apply Decimal Validation (Salary)

1. Select the Salary column.

2. Go to Data → Data Validation.

3. Choose:
● Allow: Decimal
● Minimum: 10000

● Maximum: 100000

Click OK.

Now only salary values within this range are allowed.

Step 4: Create List Validation (Department)

1. Select the Department column.

2. Go to Data → Data Validation.

3. Choose:

● Allow: List
● In Source, enter:

HR, Sales, Finance, IT, Marketing

Click OK.

Now a drop-down list will appear in the cell.

28
Step 5: Apply Date Validation

1. Select the Joining Date column.

2. Go to Data → Data Validation.

3. Choose:
● Allow: Date
● Start Date: 01-01-2020

● End Date: 31-12-2030

Click OK.

Now only dates within this range can be entered.

29
Step 6: Apply Time Validation

1. Select the Working Time column.

2. Go to Data → Data Validation.

3. Choose:
● Allow: Time
● Start Time: 09:00 AM

● End Time: 06:00 PM

Click OK.

This ensures only valid working hours are entered.

5. Result

Data Validation rules were successfully applied in Microsoft Excel, restricting user inputs to valid
values such as numbers, lists, dates, and time.

6. Conclusion

Data Validation is an important feature that helps maintain data quality and accuracy in
spreadsheets. It prevents incorrect entries and ensures consistent data input, which is essential for
reliable analysis.

30
 Practical No 6
Trace Precedents and Dependents in Excel

1. Objective

To learn how to use Trace Precedents and Trace Dependents in Microsoft Excel to identify the
relationship between cells used in formulas.

2. Brief Explanation / Theory

In Microsoft Excel, formulas often depend on values from other cells. Excel provides two auditing
tools to understand these relationships:

1. Trace Precedents:
This option shows which cells provide data to the selected formula cell. These cells are called
precedent cells.

2. Trace Dependents:
This option shows which cells use the value of the selected cell in their formulas. These are called
dependent cells.

Excel displays arrows between cells to visually show these relationships. These tools are very useful
for:
● Debugging formulas
● Understanding complex spreadsheets
● Finding errors in calculations

3. Requirements / Tools
● Computer or Laptop

● Microsoft Excel

Example Data:

Product Quantity Price Total

Laptop 2 50000

Mobile 3 20000

Formula for Total:

Total = Quantity × Price

31
4. Step-by-Step Practical Implementation

Step 1: Enter the Data

Open Microsoft Excel and enter the following data:

A B C D

Product Quantity Price Total

Laptop 2 50000 =B2*C2

Mobile 3 20000 =B3*C3

The Total column calculates the product cost.

Step 2: Trace Precedents

1. Select the Total cell (for example D2).

2. Go to the Formulas tab.

3. Click Trace Precedents.

Excel will display arrows pointing from Quantity and Price cells to the Total cell, showing that these
cells are used in the formula.

Example:

B2 →
C2 → D2
This means B2 and C2 are precedent cells for D2.

32
Step 3: Trace Dependents

1. Select a cell used in a formula (for example B2).

2. Go to the Formulas tab.

3. Click Trace Dependents.

Excel will draw arrows showing that cell D2 depends on the value in B2.

Example:

B2 → D2

This indicates D2 is the dependent cell.

Step 4: Remove Arrows

To remove the arrows:

1. Go to the Formulas tab.

2. Click Remove Arrows.

5. Result

Using Trace Precedents and Trace Dependents in Microsoft Excel, the relationships between
formula cells and their referenced cells were successfully identified.

6. Conclusion

Trace Precedents and Dependents are important auditing tools that help users understand and
troubleshoot formulas in Excel spreadsheets. They visually show how cells are connected, making it
easier to identify errors and verify calculations.

33
 Practical No 7
Identify Missing Dependents in Excel

1. Objective

To learn how to identify cells that have no dependent cells (missing dependents) using formula
auditing tools in Microsoft Excel.

2. Brief Explanation / Theory

In Microsoft Excel, a dependent cell is a cell that contains a formula referencing another cell.

Sometimes a cell may contain important data but no other formula uses that data. Such cells are
said to have missing dependents. Identifying these cells helps in:

● Detecting unused or redundant data

● Improving spreadsheet accuracy

● Debugging large spreadsheets

● Optimizing spreadsheet structure

Excel provides the Trace Dependents feature to visually show which cells rely on a selected cell.

If no arrows appear when tracing dependents, it means the selected cell has no dependent cells.

3. Requirements / Tools

● Computer or Laptop

● Microsoft Excel

Example Dataset:

Product Quantity Price Total

Laptop 2 50000

Mobile 3 20000

Tablet 4 15000

Formula:

Total = Quantity × Price

4. Step-by-Step Practical Implementation

Step 1: Enter the Dataset

34
Open Microsoft Excel and enter the following data:

A B C D

Product Quantity Price Total

Laptop 2 50000 =B2*C2

Mobile 3 20000 =B3*C3

Tablet 4 15000 =B4*C4

Step 2: Use Trace Dependents

1. Select a cell that contains data (for example B2 – Quantity).

2. Go to the Formulas tab.

3. Click Trace Dependents.

Excel will draw arrows pointing to cells that depend on the selected cell.

Example:

B2 → D2

This means D2 depends on B2.

Step 3: Identify Missing Dependents

35
 1. Select another cell (for example A2 – Product Name).

2. Click Trace Dependents again.

If no arrows appear, it means:

● The selected cell has no dependent cells

● Its value is not used in any formula

Therefore, this cell has missing dependents.

Step 4: Analyze the Spreadsheet

Review cells with no dependents to determine whether:

● They are necessary data fields, or

● They are unused or redundant data

5. Result

Using the Trace Dependents feature in Microsoft Excel, cells without dependent formulas were
successfully identified.

6. Conclusion

Identifying missing dependents helps improve spreadsheet quality by detecting unused data and
verifying formula relationships. This ensures better data organization and accurate analysis.

36
 Practical No 8
Create a Simple Application in Spreadsheet

1. Objective

To develop a simple application using formulas and functions in Microsoft Excel to automate
calculations and perform basic data analysis.

2. Brief Explanation / Theory

A spreadsheet application can be created in Microsoft Excel by combining formulas, functions, and
data entry fields to automate tasks such as calculating totals, averages, and grades.

Spreadsheet applications are widely used in business for:

● Sales tracking
● Employee salary calculation
● Student result management

● Inventory management

In this practical, we will create a Student Result Calculator Application that automatically calculates
total marks, average marks, and grade.

3. Requirements / Tools

● Computer or Laptop
● Microsoft Excel

Example Data Structure:

Student Name Subject 1 Subject 2 Subject 3 Total Average Grade

4. Step-by-Step Practical Implementation

Step 1: Create the Spreadsheet Layout

Open Microsoft Excel and create the following column headings:

A B C D E F G

Student Name Subject1 Subject2 Subject3 Total Average Grade

Step 2: Enter Student Data

37
Example:

Student Name Subject1 Subject2 Subject3

Rahul 75 80 85

Priya 60 70 65

Aman 90 85 88

Step 3: Calculate Total Marks

Select the Total column (E2) and enter the formula:

=SUM(B2:D2)

Press Enter and drag the formula down for other students.

Step 4: Calculate Average Marks

In Average column (F2) enter:

=AVERAGE(B2:D2)

Copy the formula for other rows.

Step 5: Assign Grade Using IF Function

In Grade column (G2) enter the formula:

=IF(F2>=80,"A",IF(F2>=60,"B","C"))

Explanation:

38
 ● A Grade: Average ≥ 80
● B Grade: Average ≥ 60

● C Grade: Average < 60

Copy the formula for all students.

Step 6: Final Output

Student Name Sub1 Sub2 Sub3 Total Average Grade

Rahul 75 80 85 240 80 A

Priya 60 70 65 195 65 B

Aman 90 85 88 263 87.6 A

The spreadsheet now works like a simple automated application for calculating student results.

5. Result

A simple spreadsheet application was successfully created in Microsoft Excel using formulas such as
SUM, AVERAGE, and IF to automatically calculate totals, averages, and grades.

6. Conclusion

Spreadsheet applications help automate calculations and reduce manual errors. By using formulas
and functions in Microsoft Excel, simple applications can be developed to manage and analyze data
efficiently.

39
 Practical No 9
Record and Run a Macro to Automate a Repetitive Task

1. Objective

To learn how to record and run a Macro in Microsoft Excel in order to automate repetitive tasks
such as formatting data or performing repeated calculations.

2. Brief Explanation / Theory

A Macro in Microsoft Excel is a set of recorded actions that can be executed automatically to
perform repetitive tasks. Instead of repeating the same steps multiple times, users can record a
macro once and run it whenever needed.

Macros are created using the Macro Recorder, which records user actions and converts them into
instructions. These macros are stored using Visual Basic for Applications (VBA).

Macros are commonly used for:

● Formatting large datasets
● Generating reports

● Cleaning and organizing data

● Automating repetitive spreadsheet tasks

3. Requirements / Tools
● Computer or Laptop

● Microsoft Excel

Example Task: Automatically format a dataset by applying bold headings, borders, and column
width adjustments.

4. Step-by-Step Practical Implementation

Step 1: Prepare the Dataset

Open Microsoft Excel and create a simple dataset:

Product Quantity Price Total

Laptop 2 50000

Mobile 3 20000

40
Step 2: Enable the Developer Tab

1. Click File → Options.

2. Select Customize Ribbon.

3. Check Developer.

4. Click OK.

The Developer tab will appear in Excel.

Step 3: Start Recording the Macro

1. Go to the Developer tab.

2. Click Record Macro.

3. Enter:
● Macro Name: FormatData
● Store Macro In: This Workbook

4. Click OK.

Excel will start recording your actions.

41
Step 4: Perform the Actions to Record

While recording:

1. Select the header row.

2. Click Bold formatting.

3. Apply cell borders.

4. Adjust the column width.

5. Apply center alignment.

All these steps are recorded as part of the macro.

Step 5: Stop Recording

1. Go to the Developer tab.

2. Click Stop Recording.

The macro is now saved.

Step 6: Run the Macro

To execute the macro:

42
 1. Go to the Developer tab.

2. Click Macros.

3. Select FormatData.

4. Click Run.

Excel will automatically repeat the recorded formatting steps.

5. Result

A macro was successfully recorded and executed in Microsoft Excel, allowing repetitive formatting
tasks to be performed automatically.

6. Conclusion

Macros are powerful automation tools that help save time and reduce manual effort. By using
macros in Microsoft Excel, repetitive spreadsheet tasks can be automated efficiently.

43
 Practical No 10
Create a Column Chart to Visualize Sales Data

1. Objective

To learn how to create a Column Chart in Microsoft Excel in order to visually represent and compare
sales data.

2. Brief Explanation / Theory

A Column Chart is a graphical representation of data where values are displayed as vertical bars. It is
commonly used to compare different categories such as sales across products, months, or regions.

In Microsoft Excel, column charts help users:

● Understand patterns and trends in data

● Compare performance across categories

● Present information visually in reports and presentations

Column charts are widely used in business analytics, marketing reports, and sales analysis.

3. Requirements / Tools

● Computer or Laptop
● Microsoft Excel

Example Dataset (Sales Data):

Product Sales (₹)

Laptop 50000

Mobile 30000

Tablet 20000

Printer 15000

4. Step-by-Step Practical Implementation

Step 1: Enter the Data

Open Microsoft Excel and enter the sales dataset in two columns:

A B

Product Sales

44
A B

Laptop 50000

Mobile 30000

Tablet 20000

Printer 15000

Step 2: Select the Data

1. Select the entire dataset including the headings (A1:B5).

Step 3: Insert the Column Chart

1. Go to the Insert tab.

2. In the Charts group, click Insert Column or Bar Chart.

3. Choose Clustered Column Chart.

Excel will automatically generate a column chart.

45
Step 4: Customize the Chart

After creating the chart, you can improve its appearance:

1. Add Chart Title → “Product Sales Analysis”.

2. Add Axis Titles:

o X-axis: Product

o Y-axis: Sales Amount

3. Change chart styles or colors if needed.

5. Example Output

The chart will display vertical bars representing sales for each product, making it easier to compare
which product has the highest or lowest sales.

Example interpretation:
● Laptop has the highest sales.
● Printer has the lowest sales.

6. Result

A Column Chart was successfully created in Microsoft Excel to visually represent and compare sales
data.

7. Conclusion

Column charts help transform numerical data into visual information, making it easier to analyze
trends and comparisons. Using charts in Microsoft Excel improves data presentation and decision-
making.

46
 Practical No 11
Create a Line Chart to Show Trend Analysis

1. Objective

To learn how to create a Line Chart in Microsoft Excel in order to visualize trends and changes in
data over time.

2. Brief Explanation / Theory

A Line Chart is a graphical representation where data points are connected by lines. It is commonly
used to show trends or patterns over a period of time, such as monthly sales, stock prices, or
temperature changes.

In Microsoft Excel, line charts help users:

● Identify upward or downward trends
● Analyze performance over time

● Compare changes between different periods

Line charts are widely used in business analytics, financial analysis, and sales forecasting.

3. Requirements / Tools
● Computer or Laptop

● Microsoft Excel

Example Dataset (Monthly Sales Data):

Month Sales (₹)

January 20000

February 25000

March 30000

April 28000

May 35000

4. Step-by-Step Practical Implementation

Step 1: Enter the Data

Open Microsoft Excel and enter the following data:

47
A B

Month Sales

January 20000

February 25000

March 30000

April 28000

May 35000

Step 2: Select the Data

Select the entire dataset including headings (A1:B6).

Step 3: Insert the Line Chart

1. Go to the Insert tab.

2. In the Charts section, click Insert Line or Area Chart.

3. Choose 2-D Line Chart.

Excel will automatically generate a line chart connecting the sales values for each month.

Step 4: Customize the Chart

To improve readability:

1. Add Chart Title → “Monthly Sales Trend”.

48
 2. Add Axis Titles:
o X-axis: Month

o Y-axis: Sales Amount

3. Change chart styles or markers if needed.

5. Example Output

The line chart will display a trend line showing sales changes from January to May.

Example interpretation:

● Sales increased from January to March.

● Slight decrease in April.
● Highest sales recorded in May.

This helps easily understand sales growth trends over time.

6. Result

A Line Chart was successfully created in Microsoft Excel to visualize and analyze the trend of sales
over different months.

7. Conclusion

Line charts are useful tools for trend analysis and time-based comparisons. Using charts in
Microsoft Excel helps present data visually and makes it easier to interpret patterns and trends.

49
 Practical No 12
Create a Pie Chart to Visualize Market Share

1. Objective

To learn how to create a Pie Chart in Microsoft Excel to visually represent the market share of
different products or companies.

2. Brief Explanation / Theory

A Pie Chart is a circular chart divided into slices where each slice represents a proportion or
percentage of the whole. It is mainly used to display percentage distribution of categories.

In Microsoft Excel, pie charts help users:

● Understand the proportion of each category

● Compare contributions of different segments

● Present market share or distribution data visually

Pie charts are commonly used in business analytics, marketing reports, and market share analysis.

3. Requirements / Tools

● Computer or Laptop
● Microsoft Excel

Example Dataset (Market Share of Companies):

Company Market Share (%)

Company A 40

Company B 25

Company C 20

Company D 15

4. Step-by-Step Practical Implementation

Step 1: Enter the Data

Open Microsoft Excel and enter the dataset:

A B

Company Market Share

50
A B

Company A 40

Company B 25

Company C 20

Company D 15

Step 2: Select the Dataset

Select the entire dataset including headings (A1:B5).

Step 3: Insert the Pie Chart

1. Go to the Insert tab.

2. In the Charts section, click Insert Pie or Doughnut Chart.

3. Select 2-D Pie Chart.

Excel will automatically create a pie chart showing the market share distribution.

Step 4: Customize the Chart

Improve the chart appearance by:

1. Adding Chart Title → “Market Share Distribution”.

2. Enabling Data Labels to show percentages.

3. Changing chart colors or styles if needed.

51
5. Example Output

The pie chart will show different slices representing each company's market share.

Example interpretation:
● Company A holds the largest market share (40%).
● Company D has the smallest share (15%).

This makes it easier to visually understand the distribution of market share among companies.

6. Result

A Pie Chart was successfully created in Microsoft Excel to visually represent the market share of
different companies.

7. Conclusion

Pie charts are effective tools for displaying percentage distribution and market share. Using charts
in Microsoft Excel helps present data clearly and improves understanding of category proportions.

52