Jun 9, 2014
Here’s a typical scenario we all face…you need a loan. You have a fixed interest rate and a fixed number of repayments. You can afford to pay back $200/month. So how much can you actually borrow? This video shows how Goal Seek will provide the...
May 26, 2014
Today is May 1st 2013 (I know it’s not but for the purposes of this demo it is). The new system goes live on 1st October and user training has to be completed before this date. Training can only take place on Monday – Friday and in addition, there are...
Jan 5, 2014
In this tutorial I demonstrate how to display numbers and dates correctly when they are embedded within a text entry. The screenshot below is from a simple loan calculator. The sentence in A7 is generated by combining the contents of B3, B4 and B5 with static text...
Apr 27, 2013
Whilst searching the online templates from Microsoft, I came across a great “any year calendar” – a calendar that can be re-used year-on-year. However, when I started using it, I came across a problem due to the way my computer is configured. My...
Apr 17, 2013
“How do I calculate someone’s age (whole years) if I have their date of birth?” is a common question on my Excel courses. I used to use the following: We need a cell containing the current date, that updates every day. In this example we’ll use...
