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

Excel

ResolvedVersion 2007

Thu 13 Jan 2011, 14:54 john (guest) said...

Excel

I attended the Excel intermediate course on 11/01/11 and am currently reading the course material. Can you please email me all the spreadsheets referred to in the course material so I can work through the Unit Practice Activities.

Thanks

John

Mon 17 Jan 2011, 15:10 Trainer Tristan said...

RE: Excel

Good Afternoon John,

Your reference material for the course is available through your delegate account. This account would have been setup when you completed your online feedback from the course. You just need to login:

www.stl-training.co.uk/delegate

Then select the "Your history/courseware" tab and the reference material will be available for the courses you have attended.

If you have any questions, please don't hesitate to call us on 0207 987 3777

Kind Regards,
Tristan

Mon 24 Jan 2011: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet