Based on word of mouth and ‘war stories’ from previous years, there are a number of things I’m looking forward to at Sage Summit 2013. 1. Washington, D.C. Yes, Sage Summit was based in DC two years ago, but what
Saving a Report to a File Sage Intelligence Reporting allows you to automatically close your Microsoft Excel workbook on completion of your report and to save the report to a fixed file in a designated folder. This is useful when
Microsoft Excel uses actual numbers to store specific dates inside of Excel. By subtracting these two numbers, you can then tell how many days there are between a given start date and a given end date. However this doesn’t necessarily
Scenario: You don’t always have control over the format and type of data that you import from an external data source, such as a database, text file or a Web page. Before you can analyse the data, you first need
To prevent other users from modifying a report you can use locking which freezes the properties of a report so that it cannot be modified. Other users are then only able to run a report; they will be unable to
Lets’s say you have created budgets for various company branches on different worksheets in your excel spreadsheet. However you are wondering how you can automatically generate a consolidated budget for all the branches. Well, no need to worry because by
Navigating your way around an excel workbook with many worksheets can be really frustrating and challenging. Simplify the process quickly and efficiently by using the hyperlink function. A Hyperlink is a reference to a document, a location or an action
Sage Intelligence Reporting always outputs the data for a report to the first sheet in a workbook. Subsequent worksheets in the workbook are available for you to create your report output formats. The Expression names for the columns in the
How to use the NPER Function to calculate number of periods in the life of a loan or investment plan
The NPER Function allows you to calculate the number of periods that make up the life of a loan or investment. So, If you have a loan with a constant repayment plan and a constant interest rate, the NPER function
Do you need to generate random numbers to test formulas? Consider using the RANDBETWEEN function. The function can be used to create some random numbers for testing of formulas so that you don’t need to make them up. The RANDBETWEEN