Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dates

Dates

ResolvedVersion 2003

Thu 9 Jul 2009, 16:32 Delegate Sharon said...

Sharon has attended:
Excel Advanced course

Dates

How can I convert number of days accommodation requied for training courses into dates> Iwill send you the file under seperate cover.

Tue 14 Jul 2009, 09:41 Trainer Amanda said...

RE: Dates

Hello Sharon

Thank you for your question and welcome to the forum.

If you would like to email your spreadsheet to amanda@stl-training.co.uk with an explanation of what you would like to do with reference to the spreadsheet (e.g. which rows/columns of data you would like us to look at), we'll see what we can do.

Kind regards
Amanda

Wed 15 Jul 2009, 09:20 Trainer Amanda said...

RE: Dates

Hi Sharon

Thanks for sending your example through to me.

I have attached a copy of the spreadsheet, the formulas used are in the yellow cells. I

Attached files...

fcm hotel bookings.xls

Wed 15 Jul 2009, 09:39 Delegate Sharon said...

RE: Dates

Thank you Amanda this was a big help.

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Dates

Dates

RE: Dates

RE: Dates

Attached files...

RE: Dates

Excel articles

Excel tip:

Manually rotating a 3D chart