Instead of displaying values, you can actually display formulas as a way of reviewing the spreadsheet. In this tip, we explain how that can be done. You are welcome to download the workbook to practice. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. To show all formulas in a worksheet, hold down the Ctrl […]
- Solutions
All Solutions
- Sage One Intelligence
- Sage 50 Africa Intelligence Reporting
- Sage 50 U.S Intelligence Reporting
- Sage 50 Middle East Intelligence Reporting
- Sage 50c Intelligence
- Sage Pastel Partner Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage Evolution Intelligence Reporting
- Sage Live Intelligence
- Sage 100 Intelligence Reporting
- Sage 100 Contractor Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 300c Intelligence
- Sage 500 Intelligence Reporting
- Sage X3 Intelligence Reporting (Desktop)
- Sage X3 Intelligence (Cloud)
- Sage VIP Intelligence Reporting
- Resources
All Solutions
- Sage One Intelligence
- Sage 50 Africa Intelligence Reporting
- Sage 50 U.S Intelligence Reporting
- Sage 50 Middle East Intelligence Reporting
- Sage 50c Intelligence
- Sage Pastel Partner Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage Evolution Intelligence Reporting
- Sage Live Intelligence
- Sage 100 Intelligence Reporting
- Sage 100 Contractor Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 300c Intelligence
- Sage 500 Intelligence Reporting
- Sage X3 Intelligence Reporting (Desktop)
- Sage X3 Intelligence (Cloud)
- 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.Webcasts
Want to become a Sage Intelligence whiz? We present regular webcasts of forty-five minutes to one hour on various topics to get you up to speed. Choose your product below to see what we have in store for the next few months. If you want to know more about what a webcast is, click here.White Papers
Check out our informative whitepapers to get in-depth advice about your business. You’ll discover how to make sense of your financials, how to make the most of business intelligence, and why business visibility is the key to success.eBooks
Check out our informative e-books to get in-depth advice about your business. You’ll discover how to make sense of your financials, how to make the most of business intelligence, and why business visibility is the key to success.Tips & Tricks
Join over 20 000 subscribers to our popular Sage Intelligence Reporting and Excel Tips and Tricks, and get a handy tip delivered to your inbox.Customer Stories
Don’t take our word for it, hear from our customers who can’t stop raving about how Sage Intelligence Reporting has changed their lives. You might even find a solution in their story to a similar issue you’re facing.- Learning
All Solutions
- Sage One Intelligence
- Sage 50 Africa Intelligence Reporting
- Sage 50 U.S Intelligence Reporting
- Sage 50 Middle East Intelligence Reporting
- Sage 50c Intelligence
- Sage Pastel Partner Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage Evolution Intelligence Reporting
- Sage Live Intelligence
- Sage 100 Intelligence Reporting
- Sage 100 Contractor Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 300c Intelligence
- Sage 500 Intelligence Reporting
- Sage X3 Intelligence Reporting (Desktop)
- Sage X3 Intelligence (Cloud)
- 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.Webcasts
Want to become a Sage Intelligence whiz? We present regular webcasts of forty-five minutes to one hour on various topics to get you up to speed. Choose your product below to see what we have in store for the next few months. If you want to know more about what a webcast is, click here.White Papers
Check out our informative whitepapers to get in-depth advice about your business. You’ll discover how to make sense of your financials, how to make the most of business intelligence, and why business visibility is the key to success.eBooks
Check out our informative e-books to get in-depth advice about your business. You’ll discover how to make sense of your financials, how to make the most of business intelligence, and why business visibility is the key to success.Tips & Tricks
Join over 20 000 subscribers to our popular Sage Intelligence Reporting and Excel Tips and Tricks, and get a handy tip delivered to your inbox.Customer Stories
Don’t take our word for it, hear from our customers who can’t stop raving about how Sage Intelligence Reporting has changed their lives. You might even find a solution in their story to a similar issue you’re facing.Learning Portal
Check out our brand new Sage Intelligence learning portal! Your personal library of learning resources that suits your knowledge level, and then guides you towards mastering your solution.Sage Intelligence Academy
Microsoft Excel Training
Improve your Microsoft® Excel® skills and learn how to produce insightful business reports.- Discovering Excel: If you have basic Excel knowledge you would benefit from attending this intermediate Excel course.
- Excel on Steroids: If you use Excel extensively for business reporting, then this course is for you. The course is divided into three workshops covering specific topics in Excel.
- Excel on Steroids Plus: Data analysis, visualisation and dashboards will teach you how to model your data, create interactive dashboard reports, and make analysing your data much easier, giving you clearer insights into your company.
Sage Intelligence Training
From helping you get started with Sage Intelligence Reporting through to connecting to various databases to create consolidated reports, we have a range of Sage Intelligence Reporting courses designed to upskill you so that you get the most out of your reporting solution.Tips & Tricks
How to generate a barcode in Excel
This tip shows you how to generate a barcode in Excel that will enable you to track stock, sales, purchases or fixed assets. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. Excel has no built-in functionality to generate a barcode. However, this is easily achievable by simply downloading and installing a font. This tip […]
How to Remove PivotTable Fields from Pivot Charts
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 […]
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 […]
How to Subtotal Dates by Month and Year in Excel
If your data has a column of dates, you may want to subtotal dates by month and year. However, when using the Subtotal command, the desired result is not being achieved as it creates a subtotal for each day. You are welcome to download the workbook to practice. Applies To: Microsoft® Excel® for Windows 2010, […]
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 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, […]
View specific aspects of several different worksheets on one worksheet
One worksheet can be used to view specific aspects of several different worksheets. This can be done using the Linked Picture option. There are a few options when consolidating information from multiple worksheets, and in this tip, we’ll deal with the most popular. The option for this tip enables you to paste the copied cells […]
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 2016
.
All Rights Reserved.