Menu
Close
A good Business Intelligence solution will give your company a competitive advantage, and there are many compelling reasons why all business owners should make it a priority to invest in one. Here are the top three: Reason 1: Automate reporting processes Most companies face constant pressure to increase profitability, improve cash flow, reduce costs, and […]
Have you ever found that at the beginning of the financial year you need to make a copy of the previous year’s workbook? If so, you’d need to delete all the old year’s data, but you would really like to keep your formulas in the worksheet. By using the Go To dialogue box, there is […]
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 […]
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 […]
Sometimes converting negative values to positive values can be time-consuming. This tip allows you to quickly convert a range of negative values into positive values, without having to edit each cell. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. 1. In a blank cell, enter the value -1. 2. Select the cell with […]
The traditional business intelligence (BI) environment has become bogged down with high-ticket prices, delayed deployments, failed integrations and slow responses to BI requests, and frankly, has lacked any real new innovative ideas for a long time. This begs the question—does simple and affordable business intelligence even exist? Shaking things up This poor reputation has preceded […]
The IFS function gives you an efficient alternative to the tedious task of creating a nested IF function. The IFS function checks conditions sequentially, and as soon as a condition is found to be true, the function stops and returns the specified value. You can take advantage of this logic to define a default result […]
The PivotTable is one of the easiest tools used to transform huge amounts of data into meaningful reports. Excel didn’t disappoint with the improvements that have been made to PivotTables in their 2016 version. These include the following; Field List search, Automatic Time Grouping, and Multi-select Slicers. In this tip, we explore some improvements made […]
For over a decade, Sage Intelligence has delivered on-premise solutions on almost every continent. We have amounted 100s and thousands of customers through our innovative reports and software. As can be expected, we have obtained a vast amount of expertise in both financial and operational reporting. For a long time, Excel has been our go-to area […]
Do you need to know how many customers you have invoiced this month? When creating a Pivot Table and adding your customers to both the row labels and again in the value area, each transaction is totaled for each customer. This does not give a true reflection of how many customers you have invoiced. In […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.