From the monthly archives:

February 2008

2008 Datawatch User Conference

February 17, 2008

The agenda for the 2008 Datawatch User Conference to be held in Phoenix Arizona was recently published, and I’m very pleased that I’ve been selected to once again provide a presentation to the group. The conference is a fantastic opportunity to learn about Monarch and the other Datawatch products with which you may not have [...]

0 comments Click to continue...

Make creating expressions easier to build and read

February 16, 2008

When including numeric values in the expression to build up a character string, it’s common to use the Trim (removes leading and trailing spaces) and Str (converts numerics to characters) functions together, such as: Trim(Str(MyValue)) The equivalent when programming in Excel is the Cstr() function, so why not go ahead and build yourself a custom [...]

1 comment Click to continue...

Organizing Access to Your Documents

February 14, 2008

If you have data files organized into a number of folders, or even different drives, it can be cumbersome to navigate all over the place to get what you want. To make navigation much easier, create a My Shortcuts folder on your C: drive. Store shortcuts to all of your often used locations in this [...]

0 comments Click to continue...

A Monarch Tip

February 13, 2008

When you’re downloading ASCII text report files, give them an extension of .prn instead of the common .txt extension. Odds are that the only program on your computer associated with .prn files is Monarch, so when exploring your folders you can just double click the filename to immediately open it in Monarch. Quick and easy.

0 comments Click to continue...

Be Flexible and Make Necessary Adjustments

February 13, 2008

One of best features shared by Monarch and Excel are that there often multiple ways to accomplish a task. With many of the features, you’re not forced to handle it in only one prescribed manner. How you get it done is up to you. You can be reasonably flexible in how you approach the work, [...]

0 comments Click to continue...

Copyright © 2007 - 2012 Excel with Monarch Training and Services. All rights reserved. Privacy Policy
Microsoft Excel™ Microsoft Corporation. Monarch and Monarch Pro™ Datawatch Corporation.