Have you ever wondered how you can set up your reports to pull data from the same day you run them, without having to manually change the Parameter values each time? Sage Intelligence System Variables make this possible and allows for more efficient ...

Named ranges are an essential feature in Microsoft® Excel®.  They are easy to use in formulas and can be used anywhere in a workbook. The trick comes in when you have to remember all the defined names you have created.  An easy way ...

In the Report Manager there are several, helpful shortcuts you can use to simplify your use of it.  Below is a list of them and also where to find them.   To find this list go to the Report Manager, select the Help Tab and then select ...

When viewing numerical data in Excel, you may at some point want to represent this data visually. This gives you the ability to easily analyze large amounts of data. Charts and graphs also make your report look more professional and can even help whe...

When using a data validation list, only one column of data is displayed, but sometimes there is a requirement for additional columns to be displayed simultaneously.  The multi column data validation list gives you the ability to look up data usi...

We have come to the final part of this Sage Intelligence 3-part series! Let’s take a look at what we have been through so far. In Part 1, you learned how to get started in the cloud with Sage 50cloud Intelligence giving you insta...

You’ve reached the final part of this Sage Intelligence 3-part series. Let’s recap what we have been through so far. In Part 1, you learned how to get started with Sage Intelligence Reporting so that you can have accurate a...

Welcome to Part 2 of this three-part series! In part 1 we showed you how to get started with Sage 50 Intelligence Reporting. You'll now discover how to easily customize your reports. Intelligence Reporting pulls real-time data from Sage 50 - and othe...

Welcome to Part 2 of this three-part series! In part 1 we showed you how to get started with Sage 50cloud Intelligence. You'll now discover how to easily customize your reports in the cloud. When working with Sage Intelligence reports in the cloud, ...

Have you ever experienced your Excel charts disappearing when you hide the columns showing the data? By default, Microsoft  Excel  shows only visible data in a chart. In this tip, we will show you how to easily overcome this problem, by f...

Discover how to get started with Sage 50cloud Intelligence Are you using Sage 50cloud? Did you know that Sage Intelligence is available through your Office 365 license at no additional cost?   This is how to get started: First up, let's make su...

Welcome to the first of a three-part series where you'll discover how to get started with Sage 50 Intelligence Reporting (on-premise/desktop), so that you can easily manage your business financials. In this series, you'll learn how to get a handle o...

Sage Intelligence now allows you to filter your report based on a fiscal period. No more cluttered reports, and no more redundant editing of report layouts to get your desired results! How Sage Intelligence determines Fiscal Periods Before we ...

This Microsoft  Excel  tip will come in handy when you want to create a chart that will populate your data and highlight only specific parts of that data. Download the workbook to practise this exercise. In the example below, w...

financial report often needs to be consumed in conjunction with its fellow reports and by using a management pack, this allows for just that! With Sage Intelligence, you have the ability to create, edit and view these management packs. In this tip, ...

 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 tim...

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 ...

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...

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...

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 con...

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 a...

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 / dea...

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 load...

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...

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....