Menu
Close
Sage Intelligence Reporting Cloud provides convenience to you as it lets you work in whichever environment you’re most comfortable in. You can either choose to design reports in your browser through the Online Report Designer or in Excel—through the Excel Report Designer. When making use of the Excel Report Designer, there are a number of […]
In Sage Intelligence, a number of reports are provided out-the-box for each Sage product. Most of these are standard ‘single company’ reports with some of them provided as consolidation versions—allowing you to aggregate data from multiple companies and create a multi-company report. It is, however, possible to turn any standard report into a consolidation report, […]
If your data has a column of dates, you may want to subtotal dates by month and year. However, when using the Subtotal command, the desired result is not being achieved as it creates a subtotal for each day. You are welcome to download the workbook to practice. Applies To: Microsoft® Excel® for Windows 2010, […]
My parents are remarkable. They have just celebrated their 48-year wedding anniversary, and during this time period, they raised 5 children. They have lived in seven countries and worked in numerous others. Probably most remarkable was that as part of their honeymoon in 1969, they drove a red MGB from Cape Town to rural Zambia […]
While trawling through the old files on my organization’s server recently, I stumbled across a 2008 report in which Forrester Wave for Enterprise Business Intelligence Platforms assessed 12 BI vendors/tools. While the report was incredibly interesting, I realized that it did not include Excel as one of the 12 solutions—which got me thinking: Can Excel […]
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, […]
One worksheet can be used to view specific aspects of several different worksheets. This can be done using the Linked Picture option. There are a few options when consolidating information from multiple worksheets, and in this tip, we’ll deal with the most popular. The option for this tip enables you to paste the copied cells […]
In the Sage Intelligence Financial Report Designer, account balances are returned in their “natural format” from your Sage accounting or business management solution. Therefore, credit accounts (with a credit balance) are shown as negative values and debit accounts (with a debit balance) are shown as positives values. However, in financial reporting, there are times when […]
Microsoft® Excel® has become one of the most widely used software applications of all time, in both small and mid-sized businesses—as well as in much larger corporations. Whether you like it or not, Excel is everywhere you look in the business world. By investing time in your Excel skills, you’ll not only increase your efficiency in operating the […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.