From the monthly archives:

October 2007

An Introduction to Monarch’s Custom Functions

October 31, 2007

Getting it Your Way Do you find that you’re often creating elaborate, hard to read formulas in your expressions? Do you work with other Monarch users who aren’t quite as adept as you at writing expressions? You can replace that complexity with a simple to read, easy to use custom function. Introduced in version 9, [...]

0 comments Click to continue...

Creating Secure Documents with Monarch

October 29, 2007

You’re a Secret Agent! Admit it. At one time or another, you’ve been a secret agent, probably when you were a kid. My name? It’s Cavalaris… Sandy Cavalaris. You know, it just doesn’t have the same ring as you know who. But it’s still fun to think that you can play with all those cool [...]

0 comments Click to continue...

Commenting in Your Monarch Models

October 28, 2007

The Award for Best Documentary Goes to … “If it was easy everyone would be doing it.” Sometimes the work you do isn’t as simple or as straightforward as you’d like. Complex model templates, functions, and filters all crop up in your Monarch models from time to time. Will you remember why you built it [...]

0 comments Click to continue...

Monarch’s External Lookup Feature

October 25, 2007

Hook up with Lookups! One of the best reasons to use Monarch Pro is its ability to easily add more data to what you extract from your initial data source. This will allow you to analyze your data in ways not possible with your existing source. The Problem Let’s say you have a sales report [...]

0 comments Click to continue...

Data Extraction Tips for Monarch

October 23, 2007

Mining for Gold In all likelihood, Monarch is most often used to extract data from report files. After all, that’s its specialty. Unfortunately, this most fundamental aspect is often the program’s most challenging task. Sometimes it seems that it’s more art than science. Many would say that labeling this process as a “craft” would be [...]

0 comments Click to continue...

Building Database Applications with Monarch

October 21, 2007

Importing Your Exports You know that you can count on Monarch to mine data from your reports. You might even be using Monarch to combine data from various sources. But have you considered using Monarch as your main database program? Developing database applications is usually the realm of programmers and systems analysts, but you may [...]

0 comments Click to continue...

Custom Reporting with Excel’s Pivot Tables

October 21, 2007

Driving Your Data to the Finish Line You’ve worked hard to mine data from your reports. You’ve used calculated fields and external lookups to add value to your base data. You then used filters to isolate the most important data from the mountain of information you have at your disposal. How are you going to [...]

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.