How to reduce the size of a workbook using a single formula

Sometimes, large Microsoft Excel workbooks can be slow and inefficient—which could cause frustration.  To reduce the size of a workbook, consider replacing several formulas with a single array formula. Array formulas can perform multiple calculations and they also ensure consistency, which can lead to greater accuracy.  Furthermore, array formulas provide for more security, since a […]

Continue reading


Learn how to flag missing accounts in your Sage Intelligence Financial Report Designer report layouts

Depending on your Sage business solution, you may or may not have the Missing Accounts feature in your Financial Report Designer report.  Even if you have this functionality, you are still not automatically alerted that account level detail may be missing from your layout.  In this tip, I’m going to share a way to identify […]

Continue reading


Learn how to extract more than one column of data with a single VLOOKUP formula in Excel

It’s been well over 10 years since I started training Microsoft Excel to corporate clients. During training sessions, delegates would usually ask questions on how they can use Excel to help them become more effective in their work. Last week, a financial manager asked me how she could easily look up more than one field of data […]

Continue reading


How to effectively use custom number formatting to display your + or – values

In order to effectively analyze data, custom number formatting can be applied to your Microsoft Excel spreadsheet. Custom number formatting is used to easily identify values based on a set criteria. In a large Excel spreadsheet, you can easily highlight all negative or positive values by using custom number formatting. In this example, we are going to […]

Continue reading


Additional Sage Intelligence reports to boost your business

How would you like constant access to a library of additional reports?  The Sage Intelligence Report Utility allows you to select the reports you like and automatically imports them into your Report Manager.  All you need to do is download and install the Report Utility, select the reports you want, and click the Download button. […]

Continue reading


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