Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Excel 2007

Advanced Excel 2007

ResolvedVersion 2007

Wed 13 May 2009, 14:00 Delegate Ariyanna said...

Ariyanna has attended:
Excel Intermediate course
Excel Advanced course

Advanced Excel 2007

How do you sort lots of data in excel?

Fri 15 May 2009, 19:25 Trainer Anthony said...

RE: Advanced Excel 2007

Hi Ariyanna. The easiest way to sort lots of data in Excel is to select your data and select the A-Z sort on the Data menu. Then you could switch on the Autofilter option to sort datasets according to individual fields and anything more complicated can be achieved with the Advanced filter option.

Hope this helps,

Anthony

Fri 22 May 2009: Automatically marked as resolved.

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Advanced Excel 2007

Advanced Excel 2007

RE: Advanced Excel 2007

Excel articles

Excel tip:

Highlighting a data range