working instructions

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Working Instructions

Working Instructions

resolvedResolved · Low Priority · Version 2007

Lawrence has attended:
Excel Intermediate course

Working Instructions

Where to Obtain

Edited on Fri 4 Nov 2011, 10:22

RE: Working Instructions

Hello Lawrence,

Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.

Thank you for your question regarding working instructions and where to obtain them.

I presume you are referring to our downloadable training manual. You completed the feedback form and by now should have received an email from us. The email contains your user name (your email address) and your 4 digit password. Click the link provided in our email... this link takes you to our home page.

Click the delegate login link on the top right-hand corner and you will be taken to a page containing 5 tabs. The courseware material you are looking for is available on the last tab. The course you completed yesterday will be highlighted in green and by clicking on the second zip icon (from left) you can either open or save the file.

Hope this helps!

I would be greatful if you will send an email containing this information to all of the delegates who attended the course yesterday. This will save everyone from having to open a forum request.

If anyone has any direct queries they may contact me at:

rl@stl-training.co.uk

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Thu 10 Nov 2011: Automatically marked as resolved.


 

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help


3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

View all Excel hints and tips


Server loaded in 0.09 secs.