Numbers containing more than 15 digits in Excel are not often used, however some users might use them when recording credit card numbers, account numbers, stock codes, etc. Applies To: Microsoft® Excel® for Windows 2013 and 2016. Excel can’t handle more than 15 digits per cell, and so when these numbers are entered, Excel stores […]
- 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 remove blank cells between your data in Excel
As you work through a spreadsheet, you may delete a number of cells and then want Excel to shift all the cells up again so that there are no blanks. In this tip, we explain how to remove blank cells between your data in Excel so that this happens. Applies To: Microsoft® Excel® for Windows […]
How to fix wrapped data labels in a pie chart
When creating a pie chart and adding data labels to the slices, the wording can sometimes split into two lines—giving you wrapped data labels that aren’t visually appealing. In the below example, Administration has been split into two words, each on a separate line. The labels are wrapped and the results appear incorrectly. Applies To: […]
How to view statistics on the status bar in Excel
This tip helps you discover how to quickly display statistics on the status bar by simply highlighting data. You are welcome to download the workbook to practice. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. Excel allows for up to 6 statistic options to be viewed on the status bar, namely; Average, Count, […]
How to print and display formulas in an Excel workbook
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 […]
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 […]
© Sage South Africa Pty Ltd 2016
.
All Rights Reserved.