Blog

How to create a Hierarchy SmartArt Graphic in Excel

Microsoft Excel offers you the ability to create and design a Hierarchy SmartArt Graphic.  This is useful in showing a graphical representation of an organogram, organisation chart or any hierarchy structure. This example, explained below, will help you create your own hierarchy. Our example scenario is of a Report Store that contains reports created for […]

Continue reading


Learn how to edit standard reports in Sage Intelligence for your Sage Business Cloud solution

Sage Intelligence provides you with several standard reports that are displayed under the Standard Reports page as soon as you open the application.  They provide you with necessary, ready-to-use value right off the bat. To ensure that you always have an original instance of these reports, they cannot be edited or deleted in their original […]

Continue reading


Learn how to flag missing accounts in your Sage Intelligence Financial Report Designer report layouts

Depending on your Sage business solution, you may or may not have the Missing Accounts feature in your Financial Report Designer report.  Even if you have this functionality, you are still not automatically alerted that account level detail may be missing from your layout.  In this tip, I’m going to share a way to identify […]

Continue reading


Learn how to extract more than one column of data with a single VLOOKUP formula in Excel

It’s been well over 10 years since I started training Microsoft Excel to corporate clients. During training sessions, delegates would usually ask questions on how they can use Excel to help them become more effective in their work. Last week, a financial manager asked me how she could easily look up more than one field of data […]

Continue reading


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