From the monthly archives:

October 2007

Dashboard Reporting with Monarch and Excel

October 21, 2007

Steer Your Organization Right
There are any number of software companies who want help you manage your organization by using their business intelligence programs. Often referred to as executive dashboards, these programs help organizations focus on both successful and problematic aspects of their operations so they can make ongoing positive improvements by identifying what is wrong [...]

0 comments Read more...

Making Your Excel Reports Unique

October 21, 2007

Customizing Excel Easily for a Personal Touch
If you’ve been working with Excel, or any of the Office products for that matter, you’ve seen your organization produce documents with the same basic look and feel time and time again. One of the easiest ways to shake things up a bit, and simultaneously give your documents a [...]

0 comments Read more...

Filtering Data with Monarch

October 21, 2007

Finding the Needles in the Haystack
One of the main reasons that we use data extraction tools is to help us make decisions based on that data. And while the entire data set is certainly useful, often it’s the outliers, the values that are distant from the rest, or the values that exceed certain upper or [...]

0 comments Read more...

Monarch’s calculated fields

October 21, 2007

Fields of Gold
Just like building formulas in Excel, Monarch lets you build your own formulas for your specific needs. One of the tools with which Monarch stores these formulas is called a “calculated field”.
Monarch categorizes its calculated fields as follows:

Formula-based fields. These are often very similar to the formulas you use in Excel.
Runtime parameter fields. [...]

0 comments Read more...

The Basics of Building Monarch’s Expressions

October 21, 2007

Avoiding Function Malfunctions
Apart from being aware of the functions at your disposal, and how they’re used, it’s really important to understand how the software is going to interpret your functions, and the order in which you want calculations to take place.
Central to this process is the topic of Boolean logic. Don’t get scared off if [...]

0 comments Read more...

Welcome to Excel with Monarch!

October 21, 2007

The Greatest Pair of the 21st Century!
Macaroni and cheese. Lennon and McCartney. Peanut butter and jelly. Penn and Teller. On their own, they’re good. They’re very good. But together, it’s magic.
And so it is with Microsoft Excel and Datawatch Corporation’s Monarch. Individually, they’re terrific examples of successful software. Use them together and you’ve got a [...]

6 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.