Using conditional formatting with custom Excel formulas

Conditional formatting is an effective Microsoft Excel feature that allows you to highlight important information, for example; the ability to find duplicate values within your spreadsheet. You can create your own rule by applying conditional formatting to individual cells or a range of cells. When you have selected the data you want to format, you […]

Continue reading


Have you got your head stuck in the cloud?

Cloud technology; modern day society’s means to life. A social and educational necessity to the millennial, Xennials’ daily newspaper and a spring of economic and financial opportunity for households and governments. It has become an increasingly integral part of our daily lives, how we interact, how we obtain information and how we perform our professional […]

Continue reading


Learn how to share your report between different users and companies

Did you know that in Sage Intelligence you can design a report in one company and view that same report in a different company?  That’s right, just as long as those companies carry the same account structure, you can share your report. This report will go through the following process: Designed in one company Exported […]

Continue reading


Are you seeing the wood for the trees, or rather, the information for the data?

Perhaps you’re an implementer like myself. You get a high from setting things in motion, singling out the areas where you can make the biggest difference, and attacking those relentlessly. Perhaps though, you can get so lost in the implementation and detail of your tasks or ideas, that your bigger picture field of view is […]

Continue reading


Five non-negotiable questions you should be asking your reporting solution

Many companies today suffer from a lack of visibility into key performance metrics. We call this “keyhole visibility” because it’s the equivalent of trying to evaluate what’s happening in a room by looking through the keyhole. With a narrow view, you’re unable to fully understand what’s behind the door and what might be lurking around […]

Continue reading


Two ways to create calculated columns and rows in your Sage Intelligence reports

To create insightful and highly customizable reports, Sage Intelligence provides you with the ability to add calculated columns and rows to your reports.  These can be used to calculate, for example, variances, totals and other indicators at account and account category level, or based on your columns.  The below provides and explanation of the different […]

Continue reading