excel formula
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Formula

Excel - Formula

resolvedResolved · High Priority · Version 2003

replyReply Mon 16 Nov 2009, 14:08Delegate Sharon said...

Sharon has attended:
Excel Advanced course

Excel - Formula

I have a training date spreadsheet that has training start date and end date, some delegates require accommodation the night before and others on the nights of the actual course days. I need to simply translate the night priors and intermediate room night requirements into dates ie

Course start date - 1 December 2009
Course end date - 4 December 2009
Accommodation needed for the night before course start date and during course need to transalete this into date accommodation required ie 30 November, 1st, 2nd & 3 December

I can send the spreadsheet if this would be easier






For upcoming training course dates see: Pricing & availability

replyReply Thu 19 Nov 2009, 11:12Trainer Stephen said...

RE: Excel - Formula

Hi Sharon

Thankyou for your question

It would indeed be helpful if you emailed me the sheet

My email address is sw

I will then give the matter my urgent attention

Regards

Stephen

replyReply Mon 23 Nov 2009, 17:00Trainer Jacob said...

RE: Excel - Formula

Hi Sharon

Thanks for your post and sending through the information as requested.

This has helped us establish that your request is beyond the scope of the forum and in these cases we can recommend a more consultative approach.

Any consultation will take trainer time and therefore have associated costs, we always specify any work in advance and await approval before proceeding.

I shall email you direct so if you wish for us to look into this further you can reply to my email.

Kind regards

Jacob

Mon 30 Nov 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
2002 excel microsoft training and other Microsoft training courses.

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard