microsoft+excel+training - Excel

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

Resolved · Low Priority · Version Standard

Excel

Sonia has attended:
Excel Intermediate course

by - delegate Sonia [1 post] (2007 Aug 7 Tue, 15:41) Reply

FORMAT: What is the differnce in using a format painter and setting styles?

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 David gold contributer [411 posts] (2007 Aug 8 Wed, 14:00) Reply

Format painter allows you to locally change a format, a Style allows you to globally change a format.

· How Excel Training Can Improve Your Company's Sales Process
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Do You Really Need Excel VBA Training?
· Prepare for your MOS Certification with MS Excel Courses
· Excel in the Home Office

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips