When creating Pivot Charts from PivotTables, the PivotTable fields will be displayed on the chart. In this tip, you’ll learn how to quickly hide them so that your report looks neater. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. You are welcome to download the workbook to practice this short, helpful tip. To remove […]
- Solutions
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
- Resources
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
Additional Reports
Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.Sage Intelligence Tips & Tricks
Our Sage Intelligence Tips and Tricks will help you make the most of your favorite reporting solution.Excel Tips & Tricks
Our Excel Tips and Tricks will help you improve your business reporting knowledge and skills.
How to remove spaces and characters in a cell
If you have ever had problems sorting, filtering, or manipulating data in a Microsoft® Excel® workbook, and realized that it was caused by stubborn leading spaces in the cells, this tip will show you how to remove spaces quickly the next time. If you’re wondering what causes the spaces, there are two possibilities: You may […]
Can Excel be considered a complete BI solution?
While trawling through the old files on my organization’s server recently, I stumbled across a 2008 report in which Forrester Wave for Enterprise Business Intelligence Platforms assessed 12 BI vendors/tools. While the report was incredibly interesting, I realized that it did not include Excel as one of the 12 solutions—which got me thinking: Can Excel […]
Avoiding the Ref# error: How to convert formulas to values in Excel
Sometimes when working with spreadsheets in Excel, you may want to distribute a workbook with static values. If your worksheet has formulas that are linked to other worksheets, you may end up with the dreaded Ref# error when distributing. That is why it is important to convert the formulas to values. In this tip, we […]
How business intelligence gets rid of the daily grind
Do you optimally use the invaluable business information your company collects on a daily basis? If you answer YES to one or more of the following questions, it may be about time you discover how business intelligence helps get rid of the daily grind. 1. Do you spend hours pulling together management and financial reports by manually […]
Learn how to share your Reporting Trees
If you have used the Financial Report Designer to create reports, you may have taken advantage of Reporting Trees as a way of filtering them. If you then intend on sharing these reports with other counterparts and want them to be able to filter by the same tree structures, then, rather than having them re-create […]
How to restore missing labels in Excel
Manipulating data with missing labels can pose a challenge. Copying and pasting data can be time consuming and tiresome. That is why, in this tip, we show you how to quickly restore data labels using a simple formula. If you find value in this tip, why not sign up for our Excel Tips and Tricks mailer, […]
How to ignite your Excel skills to save time and increase your productivity
Microsoft® Excel® has become one of the most widely used software applications of all time, in both small and mid-sized businesses—as well as in much larger corporations. Whether you like it or not, Excel is everywhere you look in the business world. By investing time in your Excel skills, you’ll not only increase your efficiency in operating the […]
How to avoid the VALUE error when using the SUMIF function between workbooks
When using the SUMIF function between workbooks, you may get a VALUE error if the source workbook is not open. This behavior occurs when the formula that contains the SUMIF, COUNTIF, or COUNTBLANK function refers to cells in a closed workbook. To work around this, use a combination of the SUM and IF functions together […]
How to delete data but keep your formulas on a worksheet in Excel
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 […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.