From the category archives:

Excel Reporting

Why Excel 2010 Matters to You

April 15, 2010
Image by fotographix.ca

photo credit: fotographix.ca
Have you seen some of what is soon to be available in the upcoming release of Excel 2010? Microsoft has produced some videos to demonstrate the new abilities of the software.
But before I share those with you, I thought that I’d include their “History of Business Intelligence”. While a little lengthy, it’s [...]

1 comment Read more...

Building Reporting Solutions for Hospital Operations

March 14, 2010
Image by Edgar Zuniga Jr.

With its unique abilities and affordability, Monarch software is well placed to assist those working in the healthcare industry, an area in which I must say that I don’t have much firsthand experience. But while information is information, and data is data, and I hope that much of what is available here is both useful [...]

0 comments Read more...

Learn to Program Excel to Become a Better Monarch Modeler

February 7, 2010

Working with Monarch to extract and manage the data we need is usually a very efficient experience. Often there are just three basic steps:

Open the data source,
Apply the model that was previously created, and
Export the data to another location for further use or analysis.

As we know from our earlier discussions in the 30 Days to [...]

2 comments Read more...

Focus Your Command of Monarch

February 3, 2010

Congratulations! You’ve read every part of the 30 Days to Become a Better Monarch Modeler series, and now, hopefully, you’re much more accomplished and proficient than you were beforehand.
You’ve mastered defining templates. You can handle just about any kind of report layout that comes your way. You can add new fields that extend the usefulness [...]

0 comments Read more...

Share Your Story with Monarch

December 11, 2009

Over the course of the 30 Days to Become a Better Monarch Modeler series we’ve learned how to positively fill Monarch with actionable data. We’ve morphed reports that had content that was cast in stone into dynamic and practically living data that is now free to tell its once concealed story.
But all great stories need [...]

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

Get Enchanted with Excel

March 17, 2009

A sufficiently high level of technology is indistinguishable from magic.
- Arthur C. Clarke
Jon Peltier is the wizard of Excel charting. On his PTS Blog, he describes how to make Excel do things with graphs that you not only likely believed to be impossible, but you may not have even dreamed up the concept in the [...]

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.