From the category archives:

Summaries

Seven Easy Ways to Transform Ordinary Reports into Powerful Analysis Tools with Monarch

March 27, 2012
Magical Monarch Transforms Data | Image by wrestlingentropy

Locked up tight in every single report generated by everything from your desktop accounting package to your enterprise level information system is a vast data warehouse that’s waiting for you to unlock its secrets. Monarch offers you the unique opportunity to almost magically see what isn’t there. Just like pulling a rabbit out of a [...]

0 comments Click to continue...

Monarch is the Solution to Fiscal Year Troubles

December 17, 2009

Conventional software works just fine for date based analysis if your fiscal year starts on January 1st. Excel will happily let you group dates placed in pivot tables as row or column fields into months, quarters or years. You’ll have nice looking and accurate summary tools in no time – if your fiscal dates match [...]

0 comments Click to continue...

A Summary Synopsis

November 25, 2009

Using the Report window we’ve built templates and taught Monarch how to extract our data. In the Table window we’ve added new fields and new values, but even when using filtering and sorting the data, it can be difficult to see the big picture; we’re often just too close to the details. To give us [...]

0 comments Click to continue...

Examining Chrysler Closures With Monarch

May 26, 2009

Auto maker Chrysler recently announced their intent to close 789 dealerships (PDF) in the US as part of their recovery plan. While it’s unfortunate, and will clearly have an impact on individuals and local economies, we can use their PDF list as an example of what can be done with Monarch Pro in terms of: [...]

4 comments Click to continue...

T-Shirt Monarch

May 12, 2009

Buying a T-shirt, in North America at least, means that you pick a shirt that has a label that that reads either Small, Medium, Large, Extra Large, or depending on the manufacturer, maybe Extra Small or Extra-Extra Large. This simplifies the choices rather than forcing an exact measurement. It’s not about precision; it’s about being [...]

0 comments Click to continue...

Mining Data Diamonds with Monarch

April 27, 2009

Once you’ve built the templates and calculated fields required to extract all of the data within a given report with Monarch, do you save your model, close it, and carry on to the next project, or do you spend some additional time with the report to transform your model from being perfectly functional and workmanlike [...]

0 comments Click to continue...

How to Get Direct Results Indirectly

December 17, 2008

Everybody that uses Excel regularly has their favorite functions that seem to appear in most of their work, and I’m no exception. Working as I do with data extracted by Monarch, I use Excel’s various lookup functions frequently. That said, I rarely use the Indirect function. I just never really thought that I needed to [...]

2 comments Click to continue...

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