Blog

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