microsoft excel course - Exponent

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

Resolved · Low Priority · Version Standard

Exponent

Paul has attended:
Excel Introduction course
Excel Advanced course

by - delegate Paul [1 post] (2007 Jul 26 Thu, 12:45) Reply

Could you just explain the sign ^ Exponent what is this function mainly used for?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 27 Thu	Bloomsbury	4	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	2	book now	£235	£240
2003	2008 Dec 5 Fri	Bayswater	6	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
Full Schedule: See all 99 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Exponent

by - trainer Richard platinum contributer [813 posts] (2007 Jul 26 Thu, 16:38) Reply

^ means " to the power of"

ie:

3^2 = 3x3

3^4 = 3x3x3x3

and so on.

Regards

Richard

· Tap the Power of Recorded Macros with MS Excel Courses
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· How to Create Better Excel Spreadsheets: Part Four
· What's Better Than the Help Function in Excel? Microsoft Training

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