troubleshooting Question

excel 2010 year over year calculation

Avatar of anshuma
anshumaFlag for United States of America asked on
Microsoft Excel
2 Comments1 Solution419 ViewsLast Modified:
Hi,

I have a following columns in a spreadsheet and I want to do year over year calculations. so the growth in 2011 is 50% compared to 2010 etc

2010      50
2011      75
2012      86
2013      95
2014      125
2015      300

How can I do this easily in excel 2010 and excel 2013 (i am going to install it soon)

Is there a one click way to do this, like what we can do it tools like Tableau

thanks
-anshu
ASKER CERTIFIED SOLUTION
KimputerIT Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros