Menu
Close
A step chart shows changes that occur over irregular intervals. For example, it can show stock movement changes, interest rates, etc. A step chart is the perfect alternative to a line chart as it displays the trend as well as the time taken between changes. The difference between a Step Chart and Line Chart: A line […]
This Sage Intelligence tip is focused on Sage Business Cloud Accounting. There are many decisions that need to be made in a business and basing these decisions on accurate data will help to make more informed decisions. Without data most businesses work from their experience or intuition which may not be accurate. With Sage Intelligence […]
Data visualisation is fast becoming the norm for effective business intelligence. Having visuals that tell the right story at a glance go a long way in achieving this. Microsoft® Excel® provides you with a multitude of ways to enhance the visuals that you create. In this tip, I’ll show you how to format a basic bar […]
This tip is focused on Sage Intelligence for Accounting. With the daily activity and pressure of running a business, it can be difficult to keep track of your business health. Reporting gives you a sense of your numbers, but it often doesn’t provide the detail, flexibility and presentation that you need. Sage Intelligence gives you […]
These Microsoft® Excel® tips and tricks are the top performing tips of 2018, and have raked up a combined viewership of over 200 000. Without further ado, here they are, the Top 5 Excel tips and tricks of 2018. How to consolidate data in Excel using Data Consolidation (66,027 views) How to get a distinct […]
When working with Sage Intelligence, you may feel the need to make changes to your reports using functionality that isn’t included online, like adding tables, charts, trendlines, etc. If this is you, then Sage Intelligence has you covered by allowing you to download and open your reports in Microsoft Excel, giving you access to standard […]
Not grasping why your system is returning an unexpected result can be a source of great frustration. If you suspect there could potentially be an issue with Sage Intelligence, try this quick troubleshooting technique. While Sage Intelligence is loaded on your screen, press F12 on your keyboard—this will open a console at the bottom or […]
In our last tip, we looked at the functionality of the different icons provided on the Report Manager menu ribbon. You can find this tip here. Now, we’re going to do the same for the Connector module. Take note that icons will activate / deactivate based on your selection in the object window. These icons are […]
In a previous tip, we explained how you can easily remove duplicate rows from your data using the Remove Duplicates function. You can find it here. At times though, you may just want to highlight duplicate rows without actually deleting them. In this tip, we show you how you can do this using an Excel […]
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 […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.