Blog

How to create a linked dashboard (or landing page) for your Excel workbook

Have you ever had the pleasure (or displeasure) of working with an extra large Excel workbook with many, many different sheets? This happens frequently, especially if you are working with a large amount of data that needs to be analyzed periodically. This may be due to multiple tables, lookups, references, charts, graphs etc. This has […]

Continue reading


Learn how to use Column Variables for more descriptive headings in your cloud reports

Having descriptive headings in a report can make it easier to comprehend.  For example, having month names instead of period values for column titles can make it easier to determine the data a column refers to.  Sage Intelligence now makes this possible in a dynamic way through Column Variables. This tip applies to: Sage Business […]

Continue reading


Using Wildcards to make finding or replacing data in Excel quicker and easier

This tip is useful when you want to replace or find text using Wildcards, e.g. if you have a column where you would like to replace everything after the space character with text. What are Wildcards? Wildcards are characters that are used to represent one or more characters. The following wildcard characters can be used […]

Continue reading


Learn how to check your Containers in the Sage Intelligence Connector module

Being able to check if the components of a report are functioning as expected while working with them can help provide a smooth workflow and save time dealing with problems later in the report creation process.  Also, if you do come across errors in a report, being able to test its components easily allows for […]

Continue reading


Sage © Sage South Africa Pty Ltd 2018 . All Rights Reserved.