Excel 2010 expert needed: advanced skills for custom sort creation

am working on an excel 2010 worksheet and i need the help of an excel expert.

 

Don't use plagiarized sources. Get Your Custom Essay on
Excel 2010 expert needed: advanced skills for custom sort creation
Just from $13/Page
Order Essay

worksheet it only has two columns – date and amount.

 

data should be subtotaled by FY year based on the guidelines below:

07/01/2008 – 06/30/2009   to be called FY 2009

07/01/2009 – 06/30/2010   to be called FY 2010

07/01/2010 – 06/30/2011   to be called FY2011

07/01/2011 – 06/30/2012   to be called FY 2012

07/01/2012 – 06/30/2013   to be called FY 2013

07/01/2013 – 06/30/2014   to be called FY2014

07/01/2014 – 06/30/2015   to be called FY 2015

 

from the table, i’d like to create a chart using only the FY subtotals.  

 

i think that pivot table is the key (am not sure though).  i can’t figure out how to create the custom date range.  it is still yearly but i need to create my own year definitions.

 

this is a quick turnaround, need it by 5:00 am EST (NY time) at the latest, sooner is appreciated.  small file of data with a little less than 700 rows.

 

i will email worksheet to tutor.  i can offer $20.

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper