View specific aspects of several different worksheets on one worksheet

One worksheet can be used to view specific aspects of several different worksheets. This can be done using the Linked Picture option. There are a few options when consolidating information from multiple worksheets, and in this tip, we’ll deal with the most popular. The option for this tip enables you to paste the copied cells […]

Continue reading


How to reverse the sign of an account in your Sage Intelligence Financial Report Designer

In the Sage Intelligence Financial Report Designer, account balances are returned in their “natural format” from your Sage accounting or business management solution.  Therefore, credit accounts (with a credit balance) are shown as negative values and debit accounts (with a debit balance) are shown as positives values.  However, in financial reporting, there are times when […]

Continue reading


Hide a row or column when designing or editing reports in the Online Report Designer.

Creating a report can be a masterful art, and creating a report that is perfectly tailored to your audience can be an ever-evolving process – especially as the audience evolves. To ensure your report is concise and to the point, it is important to only show the items relevant to your viewers, and not any […]

Continue reading


How to ignite your Excel skills to save time and increase your productivity

Microsoft® Excel® has become one of the most widely used software applications of all time, in both small and mid-sized businesses—as well as in much larger corporations.  Whether you like it or not, Excel is everywhere you look in the business world. By investing time in your Excel skills, you’ll not only increase your efficiency in operating the […]

Continue reading