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 […]
Assuming your business already uses an integrated software system, you will also need reporting or business intelligence tools that can extract, clean, and transform the data into a format that’s meaningful for users. New tools and technologies are emerging to make information come alive, including data visualization, process simulation, and predictive techniques. By taking advantage […]
Mobility has changed the way we work—especially for businesses that depend on personnel not working at a desk or in and office. When asked how “anytime, anywhere” connectivity helps business leaders be more efficient, they typically respond with three answers: convenience, communication, or collaboration. Convenience When operations or field personnel need to call office staff […]
Even though most solo-entrepreneurs understand the benefits of business intelligence, they will probably never take advantage of it. They will assume they have neither the time nor the money to make use of business intelligence. But the field of business intelligence has changed over the years. It’s now cheaper and easier than ever for freelancers, […]
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 […]
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 […]
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 […]
Once you know how to create your own customized reports, using the Sage Intelligence Report Designer and Microsoft® Excel®, you have the power to analyze any aspect of your financials! At the core of this is knowing how to add and edit Sage Intelligence formulas in a report. In this tip, I’ll show you the […]
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 […]
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 […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.