Menu
Close
Many companies today suffer from a lack of visibility into key performance metrics. We call this “keyhole visibility” because it’s the equivalent of trying to evaluate what’s happening in a room by looking through the keyhole. With a narrow view, you’re unable to fully understand what’s behind the door and what might be lurking around […]
For quick access to related information in another file, workbook or on a web page, you can insert a hyperlink in a Microsoft® Excel® worksheet cell. You can also insert hyperlinks in specific chart elements or images. If you struggle to navigate to various worksheets in a large workbook, then hyperlinks may be your solution. […]
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. […]
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 […]
Mobility has changed the way we work—especially for businesses that depend on personnel not working at a desk or in and office. When asked how “anytime, anywhere” connectivity helps business leaders be more efficient, they typically respond with three answers: convenience, communication, or collaboration. Convenience When operations or field personnel need to call office staff […]
Reporting Trees is a feature of the Financial Report Designer, and allows you to model organisational hierarchies based on the structure of your business. You can then filter your layouts by the different units in your trees to view your data in ways that make sense to you. Sage Intelligence makes use of wildcards to […]
In Sage Intelligence, account balances are typically returned in their “natural format” from your Sage accounting or business management solution. In other words, credit accounts (with a credit balance) are shown as negative values and debit accounts (with a debit balance) are shown as positives values. However, in financial reporting, there are times when the […]
Numbers containing more than 15 digits in Excel are not often used, however some users might use them when recording credit card numbers, account numbers, stock codes, etc. Applies To: Microsoft® Excel® for Windows 2013 and 2016. Excel can’t handle more than 15 digits per cell, and so when these numbers are entered, Excel stores […]
As you work through a spreadsheet, you may delete a number of cells and then want Excel to shift all the cells up again so that there are no blanks. In this tip, we explain how to remove blank cells between your data in Excel so that this happens. Applies To: Microsoft® Excel® for Windows […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.