Menu
Close
Have you ever used the VLOOKUP formula with the approximate match in Excel? By using this formula, you’re able to extract the correct trade discount percentage based on the quantity of a specific item purchased. In this tip, we demonstrate how to set this up. If TRUE or 1 is specified in the Range_lookup argument text […]
Do you need to future-proof your business? The Excel Forecast sheet may be the right tool for you! The Forecast sheet allows you to take your historical business data (sales, cash flow, etc.) and create more accurate forecasts for the future. You are welcome to download the workbook to practice! 1. To create a Forecast […]
Ever pictured the most popular business reporting and analytics tools as superheroes, fighting to defend businesses against pesky misinformation? Well, our in-house business intelligence specialist, Nigel Naicker, has. Here’s his creative account of how two well-known heroes, Excel and Power BI, can unite and use their superpowers together to defeat misinformation for good! The city […]
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 […]
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 […]
Do you have an Excel management pack with multiple worksheets and would like to save it as a PDF for convenient viewing and sharing? In this tip, I’m going to show you how easy this is to do. You have three options for this, but before continuing, there are a few things to take note […]
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.
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.