Menu
Close
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 […]
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 […]
In part one of this blog, I posed a few key questions that probed into how you feel you make a difference in the world—as desk-job heroes—even though you have a corporate role and are in no way packing up to trek into the Andes and save mountain Lions. I loved reading the responses. Each […]
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 […]
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 […]
Instead of displaying values, you can actually display formulas as a way of reviewing the spreadsheet. In this tip, we explain how that can be done. You are welcome to download the workbook to practice. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. To show all formulas in a worksheet, hold down the Ctrl […]
Learning your business intelligence solution doesn’t have to be as daunting as some may feel. Here’s the thing—you already know the benefits of business intelligence (BI). You know that good BI can provide valuable, and profitable, insights for your company. But, are you fully implementing your BI solution and taking advantage of all of its […]
Sage Intelligence gives you a lot of value out-the-box, through the ready-to-use reports provided in the Report Manager and the free reports that you can access via the Report Utility. If these aren’t exactly what you’re looking for then you also have the ability to tweak them to suit your needs or build your own […]
In Sage Intelligence, a number of reports are provided out-the-box for each Sage product. Most of these are standard ‘single company’ reports with some of them provided as consolidation versions—allowing you to aggregate data from multiple companies and create a multi-company report. It is, however, possible to turn any standard report into a consolidation report, […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.