From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Payment tracking

Payment tracking - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Payment tracking

“

- [Instructor] We've got a diving camp that's coming up and Anson down to Wynn in column B are going to be attending and we see their respective fees. Now we know that some people are going to make multiple payments. This is where your help is needed. In cell G3 start a table that tracks the payments. So, if Anson shows up with $1,000 check, and then a $200 check, and then Javier shows up with a $2,000 check, and then Gloria has the whole $2,075. We want to be able to track all of the individual payments and dynamically calculate what's due, in column D, in the Amount Due column. And you are going to have to make up your own data in order to get this to work. And include some way that we can tell that, for example, Kermit paid $500 for Vitaly. And you know the drill now. Pause the video, get it done, come on back. (bright music) Welcome back, let's put on our goggles and dive in. Let's give ourselves some room. I'm…

Contents