by admin | Jun 18, 2018 | Excel | Advanced Lessons, Excel | Case Studies, Excel | General
Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam – and the techniques I learned there made me realise I could have done this more effectively.. You can view Part one here (Steps one to three) Just a reminder about what deferred income...
by admin | Jun 18, 2018 | Excel | Advanced Lessons, Excel | Case Studies, Excel | General
Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam – and the techniques I learned there made me realise I could have done this more effectively, but that will be for another post…:-) There are seven steps in this so I have published...
by admin | Apr 6, 2015 | Excel | Advanced Lessons
I recently got a request through LinkedIn from someone I met at a conference who wanted to know how she could do the following.. She wanted to calculate exam results given the following parameters. ” If they do not fail any module but can now have up to a...
by admin | Oct 7, 2013 | Excel | Advanced Lessons, Excel | General
One of the issues I come across frequently in class are people who have to work with large amounts of data. That often means a Lot of scrolling and selecting of lists of data and I have often wondered how I could make this easier for people. I have found an answer...
by admin | Oct 23, 2012 | Excel | Advanced Lessons, Excel | General
In this blog posting, I’m going to show you how to use a feature in Excel to create a large table of values. The feature is called Data Tables and I’m going to use the PMT function with it to show you how to quickly create a large table of loan repayment...
by admin | Oct 23, 2012 | Excel | Advanced Lessons, Excel | Excel for Small business
In today’s tutorial we are going to look at how to use the PMT function in Excel to calculate mortgage repayments. In another post, I’m going to show you how to use the PMT function with another Excel feature (called Data Tables) to very quickly generate a...