From the category archives:

Functions

Monarch is the Solution to Fiscal Year Troubles

December 17, 2009

Conventional software works just fine for date based analysis if your fiscal year starts on January 1st. Excel will happily let you group dates placed in pivot tables as row or column fields into months, quarters or years. You’ll have nice looking and accurate summary tools in no time – if your fiscal dates match [...]

0 comments Click to continue...

A Challenging Reinforcement

November 27, 2009

As we’re at the midpoint of the 30 Days to Become a Better Monarch Modeler series, today on day 15 I have a real-life challenge and proposed solution that I think quite nicely reinforces some of the concepts and tools that we’ve discussed so far. This week a new Monarch Forum member named MikeMetta posted [...]

0 comments Click to continue...

Employing Functions for Specialized Tasks

October 14, 2009

On day 10 of the 30 Days to Become a Better Monarch Modeler series, we’ll put Monarch’s functions to work to improve our models, both by facilitating finicky data extractions and by adding useful calculations that are based on the extracted data itself. On day 8, I wrote about the types of calculated fields. In [...]

1 comment Click to continue...

Get Access to Additional Functions

March 25, 2009

In a prior post, I wrote about how Monarch outperformed Access as a report writer. Today the wind has blown the other way, and we’ll focus on how Access can provide additional functionality for your Monarch models. Monarch user Diane recently asked whether a logarithmic function was available in the software. Unfortunately it is not, [...]

0 comments Click to continue...

Batman Would Love Monarch

July 17, 2008

I always found Batman to be the cleverest of the famous super heroes. He always had the coolest gadgets, had designed them himself, and always had them at the ready. Batman doesn’t have to be the only one building cool and useful tools. One of the best ways for you to excel with Monarch is [...]

0 comments Click to continue...

Monarch’s Conversion Functions

June 19, 2008

Over the past week, we’ve been discussing Monarch various functions that you can use in your calculated fields and filters. So far, we’ve covered date functions, the special report functions that return data related to the origin of the data (as opposed to the data within the report), and we even had a quick look [...]

0 comments Click to continue...

Monarch’s Special Functions

June 16, 2008

Over the last couple of posts, we’ve examined some of Monarch functions. Since we’re on a bit of a roll, let’s carry on with the topic. Today we’ll look at a special category of functions, known as, well, special functions. There aren’t too many, so this might be pretty quick. If() Just about every application [...]

2 comments Click to continue...

Copyright © 2007 - 2013 Excel with Monarch Training and Services. All rights reserved. Privacy Policy
Microsoft Excel™ Microsoft Corporation. Monarch and Monarch Pro™ Datawatch Corporation.