Menu
Close
Did you know that whether you are using a standard or a customised Sage Intelligence report, you’re free to add additional fields to it in the Sage Intelligence Report Manager? There are a couple of reasons why you might want to do this. For example, perhaps the report doesn’t have a particular field you want […]
Conditional formatting is an effective Microsoft Excel feature that allows you to highlight important information, for example; the ability to find duplicate values within your spreadsheet. You can create your own rule by applying conditional formatting to individual cells or a range of cells. When you have selected the data you want to format, you […]
No matter what time of day it is, it’s never a good time for Sage Intelligence errors. What can you do to resolve these errors on your own? And, what can you do next? Sage Intelligence has made it possible to triage these issues, and if you can’t figure it out on your own—you can […]
In a previous tip, we showed you how to set up a PivotTable using PowerPivot. You’re now going to learn how you can easily calculate Sales Tax/ VAT using the Measures feature in the PowerPivot tab. If you’re the business’s accountant, you may want to analyze the Sales Tax/ VAT that will be paid on the products […]
Perhaps you’re an implementer like myself. You get a high from setting things in motion, singling out the areas where you can make the biggest difference, and attacking those relentlessly. Perhaps though, you can get so lost in the implementation and detail of your tasks or ideas, that your bigger picture field of view is […]
Near the end of the 2017, I read an interesting article by Microsoft’s Brad Smith, which was written as part of celebrating the completion of a 4,000-mile-long, sub-sea, communications cable between North America and Spain. The laying of this cable is an impressive achievement, as well as the fact that it can apparently transmit eight times […]
In our last tip, we showed you how to save a copy of your Excel workbook to file when running a report. If you’d like to catch up on it, then take a look here. Did you know that in addition to saving your reports in an Excel format, you have the option to run […]
In a climate of economic volatility, changing consumers, and globalized competition, small to medium-sized enterprises (SMEs) perhaps need access to accurate, actionable business insight into data even more than bigger enterprises do. Most SMEs are operating on tight margins and don’t have endless reservoirs of cash and credit. They need up-to-the-minute information about trends in […]
Apart from just running out a report, Sage Intelligence allows you to automatically save the generated workbook to a file during run-time. This is useful, for example, if you run a monthly sales report that needs to be saved to a central location for others to view. In this tip, I’m going to show you […]
A dashboard is a business tool that displays a set of metrics, KPIs and other relevant information to a business user. Dashboards are here to stay because of their simplicity and self-service capabilities. And recently, Microsoft has made dashboards even more relevant, visual and efficient to use through Power BI. Haven’t heard of it? Here’s […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.