Tips & Tricks

Learn how to report on more than just your financials in the Financial Report Designer






The Sage Intelligence Financial Report Designer report provides a comprehensive tool for your financial reporting needs.  However, there may be times when you’d like to include other data in it to add to the information you can report on in a single report. Although the Report Designer has a defined structure which must be maintained, […]

Continue reading


How to quickly rearrange your worksheets in alphabetical order






Are you looking for a shortcut to quickly rearrange your worksheets in alphabetical order?  Instead of dragging and manually arranging your worksheets, you can use VB for Microsoft® Excel® to quickly rearrange them into alphabetical order. Excel currently has no built-in function to rearrange your worksheets. Therefore, if you have a workbook with many worksheets, […]

Continue reading


How to enhance your Excel dashboards with Power View reports






Dashboards in Microsoft® Excel® are used for visually presenting important business information. Dashboards can display current status of metrics and key performance indicators. In this tip, we look at how to enhance dashboards with a Power View report by analyzing sales data. Power View reports in Microsoft® Excel® pull your data together in tables, matrices, […]

Continue reading


Sage © Sage South Africa Pty Ltd 2016 . All Rights Reserved.