Menu
Close
“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 […]
Did you know that apart from being able to run reports out to Excel, Sage Intelligence allows you to switch output modes which can be useful when designing and debugging reports? Two additional options are provided, output to Screen and output to SQL. Output to Screen does away with rendering a report to Excel and […]
When designing reports in Sage Intelligence, you may create custom rows and columns that you might want to make use of in future reports. Sage Intelligence provides a convenient way to save these sets, making future report creation a breeze. In this tip, I’m going to show you how to work with the Quick Add […]
Instead of displaying values, you can actually display formulas as a way of reviewing the spreadsheet. In this tip, we explain how that can be done. You are welcome to download the workbook to practice. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. To show all formulas in a worksheet, hold down the Ctrl […]
Sometimes when working with spreadsheets in Excel, you may want to distribute a workbook with static values. If your worksheet has formulas that are linked to other worksheets, you may end up with the dreaded Ref# error when distributing. That is why it is important to convert the formulas to values. In this tip, we […]
Manipulating data with missing labels can pose a challenge. Copying and pasting data can be time consuming and tiresome. That is why, in this tip, we show you how to quickly restore data labels using a simple formula. If you find value in this tip, why not sign up for our Excel Tips and Tricks mailer, […]
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 […]
When extracting data from a database, dates don’t always show up in the format you want them to. That’s why it’s helpful to know how to use the Text to Columns option to convert dates into a format that can be used to easily analyze or work with data. As an accountant, you may want […]
In Sage Intelligence Reporting you have the ability to distribute reports using 3 different methods. 1. You can send a report via email 2. You can send a report to a FTP location 3. You can publish your file to a drive In older versions of Sage Intelligence Reporting, only static values were sent when […]
When creating formulas in Microsoft® Excel®, the expected result is not always returned, and if a complex formula is being used, it can be time consuming to find where the error is occurring. Luckily there is an easy way to audit complex formulas in Excel. In this tip we explain how you can quickly and easily […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.