Blog

Using Wildcards to make finding or replacing data in Excel quicker and easier

This tip is useful when you want to replace or find text using Wildcards, e.g. if you have a column where you would like to replace everything after the space character with text. What are Wildcards? Wildcards are characters that are used to represent one or more characters. The following wildcard characters can be used […]

Continue reading


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


How to create a Hierarchy SmartArt Graphic in Excel

Microsoft Excel offers you the ability to create and design a Hierarchy SmartArt Graphic.  This is useful in showing a graphical representation of an organogram, organisation chart or any hierarchy structure. This example, explained below, will help you create your own hierarchy. Our example scenario is of a Report Store that contains reports created for […]

Continue reading


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