Menu
Close
Shortcut keys are common in many software applications and can save you time by making common functions easy to perform. Sage Intelligence is no different, and several shortcuts are provided in both the Report Manager and Connector. They are as follows: CTRL + R In the Report Manager, selecting a report and pressing CTRL + […]
Have you ever felt the need to effortlessly switch the date ranges within your Pivot Table in Excel? Have you ever wanted to view the data for just one specific time-frame without having to apply a logical filter all the time? When is the last time you were able to get your Pivot Table to […]
The 3 skills and knowledge domains a Business Analyst requires to effectively add value is well versed and well documented; they need a degree of Technical Knowledge, Business Knowledge and Interpersonal Skills. Although most industry reports and literature focus on the two former items in the list, the latter is certainly not emphasized enough, and […]
In a previous tip, we showed you how you can navigate around a data list quickly using keyboard shortcuts. To view the tip, take a look here. By combining the same shortcuts with the Shift key, you can easily make selections in your data for editing purposes. Assume that you have a data list with […]
You may have reports that you don’t run out often, if at all. A common example is the sub-reports of a union report, and you only ever run out the union report. Having these additional reports in your Report Manager may be necessary but can clutter up your folders. Fortunately, the Report Manager gives you […]
Let’s say you have a workbook containing sales over a two year period. You would now like to know what the average is for your top 5 sales values, as well as the value for your largest sale. In our example, which you are welcome to download here, we are using Column A for the […]
Sometimes, large Microsoft Excel workbooks can be slow and inefficient—which could cause frustration. To reduce the size of a workbook, consider replacing several formulas with a single array formula. Array formulas can perform multiple calculations and they also ensure consistency, which can lead to greater accuracy. Furthermore, array formulas provide for more security, since a […]
Sage Intelligence have introduced five interactive dashboard reports to Sage Business Cloud Accounting that will give you regular insights into your business’s key performance indicators. With these improved reports, you’ll be empowered with the ability to drill down into the detail of your information so that you can make faster decisions and act more decisively. […]
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 […]
Being able to save your reports to PDF provides a convenient way to view and share them. Sage Intelligence provides two common ways that you can do this. These include; distributing a report as a PDF using the Distribution Options in Excel once a report has run out, and using the Generate Output File field […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.