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 had [...]

0 comments Read more...

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 function [...]

1 comment Read more...

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 folder.
Now, [...]

0 comments Read more...

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 Read more...

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 Read more...

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