Select Page

## Deferred Income – When you haven’t quite got the money in the bank – Part Two

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...

## Deferred Income – when you haven’t quite got the money in the bank…Part One

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...

## Calculating exam results : pass, fail, compensation pass

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...

## Tables and Structural References or how to do a lot less highlighting when creating formulas

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...

## DATA TABLE | QUICKLY CREATE A LARGE TABLE OF VALUES

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...

## PMT FUNCTION | MORTGAGE REPAYMENT CALCULATOR

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...