Menu
Close
You may be aware that Sage Intelligence allows you to connect to any ODBC compliance data source, meaning that you can access and report on information from just about anywhere in your organisation. Included is the ability to use Microsoft Excel as a data source, which is useful in cases where your business management or […]
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, […]
There may be times when you want to run out the same report but with different parameters. For example, you may have a financial report that you want to run individually for three separate fiscal years. Typically, you would need to run out the report three times, once for each year. Did you know that […]
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 […]
Sage Intelligence gives you a lot of value out-the-box, through the ready-to-use reports provided in the Report Manager and the free reports that you can access via the Report Utility. If these aren’t exactly what you’re looking for then you also have the ability to tweak them to suit your needs or build your own […]
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, […]
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 […]
Microsoft Excel is the universal language of business and accountants, and most decision-makers in small to mid-sized businesses use the king of spreadsheets in some way for reporting. In fact, research analyst Gartner has conceded that “Excel is still the number one reporting tool”. Why then, would you want or need to use a Business […]
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 […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.
