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

0 comments Read more...

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

0 comments Read more...

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

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 that shows units [...]

0 comments Read more...

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 more accurate, [...]

0 comments Read more...

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 well have [...]

0 comments Read more...

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 present your [...]

0 comments Read more...

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