Recent News
Personal Budget in Excel
One very common application of Excel is building budgets – from simple personal budgets to complicated business budgets. It is also a very good teaching tool, because even a simple budget will require some knowledge of Formulas, formatting, etc. (plus bells and whistles, of course!) I’ve created an example of a personal budget here that [...]
Read Article ›
Excel quick tip: change names from “Last, First” to “First Last”
I’m sure you’ve seen this before: you get a load of data with names shown “First Last” or “Last, First”, but you need it the other way… Good news! Excel can do that. Before we get into the details, you’ll need to refresh yourself of some of the text functions, namely: =RIGHT =LEFT =LEN =FIND [...]
Read Article ›Excel in the Real World – Manhattan Transit
I love hearing interesting ways that Excel is being used everyday — from simple things like making a personal budget or far more complicated things, like assessing the impact of transit prices on Manhattan’s traffic. Check out this article from Wired magazine about Charles Komanoff, the guru behind the “Balanced Transport Analyzer.” His model takes [...]
Read Article ›