Tips & Tricks

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


Saving changes to an existing report layout in Sage Intelligence Reporting






Sage Intelligence Reporting allows you to create reports of your own, as well as customize your existing ones, all in the familiar environment of Microsoft® Excel®.  This is based on the Excel template that gets attached to each report.  Once it’s linked back, after any changes have been made, the formulas will update seamlessly with […]

Continue reading


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