Menu
Close
The Analysis of Aged Creditors report will help you to effectively manage who you owe money to. As a business owner, you’ll need to know how much money you’re expected to pay your suppliers within your credit terms, and which payments you can potentially push out to help manage your cash flow more appropriately. Looking […]
Most successful businesses use a Sales Trend Analysis to report on and predict sales performance. As a small business, knowledge of this information is power! Being able to view and track Sales Trends year-on-year, as well as sales per sales representative, means that you’re kept up to date and empowered to use this information to […]
This is a tip that you’re going to really enjoy if you love imagery and visualisations in your spreadsheet! It’s not the most useful tip in the world, but for most people, especially the creative types—it will put a smile on your face because it’s so much fun to play with. In this tip, I’m […]
When working with large data lists in Excel, you may need to know the extent of the data, i.e. the number of rows and columns. If consistency of the data is important too, then you may need to identify whether there’s any empty rows, columns or cells. An obvious way to check this is by […]
How would you like constant access to a library of additional reports? The Sage Intelligence Report Utility allows you to select the reports you like and automatically imports them into your Report Manager. All you need to do is download and install the Report Utility, select the reports you want, and click the Download button. […]
As an accountant, my most valuable commodity is time. Being responsible for daily capturing, month end procedures and group reporting, I often don’t have time to breathe! Fortunately, a lot of my responsibilities are hastened because I use business intelligence (BI), which helps me extract key information from large volumes of data directly from our […]
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 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 […]
You can quickly view or compare two or more worksheets in the same workbook, or in different workbooks, by viewing them side by side. You can also arrange multiple worksheets to view them all at the same time. In this tip, I show you how. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. […]
Did you know that apart from being able to run reports out to Excel, Sage Intelligence allows you to switch output modes which can be useful when designing and debugging reports? Two additional options are provided, output to Screen and output to SQL. Output to Screen does away with rendering a report to Excel and […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.