Menu
Close
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 […]
In today’s competitive business environment, small business owners and mid-sized business managers need to dedicate their skills to managing their businesses, and not sifting through endless reports trying to make sense of heaps of information. A snapshot view of your business is critical in a business environment when there is so much valuable information floating […]
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 […]
Keyhole visibility is a concept that is familiar to many Small & Medium Businesses (SMBs). This type of business visibility is equivalent to trying to see what’s happening in a room by looking through the keyhole of a door. Likewise, with a narrow view of your business, you are forced to make critical decisions with […]
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 […]
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 […]
Accountants, bookkeepers and financial analysts alike will tell you one of the most sought after capabilities of a well-tuned accounting package is time efficiency. No one wants to spend unnecessary time having to enter monotonous data. This is where a well-specified reference sheet in your Sage Intelligence reports can be of immense help. Take the […]
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, […]
The PivotTable is one of the easiest tools used to transform huge amounts of data into meaningful reports. Excel didn’t disappoint with the improvements that have been made to PivotTables in their 2016 version. These include the following; Field List search, Automatic Time Grouping, and Multi-select Slicers. In this tip, we explore some improvements made […]
Understanding cash flow is a vital component of any business. According to Eric T. Wagner, contributor for Forbes, “At surface level, the primary reason businesses fail is that they simply run out of cash.” Knowing how much money is coming into and going out of your business means you can determine your net cash flow […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.