Menu
Close
Microsoft Excel offers you the ability to create and design a Hierarchy SmartArt Graphic. This is useful in showing a graphical representation of an organogram, organisation chart or any hierarchy structure. This example, explained below, will help you create your own hierarchy. Our example scenario is of a Report Store that contains reports created for […]
We all know that cash flow is such an essential ingredient to the survival and success of any business. If you ever encounter cash flow problems at some stage of your business’s life, it could be a serious obstacle to your progress. Which is why it always pays to keep a close eye on what […]
This is a tip that you’re going to really enjoy if you love imagery and visualisations in your spreadsheet! It’s not the most useful tip in the world, but for most people, especially the creative types—it will put a smile on your face because it’s so much fun to play with. In this tip, I’m […]
More and more companies are calling for the necessity of business intelligence (BI) and reporting. It’s fast becoming the it word in business, and regularly features in the discussions of many business circles. However, there seems to be a gap in understanding why we need BI. What’s the point of having BI? What’s the big […]
Depending on your Sage business solution, you may or may not have the Missing Accounts feature in your Financial Report Designer report. Even if you have this functionality, you are still not automatically alerted that account level detail may be missing from your layout. In this tip, I’m going to share a way to identify […]
Do you have a workbook that could do with some neatening up? Being able to hide rows and columns in a report that contains data you don’t need to view is a great way to do this. An example of a report like this is a financial statement, which has account level detail and monthly […]
To complete an analytical review of the depreciation of your company’s assets, you can calculate the average useful life of these assets. The average useful life, which is a measure of conditional central tendency, can be calculated using the AVERAGEIF function. Central tendency is the middle value or a typical value within a data set. […]
Would you like to separate your debit and credit balances while using the Excel Design Pane? If so, then the Balance Type function is for you. An example is if you want to create a Trial Balance with debit balances reflected in a debit column and credit balances reflected in a credit column.
With a disorganized reporting structure, finding anything specific can be like finding a needle in a haystack. Stop wasting time searching for reports by creating an organized folder structure with Sage Intelligence. The most effective folders structures are easy to use, so everyone can intuitively find the reports they’re looking for. Applicable Sage Business Cloud […]
In the first part of this series, I compared becoming a new parent to nurturing relationships with new customers (and also managing their payments). The intent was for entrepreneurs to take 5 minutes every now and then to reflect on one element of their businesses to help them grow. In this article, I will focus on […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.