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


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