Create a graph or chart that compares the data

Reference no: EM13751617

Sales Analysis Spreadsheet

Using the ABC Technologies Inc., Q1 2012 Sales spreadsheet, analyze the data on Q1 2012 Sales identifying the following:

Monthly sales by Region
Quarter One sales by Region
Monthly sales by Product
Quarter One sales by Product
Monthly sales by Region, by Sales people
Quarter One sales by Region, by Sales people

Create a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month, etc.

Create a spreadsheet formatted to present your analysis of the sales numbers to management. In your spreadsheet, use the following:

Use the SUM function
The date function
An additional math or statistical function of your choice
Fill colors to differential areas of your spreadsheet
Border lines to differential area of your spreadsheet.

Attachment:- data.xlsx

Reference no: EM13751617

Questions Cloud

Disability culture compared to other cultural identities : How do you think the nature of disability, where disabilities can either be apparent or non-apparent, affects America's disability culture compared to other cultural identities Can you think of other non-apparent identities that are similar to dis..

Challenges in the global business environment : According to the textbook, ongoing challenges in the global business environment are mostly attributed to unethical business practices, failure to embrace technology advancements, and stiff competition among businesses. Use the Internet to researc..

Determine the range of meaning for bible and james : determine the range of meaning for Bible and James. List its possible meaning with each possible meaning list all the verses that all the verses that correspond to that meaning.

Iinterpersonal communication skills : Iinterpersonal communication skills and effective project management that helped me thrive in the workplace.

Create a graph or chart that compares the data : Create a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month

Which function do you believe managers use most often : Describe that experience to your classmates using research support from the text or another viable source (you may not use Wikipedia). Which function do you believe managers use most often. What could have made the leadership function a better exper..

Role of social media in commerce in a future job interview : Write a two-paragraph summary of this exercise that you could use to demonstrate your knowledge of the role of social media in commerce in a future job interview

How was freedom defined in the spanish colonies : How was freedom defined in the spanish colonies? How was it defined in the british colonies?what liberties were extended and to whom?

Analyzed and discussed the external forces : Analyzed and discussed the external forces and industry conditions that have impacted TEOCO's performance over the years. Analyzed and discussed how the internal organization and culture at TEOCO influenced its performance.

User Account

All Pages