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

excel

ResolvedVersion 2010

Sarita has attended:
Word Intermediate course
Excel Intermediate course
Excel Advanced course

Excel

i'd like to put a spreadsheet together where there are monies owed from several people for different music events and holidays from 2013 through to 2014.
easc has a diff payment plan.
i'd like to know how to put in formulas to know how long it will take for them all to pay off the monies owed-thanks

RE: excel

Hi Sarita

Thanks for getting in touch. I hope you enjoyed your course.

There's a few ways to lay this data out to get the result you want, but before I suggest is there any interested accumulated on these or are the amounts fixed (i.e. same payment every month) ?

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: excel

Hello Sarita,

I am currently going through our forum to clear out any active questions.
Did you manage to fix the problem you asked about?

If not, please reply within five days so I can contact a trainer who can help you, otherwise this question will be marked as Resolved.

Thank you for your assistance.


Kind regards

Cindy
Microsoft Office Trainer

RE: excel

THANK YOU FOR YOUR RESPONSE Gary.
There is no interest accrued just fixed amounts.

Thu 26 Dec 2013: Automatically marked as resolved.

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.