Menu
Close
In a previous tip, we explained how you can easily remove duplicate rows from your data using the Remove Duplicates function. You can find it here. At times though, you may just want to highlight duplicate rows without actually deleting them. In this tip, we show you how you can do this using an Excel […]
In our example workbook, we’re working with Date, Value In and Value Out fields. We need to create a Pivot Table that will also display the variance per month, as well as a running total of the variance for the year. In this tip, we show you how to do this. First up; select your […]
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 […]
This tip may seem basic, but with Microsoft continually adding value to its products—we just had to mention it. It’s lead by a repository of every icon imaginable (and maybe even a few that are unimaginable) that you may find useful, especially if you’re someone who likes your Excel workbooks to look a little more […]
The 3 skills and knowledge domains a Business Analyst requires to effectively add value is well versed and well documented; they need a degree of Technical Knowledge, Business Knowledge and Interpersonal Skills. Although most industry reports and literature focus on the two former items in the list, the latter is certainly not emphasized enough, and […]
In a previous tip, we showed you how you can navigate around a data list quickly using keyboard shortcuts. To view the tip, take a look here. By combining the same shortcuts with the Shift key, you can easily make selections in your data for editing purposes. Assume that you have a data list with […]
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 […]
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 […]
When working with large data lists in Excel, you may need to know the extent of the data, i.e. the number of rows and columns. If consistency of the data is important too, then you may need to identify whether there’s any empty rows, columns or cells. An obvious way to check this is by […]
Do you have an Excel management pack with multiple worksheets and would like to save it as a PDF for convenient viewing and sharing? In this tip, I’m going to show you how easy this is to do. You have three options for this, but before continuing, there are a few things to take note […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.