98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Medium Priority · Version 2010
Wed 4 Dec 2013, 15:57Delegate Sarita said...
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
Fri 6 Dec 2013, 12:33Trainer Gary said...
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
Thu 19 Dec 2013, 14:30Trainer Cindy said...
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
Thu 26 Dec 2013: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Counting BlanksSome times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted. |
