excel

verified by visa - mastercard securecode

about microsoft training company london uk

Add to favourites

Printable version

Email this page

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

Home Course details Training formats Pricing FAQ Clients Book online Online schedule (live) Forum Contact us

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

Search forum

Active questions (218)
Advanced/consultancy questions (11)
Today's questions
Unanswered questions

Excel

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

Resolved · Low Priority · Version 2003

Excel

Rachel has attended:
Excel Introduction course

by - delegate Rachel [2 posts] (2008 May 7 Wed, 16:35) Reply

Is there a formula which converts values into percentages?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course				List price £225
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 May 19 Mon	Bloomsbury	0	FULL
2003/XP	2008 May 20 Tue	Tooting	0	FULL
2003/XP	2008 May 20 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 May 22 Thu	Bloomsbury	7	book now	£188	£215
2003/XP	2008 May 29 Thu	Southwark	4	book now	£207	£215
2003/XP	2008 Jun 3 Tue	Bayswater	5	book now	£198	£215
Full Schedule: See all 169 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel

by - trainer Tracy platinum contributer [586 posts] (2008 May 7 Wed, 20:16) Reply

Hi Rachel,

There is a percentage button which converts decimals into percentages, does that help? For example .2 press the % button turns into 20%

Tracy

RE: Excel

by - delegate Rachel [2 posts] (2008 May 9 Fri, 11:36) Reply

Not quite, say for example if I did a survey of 68 people and 22 people said "yes", is there a way on Excel i could convert the 22 out of 68 people into a percentage?

Many thanks!

RE: Excel

by - trainer Tracy platinum contributer [586 posts] (2008 May 12 Mon, 01:29) Reply

OK fool proof method
A1 = 68
B1 = 22

solution = (B1/A1)*100

But no I don't think there is a button for this you would have to use a formula
Tracy

· Tools From Advanced Excel Courses: Goal Seek and Solver
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Fun Things I've Done With Excel
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks

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

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

Excel

Related articles

Excel tip:

Converting an American date format to European using Formula