Menu
Close
When using the SUMIF function between workbooks, you may get a VALUE error if the source workbook is not open. This behavior occurs when the formula that contains the SUMIF, COUNTIF, or COUNTBLANK function refers to cells in a closed workbook. To work around this, use a combination of the SUM and IF functions together […]
Have you ever found that at the beginning of the financial year you need to make a copy of the previous year’s workbook? If so, you’d need to delete all the old year’s data, but you would really like to keep your formulas in the worksheet. By using the Go To dialogue box, there is […]
Sometimes converting negative values to positive values can be time-consuming. This tip allows you to quickly convert a range of negative values into positive values, without having to edit each cell. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. 1. In a blank cell, enter the value -1. 2. Select the cell with […]
If you need to round a number off to a specified multiple, for example; rounding a selling price to the nearest 5cents or rounding a time to the nearest 15 minutes—then MROUND is the function to use. Below we explain how that can be done. Applies To: Microsoft® Excel® for Windows 2010,2013,2016 If you want to […]
When wanting to move a row or column in Excel from one section of a worksheet to another (e.g. from row 13 to row 10), it’s normal practice to use the Cut and Insert Cut Cells command. However, an easier and quicker way to do this is the following: Select the values in the row/rows […]
It is very easy to create a large list of named ranges but to manage those ranges can be confusing, especially if you receive the workbook from somebody else. Having a list of the named ranges in your workbook could be helpful. To get a list, follow these steps: Applies To: Microsoft® Excel® for Windows […]
In a previous tip, we showed you how to set up a PivotTable using PowerPivot. This week, you’re going to learn how you can easily calculate Sales Tax/ Vat using the Measures feature in the PowerPivot tab. If you’re the business’s accountant, you may want to analyze the Sales Tax/ Vat that will be paid on the […]
Using keyboard shortcuts in Microsoft Excel helps you increase your efficiency and productivity, and helps you to use Microsoft Excel like a pro. In this Tip, we take a look at how we can use Excel shortcuts to save us time and increase our business efficiency. We will learn how to use keyboard shortcuts to […]
The IFS function gives you an efficient alternative to the tedious task of creating a nested IF function. The IFS function checks conditions sequentially, and as soon as a condition is found to be true, the function stops and returns the specified value. You can take advantage of this logic to define a default result […]
With a 3D Map, you can plot geographical data and view it on a 3D globe or custom map. If your data is time-stamped, you can even use a 3D Map to get a geographical tour of how your data changes over time. To create a 3D Map, your data must be in table format, […]
© Sage South Africa Pty Ltd 2016
.
All Rights Reserved.