Excel Intermediate Training

Resolved · Low Priority · Version Standard

Donna has attended:
Excel Intermediate course

by - delegate Donna [2 posts] (2008 Mar 11 Tue, 16:27) Reply

Please can you remind me the code for today's system date?

Thanks

Donna

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 8 Mon	Bayswater	2	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
2002/XP	2008 Dec 16 Tue	Tooting	0	FULL
Full Schedule: See all 108 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel Intermediate Training

by - trainer Mark gold contributer [287 posts] (2008 Mar 14 Fri, 14:52) Reply

Hi Donna

Hope you enjoyed your course on Tuesday

The formula you need to get todays date is =today()
you can also get the time and date by =now()

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please click reply or post it as a new question and we should be able to answer that!!

Many Thanks

Mark East
mark

· Microsoft Excel Training - Numerical excellence for all
· Tips for Transitioning to Excel 2007
· Creating Charts with Excel
· Excel and Inventory Management
· Microsoft Excel Training: Essential for Today's Employees

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

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant´s name as 'VAT' (no spaces allowed) in the 'Names in Workbook' line.

Enter the constant value of '0.175' in the 'Refers To' text box - making sure any other text has been deleted.

Click OK.

In Excel you may have cell 'B10' as containing an amount and in 'C10' you want to work out the VAT on the amount in 'B10'.

The formula would be

=B10*VAT

This formula will generate the amount of VAT only.