Advanced Excel

The UK's most regular instructor-led training courses.
Training information: learn excel in london · Excel training course · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Advanced Excel

Wayne has attended:
Excel Advanced course
Excel Intermediate course

by - delegate Wayne [1 post] (2008 Apr 18 Fri, 16:07) Reply

How is PMT calculated?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Advanced Excel

by - trainer Pete platinum contributer [799 posts] (2008 Apr 18 Fri, 18:18) Reply

Hi Wayne, Thanks for the post, welcome to the forum, in answer to your question;
The PMT function, one of Excel's Financial functions, can be used to calculate the payments for a loan or the future value of an investment. The syntax for the PMT function is: = PMT ( rate , nper , pv , fv , type )
rate - the annual interest rate for the loan.
nper - the total number of payments for the loan.
pv - the present value or the amount borrowed or the "principal of the loan.
fv - future value - for a loan this will be £0.00. For loans this argument can be omitted.
type - indicates when payments are due:
"0" (or omitted) - at the end of the period ie: end of the month.
"1" - at the beginning of the period ie: beginning of the month.
I hope that has helped, if so please click the resolved link, best regards Pete

· Tips to Facilitate Printing of Excel worksheets
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Microsoft Excel Training - Numerical excellence for all
· Prepare for your MOS Certification with MS Excel Courses
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets

Please browse our web site to find out more about
learn excel in london and other Microsoft training courses.

Excel tip:

Reconciling a list to correspond with another

May have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way.
Create another column in the sheet that has the most items and type in the first cell

=Exact(text1,text2) text1 being the cell that you want compared with text2 cell reference. Drag to filldown and your first false will give you for first cells that does not match. Correct insert the row with data in other sheet and continue the process until all the data returns true. Delete the column inserted.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

Prodigy Platinum Learning Partner

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

Advanced Excel

Related articles

Excel tip:

Reconciling a list to correspond with another