Scribd
Upload
9 views2 pages

FlashSystem 9100 Data Analysis Techniques

The document outlines a series of IT skill lab tasks for MBA students at the Tech Institute of Management Sciences, focusing on data analysis and visualization techniques using Excel. It includes instructions for creating Pivot Tables, charts, and utilizing functions like VLOOKUP, INDEX, and MATCH. The tasks aim to enhance students' proficiency in handling sales data and performing complex calculations.

Uploaded by

dy7949748
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views2 pages

FlashSystem 9100 Data Analysis Techniques

The document outlines a series of IT skill lab tasks for MBA students at the Tech Institute of Management Sciences, focusing on data analysis and visualization techniques using Excel. It includes instructions for creating Pivot Tables, charts, and utilizing functions like VLOOKUP, INDEX, and MATCH. The tasks aim to enhance students' proficiency in handling sales data and performing complex calculations.

Uploaded by

dy7949748
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

IT SKILL LAB-2

TECHNO INSTITUTE OF MANAGEMENT SCIENCES


LUCKNOW

In Partial Fulfillment of the Requirements


For the Degree of
MASTER IN BUSINESS ADMINISTRATION
BY
DR. A.P.J. ABDUL KALAM TECHNICAL UNIVERSITY,
UTTAR PRADESH

Batch 2023 - 2025


Session (2023-2024)

Submitted By Submitted To
Student Name Mr. Sushant Mishra
MBA 1st Year 2nd Semester Assistant Professor
Index
Sno. Question Page No.
Create a Pivot Table from a dataset containing sales data. Summarize the total
1
sales for each product category.
Create a Pivot Chart from the Pivot Table to visually represent the total sales
2
per region.
Use VLOOKUP to find the price of a specific product from a table that lists
3
product names and prices.
Apply VLOOKUP across two different worksheets within the same workbook
4
to retrieve employee details based on their ID.
Construct a pie chart to represent the market share of different products based
5
on sales data.
Create a combination chart that includes both a column chart for sales data and
6
a line chart for profit data on the same axis.
Create a histogram to analyze the distribution of exam scores for a class of
7
students.
Combine the IF, AND, and SUM functions to calculate the total bonus for
8 employees who meet certain performance criteria and have worked more than
one year.
Use the INDEX and MATCH functions together to retrieve data from multiple
9
tables where the lookup value can be in different columns.
Combine the use of VLOOKUP and INDIRECT functions to dynamically pull
10
data from different tables based on user input.
Create a macro to automate the process of refreshing multiple Pivot Tables in
11
a workbook.
Generate a scatter plot to analyze the relationship between advertising spend
12
and sales revenue.
Implement a VLOOKUP to pull data from a table where the lookup value is in
13
the first column and the data to be retrieved is in the third column.
Insert a calculated field in the Pivot Table to show the profit margin (Profit =
14
Sales - Cost).
Make table with students’ scores from all classes (from class 1 to 12) and find
15
out weakest and strongest subjects of a student by entering his/her name.

You might also like