[ Dec. 2001 ] [ Nov. 2001 ] [ Oct. 2001 ] [ Sept. 2001 ] [ August 2001 ] [ July 2001 ] [ June 2001 ] [ May 2001 ] [ April 2001 ] [ Mar. 2001 ] [ Feb. 2001 ] [ Jan 2001 ]
[ UF_smrNext3rdFriday ] [ UF_smrNextNthWeekday ]
|
6:30-7:15 pm
|
Introduction: General
Questions and Problems from the Audience Puzzler:
How can you create a table listing the THIRD FRIDAY of every month?
It is a short, neat, useful problem.
Solutions: Excel Workbook:
Puzzler third Fri2.zip (Rasey)
User Defined Function: smrNext3rdFriday
User Defined Function: smrNextNthWeekday(InputDate,iNth,iWeekday)
|
|
7:15-8:00 pm
|
Goal
Seek: This is a tool that allows you
automatically change one input value in a workbook and search for a
value that will yield a desired result in another cell. |
|
8:00-8:10 pm
|
(Break) |
|
8:10-9:00 pm
|
Scenario
Manager: When you need to do many
"What If..." cases in a project, Scenario Manager can be used
to catalog the key Inputs and Outputs of the many cases you run. |
Jamal Eldahdouly will be in
charge of this meeting.
|
