Menu
Close
According to research, 35% of organizations indicate that demand for expedited financial information delivery is their top pressure. Financial analytics and financial reporting, are valuable sources for informed decision-making across an organization, and should be part of your company’s analytics strategy. By leveraging a financial analysis and reporting solution integrated with your business management solution, […]
In our last tip, I showed you how to create a Consolidation Connection in the Connector module, which lets you combine data from different companies into a single report to obtain a holistic view of your organization. If you would like to review the tip, you can find it here. Once one is created, there […]
Multiple users can effectively work on a spreadsheet by sharing it, and then collaborating on it. Edits can be made simultaneously by team members, thus having a continuously updated version of the spreadsheet available all the time. In this way, version control is enforced, and duplicate work is eliminated. Applies To: Microsoft® Excel® for Windows […]
I read an interesting article the other day about how a novel targeted at young, single females and housewives wasn’t selling as well as expected. When the publisher looked deeper into its sales data, it found that this market segment made up only a small portion of readers – and that the majority of buyers […]
Sometimes when working in Excel, you may want to compare two versions of a workbook to see what was changed. It could be an issue such as totals that are manually entered instead of formula calculated that you want to check. You can use Microsoft Spreadsheet Compare to run a report on the differences, and […]
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 […]
You may be aware that Sage Intelligence allows you to connect to any ODBC compliance data source, meaning that you can access and report on information from just about anywhere in your organisation. Included is the ability to use Microsoft Excel as a data source, which is useful in cases where your business management or […]
This tip helps you discover how to quickly display statistics on the status bar by simply highlighting data. You are welcome to download the workbook to practice. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. Excel allows for up to 6 statistic options to be viewed on the status bar, namely; Average, Count, […]
There may be times when you want to run out the same report but with different parameters. For example, you may have a financial report that you want to run individually for three separate fiscal years. Typically, you would need to run out the report three times, once for each year. Did you know that […]
This tip shows you how to generate a barcode in Excel that will enable you to track stock, sales, purchases or fixed assets. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. Excel has no built-in functionality to generate a barcode. However, this is easily achievable by simply downloading and installing a font. This tip […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.