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. […]
- Solutions
All Solutions
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50 U.S Intelligence Reporting
- 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
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50 U.S Intelligence Reporting
- 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.- Learning
- Support
All Solutions
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50 U.S Intelligence Reporting
- 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.Get Support Assistance
Can’t find the solution to the challenge you’re facing in the resource library? No problem! Our highly-trained support team are here to help you out.Knowledgebase
Did you know that you also have access to the same knowledgebase articles our colleagues use here at Sage Intelligence? Available 24/7, the Sage Intelligence Knowledgebase gives you access to articles written and updated by Sage support analysts.Report Writers
Having some trouble creating or customizing the exact report you need to suit your business’s requirements? Contact one of the expert report writers recommended by Sage Intelligence.- Sage City
- University
- About Us
- Contact Us
How to compare and merge a shared workbook in Excel
Sometimes when working in Excel and collaborating with your colleagues on a single document, you may wonder to yourself; how can I compare and merge a shared workbook? The answer is simple! You can do this by using the Compare and Merge Workbooks command (this command will have to be added to the quick access […]
The business mindfulness series: Part 1 – New beginnings
I recently became a parent. For those who have gone through this experience, you’ll know it’s an emotional one, and the way you view the world changes. Even if that change is only because you are viewing it through half-closed eyes because of a lack of sleep. For those that don’t have children, the experience […]
Learn how to forecast with scenarios using what-if analysis tools in Excel
The Scenario Manager is a feature in what-if analysis and you can use this to enhance your forecasting in Microsoft® Excel®. A scenario is a set of values that Excel saves and can automatically substitute in specific cells on a worksheet. You can create and save different groups of values on a worksheet, and then […]
How to create a hyperlink to a specific location in a workbook
For quick access to related information in another file, workbook or on a web page, you can insert a hyperlink in a Microsoft® Excel® worksheet cell. You can also insert hyperlinks in specific chart elements or images. If you struggle to navigate to various worksheets in a large workbook, then hyperlinks may be your solution. […]
How to view or compare two or more worksheets at the same time in Excel
You can quickly view or compare two or more worksheets in the same workbook, or in different workbooks, by viewing them side by side. You can also arrange multiple worksheets to view them all at the same time. In this tip, I show you how. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. […]
Collaborating on a Shared Workbook
Multiple users can effectively work on a spreadsheet by sharing it, and then collaborating on it. Edits can be made simultaneously by team members, thus having a continuously updated version of the spreadsheet available all the time. In this way, version control is enforced, and duplicate work is eliminated. Applies To: Microsoft® Excel® for Windows […]
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 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 […]
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 […]
Return to topLearning
Sage South Africa© Sage South Africa Pty Ltd 2020 . All Rights Reserved.