Excel

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

Resolved · Low Priority · Version Standard

Excel

Krishan has attended:
MOS/MCAS exam course
Excel Intermediate course
Excel Advanced course
Excel VBA course

by - delegate Krishan [2 posts] (2008 Feb 26 Tue, 17:03) Reply

How do I zoom on data quickly

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	0	FULL
2003	2008 Oct 23 Thu + 24 Fri	Southwark	0	FULL
2003	2008 Oct 30 Thu + 31 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Nov 3 Mon + 4 Tue	Bayswater	4	book now	£475	£485
2003	2008 Nov 17 Mon + 18 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	6	book now	£450	£485
Full Schedule: See all 40 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel

by - trainer Rich platinum contributer [718 posts] (2008 Mar 1 Sat, 10:12) Reply

Go to view>>toolbars>>standard toolbar to make sure the toolbar is showing. It defaults to 100% but you can change it to be 200% if you want. Also, another quick way is to hold down the ctrl key and if you have a scroll wheel on your mouse then you can roll it back and forth to automatically zoom in and out.

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· How to Create Better Excel Spreadsheets: Part Two
· Advanced level training: Microsoft Excel and the Web
· Prepare for your MOS Certification with MS Excel Courses
· How Excel Training Can Improve Your Company's Sales Process

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

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips