First off, while I'm not a particular expert at any programming language, I am an electrical engineer, and I've done more than my fair share of code-slinging over the years, including VBA.
I'd like a tool where I can start with a known balance in an account, schedule multiple recurring and one-time transactions (direct deposit every payday, monthly auto-billed deductions, big planned expenses, that kind of thing), and generate a graph showing the day-by-day (or weekly) balance going into the future.
I've always wanted a good reason to get better at Excel, and I'm hoping this might be it... but I'm not so sure Excel is the right tool.
To be honest, I'm thinking Matlab or Mathmatica might be the way to go, but I'm already pretty good at those tools... so there's less benefit.
If excel is a decent tool for this, any advice on setting the project up properly from the start? Good functions I should get to know? Any recommendations for good youtube videos or online articles or some such?
Thanks!
Bookmarks