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 » Excel

	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:

Excel

Resolved · Urgent Priority · Version 2003

ReplyThu 10 Dec 2009, 12:32Delegate Esson said...

Excel

I have two workbooks one has names and address and the other has the same but also has extra infomation. Is there an easy way I can compare text data from one workbook to another????

For upcoming training course dates see: Pricing & availability

ReplyMon 14 Dec 2009, 15:17Trainer Jacob said...

RE: excel

Hi Esson

Thanks for your post. From reviewing this we believe we can provide a solution but it will fall outside the scope of this forum.

We will need 1-2 days development time to create the solution for you which is chargable consultancy work.

If you are interested in investigating this further please reply to my email.

Kind regards

Jacob

Tue 29 Dec 2009: Automatically marked as resolved.

Excel articles

· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· How To Pick The Best Chart Type In Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· Identifying Suitable Candidates For VBA For Excel Training
· Excel in the Home Office

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

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips

What is a footer and header?

» Forum post: What is a footer and header?

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