Menu
Close
Have you ever used the VLOOKUP formula with the approximate match in Excel? By using this formula, you’re able to extract the correct trade discount percentage based on the quantity of a specific item purchased. In this tip, we demonstrate how to set this up. If TRUE or 1 is specified in the Range_lookup argument text […]
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 […]
Have you ever run out a report only to find the need to change the sorting of a specific field once the output is in Excel? This can be quite taxing, especially if you run multiple reports with a lot of data on a regular basis, and if you need to sort multiple columns on […]
For quick access to related information in another file, workbook or on a web page, you can insert a hyperlink in a Microsoft® Excel® worksheet cell. You can also insert hyperlinks in specific chart elements or images. If you struggle to navigate to various worksheets in a large workbook, then hyperlinks may be your solution. […]
“When are you introducing user-defined functions for Excel?” This was the big question we had for Microsoft back in the middle of this year (2017). Specifically for us, this meant user-defined functions that were defined in Javascript, and made available through our web-based Excel add-in for the cloud version of Sage Intelligence. We’d asked this […]
You can quickly view or compare two or more worksheets in the same workbook, or in different workbooks, by viewing them side by side. You can also arrange multiple worksheets to view them all at the same time. In this tip, I show you how. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. […]
Multiple users can effectively work on a spreadsheet by sharing it, and then collaborating on it. Edits can be made simultaneously by team members, thus having a continuously updated version of the spreadsheet available all the time. In this way, version control is enforced, and duplicate work is eliminated. Applies To: Microsoft® Excel® for Windows […]
Numbers containing more than 15 digits in Excel are not often used, however some users might use them when recording credit card numbers, account numbers, stock codes, etc. Applies To: Microsoft® Excel® for Windows 2013 and 2016. Excel can’t handle more than 15 digits per cell, and so when these numbers are entered, Excel stores […]
As you work through a spreadsheet, you may delete a number of cells and then want Excel to shift all the cells up again so that there are no blanks. In this tip, we explain how to remove blank cells between your data in Excel so that this happens. Applies To: Microsoft® Excel® for Windows […]
When creating a pie chart and adding data labels to the slices, the wording can sometimes split into two lines—giving you wrapped data labels that aren’t visually appealing. In the below example, Administration has been split into two words, each on a separate line. The labels are wrapped and the results appear incorrectly. Applies To: […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.