training ms excel advanced - Excel

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

Resolved · Low Priority · Version Standard

Excel

Sue has attended:
Excel Intermediate course

by - delegate Sue [1 post] (2007 Aug 14 Tue, 12:58) Reply

How do I set up cells to create percentages in excel?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 15 Wed, 06:12) Reply

Hi Sue,

Thanks for the question. I believe you are asking about the percentage sign, this toolbar button(%) converts a decimal 0.25 into a percentage 25%, and from there you can use this cell to multiply to find percentages of other values.

If there was anything more specific please get back to me.

Tracy

· Microsoft Excel Training: Not Just for Newbies Anymore
· MS Excel: Excel At Making The Most Of Your Christmas
· Tips for Transitioning to Excel 2007
· How to check for and reduce errors in Microsoft Excel
· Reporting and Analysis with Excel

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips