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 […]
- Solutions
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
- Resources
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
Additional Reports
Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.Sage Intelligence Tips & Tricks
Our Sage Intelligence Tips and Tricks will help you make the most of your favorite reporting solution.Excel Tips & Tricks
Our Excel Tips and Tricks will help you improve your business reporting knowledge and skills.- Learning
- Support
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
Additional Reports
Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.Sage Intelligence Tips & Tricks
Our Sage Intelligence Tips and Tricks will help you make the most of your favorite reporting solution.Excel Tips & Tricks
Our Excel Tips and Tricks will help you improve your business reporting knowledge and skills.Get Support Assistance
Can’t find the solution to the challenge you’re facing in the resource library? No problem! Our highly-trained support team are here to help you out.Knowledgebase
Did you know that you also have access to the same knowledgebase articles our colleagues use here at Sage Intelligence? Available 24/7, the Sage Intelligence Knowledgebase gives you access to articles written and updated by Sage support analysts.Report Writers
Having some trouble creating or customizing the exact report you need to suit your business’s requirements? Contact one of the expert report writers recommended by Sage Intelligence.- Sage City
- University
- About Us
- Contact Us
Home automated spreadsheets
Learn the various Report Manager menu ribbon functions
When you use the Sage Intelligence Report Manager module, you will see an array of icons on the menu ribbon. Here is a quick tip on their functionality. Take note that icons will activate / deactivate based on your selection in the object window. These icons are available on software using Sage Intelligence Core 7.3 […]
How to add a variance and running total in a Pivot Table
In our example workbook, we’re working with Date, Value In and Value Out fields. We need to create a Pivot Table that will also display the variance per month, as well as a running total of the variance for the year. In this tip, we show you how to do this. First up; select your […]
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 […]
Learn how to use Title Variables in your Sage Intelligence reports
Having a meaningful title for a report can help make its intention clear. For example, being able to add a date to a report name allows you to tell at a glance what information the report is referring to, and having this work dynamically is an obvious convenience. Sage Intelligence has now made this possible […]
Save time by using shortcut keys in Sage Intelligence
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 + […]
Discover a more detailed analysis of dates using timelines in Excel
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 […]
Let’s get personal!
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 […]
How to keep your Report Manager tidy by hiding reports you don’t use
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 […]
How to calculate the average of the top 5 values
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 […]
Return to topLearning
Sage South Africa© Sage South Africa Pty Ltd 2020 . All Rights Reserved.