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 […]
Do you want to create your own operational report and analyze it according to your specific reporting needs from Accounting International? Sage Intelligence Reporting & Microsoft Excel make this easy and quick to do. Applies to: Accounting International, Microsoft Excel 2013 & 2016 How do I do this? 1. Download one of the standard Intelligence […]
Do you want to consolidate, bring together and analyze different kinds of data in one report? You may want to view your financial, payroll and payments information in a single dashboard. Currently, you may be spending a large amount of time reviewing these different reports to be able to draw a final conclusion. In Sage […]
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 […]
If you start each day needing to use a frequently used workbook, e.g. daily sales report, to-do list, calendar, etc, then this tip is for you. You can automatically open these workbooks, by simply adding the workbooks or a shortcut in the XLStart folder. This is a specific folder that Microsoft® Excel® uses in which files […]
Auditing and troubleshooting formulas in Microsoft® Excel® can be time consuming and difficult. That is why the FORMULATEXT function is helpful because it simplifies formulae error checking and correction. The formula text can easily be extracted without having to copy and paste. The FORMULATEXT function syntax has one required input—a reference to a cell or […]
If you’ve created a Microsoft® Excel® report that needs to be printed double-sided (e.g. booklet form), you may want to have your headers or footers printed on different sides of the paper—left hand side for odd pages, and right hand side for even pages. To achieve this effect, follow this tip and use the Page […]
Charts are used for displaying data graphically, and they can be enhanced by using a pictograph. Pictographs use any picture you choose to represent as your data series in the charts. Icons can also be used as pictograph to represent data values in order to decrease the size of the graph. You will find the […]
In our last tip, you discovered that with an existing report, you’re able to make and save changes to a layout as a result of the Excel template that is associated with it. This means that any modifications you make persist each time the report is run, with the latest data being populated. If you’d […]
Are you looking for a shortcut to quickly rearrange your worksheets in alphabetical order? Instead of dragging and manually arranging your worksheets, you can use VB for Microsoft® Excel® to quickly rearrange them into alphabetical order. Excel currently has no built-in function to rearrange your worksheets. Therefore, if you have a workbook with many worksheets, […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.