excel training program - Choose

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

Resolved · Low Priority · Version Standard

Choose

Don has attended:
Excel Advanced course
Excel VBA course
Excel VBA course

by - delegate Don [2 posts] (2007 Mar 1 Thu, 09:59) Reply

Describe the operation of Choose

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Choose

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 2 Fri, 11:18) Reply

The choose function return the value of a list of values based on its position. For example,

=CHOOSE(1, Don, attended, excel, advanced) would return "Don"
=CHOOSE(2, Don, attended, excel, advanced) would return "attended"
=CHOOSE(3, Don, attended, excel, advanced) would return "excel"
=CHOOSE(4, Don, attended, excel, advanced) would return "advanced"

hope that helps

Tracy

· Microsoft Excel Training Course
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Compare Different MS Excel Training Methods

Excel tip:

Get to the end of the used range

What’s the quickest way to get to the bottom right of the used range in your spreadsheet? The two-handed method is Ctrl+End (hold down Ctrl and press End). The one-handed method is End Home (press and release End, and then press and release Home).

The last cell so selected may appear to be empty. However, there is a cell in that row that has an entry or a format and there is a cell in that column that has an entry or format.

View all Excel hints and tips