From the category archives:

Combining Data Sources

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

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

Get Access to Additional Functions

March 25, 2009

In a prior post, I wrote about how Monarch outperformed Access as a report writer. Today the wind has blown the other way, and we’ll focus on how Access can provide additional functionality for your Monarch models. Monarch user Diane recently asked whether a logarithmic function was available in the software. Unfortunately it is not, [...]

0 comments Click to continue...

Comparing Monarch’s Internal and External Lookups

March 21, 2008

One of Monarch’s greatest strengths is its ability to add even more related data to the new data that has just been extracted. This gives all kinds of flexibility and analytical capabilities to your main information system, be it a small accounting package or a large ERP system, that it doesn’t currently provide. Imagine being [...]

3 comments Click to continue...

Video: Monarch’s External Lookups

January 7, 2008

This past weekend, it’s possible that a number of Excel users were introduced to Monarch for the first time. As they may not have even heard of the product before, I thought that this might be an opportune time to demonstrate how one can work with both Excel and Monarch simultaneously.Today’s video shows how to [...]

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