Menu
Close
When working with large data lists in Excel, you may need to know the extent of the data, i.e. the number of rows and columns. If consistency of the data is important too, then you may need to identify whether there’s any empty rows, columns or cells. An obvious way to check this is by […]
If you’re a user of the Sage Intelligence Connector Module, you’ll know that the Connector maintains the links between your Sage Intelligence reports and your Sage Business Management Solution data sources. Different database systems store and recognise dates in different formats, and Sage Intelligence attempts to hide this detail from you by translating dates at […]
As an accountant, my most valuable commodity is time. Being responsible for daily capturing, month end procedures and group reporting, I often don’t have time to breathe! Fortunately, a lot of my responsibilities are hastened because I use business intelligence (BI), which helps me extract key information from large volumes of data directly from our […]
I recently became a parent. For those who have gone through this experience, you’ll know it’s an emotional one, and the way you view the world changes. Even if that change is only because you are viewing it through half-closed eyes because of a lack of sleep. For those that don’t have children, the experience […]
If you want to create a report quickly or you’re not sure how to design one from scratch, the Quick Create Report feature in Sage Intelligence is very easy to use. By simply selecting a set of pre-defined columns and rows, you’re able to set up a financial report in a matter of seconds. Then, […]
Conditional formatting is an effective Microsoft Excel feature that allows you to highlight important information, for example; the ability to find duplicate values within your spreadsheet. You can create your own rule by applying conditional formatting to individual cells or a range of cells. When you have selected the data you want to format, you […]
Imagine a small child embarking on their first trip in an aeroplane. The excitement of the trip to come, the cute, Disney bag packed (maybe large enough to ride around the airport) and a long, tiring walk through the terminal. Then they’re quickly strapped into seat, a friendly pat on the head from a steward […]
Perhaps you’re an implementer like myself. You get a high from setting things in motion, singling out the areas where you can make the biggest difference, and attacking those relentlessly. Perhaps though, you can get so lost in the implementation and detail of your tasks or ideas, that your bigger picture field of view is […]
Near the end of the 2017, I read an interesting article by Microsoft’s Brad Smith, which was written as part of celebrating the completion of a 4,000-mile-long, sub-sea, communications cable between North America and Spain. The laying of this cable is an impressive achievement, as well as the fact that it can apparently transmit eight times […]
In our last tip, we showed you how to save a copy of your Excel workbook to file when running a report. If you’d like to catch up on it, then take a look here. Did you know that in addition to saving your reports in an Excel format, you have the option to run […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.