Track Savings with Excel Part 2 What-If Analysis

Channel:
Subscribers:
3,620
Published on ● Video Link: https://www.youtube.com/watch?v=Lq_yK-0_IoE



Duration: 13:32
1,818 views
7


This is a short beginners' guide to tracking your savings with Excel. In my previous video I showed how to build a simple spreadsheet to track monthly savings, and how to chart this with a line graph.

In this video I take it a step further, showing how to use Excel's financial functions to quickly and easily do a 'what-if' analysis to figure out how much you need to save each month to reach your target, or conversely, how much you could save in a given time, and so on.

ABOUT ALPHATUCANA
I mostly do gameplay playthroughs on easier levels of difficulty for beginners, some (hopefully) intelligent vlogging about current affairs, science, money and philosophy, and a few sightseeing videos of London and our holidays. Do subscribe if you like what you see!

POSTING SCHEDULE
This depends in part on whether I have had time to record videos in between going to work and living the rest of my life! Usually it runs like this:
- Sat & Sun: a video at midday and 6pm (UK time)
- Tues & Thurs most weeks: a video at midday
- If I have something extra to post it usually appears at some random time :)

SUBSCRIBE!
http://www.youtube.com/subscription_center?add_user=alphatucana

SUPPORT THIS CHANNEL!
Perks for viewers who become a patron of this channel:
https://www.patreon.com/alphatucana

CONNECTIONS
https://www.facebook.com/alphatucana
https://twitter.com/alphatucana
https://www.pinterest.com/alphatucana/

MY WEBSITE
Not updated too often these days - YouTube comes first!
http://www.alphatucana.co.uk







Tags:
Microsoft Excel (Software)
Chart
what-if
what if
what if analysis
excel nper function
fv
pv
nper
excel savings plan
savings goal chart excel
savings goal tracking with excel
savings
target
trend
track savings
track savings with excel
excel
excel savings
beginners guide
tutorial
spreadsheet
savings goal tracker
spreadsheet savings plan
spreadsheet savings calculator
on target
excel 2007
excel 2010
example
trendline
glwaverbigiod2014