Excel

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

Resolved · Low Priority · Version 2003

1 post

ReplyWed 24 Jun 2009, 14:07Delegate Nicola said...

Nicola has attended:
Excel Intermediate course

Excel

How do I sort data alphabetically?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Thu 18 + Fri 19 Mar 2010	Southwark	0	FULL
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	2		£495	£495
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	8		£445	£450
Full Schedule: See all 36 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

642 posts

ReplyWed 24 Jun 2009, 15:34Trainer Simon said...

RE: Excel

Hi Nicola,

Thank you for your question.

Click into one of the data cells underneath the heading you want the excel list sorted by.

E.g. If you want sort the data by County, click in any cell containing a county and go to the Data menu and then Sort.

Ensure that the County field is selected from the options available in the Sort By box.

I hope this answers your question.

Regards

Simon

Wed 1 Jul 2009: Automatically marked as resolved.

· Crazy Things People Have Done With Excel
· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· That's The Wonder Of Autofill
· Tap the Power of Recorded Macros with MS Excel Courses

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

Excel tip:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart�s elevation and rotation to make it more visually appealing. To do this, click the chart and select 3-D View from the Chart menu. The 3-D View dialog box will appear.

The elevation is the height you view the chart from. Click the arrows to the left of the preview picture or enter a value (something between 90 and �90) in the Elevation field to adjust the elevation.

Rotation is the rotation of the plot area around the z-axis. Click the arrows below the preview picture or enter a value (something between 0 and 360) in the Rotation field to adjust the rotation

View all Excel hints and tips