From the category archives:

Excel Reporting

Use PDF files for Distributing Dashboard Reports

May 1, 2012

Use annual reports to inspire your Monarch based dashboard reports

I’ll just come out with it: you should share PDF files, not Excel files when distributing dashboard reports. Sacrilege! Say it isn’t so! I know, this is pretty odd advice coming from someone who professes that Excel is one of the best tools available. But there are times when you have to remember that your [...]

0 comments Click to continue...

Build an Excel Dashboard Report with Monarch Data

April 15, 2012

Recently, I looked at how Monarch builds range names when exporting to Excel, and then some examples of how we can use those range names in Excel functions. Today we’ll look at the process of having Monarch create an Excel dashboard report workbook and how we can begin to easily add dramatic functionality to that [...]

2 comments Click to continue...

How to Add Excel Functions to Monarch’s Solid Foundation

March 29, 2012

Monarch Makes Beautiful Music | Image by chrisbb@prodigy.net

In the previous post, The Secret is in the Names, I wrote about how Monarch populates Excel files with useful named ranges when exporting data. Today we’ll look at how we can capitalize on those named ranges with specific Excel functions. In that previous post, the first point regarding the range names is that Monarch [...]

0 comments Click to continue...

The Secret is in the Names

March 28, 2012

We all know that Monarch can export to wide range of file formats, and that here the local favorite for Monarch exports is clearly Excel files. But do you know the three secret things Monarch does when it creates those Excel files that we can always easily exploit when working with that data in Excel? [...]

0 comments Click to continue...

Create a Different Kind of Truth with Monarch

March 22, 2012

Monarch’s forte is in not only capturing the data that’s locked in static report, but in allowing us to easily add vital information to that data, and to easily create different views of the data and share those views. Just as you can do in Excel, Monarch allows you to create new calculations based on [...]

0 comments Click to continue...

Why Excel 2010 Matters to You

April 15, 2010

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 cute, entertaining [...]

2 comments Click to continue...

Building Reporting Solutions for Hospital Operations

March 14, 2010

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 Click to continue...

← Previous Entries