When you are working on a project timeline in Microsoft® Excel®, the end date should always be greater than the start date; however, errors can occur when entering dates manually onto a spreadsheet. By applying Excel’s Date Data Validation you can ensure that the project end date will always be greater than the start date. […]
- 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.
Build advanced reporting skills and save time for your business with Excel on Steroids 2013 Online
Sage Intelligence – a division of Sage, the global leader in integrated accounting, payroll and payment systems – has launched Excel on Steroids 2013 Online. The course aims to help you build advanced reporting skills so that you can save time and streamline your business reporting and analysis. It is the latest offering from the rapidly […]
Improve your finance team’s financial reporting in Excel
Sage Intelligence recently launched an exciting online course for Microsoft® Excel® 2013 which will help you not only move to the next level of financial reporting, but also improve inefficiencies in your company. There are many useful features covered in this course, but in this article, we focus on three particular functions that highlight the […]
5 Easy steps using the combination chart in Excel to help you monitor budgets
There are many different charts in Microsoft® Excel®, but only one that allows you to highlight different types of information by combining two or more chart types into one. The combination chart can be used to see how far away a value is from the target or if it is over the target. In this […]
4 Easy steps using the Advanced Filter to extract unique values in Excel
Have you ever found yourself in a situation where you have thousands of duplicate values in a column? Perhaps you were importing client data into Microsoft® Excel® from an accounting system or simply combining data in Excel, but often end up having duplicates values in a given column. If you frequently experience this problem when […]
2 Easy steps using the TRANSPOSE function in Excel to re-arrange data
Have you ever needed to change the orientation of a range of cells whilst maintaining links to the source data and end up having to manually recreate the spreadsheet? Here’s a quick and easy way using the Microsoft® Excel® TRANSPOSE function. The TRANSPOSE function returns a vertical range of cells as a horizontal range, or […]
Yes, you too can excel at (Microsoft) Excel!
Millions of people around the world use Microsoft® Excel® on a daily basis. But how many of those people can really claim to excel at Excel? I’m not just talking about getting things done, but taking full advantage of Excel’s features to work as efficiently as possible. You know the ones who have a template […]
Sage Intelligence Reporting and Google Sheets integration: It is all about what is “familiar” for the customer
At the Google I/O conference, 18-20 May 2016, Google & Sage presented a prototype that allowed customers to create Google Sheets reports directly from Accounting (using Sage Intelligence Reporting Cloud). It also allowed the Google Sheets report to be automatically updated from Sage Intelligence Reporting Cloud based on customer or data changes while maintaining any […]
Get creative in Excel using sparklines to show data trends
New in Microsoft® Excel® 2010, and later versions, a sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. For more impact, a sparkline […]
An easy way to create a dual chart in Excel, trending with a secondary axis
Charts by default display a primary vertical axis when created. This works if there is only one unit of measure in the data. However, should there be different units of measure in your data, a secondary axis will be required, thus allowing you to create a dual chart in your Microsoft® Excel® workbook. In our […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.