Menu
Close
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 […]
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 […]
This tip helps you discover how to quickly display statistics on the status bar by simply highlighting data. You are welcome to download the workbook to practice. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. Excel allows for up to 6 statistic options to be viewed on the status bar, namely; Average, Count, […]
Instead of displaying values, you can actually display formulas as a way of reviewing the spreadsheet. In this tip, we explain how that can be done. You are welcome to download the workbook to practice. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. To show all formulas in a worksheet, hold down the Ctrl […]
Sometimes when working with spreadsheets in Excel, you may want to distribute a workbook with static values. If your worksheet has formulas that are linked to other worksheets, you may end up with the dreaded Ref# error when distributing. That is why it is important to convert the formulas to values. In this tip, we […]
Manipulating data with missing labels can pose a challenge. Copying and pasting data can be time consuming and tiresome. That is why, in this tip, we show you how to quickly restore data labels using a simple formula. If you find value in this tip, why not sign up for our Excel Tips and Tricks mailer, […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.