Slicers are used for filtering data and gives you a better understanding of your information. By using slicers you can quickly drill down on a PivotTable. Slicers also indicate the current filtering state, which makes it easy to understand what exactly is shown in a filtered PivotTable report. You can save time by linking slicers […]
- 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.
5 Easy steps to create a PivotChart in Excel
You can easily represent your data from a PivotTable into a PivotChart. PivotCharts allow you to graphically represent your data which can help you to easily see comparisons, patterns and trends. For example, a Sales Manager can use PivotCharts to analyse the performance of his or her sales staff. A PivotTable is an interactive table […]
Learn how to easily round off time values in Excel using the MROUND function
Working with time values comes with its own challenges. One of the issues is how to round off time values from seconds to minutes or minutes to hours. You can use the MROUND function to round off time values. The MROUND function returns a number rounded to the nearest instance of a specified multiple. It’s […]
How to quickly round off numbers using the ROUND function in Excel
Anyone who works with figures in Microsoft® Excel® knows the importance of quickly rounding off numbers. Luckily Excel has an easy function that allows you to round off numbers without any hassle. Instead of clicking the increase or decrease decimal options on the ribbon, you can use the ROUND function to round off numbers to […]
2 Easy steps to help you lookup data in Excel using multiple criteria
In last week’s tip, I showed you how to extract more than one column of data with a single Vlookup formula. However, if you want to lookup data with multiple criteria then you can use the INDEX and MATCH functions. You can lookup data that meets multiple criteria and overcome the limitations of the Vlookup, thus […]
How to calculate a deposit or down payment in Excel
Purchasing a car or a house is usually a pleasant experience for the buyer. However, most financial institutions require a deposit or down payment to be made towards the total purchase price. In this week’s tip, we share how to calculate the deposit or down payment for a car. For instance, the cost of the […]
Easy Steps to using the Compound Interest Calculator in Excel
My daughter just completed a project of creating a piggy bank at school. This reminded me of the importance of saving. The return on investment is often determined by interest rates and this is why investors or anyone who wants to save chooses the right moment to make an investment. In this week’s tip we […]
4 Easy steps to Calculating Formulas with the Paste Special Command
Have you ever wondered how to use the formulas operations under the Paste special command? You can divide, add, multiply and subtract values when you copy and paste. Let’s say, you want to quickly convert values from millions to thousands when you copy and paste, you can use the paste special divide formula. This command […]
Learn how to quickly consolidate your data using the Paste Link command in Excel
Did you know that you can use the Paste Link command to quickly consolidate data from multiple Microsoft Excel worksheets into one? The consolidated data can be more easily analyzed and combined on a regular or ad-hoc basis. Furthermore, the consolidated data will be updated whenever changes are made in the source worksheets. Let’s check this out […]
Summarize your company’s financial status with our balance sheet statement
We continue our series on financial templates and in this week’s tip we share the balance sheet statement. The balance sheet statement summarizes a company’s assets, liabilities and capital at a particular point in time. These three balance sheet segments give business owners an idea as to what the company owns and owes. It also […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.