The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Advanced training

Resolved · Low Priority · Version 2003

ReplyFri 15 Jan 2010, 16:27Delegate Jennie said...

Advanced training

Very useful course - i'm sure i'll be back asking questions about Pivot tables at a later stage though!

For upcoming training course dates see: Pricing & availability

ReplySun 17 Jan 2010, 19:48Trainer Anthony said...

RE: Advanced training

Hi Jennie, thanks for posting on the forum. Let me know if you have any problems with those Pivot tables in the future!

All the best,

Anthony

Mon 25 Jan 2010: Automatically marked as resolved.

Excel articles

· Advanced level training: Microsoft Excel and the Web
· Using The Excel Forms Toolbar To Spruce Up A Workbook
· Training Budgets In A Bad Economy
· How To Avoid The Embarrassment Of Dirty Data
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks

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

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

I have run a query in Access in 2002 whereby I wanted it show several trade types to show "Borrow" positions. For borrow positions you would have 5 trade types. I do not want to show the trade types in a column but want to replace these with &..

» Forum post: Query - Replace function

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions