|
Wednesday,
January 14, 2004
6:30-7:00 pm
|
General Questions and Problems from the Audience
Ideas about how to keep track of Buys and Sells for Stocks in an
Excel workbook.
StocksJournal.zip |
| 7:00 - 8:00 |
Excel
Functions of the Month - String and Text functions Left(), Mid(),
Right(), Len()
Find(), Replace(), Search(), Substitute(), Trim()
Concatenate(), & operator
Upper(), Lower(), Proper()
Fixed(), Dollar(), T(), Text()
Value() Example Excel workbook:
TextFunctions.zip Includes an example of how to split a
"First Last" name into First and Last into two cells. |
| |
(Break) |
| 8:10 - 9:00 |
Email
Merge with Excel
(not enough time) Suppose you need to send filtered reports to different clients.
If you have their parameters for the report and their email addresses, you
can automate the entire batch. |
------------------------
|
