Excel beginners

The UK's most regular instructor-led training courses.
Training information: excel courses · Excel training course · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel beginners

Lorna has attended:
Word Intermediate course
Excel Introduction course

by - delegate Lorna [2 posts] (2008 Feb 6 Wed, 15:38) Reply

how do you arrange dates in order in a table?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: excel beginners

by - delegate Paul gold contributer [121 posts] (2008 Feb 6 Wed, 16:39) Reply

highlight the range of cells and then go data > sort then sort by the relevant column, choosing whether you have header rows or not also

RE: excel beginners

by - trainer Pete platinum contributer [864 posts] (2008 Feb 8 Fri, 22:12) Reply

Hi Lorna, Thank you for your post, to answer your question, in the list or database that the dates appear, click in the column with the dates and on the toolbar choose the button A-Z to arrange them in sequential order. Hope that helps, best regards Pete

· Prepare for your MOS Certification with MS Excel Courses
· Do You Really Need Excel VBA Training?
· Identifying Suitable Candidates For VBA For Excel Training
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Database Tips from an Excel Training Course

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

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

View all Excel hints and tips

Rate this page: