Excel with Monarch Training and Services — Stop working for your data. Make your data work for you.

Overcoming Limitations and Developing Top N Tables

August 31, 2010

The ability of Monarch to sort key fields in both the Table and Summary windows is tremendously useful as it enables us to further analyze our data. The ability to focus only on the most important data can be critical when working with data sets of any size.

photo credit: sam_churchill
Let’s assume that we have [...]

0 comments Read more...

Monarch is a Complete Solution

June 3, 2010

Auto mechanics have cabinet after cabinet of tools, as do carpenters and plumbers, surgeons and dentists. Every tool has a special use and its shape and purpose has been refined over many, many years. The physical space required to house these collections of tools can be tremendous.

photo credit: Watt_Dabney
The other night I attended a [...]

0 comments Read more...

Why Excel 2010 Matters to You

April 15, 2010

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

Practice Building Models for Personal Projects

April 13, 2010

Today’s post is the final contribution – for now – from UK-based consultant Grant Perkins who kindly offered his assistance while I was ill.
I can’t speak for everyone of course but personally I find that something that interests me is much more rewarding to work with and through than something that does not interest me.
Now [...]

3 comments Read more...

Favorite Functions and Features

April 8, 2010

UK-based consultant Grant Perkins continues to share his insights with us while I do my best to fight back against a touch of pneumonia.
As users will know (I hope!) Monarch offers a broad selection of Functions to help us extract information from a wide range of data sources and then shape it into the format [...]

0 comments Read more...

One Report to Fit Them All

April 6, 2010

This is second in a series of contributions from UK-based consultant Grant Perkins. Today Grant offers some sweet ways to enhance your contribution to your organization.
How many times have you been asked to provide some information or an analysis from a new source and thought: “I have all that in my old sources”?
How many times [...]

0 comments Read more...

Making the Most of IT

April 4, 2010

Somehow I’ve managed to wind up with case of pneumonia, and thus my recent absence. While I continue to fight it off, UK-based Monarch expert Grant Perkins has kindly volunteered to share a few of his ideas over next few posts.
Here’s Grant’s first submission.
Back in 2009 The Register ran a series of reports by Dale [...]

0 comments Read more...

← Previous Entries