excel+xp+training - Excel version number

Resolved · Low Priority · Version Standard

Excel version number

Wendy has attended:
Excel Intermediate course
Excel Introduction course
Outlook Advanced course
Excel Intermediate course
Powerpoint Introduction course

by - delegate Wendy [7 posts] (2007 Feb 13 Tue, 16:16) Reply

How do I check which version of Excel I am using?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	5	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel version number

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 14 Wed, 11:46) Reply

To find out which version you are currently using you can go the the Help menu and down to "About Microsoft Excel" at the top of the dialog box it will tell you which version you are using.

Good luck

Tracy

· Microsoft Excel Training: Essential for Today's Employees
· What's Better Than the Help Function in Excel? Microsoft Training
· Prepare for your MOS Certification with MS Excel Courses
· Fun Things I've Done With Excel
· Microsoft Excel Courses Teach Advanced Macro Techniques

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips

Rate this page: