From the monthly archives:

January 2008

How to Create a Dashboard Reporting System – Part Two

January 24, 2008

In Part One of this series, we basically set the stage for a performance dashboard project. Today we’ll lay the foundations for your custom business intelligence system.
What Does Your Dashboard Reveal?
Just as you would if you were taking a road trip, you won’t know if you’ve arrived if you don’t know where you’re going, so [...]

1 comment Read more...

How to Create A Dashboard Reporting System – Part One

January 23, 2008

A few weeks ago on Inc. Magazine’s Technology web site, respected business writer Anita Campbell wrote a piece entitled “Ten Must-Have Tech Tools for 2008“. In it, one of items she recommended that every business take advantage of in the coming year is the business dashboard.
I couldn’t agree more, and I’ll take her recommendation a [...]

0 comments Read more...

Monarch Benefits IT Staff Too

January 16, 2008

I’ve often talked about Monarch’s ease of use advantage, in that it doesn’t require you to have a programming or technical IT background to get the results and the data that you need.
But what if you do have the skills of a programmer? You wouldn’t possibly need Monarch then, would you? You’d easily be able [...]

1 comment Read more...

Monarch Benefits Popular Accounting Package Users

January 13, 2008

Video: Monarch’s Multi-Column Region
Every business uses some form of accounting software. Of course, just as there are different sizes of firms, there are large scale and small scale accounting software solutions. Similarly, not every firm uses a complex ERP solution; more often than not they’re using software purchased at a local office supply or electronics [...]

3 comments Read more...

Better Excel Color Management

January 8, 2008

A Complete Rewrite (Already!)
Loyal Excel with Monarch reader Nicholas Osdale-Popa contacted me to let me know that the Free Excel Color Tool inspired him so much that he not only decided to take it upon himself to take the concept to the next level, but decided to share his creation with all of us too!
While [...]

0 comments Read more...

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

Excel’s Subtotal Function

January 3, 2008

Making it all add up
One of the great new features in Monarch v9 is the ability to include Excel formulas when exporting a Monarch summary with simple Sum key level subtotals to an Excel file. This lets you do some what-if work with the exported data much more easily than was possible with prior Monarch [...]

0 comments Read more...

← Previous Entries