From the monthly archives:

April 2008

Building Excel Formulas with Monarch

April 27, 2008

Regular readers will recognize the name Nick Osdale-Popa from his contribution to the site a few months ago that gave all of us a better color management tool for Excel.
Well he’s been at it again, only his activity wasn’t recent; it was almost four years ago!
Nonetheless, I only discovered his idea this week and thought [...]

2 comments Read more...

Use Monarch to Build a Report with Both Details and a Summary

April 25, 2008

I was recently contact by a regular ExcelWithMonarch.com reader, Nigel Winton of England, who relayed how he used Monarch to create an interesting solution to a challenge given to him by a co-worker.
Here’s his story…
I have one person who is always requesting something new. You know the type: flexible goal posts with no fixed abode.
Recently [...]

0 comments Read more...

Becoming Number One (and Staying There)

April 14, 2008

As I write this I’m returning from a week long vacation with my family at a world famous theme park in California. We all had a terrific time as it was the first visit for half of the group, and there were many new attractions for the other half who had been there before, some [...]

1 comment Read more...

Using Monarch for Data Entry Validation

April 11, 2008

I was recently required to review a thousand page PDF file. This file contained hundreds of financial summaries for specific topics. The challenge was, and the need for the review, was that just because certain numeric values were permitted by the online system, the updates the users provided might have been incorrect, incomplete or otherwise [...]

2 comments Read more...

How to Avoid Overloading Servers

April 8, 2008

Today I’m thrilled to welcome a very special guest to Excel with Monarch site.
Grant Perkins of Grant Perkins Consulting based near Derby, England has been an independent consultant for 12 years, assisting clients around the UK and Europe with their computing solutions, and specializes in Monarch and Datapump installations. Grant has a 25 year background [...]

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