microsoft excel training courses london - EXCEL

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

Resolved · Low Priority · Version Standard

EXCEL

Jaz has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Jaz [1 post] (2007 Feb 27 Tue, 09:51) Reply

How do I use validation in cells?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: EXCEL

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 27 Tue, 11:07) Reply

Hi Jaz,

Validation in cells is where you will only allow a certain criteria of data to be input into a cell. You do this by highlighting where you want to put the validation in, then go into the Data menu and down to the option that says Validation then simply put in the options as to what you want to be input, there is also an option of editing the error message.

Have a look at that option and see what you think.

Tracy

· Prepare for your MOS Certification with MS Excel Courses
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Office and the Small Business: Part 1 Excel
· How Small Businesses Profit from Outside Excel Training
· How Excel Training Can Improve Your Company's Sales Process

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips