KCC Institute of Technology and
Management
Department of Management Studies
Lab Manual
Course Title: IT Skills Lab
Course Code: MBA-105
Program: Master of Business Administration (MBA)
Semester: I
Session: 2025-26
Faculty Name: [Your Name]
Designation: Assistant Professor
Institute: KCC Institute of Technology and Management
University: Dr. A.P.J. Abdul Kalam Technical University, Lucknow
Table of Contents
1. Unit I: Advanced Spreadsheet Functions
1.1 Pivot Tables
1.2 Goal Seek and Solver
1.3 Scenarios
1.4 Data Validation and Auditing
1.5 Macros
2. Unit II: Charts and Graphs
2.1 Understanding Chart Types
2.2 Combined Charts
2.3 Chart Customization
3. Experiment Details
4. Assessment and Evaluation
5. References
Unit I: Advanced Spreadsheet Functions
1.1 Pivot Tables
Objective: To create and manipulate Pivot Tables for data analysis.
Example: Summarize sales data by region and product category using a Pivot Table.
Steps:
1. Open Excel.
2. Use Insert > PivotTable.
3. Drag fields to Rows, Columns, and Values.
4. Apply filters and summarize data.
1.2 Goal Seek and Solver
Objective: Perform what-if analysis using Goal Seek and Solver.
Example: Determine required sales to achieve a target profit using Goal Seek.
Steps:
- Use Data > What-If Analysis > Goal Seek.
- Use Solver to optimize values with constraints.
1.3 Scenarios
Objective: Manage multiple business scenarios in Excel.
Example: Compare best-case, worst-case, and likely-case profit margins.
Steps:
- Data > What-If Analysis > Scenario Manager.
- Add/Edit/Delete Scenarios.
- Generate a summary report.
1.4 Data Validation and Auditing
Objective: Enforce data integrity and trace cell relationships.
Example: Validate a range to accept only whole numbers.
Steps:
- Data > Data Validation.
- Set criteria.
- Use Formulas > Trace Precedents/Dependents.
1.5 Macros
Objective: Automate tasks using macros.
Example: Record a macro to apply consistent formatting.
Steps:
- View > Macros > Record Macro.
- Perform tasks.
- Stop recording and assign to a button.
Unit II: Charts and Graphs
2.1 Understanding Chart Types
Objective: Create and understand various chart types.
Types include Column, Bar, Line, Pie, XY Scatter, Area, Surface, and Bubble charts.
Example: Create a pie chart to represent sales distribution.
2.2 Combined Charts
Objective: Combine chart types for better visualization.
Example: Combine a column and line chart to compare sales and growth.
Steps:
- Insert a chart.
- Change one series chart type.
- Use secondary axis if needed.
2.3 Chart Customization
Objective: Format charts to improve presentation.
Example: Change axis scale, display units, and format chart areas.
Steps:
- Add titles, legends, data labels.
- Modify value axis.
- Apply color/image formatting.
Experiment Details
Experiment No. Title Objective
1 Creating Pivot Tables Summarize and analyze
data using PivotTables.
2 Goal Seek and Solver Perform what-if analysis for
decision-making.
3 Scenario Management Evaluate different business
scenarios.
4 Data Validation and Ensure data integrity and
Auditing trace formula errors.
5 Recording Macros Automate repetitive tasks in
Excel.
6 Creating Various Chart Visualize data using
Types appropriate chart types.
7 Creating Combined Charts Combine multiple chart
types for comparison.
8 Customizing Charts Enhance chart aesthetics
and clarity.
Assessment and Evaluation
Component-wise Marks Distribution:
Component Marks
Lab Performance 20
Lab Record Submission 10
Viva Voce 10
Total 40
References
1. Microsoft Excel Official Documentation: https://support.microsoft.com/excel
2. "Excel 2019 Bible" by Michael Alexander, Richard Kusleika, and John Walkenbach.
3. "Data Analysis Using Microsoft Excel" by Michael R. Middleton.
