Scribd
Upload
103 views15 pages

Excel Sales and Advertising Data Analysis

The document shows Excel sales and advertising expenses from 2010-2014. Excel sales were highest in 2012 at $300 million and lowest in 2011 at $100 million. Advertising expenses followed a similar trend and were highest when sales were highest.

Uploaded by

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

Excel Sales and Advertising Data Analysis

The document shows Excel sales and advertising expenses from 2010-2014. Excel sales were highest in 2012 at $300 million and lowest in 2011 at $100 million. Advertising expenses followed a similar trend and were highest when sales were highest.

Uploaded by

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

Excel sales(million $) Advertising expenses

400
Year 2010 175 25
Year 2011 100 14
Year 2012 300 22 350
Year 2013 100 5
Year 2014 350 19 300

250

200

150

100

50

0
Year 2010 Yea r 2011 Year 2012

Excel s al es(mi l l i on $) Adve


Blog Posts & Articles:
[Link]

Yea r 2011 Year 2012 Year 2013 Yea r 2014

Excel s al es(mi l l i on $) Advertisi ng expens es


Articles:
[Link]
January Sales
1/1/2013 #N/A
1/2/2013
1/3/2013
1/4/2013
1/5/2013
1/6/2013
1/7/2013
1/8/2013
1/9/2013
1/10/2013
1/11/2013
1/12/2013
1/13/2013
1/14/2013
1/15/2013
1/16/2013
1/17/2013
1/18/2013
1/19/2013
1/20/2013
1/21/2013
1/22/2013
1/23/2013
1/24/2013
1/25/2013
1/26/2013
1/27/2013
1/28/2013
1/29/2013
1/30/2013
1/31/2013
###
Blog Posts & Articles:
### [Link]
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
Item category Sales
Spirits 730
Cosmetics 215
Souvenirs 140
cigarettes 90
Honey 50
refreshments 790
Mineral water 390
Blog Posts & Articles:
[Link]
Mellon Software Application
Start Date Days End Date Days in total
Designing software 9/20/2014 20 10/17/2014 27
Programming 10/13/2014 30 11/24/2014 42
Testing 11/22/2014 8 12/3/2014 11
Finalizing 12/3/2014 6 12/11/2014 8
Updating 12/12/2014 30 1/23/2015 42
Blog Posts & Articles:
[Link]
Articles:
[Link]
Year Excel Power Point Word Outlook
Year 2010 175 200 250 300
Year 2011 100 125 170 200
Year 2012 300 350 400 450
Year 2013 100 250 350 325
Year 2014 350 275 525 375

Sales of Software programs per Year


600

500

400

300

200

100

0
Year 2010 Yea r 2011 Yea r 2012 Year 2013 Year 2014
Excel Power Poi nt Word Outl ook
Blog Posts & Articles:
[Link]
January Sales Breakpoints Frequency
1/1/2013 3500 3000
1/2/2013 4804 6000
1/3/2013 6900 9000
1/4/2013 12654 12000
1/5/2013 15243 15000
1/6/2013 9532 18000
1/7/2013 4233
1/8/2013 1700
1/9/2013 11322
1/10/2013 14744
1/11/2013 7566
1/12/2013 6880
1/13/2013 3711
1/14/2013 16444
1/15/2013 8900
1/16/2013 7800
1/17/2013 6500
1/18/2013 4500
1/19/2013 14500
1/20/2013 17699
1/21/2013 18500
1/22/2013 13500
1/23/2013 12800
1/24/2013 18000
1/25/2013 11311
1/26/2013 6900
1/27/2013 4099
1/28/2013 14100
1/29/2013 15000
1/30/2013 9500
1/31/2013 6900
Blog Posts & Articles:
[Link]
Blog Posts & Articles:
[Link]

You might also like