From the monthly archives:

November 2009

Creating New Opportunities With Monarch

November 29, 2009

It’s day 16 of the 30 Days to Become a Better Monarch Modeler series and for today I had scheduled a discussion about combining data sources with Monarch.
But reviewing some of the existing content on the topic already available here on ExcelWithMonarch.com, most notably a somewhat lengthy comparison of the available internal and external lookup [...]

0 comments Read more...

Datawatch Introduces v10 Updates

November 29, 2009

Some time ago I wrote about how auditors should be able to use Monarch to assist both themselves and their clients.
Last month Datawatch published an update to Monarch which brings the current release to version 10.5. The patch is a free upgrade to users of version 10 of the program.
In addition to a few necessary [...]

0 comments Read more...

A Challenging Reinforcement

November 27, 2009

As we’re at the midpoint of the 30 Days to Become a Better Monarch Modeler series, today on day 15 I have a real-life challenge and proposed solution that I think quite nicely reinforces some of the concepts and tools that we’ve discussed so far.
This week a new Monarch Forum member named MikeMetta posted a [...]

0 comments Read more...

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

0 comments Read more...

A to Z Monarch

November 25, 2009

Yesterday’s topic of filtering Monarch’s extractions and calculations helped to focus on specific aspects of the data. But what if, even after that effort, we’re still left with a large sample to make sense of?
Today on day 13 of the 30 Days to Become a Better Monarch Modeler series, we’ll rather quickly sort through, well, [...]

0 comments Read more...

Finding Critical Data with Monarch

November 23, 2009

Well here we are again with another unexpected interruption of the 30 Days to Become a Better Monarch Modeler series. This time around, I had to take an unplanned business trip that threw a bit of a proverbial wrench in my machine. This was followed by returning to a sick family, and eventually and inevitably, [...]

0 comments Read more...