Are you looking for a shortcut to quickly rearrange your worksheets in alphabetical order? Instead of dragging and manually arranging your worksheets, you can use VB for Microsoft® Excel® to quickly rearrange them into alphabetical order. Excel currently has no built-in function to rearrange your worksheets. Therefore, if you have a workbook with many worksheets, […]
- Solutions
All Solutions
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50 U.S Intelligence Reporting
- 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
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50 U.S Intelligence Reporting
- 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.
Learn how to categorize debtors balances in Excel using icon sets
As an accountant, you can easily categorize debtors balances by using the conditional formatting – icon sets option. Icon sets creates a visual effect in your data and helps you to see how the value of a cell compares to other cells. In the example below we categorize the debtors balances as follows: red icon […]
5 Easy steps to enhance your dashboards in Excel using the camera tool
The camera tool enables you to take a picture of a range of cells and display it in a preferred way, thus allowing you to enhance your dashboards. The picture will automatically update when the data in the original cells change. In this example, the column Sparkline chart will be rotated to create a bar chart enabling […]
5 Easy steps using Data Validation for dates in Excel
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. […]
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 […]
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 […]
Learn how easy it is to reduce the size of an Excel workbook using a single array formula
We often find ourselves working with Microsoft® Excel® workbooks that contain large amounts of data, causing them to process instructions slowly. To reduce the size of an Excel workbook, consider replacing several formulas with a single array formula. Array formulas can perform multiple calculations and ensure consistency which can lead to better accuracy in your […]
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 […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.