If you need to round a number off to a specified multiple, for example; rounding a selling price to the nearest 5cents or rounding a time to the nearest 15 minutes—then MROUND is the function to use. Below we explain how that can be done. Applies To: Microsoft® Excel® for Windows 2010,2013,2016 If you want to […]
- 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 Tips and tricks
How to convert dates into the correct format in Excel
When extracting data from a database, dates don’t always show up in the format you want them to. That’s why it’s helpful to know how to use the Text to Columns option to convert dates into a format that can be used to easily analyze or work with data. As an accountant, you may want […]
The Sage Intelligence Reporting resources and learning you need, all in one place
To enable you to get going and make the most of our smart reporting solution, here’s a list of the helpful Sage Intelligence Reporting resources available in our resource library: You can engage with partners and customers right now on the Sage Intelligence Reporting Community. Download the one-page Kick-off guide specific to your accounting/BMS solution […]
Our top 5 Sage Intelligence tips shared in 2015
In 2015, we shared a total of 24 Sage Intelligence Reporting tips with you. We’ve reflected on which ones were the most popular rounded up the top 5 tips. The top 5 tips are based on how many times they were viewed by our subscribers throughout the year. 1. Introducing the new Sage Intelligence Report […]
Return to topLearning
Sage South Africa© Sage South Africa Pty Ltd 2020 . All Rights Reserved.