excel vba courses london - Using analytical options

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

Resolved · Low Priority · Version Standard

Using analytical options

Swaley has attended:
Excel Intermediate course
Excel Advanced course
Powerpoint Advanced course

by - delegate Swaley [2 posts] (2007 Feb 14 Wed, 17:03) Reply

I HAVE NOT UNDERSTOOF THE GOAL SEEKER AND SOLVER FUNCTIONS VERY WELL.CAN I HAVE SOME MORE EXPLANATIONS ON THESE PLEASE?

THANKS

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 21 Thu	Bloomsbury	0	FULL
2003/XP	2008 Aug 21 Thu	Bayswater	2	book now	£195	£205
2003/XP	2008 Aug 28 Thu	Southwark	1	book now	£215	£215
2003/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003/XP	2008 Sep 2 Tue	Bloomsbury	5	book now	£198	£215
2003/XP	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
Full Schedule: See all 141 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: using analytical options

by - trainer Jacob silver contributer [89 posts] (2007 Feb 19 Mon, 11:42) Reply

Hi

The best places to check for further information are your course reference files you were provided with. Also Excel's online help provides comprehensive descriptions.

Jacob

· Identifying Suitable Candidates For VBA For Excel Training
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Microsoft Excel Training - Numerical excellence for all
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Customized Financial Excel Courses in London

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips