From the category archives:

Functions

Exploring Monarch’s Report Functions

June 15, 2008

Last week we touched on a couple of useful conversion functions that are available to us in Monarch. Today we’ll continue looking at functions; this time focusing on one of the smaller function categories, that of the “report” functions. Report functions are those which give us data related to the actual report file in use, [...]

0 comments Read more...

Conquering Date Problems in Monarch

June 12, 2008

Yesterday I received a message from a reader asking about how she could resolve a challenge with extracting dates from her report.
The problem was that the date in the report appeared in the form of 01-Oct-07, and she wanted 10-01-2007. She’d been trying to use, correctly, the CtoD function, but kept getting null values no [...]

2 comments Read more...

Handling Floating or Missing Values with Monarch

March 13, 2008

From time to time you may run into a report designed by some renegade programmer who thought that having values shift positions from line to line on the report was actually a good idea. Additionally, maybe she thought that, rather than display zero values, it would be best if the report simply doesn’t display anything [...]

0 comments Read more...

Monarch Benefits Popular Accounting Package Users

January 13, 2008

Video: Monarch’s Multi-Column Region
Every business uses some form of accounting software. Of course, just as there are different sizes of firms, there are large scale and small scale accounting software solutions. Similarly, not every firm uses a complex ERP solution; more often than not they’re using software purchased at a local office supply or electronics [...]

3 comments Read more...

Building Efficient Excel Formulas

November 13, 2007

Little Known Ways to Help Excel Work Faster
It’s often challenging to design and build large, complex Excel models – the kind of workbook that requires dozens of sheets, each with hundreds or thousands of rows and dozens of columns. But when every sheet requires values found on other sheets you can find yourself in the [...]

1 comment Read more...

An Introduction to Monarch’s Custom Functions

October 31, 2007

Getting it Your Way
Do you find that you’re often creating elaborate, hard to read formulas in your expressions? Do you work with other Monarch users who aren’t quite as adept as you at writing expressions? You can replace that complexity with a simple to read, easy to use custom function. Introduced in version 9, Monarch [...]

0 comments Read more...

The Basics of Building Monarch’s Expressions

October 21, 2007

Avoiding Function Malfunctions
Apart from being aware of the functions at your disposal, and how they’re used, it’s really important to understand how the software is going to interpret your functions, and the order in which you want calculations to take place.
Central to this process is the topic of Boolean logic. Don’t get scared off if [...]

0 comments Read more...

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.