From the category archives:

Excel Reporting

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

2 comments Read more...

Restoring the Last 8 Seconds

November 24, 2008

For the last couple of years I’ve been running a particular report generation every week. This Excel custom VBA program acquires new data with Monarch, of course, and creates a distributable file that shelters the recipients of the file from the behind the scenes calculations required to get to the end result. One of the [...]

1 comment Read more...

How Monarch Makes Quick Work of Long Term Improvements

November 3, 2008

Not every process improvement task that you undertake needs to take weeks or months to accomplish. Sometimes you can genuinely produce terrific long term benefits in mere minutes.
I was recently approached by someone began the conversation by saying that he needed my help to “automate a report update with some programming”.
He had been manually updating [...]

0 comments Read more...

Is 80 Percent Better Than 100 Percent?

September 22, 2008

Technology blogger Robert Cringley wrote today about 80 percent solutions.
“80 percent solutions … are fast, increasingly reliable, and keep the end users in the loop from almost the beginning.”
This got me wondering: do 80% solutions now suffice nearly 100% of the time? And is this acceptable? Should we strive for more? Is the incremental improvement [...]

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

Presentation Matters

March 26, 2008

I was watching a music documentary on television recently, and one of the comments made really, um, struck a chord with me.
The interviewee in one particular segment was talking about how the introduction of music video in the 1980’s changed the industry, and how the careers of talented musicians such as Supertramp arguably ended almost [...]

0 comments Read more...

Revise Excel Formulas Quickly with Search and Replace

March 4, 2008

You can save yourself a lot of manual editing, or even copying and pasting, in Excel by using the search and replace (Ctrl-h) feature. This will replace all occurrences of one value, or even a part of a formula, with a different value.
Say you defined a lookup range improperly, setting the rightmost column to H, [...]

0 comments Read more...

← Previous Entries

Next Entries →

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.